public InvoicingFlag GetFlagQuery(int flagType, string dbName) { string connectionString = cons.GetConn(dbName); InvoicingFlag invoicingFlag = new InvoicingFlag(); using (SqlConnection con = new SqlConnection(connectionString)) { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlCommand cmd = new SqlCommand("spGetFlag", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@iFlagType", flagType); SqlDataReader reader; reader = cmd.ExecuteReader(); while (reader.Read()) { invoicingFlag.FlagStatus = Convert.ToBoolean(reader["bFlagStatus"].ToString()); invoicingFlag.UserName = reader["cUserName"].ToString(); } reader.Close(); } con.Close(); } return(invoicingFlag); }
public IActionResult Index() { string userName = HttpContext.Session.GetString("UserName"); string databaseName = HttpContext.Session.GetString("Database_Name"); InvoicingSelectionViewModel invoicingSelectionViewModel = new InvoicingSelectionViewModel(); try { InvoicingFlag = _invoicGeneration.GetFlagQuery(StaticConstItems.InvoicingFlag, databaseName); if (InvoicingFlag.FlagStatus) { ViewBag.InvoiceStatus = "Task is not permitted while invoicing is busy by user: "******"Task is not permitted while invoicing is busy by user: "******"", Text = "" }); invoicingSelectionViewModel.Company = companies; //------------------------------Pricing---------------------------------------------- IList <SelectListItem> invoice = _invoicGeneration.ViewInvoicePrintTypeQuery(0, databaseName); invoicingSelectionViewModel.InvoiceOption = invoice; } catch (Exception ex) { } List <string> invoiceType = new List <string>() { "Invoicing", "Split biling" }; invoicingSelectionViewModel.Action = new List <string>() { "Check", "Uncheck" }; invoicingSelectionViewModel.InvoiceType = invoiceType; invoicingSelectionViewModel.BillingCycle = 23; invoicingSelectionViewModel.InvoiceDate = DateTime.Now.Date; return(View(invoicingSelectionViewModel)); }