public ActionResult CheckLogin(string username, string pwd)
{
int role;
TMS_UserMaster userObj = db.TMS_UserMaster.Where(x => x.UserMail == username.Trim() && x.Password == pwd.Trim() && x.IsActive == true).FirstOrDefault();
if (userObj != null)
{
TempData["name"] = userObj.Name;
Session["RoleId"] = userObj.RoleId;
Session["UserDetails"] = userObj;
role = userObj.RoleId;
FormsAuthentication.SetAuthCookie(username, true);
switch (role)
{
case 1:
return(RedirectToAction("Index", "Admin"));
case 2:
return(RedirectToAction("Index", "Manager"));
case 3:
return(RedirectToAction("Index", "Employee"));
}
}
else
{
TempData["InvalidLoginMessage"] = "!! Invalid Username Or Password !!";
}
return(View("Index"));
}
public ActionResult CreateUser(TMS_UserMaster formObj)
{
int EmailAlreadyRegistered = db.TMS_UserMaster.Where(x => x.UserMail == formObj.UserMail).Count();
if (EmailAlreadyRegistered > 0)
{
TempData["Warning"] = "Email Already Registered";
return(RedirectToAction("CreateUser"));
}
try
{
if (formObj.UserId == 0)
{
TMS_UserMaster obj = new TMS_UserMaster();
obj.RoleId = formObj.RoleId;
obj.ManagerID = formObj.ManagerID;
obj.UserMail = formObj.UserMail;
obj.DOB = Convert.ToDateTime(formObj.DOB);
obj.DOJ = Convert.ToDateTime(formObj.DOJ);
obj.Password = formObj.Password;
obj.Name = formObj.Name;
obj.IsActive = true;
obj.CreatedBy = ((TMS_UserMaster)Session["UserDetails"]).UserId;
obj.CreatedOn = DateTime.Today;
obj.ModifiedBy = ((TMS_UserMaster)Session["UserDetails"]).UserId;
obj.ModifiedOn = DateTime.Today;
obj.SkillId = "1,2,3,4";
obj.PrimarySkillId = formObj.PrimarySkillId;
obj.MobNo = formObj.MobNo.ToString();
obj.PAN = formObj.PAN.ToString();
obj.Address = formObj.Address;
obj.Experience = formObj.Experience;
obj.PassportExpiryDate = System.DateTime.Today;
obj.PassportNumber = "";
obj.DesignationID = 3;
db.TMS_UserMaster.Add(obj);
db.SaveChanges();
TempData["Success"] = "New User Registered Successfully.";
}
else //Update
{
TMS_UserMaster obj = db.TMS_UserMaster.Where(x => x.UserId == formObj.UserId).FirstOrDefault();
obj.RoleId = formObj.RoleId;
obj.ManagerID = formObj.ManagerID;
obj.UserMail = formObj.UserMail;
obj.DOB = Convert.ToDateTime(formObj.DOB);
obj.DOJ = Convert.ToDateTime(formObj.DOJ);
obj.Name = formObj.Name;
obj.ModifiedBy = ((TMS_UserMaster)Session["UserDetails"]).UserId;
obj.ModifiedOn = DateTime.Today;
db.SaveChanges();
TempData["Success"] = obj.Name.ToLower() + "'s Record Updated Successfully.";
}
}
catch (Exception)
{ TempData["Warning"] = "Invalid Request /Validation Error"; }
return(RedirectToAction("CreateUser"));
}
public ActionResult ChangePassword(string NewPassword)
{
int id = ((TMS_UserMaster)Session["UserDetails"]).UserId;
TMS_UserMaster tMS_UserMaster = (from a in db.TMS_UserMaster
where a.UserId == id
select a).FirstOrDefault();
tMS_UserMaster.Password = NewPassword;
db.SaveChanges();
Session.Abandon();
return(RedirectToAction("Index"));
}
public ActionResult BatchDetails()
{
if (Session["UserDetails"] != null)
{
TMS_UserMaster uObj = (TMS_UserMaster)Session["UserDetails"];
var RequestList = GetRequestList(uObj.UserId);
if (RequestList.Count != 0)
{
ViewBag.List = RequestList;
}
}
return(View());
}
public ActionResult RequestForm(int bid)
{
try
{
int user_id = ((TMS_UserMaster)Session["UserDetails"]).UserId;
int q = (from a in db.TMS_Request
join b in db.TMS_BatchMaster on a.BatchId equals b.BatchId
join c in db.TMS_UserMaster on a.UserId equals user_id
where b.BatchId == bid
select a.RequestId).Count();
if (q == 0)
{
if (Session["UserDetails"] != null)
{
TMS_UserMaster usrObj = (TMS_UserMaster)Session["UserDetails"];
int empid = usrObj.UserId;
var EmpObj = db.TMS_UserMaster.Where(x => x.IsActive == true && x.UserId == empid).FirstOrDefault();
var batch = getBatch(bid);
TMS_Request objrqst = new TMS_Request();
objrqst.BatchId = batch.BatchId;
objrqst.ManagerId = Convert.ToInt32(EmpObj.ManagerID);
objrqst.UserId = EmpObj.UserId;
objrqst.Status = "P";
objrqst.IsActive = true;
objrqst.CreatedBy = 12;
objrqst.CreatedOn = DateTime.Today;
objrqst.ModifiedBy = 1;
objrqst.ModifiedOn = DateTime.Today;
db.TMS_Request.Add(objrqst);
db.SaveChanges();
int mgrid = objrqst.ManagerId;
TempData["Success"] = "Request has been Forwared to the manager.";
}
}
else
{
TempData["Warning"] = "Already Registered in Batch";
return(RedirectToAction("CreateRequest"));
}
}
catch (Exception)
{ TempData["Danger"] = "Invlaid Request/ Invalid Data"; }
return(RedirectToAction("CreateRequest"));
}
public ActionResult CreateUser(int?id)
{
TMS_UserMaster obj = new TMS_UserMaster();
if (id != null)
{
obj = db.TMS_UserMaster.Where(x => x.UserId == id).FirstOrDefault();
ViewBag.id = id;
}
List <ViewModelClass.ModelUserView> umList = (from a in db.TMS_UserMaster
join b in db.TMS_UserMaster on a.ManagerID equals b.UserId
join c in db.TMS_RoleMaster on a.RoleId equals c.RoleId
where a.IsActive == true
select new ViewModelClass.ModelUserView
{
id = a.UserId,
name = a.Name,
email = a.UserMail,
rolename = c.RoleName,
managername = b.Name,
dob = a.DOB,
doj = a.DOJ
}).ToList();
umList = umList.OrderByDescending(x => x.id).ToList();
ViewBag.List = umList;
//Role DropDown
ViewBag.rolelist = db.TMS_RoleMaster.Where(x => x.IsActive == true && x.RoleId != 1).Select(c => new SelectListItem
{
Value = c.RoleId.ToString(),
Text = c.RoleName
}).ToList();
//MAnager DropDown
ViewBag.mangerlist = GetManagerList();
//Skill List Drop Down
ViewBag.SkillList = GetSkillList();
return(View(obj));
}
