public ActionResult Dashboard() { if (Convert.ToString(Session["BrowserId"]) != GenerateHashKeyForCheckBroswerEveryCall()) { return(RedirectToAction("Login", "Account")); } //int i = obj.CheckSessionEveryCall(); //if (i != 0) //{ // return RedirectToAction("Login", "Account"); //} AdminData objAD = new AdminData(); Accountstatusmodel objASM = new Accountstatusmodel(); objASM = objAD.GetAccountsDetails(Convert.ToInt32(Session["UserType"])); ViewBag.Totalaccounts = objASM.Totalaccount; ViewBag.ARCSaccount = objASM.ARCSaccount; ViewBag.inspectoraccount = objASM.Inspectoraccount; return(View()); }
public Accountstatusmodel GetAccountsDetails(int UserTypeCode) { Accountstatusmodel objASM = new Accountstatusmodel(); using (SqlConnection con = new SqlConnection(ConStr)) { con.Open(); SqlCommand com = new SqlCommand("[dbo].[GetNumberOfAccount]", con) { CommandType = CommandType.StoredProcedure }; com.Parameters.AddWithValue("@UserTypeCode", UserTypeCode); SqlDataReader rdr = com.ExecuteReader(); while (rdr.Read()) { objASM.Totalaccount = Convert.ToInt32(rdr["Totalaccount"]); objASM.ARCSaccount = Convert.ToInt32(rdr["ARCSaccount"]); objASM.Inspectoraccount = Convert.ToInt32(rdr["inspectoraccount"]); } return(objASM); } }