now how can i use the switch statement because i wanted my number to be concatenated by the year as it is hereAuto increment based on last number from database in ASPNet MVC39If MeAccount 3434 ThenSelect Case maxcode Case 0 To 9 MeACCOUNT RightstrYearNow 2 34000034 Trimstrmaxcode MeADMNO RightstrYearNow 2 34000034 Trimstrmaxcode 39MeAccount 3406000034 TrimStrmaxcode Case 10 To 99

Hi makumbiPlease refer below sampleControllerpublic class HomeController Controller GET Home public ActionResult Index return View HttpPost public ActionResult Insert string connStr ConfigurationManagerConnectionStrings34constr34ConnectionString string previousIdQuery 34SELECT TOP 1 UniqueId FROM TransID ORDER BY CustomerID DESC34 int newId ConvertToInt32GenerateNewIdconnStr previousIdQuerySplit39391 string maxcode stringEmpty switch newId case int n when n gt 0 ampamp n lt 9 maxcode DateTimeTodayYearToStringSubstringDateTimeTodayYearToStringLength 2 34000034 newId break case int n when n gt 10 ampamp n lt 99 maxcode DateTimeTodayYearToStringSubstringDateTimeTodayYearToStringLength 2 3400034 n

Use switch statement to concatenate string in ASP.Net MVC

makumbi

SOLVED CLOSED ACTIVE ANSWERED
User: makumbi
Posted: on Mar 06, 2022 09:59 PM
Forum: ASP.Net MVC
Answer: 1
Views: 1975

now how can i use the switch statement because i wanted my number to be concatenated by the year as it is here.

'If Me!Account = "" Then
Select Case maxcode
    Case 0 To 9
        Me!ACCOUNT = Right(str(Year(Now)), 2) + "-0000" + Trim(str$(maxcode))
         Me!ADMNO = Right(str(Year(Now)), 2) + "-0000" + Trim(str$(maxcode))
        'Me!Account = "06-0000" + Trim(Str$(maxcode))
    Case 10 To 99
        Me!ACCOUNT = Right(str(Year(Now)), 2) + "-000" + Trim(str$(maxcode))
         Me!ADMNO = Right(str(Year(Now)), 2) + "-000" + Trim(str$(maxcode))
        'Me!Account = "06-000" + Trim(Str$(maxcode))
    Case 100 To 999
        Me!ACCOUNT = Right(str(Year(Now)), 2) + "-00" + Trim(str$(maxcode))
         Me!ADMNO = Right(str(Year(Now)), 2) + "-00" + Trim(str$(maxcode))
        'Me!Account = "06-00" + Trim(Str$(maxcode))
    Case 1000 To 9999
         Me!ACCOUNT = Right(str(Year(Now)), 2) + "-0" + Trim(str$(maxcode))
          Me!ADMNO = Right(str(Year(Now)), 2) + "-0" + Trim(str$(maxcode))
         'Me!Account = "06-0" + Trim(Str$(maxcode))
    Case Else
        Me!ACCOUNT = Right(str(Year(Now)), 2) + "-" + Trim(str$(maxcode))
        Me!ADMNO = Right(str(Year(Now)), 2) + "-" + Trim(str$(maxcode))
        'Me!Account = "06-" + Trim(Str$(maxcode))
End Select

Download FREE API for Word, Excel and PDF in ASP.Net

arjunv

0 2

Reply
ANSWER
User: arjunv
Replied: on Mar 07, 2022 06:04 AM
Report

Hi makumbi,

Please refer below sample.

Controller

public class HomeController : Controller
{
    // GET: Home
    public ActionResult Index()
    {
        return View();
    }

    [HttpPost]
    public ActionResult Insert()
    {
        string connStr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        string previousIdQuery = "SELECT TOP 1 UniqueId FROM TransID ORDER BY CustomerID DESC";
        int newId = Convert.ToInt32(GenerateNewId(connStr, previousIdQuery).Split('-')[1]);
        string maxcode = string.Empty;
        switch (newId)
        {
            case int n when (n >= 0 && n <= 9):
                maxcode = DateTime.Today.Year.ToString().Substring(DateTime.Today.Year.ToString().Length - 2) + "-0000" + newId;
                break;
            case int n when (n >= 10 && n <= 99):
                maxcode = DateTime.Today.Year.ToString().Substring(DateTime.Today.Year.ToString().Length - 2) + "-000" + newId;
                break;
            case int n when (n >= 100 && n <= 999):
                maxcode = DateTime.Today.Year.ToString().Substring(DateTime.Today.Year.ToString().Length - 2) + "-00" + newId;
                break;
            case int n when (n >= 1000 && n <= 9999):
                maxcode = DateTime.Today.Year.ToString().Substring(DateTime.Today.Year.ToString().Length - 2) + "-0" + newId;
                break;
            default:
                maxcode = DateTime.Today.Year.ToString().Substring(DateTime.Today.Year.ToString().Length - 2) + "-" + newId;
                break;
        }

        string insertQuery = "INSERT INTO TransID VALUES(" + maxcode + ")";
        using (SqlConnection con = new SqlConnection(connStr))
        {
            con.Open();
            SqlCommand cmd = new SqlCommand(insertQuery, con);
            cmd.ExecuteNonQuery();
            con.Close();
        }
        return RedirectToAction("Index");
    }

    private string GenerateNewId(string connection, string query)
    {
        string newId = string.Empty;
        using (SqlConnection con = new SqlConnection(connection))
        {
            con.Open();
            SqlCommand cmd = new SqlCommand(query, con);
            string i = Convert.ToString(cmd.ExecuteScalar());
            if (string.IsNullOrEmpty(i))
            {
                newId = "1";
            }
            else
            {
                int j = Convert.ToInt32(i);
                j = j + 1;
                newId = j.ToString();
            }
            con.Close();
        }

        return newId;
    }
}

View

@{
    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Index</title>
</head>
<body>
    @using (Html.BeginForm("Insert", "Home", FormMethod.Post))
    {
        <input type="submit" value="Submit" />
    }
</body>
</html>

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Use switch statement to concatenate string in ASP.Net MVC

Auto increment based on last number from database in ASP.Net MVC

Company

Explore

Follow us

Contact Us