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