private string GenSIC() { //var context = new ApplicationDbContext(); try { //SalesInvoice lastOrder = context.SalesInvoices.LastOrDefault(); SalesInvoice lastOrder = Invoice_repo.GetLast(); string value = lastOrder.SalesInvoiceCode; string number = Regex.Match(value, "[0-9]+$").Value; return(value.Substring(0, value.Length - number.Length) + (long.Parse(number) + 1).ToString().PadLeft(number.Length, '0')); } catch (NullReferenceException) { return("SINN0000000001"); } }