public ActionResult Register(Tb_M_User registerUser) { string strmsg = ""; try { bool bIsExist = _dbContext.Tb_M_User.Any(u => u.UserName == registerUser.UserName); if (bIsExist) { strmsg = "User Name already exist"; return(Json(new { msg = strmsg, }, JsonRequestBehavior.AllowGet)); } _dbContext.Tb_M_User.Add(registerUser); int result = _dbContext.SaveChanges(); if (result > 0) { strmsg = "User Added Successfully"; } else { strmsg = "User not added Successfully"; } } catch (Exception e) { ViewBag.msg = e.Message; } return(Json(new { msg = strmsg, }, JsonRequestBehavior.AllowGet)); }
public JsonResult Login(Tb_M_User user) { string strmsg = "", strurl = ""; try { bool IsValidUser = _dbContext.Tb_M_User .Any(u => u.UserName.ToLower() == user.UserName.ToLower() && u.Uspassword == user.Uspassword); if (IsValidUser) { var nRoleId = _dbContext.Tb_M_User.Where(u => u.UserName == user.UserName).SingleOrDefault().UsRoleId; string userRoleName = _dbContext.Tb_M_Role.Where(u => u.RoleId == nRoleId).SingleOrDefault().RoleName; FormsAuthentication.SetAuthCookie(user.UserName, false); strmsg = "Validuser"; if (userRoleName == "Admin") { strurl = Url.Action("", "Employee/Details"); } else if (userRoleName == "Manager") { strurl = Url.Action("", "Project/CreateProject"); } else if (userRoleName == "Employee") { SqlCommand select_emp_id = new SqlCommand("select Id from Tb_M_Emp where EmpName = '" + user.UserName + "'", sqlCon); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(select_emp_id); DataSet Ds = new DataSet(); sqlDataAdapter.Fill(Ds); int empid = Convert.ToInt32(Ds.Tables[0].Rows[0]["Id"]); strurl = string.Format("/Project/EmployeeAllDetail?nEmpId={0}", empid); var hrefurl = string.Format("http://localhost:50183/Project/EmployeeAllDetail?nEmpId={0}", empid); ViewBag.DetailURL = hrefurl; } } else { strmsg = "invalid Username and password"; strurl = Url.Action("", ""); } } catch (Exception e) { ViewBag.msg = e.Message; return(Json(new { msg = e.Message, url = strurl }, JsonRequestBehavior.AllowGet)); } return(Json(new { msg = strmsg, url = strurl }, JsonRequestBehavior.AllowGet)); }