public ActionResult Login(string inputUser, string inputPassword, string checkRemember)
{
AttendanceManagementSystem.AppCode.Global obj = new AttendanceManagementSystem.AppCode.Global();
//string query = "USP_GETLOGINDETAILS '" + inputUser + "','" + inputPassword + "' ";
string query = "select * from USERMASTER WHERE USERCODE='" + inputUser + "' and PASSWORD='******' and isblocked=0";
DataTable dt = new DataTable();
dt = obj.GetData(query);
if (dt.Rows.Count == 0)
{
return(View());
}
else
{
foreach (DataRow dr in dt.Rows)
{
Session["usercode"] = dr["usercode"];
Session["usertype"] = dr["usertype"];
}
string query1 = "SELECT MENU,CONTROLLER,ACTION FROM ROLUMENUMASTER WHERE USERTYPE=" + Session["usertype"] + "";
DataTable dt1 = new DataTable();
dt1 = obj.GetData(query1);
Session["menu"] = dt1;
FormsAuthentication.SetAuthCookie(inputUser, false);
return(RedirectToAction("Home", "Dashboard"));
}
}
public JsonResult DropdownBindWorkType()
{
string query = "select WORKCODE,WORKDESCRYPTION FROM WORKTYPEMASTER";
DataTable dt = new DataTable();
dt = obj.GetData(query);
string JSONresult = JsonConvert.SerializeObject(dt);
return(Json(JSONresult, JsonRequestBehavior.AllowGet));
}
public JsonResult GetProfile()
{
string query = "SELECT USERCODE,USERNAME,MOBILE,EMAIL,UT.DESCRYPTION FROM USERMASTER UM LEFT JOIN USERTYPE UT ON UM.USERTYPE=UT.USERTYPE WHERE UM.USERCODE='" + Session["usercode"].ToString() + "'";
DataTable dt = new DataTable();
dt = obj.GetData(query);
string JSONresult = JsonConvert.SerializeObject(dt);
return(Json(JSONresult, JsonRequestBehavior.AllowGet));
}