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