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