public ActionResult staff(EmployeeDetails emp) { List <EmployeeDetails> EmpList = new List <EmployeeDetails>(); string id = emp.UserTypeId; Property p = new Property(); DataSet ds = new DataSet(); p.OnTable = "FetchEmployee"; if (id != null) { p.Condition3 = id; } ds = dl.FetchEmployee_sp(p); List <SelectListItem> CategoryList = new List <SelectListItem>(); CategoryList.Add(new SelectListItem { Text = "Select", Value = "" }); foreach (DataRow dr in ds.Tables[1].Rows) { CategoryList.Add(new SelectListItem { Text = dr["UserType"].ToString(), Value = dr["UserTypeId"].ToString() }); } ViewBag.CategoryList = new SelectList(CategoryList, "Value", "Text"); try { foreach (DataRow item in ds.Tables[2].Rows) { EmployeeDetails m = new EmployeeDetails(); m.EmployeeId = item["EmployeeId"].ToString(); m.FullName = item["FullName"].ToString(); m.UserTypeId = item["UserTypeId"].ToString(); m.UserType = item["UserType"].ToString(); m.Phone = item["Phone"].ToString(); //m.ProfilePic = item["ProfilePic"].ToString(); EmpList.Add(m); } ViewBag.EmpList = EmpList; } catch (Exception e) { } return(View()); }
public ActionResult ShowEmployee() { HttpCookie rxgoadmin = Request.Cookies["rxgoAdmin"]; string adminid = rxgoadmin.Values["Hid"]; List <EmployeeDetails> EmployeeList = new List <EmployeeDetails>(); Property p = new Property(); DataSet ds = new DataSet(); p.OnTable = "FetchEmployee"; if (adminid != null) { p.Condition1 = adminid; } ds = dl.FetchEmployee_sp(p); List <SelectListItem> TypeList = new List <SelectListItem>(); TypeList.Add(new SelectListItem { Text = "Select User Type", Value = "" }); foreach (DataRow dr in ds.Tables[1].Rows) { TypeList.Add(new SelectListItem { Text = dr["UserType"].ToString(), Value = dr["UserTypeId"].ToString() }); } ViewBag.TypeList = new SelectList(TypeList, "Value", "Text"); foreach (DataRow item in ds.Tables[0].Rows) { EmployeeDetails m = new EmployeeDetails(); m.EmployeeId = item["EmployeeId"].ToString(); m.FullName = item["FullName"].ToString(); m.EmailId = item["EmailId"].ToString(); m.Phone = item["Phone"].ToString(); //m.Age = item["Age"].ToString(); m.IsActive = item["IsActive"].ToString(); EmployeeList.Add(m); } ViewBag.EmployeeList = EmployeeList; return(View()); }
public ActionResult Index(EmployeeDetails a) { Property p = new Property(); DataSet ds = new DataSet(); p.OnTable = "FetchEmployeeLogin"; p.Condition1 = a.EmailId; p.Condition2 = a.Password; ds = dl.FetchEmployee_sp(p); try { if (ds.Tables[0].Rows.Count > 0) { HttpCookie rxgoEmployeeCookie = Request.Cookies["rxgoEmployee"]; rxgoEmployeeCookie = new HttpCookie("rxgoEmployee"); rxgoEmployeeCookie["Eid"] = ds.Tables[0].Rows[0]["EmployeeId"].ToString(); rxgoEmployeeCookie["Utyp"] = ds.Tables[0].Rows[0]["UserTypeId"].ToString(); rxgoEmployeeCookie.Expires = DateTime.Now.AddDays(1); Response.Cookies.Add(rxgoEmployeeCookie); return(RedirectToAction("Index", "Employees")); } else { TempData["MSGlogin"] = "******"; } } catch (Exception ex) { TempData["MSGlogin"] = "******"; } TempData["MSG"] = "Email-id / Password is incorrect or account not active!"; return(RedirectToAction("Index", "EmployeeLogin")); }