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));
}
