public ActionResult SignIn(LogIn objSignIn) { if (ModelState.IsValid) { if (Membership.ValidateUser(objSignIn.USERID, objSignIn.USERPASSWORD)) { oCCUSER = oDBContext.CCUSERs.FirstOrDefault(t => t.USERID == objSignIn.USERID && t.USERPASSWORD == objSignIn.USERPASSWORD); Session["User"] = oCCUSER; Session["UserRole"] = oCCUSER.CCROLE.ROLENAME; return(RedirectToAction("Index", "Home")); } else { TempData["SignMsg"] = "Invalid User ID / Password"; return(View("Index")); } //oCCUSER = oDBContext.CCUSERs.FirstOrDefault(t => t.USERID == objSignIn.USERID && t.USERPASSWORD == objSignIn.USERPASSWORD); //if (oCCUSER != null) //{ // Session["User"] = oCCUSER; // Session["UserRole"] = oCCUSER.CCROLE.ROLENAME; // Roles.AddUserToRole(oCCUSER.USERID, oCCUSER.CCROLE.ROLENAME); // return RedirectToAction("Index", "Home"); //} //else //{ // TempData["SignMsg"] = "Invalid User ID / Password"; // return View("Index"); //} } return(View("Index")); }
public ActionResult HeaderDetails() { UserInfo oUserInfo = null; if (Session["User"] != null) { CCUSER oCCUSER = (CCUSER)Session["User"]; oUserInfo = new UserInfo(); oUserInfo.ID = oCCUSER.ID; oUserInfo.USERID = oCCUSER.USERID; oUserInfo.USERNAME = oCCUSER.EMPLOYEENAME; oUserInfo.GROUP = oCCUSER.CCGROUP.GROUPNAME; oUserInfo.ROLE = oCCUSER.CCROLE.ROLENAME; oUserInfo.IMAGEPATH = oCCUSER.IMAGEPATH; oUserInfo.PendingTaskList = oDBContext.CCMEMOMASTERs.Where(t => t.ISACTIVE && t.CCMEMOLOGs.Where(x => x.ASSIGNGROUP == oCCUSER.GROUPID).OrderByDescending(p => p.ID).FirstOrDefault() != null && t.ASSIGNGROUP == oCCUSER.GROUPID && t.ISOPEN == true).OrderByDescending(t => t.ID).ToList(); oUserInfo.PriorityTaskList = oUserInfo.PendingTaskList.Where(t => t.CREATEDBY == oCCUSER.ID).ToList(); return(PartialView("_HeaderPartial", oUserInfo)); //DateTime.Now.Subtract(DateTime.Now).Hours } else { return(RedirectToAction("SignIn", "SignIn")); } }
public ActionResult SearchList(string searchCat, int?grpId) { oCurrentUser = (CCUSER)Session["User"]; var srchTaskList = new TaskList(); int enumDBType = 0; enumDBType = Convert.ToInt32(Enumaretion.DBEnumType.PriorityType); if (searchCat == "1") { srchTaskList.TASKTYPE = 1; srchTaskList.TASKTYPENAME = "High Priority Request List"; long HightPriorityId = oDBContext.CCENUMERATIONs.FirstOrDefault(t => t.TYPE == enumDBType && t.NAME.ToLower().Contains("high")).ID; srchTaskList.CCMEMOLIST = oDBContext.CCMEMOMASTERs.Where(t => t.PRIORITY == HightPriorityId && t.ISOPEN && t.ISACTIVE == true).OrderByDescending(x => x.CREATEDON).ToList(); } else if (searchCat == "2")//when any case is referred to checker 6hours ago { srchTaskList.TASKTYPE = 2; srchTaskList.TASKTYPENAME = "6 Hours Crossed Request"; srchTaskList.CCMEMOLIST = oDBContext.CCMEMOLOGs.Where(t => EntityFunctions.DiffHours(t.CREATEDON, DateTime.Now).Value > 6 && t.CCMEMOMASTER.CCGROUP.GROUPNAME.ToLower().Contains("check") && t.CCMEMOMASTER.CCENUMERATION.NAME.ToLower().Contains("refer") && t.CCMEMOMASTER.ISOPEN && t.CCMEMOMASTER.ISACTIVE).Select(x => x.CCMEMOMASTER).OrderByDescending(x => x.CREATEDON).Distinct().ToList(); } else if (searchCat == "3") { srchTaskList.TASKTYPE = 3; srchTaskList.TASKTYPENAME = "Total Refer Request List"; enumDBType = Convert.ToInt32(Enumaretion.DBEnumType.ActionType); long openActionId = oDBContext.CCENUMERATIONs.FirstOrDefault(t => t.TYPE == enumDBType && t.NAME.ToLower().Contains("open")).ID; long referActionId = oDBContext.CCENUMERATIONs.FirstOrDefault(t => t.TYPE == enumDBType && t.NAME.ToLower().Contains("refer")).ID; srchTaskList.CCMEMOLIST = oDBContext.CCMEMOMASTERs.Where(t => (t.LASTACTIONTYPE == openActionId || t.LASTACTIONTYPE == referActionId) && t.ISOPEN && t.ISACTIVE).OrderByDescending(x => x.CREATEDON).ToList(); } else if (searchCat == "4") { srchTaskList.TASKTYPE = 4; srchTaskList.TASKTYPENAME = "Group Pending Request List"; enumDBType = Convert.ToInt32(Enumaretion.DBEnumType.ActionType); long openActionId = oDBContext.CCENUMERATIONs.FirstOrDefault(t => t.TYPE == enumDBType && t.NAME.ToLower().Contains("open")).ID; long referActionId = oDBContext.CCENUMERATIONs.FirstOrDefault(t => t.TYPE == enumDBType && t.NAME.ToLower().Contains("refer")).ID; srchTaskList.CCMEMOLIST = oDBContext.CCMEMOLOGs.Where(t => !t.CCMEMOMASTER.CCGROUP.GROUPNAME.ToLower().Contains("make") && !t.CCMEMOMASTER.CCGROUP.GROUPNAME.ToLower().Contains("check") && (t.ACTIONTYPE == openActionId || t.ACTIONTYPE == referActionId) && t.CCMEMOMASTER.ISOPEN && t.CCMEMOMASTER.ISACTIVE).Select(x => x.CCMEMOMASTER).Distinct().OrderByDescending(x => x.CREATEDON).ToList(); if (grpId.HasValue) { srchTaskList.TASKTYPE = 4; srchTaskList.CCMEMOLIST = srchTaskList.CCMEMOLIST.Where(t => t.ASSIGNGROUP == grpId).ToList(); srchTaskList.TASKTYPENAME = srchTaskList.CCMEMOLIST[0].CCGROUP.GROUPNAME + " Pending Request List"; } } return(PartialView("_requestListPartial", srchTaskList)); }
public void AddOccupiedTask(CCUSER UId, string TId) { TASKOCCUPIEDINFO oTASKOCCUPIEDINFO = new TASKOCCUPIEDINFO(); oTASKOCCUPIEDINFO.UserId = UId.USERID; oTASKOCCUPIEDINFO.OccupiedBy = UId.EMPLOYEENAME; oTASKOCCUPIEDINFO.BrowserId = Request.Browser.Id.ToString(); oTASKOCCUPIEDINFO.TaskTakenDate = DateTime.Now; oTASKOCCUPIEDINFO.TokenId = TId; oTASKOCCUPIEDINFO.TokenType = "task"; if (oTaskTakenList == null) { oTaskTakenList = new List <TASKOCCUPIEDINFO>(); } oTaskTakenList.Add(oTASKOCCUPIEDINFO); }
public ActionResult EditUser(int id) { ViewBag.GroupList = oDBContext.CCGROUPs.Select(x => x).ToList().Select(x => new SelectListItem { Value = x.ID.ToString(), Text = x.GROUPNAME.ToString() }); ViewBag.RoleList = oDBContext.CCROLEs.Select(x => x).ToList().Select(x => new SelectListItem { Value = x.ID.ToString(), Text = x.ROLENAME.ToString() }); oCCUSER = oDBContext.CCUSERs.FirstOrDefault(t => t.ID == id); return(PartialView("_EditUserPartial", oCCUSER)); }
public ActionResult MenuDetails() { UserInfo oUserInfo = null; if (Session["User"] != null) { CCUSER oCCUSER = (CCUSER)Session["User"]; List <CCROLEMENU> oCCMENUList = new List <CCROLEMENU>(); oCCMENUList = oDBContext.CCROLEMENUs.Where(t => t.ROLEID == oCCUSER.EMPLOYEEROLEID && t.CCMENU.ISACTIVE == true).ToList(); return(PartialView("_UserMenuPartial", oCCMENUList)); } else { return(RedirectToAction("SignIn", "SignIn")); } }
public ActionResult Index() { var User = HttpContext.User; var role = Roles.GetAllRoles(); int enumDBType = 0; enumDBType = Convert.ToInt32(Enumaretion.DBEnumType.PriorityType); long HightPriorityId = oDBContext.CCENUMERATIONs.FirstOrDefault(t => t.TYPE == enumDBType && t.NAME.ToLower().Contains("high")).ID; enumDBType = Convert.ToInt32(Enumaretion.DBEnumType.ActionType); long openActionId = oDBContext.CCENUMERATIONs.FirstOrDefault(t => t.TYPE == enumDBType && t.NAME.ToLower().Contains("open")).ID; long referActionId = oDBContext.CCENUMERATIONs.FirstOrDefault(t => t.TYPE == enumDBType && t.NAME.ToLower().Contains("refer")).ID; //ViewBag.Message = "Modify this template to jump-start your ASP.NET MVC application."; enumDBType = Convert.ToInt32(Enumaretion.DBEnumType.TickerMsg); CCUSER oCCUSER = (CCUSER)Session["User"]; Dashboard oDashboard = new Dashboard(); oDashboard.NewsTicker = oDBContext.CCENUMERATIONs.Where(t => t.TYPE == enumDBType).OrderByDescending(t => t.CREATEDON).ToList(); oDashboard.USERID = oCCUSER.USERID; oDashboard.USERNAME = oCCUSER.EMPLOYEENAME; oDashboard.GROUP = oCCUSER.CCGROUP.GROUPNAME; oDashboard.ROLE = oCCUSER.CCROLE.ROLENAME; oDashboard.UrgentMemo = oDBContext.CCMEMOMASTERs.Where(t => t.PRIORITY == HightPriorityId && t.ISOPEN && t.ISACTIVE).Count(); oDashboard.HourCrossedMemo = oDBContext.CCMEMOLOGs.Where(t => EntityFunctions.DiffHours(t.CREATEDON, DateTime.Now).Value > 6 && t.CCMEMOMASTER.CCGROUP.GROUPNAME.ToLower().Contains("check") && t.CCMEMOMASTER.CCENUMERATION.NAME.ToLower().Contains("refer") && t.CCMEMOMASTER.ISOPEN && t.ISACTIVE).Select(x => x.CCMEMOMASTER).OrderByDescending(x => x.CREATEDON).Distinct().Count(); oDashboard.ReferMemo = oDBContext.CCMEMOMASTERs.Where(t => (t.LASTACTIONTYPE == openActionId || t.LASTACTIONTYPE == referActionId) && t.ISOPEN && t.ISACTIVE).ToList().Count(); var OtherGroupMemo = oDBContext.CCMEMOLOGs.Where(t => !t.CCMEMOMASTER.CCGROUP.GROUPNAME.ToLower().Contains("make") && !t.CCMEMOMASTER.CCGROUP.GROUPNAME.ToLower().Contains("check") && (t.ACTIONTYPE == openActionId || t.ACTIONTYPE == referActionId) && t.CCMEMOMASTER.ISOPEN && t.CCMEMOMASTER.ISACTIVE).Select(x => x.CCMEMOMASTER).Distinct().ToList(); oDashboard.OtherGroupMemo = OtherGroupMemo.Count; oDashboard.OtherGrpList = OtherGroupMemo.GroupBy(t => t.CCGROUP).Select(x => x).ToList().Select(x => new DashGroupTicket { GroupId = x.Key.ID.ToString(), GroupName = x.Key.GROUPNAME, SrchCategory = "4", TotalTicketNo = x.Count().ToString() }).ToList(); return(View(oDashboard)); }
public ActionResult CreateUser() { oCCUSER = new CCUSER(); oCCUSER.ISACTIVE = true; ViewBag.GroupList = oDBContext.CCGROUPs.Select(x => x).ToList().Select(x => new SelectListItem { Value = x.ID.ToString(), Text = x.GROUPNAME.ToString() }); ViewBag.RoleList = oDBContext.CCROLEs.Select(x => x).ToList().Select(x => new SelectListItem { Value = x.ID.ToString(), Text = x.ROLENAME.ToString() }); return(PartialView("_EditUserPartial", oCCUSER)); }
public ActionResult ChangePassword(CCUSER oCCUser, string btnName) { var errors = ModelState.Values.SelectMany(v => v.Errors); try { if (ModelState.IsValid) { oCurrentUser = (CCUSER)Session["User"]; oCCUser.MODIFIEDBY = oCurrentUser.ID; oCCUser.MODIFIEDON = DateTime.Now; oDBContext.Entry(oCCUser).State = EntityState.Modified; oDBContext.SaveChanges(); TempData["SuccessMsg"] = "Data Updated Successfully."; } } catch (Exception ex) { TempData["ErrorMsg"] = "Data is not saved due to " + ExceptionMsg(ex); } return(Redirect("../UserSetting/ChangePasswordProfile/" + oCCUser.ID.ToString())); }
public ActionResult Create(CCUSER oCCUser) { ViewBag.GroupList = oDBContext.CCGROUPs.Select(x => x).ToList().Select(x => new SelectListItem { Value = x.ID.ToString(), Text = x.GROUPNAME.ToString() }); ViewBag.RoleList = oDBContext.CCROLEs.Select(x => x).ToList().Select(x => new SelectListItem { Value = x.ID.ToString(), Text = x.ROLENAME.ToString() }); oCurrentUser = (CCUSER)Session["User"]; oCCUser.ISACTIVE = true; oCCUser.CREATEDBY = oCurrentUser.ID; oCCUser.CREATEDON = DateTime.Now; if (ModelState.IsValid) { try { oDBContext.CCUSERs.Add(oCCUser); oDBContext.SaveChanges(); TempData["SuccessMsg"] = "Data Saved Successfully."; } catch (Exception ex) { TempData["ErrorMsg"] = "Data is not saved due to " + ExceptionMsg(ex); } } else { TempData["ErrorMsg"] = "Data is not complete or in valid format.Please Check..."; } return(View("Create", oCCUser)); }
public ActionResult InsertEditUser(CCUSER oCCUser, HttpPostedFileBase ctrlImage, string btnName) { string UserImagePath = string.Empty; //ctrlImage = Request.Files[0]; var errors = ModelState.Values.SelectMany(v => v.Errors); try { if (ModelState.IsValid) { oCurrentUser = (CCUSER)Session["User"]; if (ctrlImage != null) { var fileName = Path.GetFileName(ctrlImage.FileName); } switch (btnName) { case "create": if (ctrlImage != null) { var path = oCCUser.USERID + "." + Path.GetExtension(ctrlImage.FileName); UserImagePath = path; oCCUser.IMAGEPATH = UserImagePath; } oCCUser.ISACTIVE = true; oCCUser.CREATEDBY = oCurrentUser.ID; oCCUser.CREATEDON = DateTime.Now; oDBContext.CCUSERs.Add(oCCUser); oDBContext.SaveChanges(); if (ctrlImage != null) { ctrlImage.SaveAs(Path.Combine(Server.MapPath("~/Content/UserImage/"), UserImagePath)); } TempData["SuccessMsg"] = "Data Saved Successfully."; break; case "update": if (ctrlImage != null) { var path = oCCUser.USERID + "." + Path.GetExtension(ctrlImage.FileName); UserImagePath = path; oCCUser.IMAGEPATH = UserImagePath; } oCCUser.MODIFIEDBY = oCurrentUser.ID; oCCUser.MODIFIEDON = DateTime.Now; oDBContext.Entry(oCCUser).State = EntityState.Modified; oDBContext.SaveChanges(); if (ctrlImage != null) { ctrlImage.SaveAs(Path.Combine(Server.MapPath("~/Content/UserImage/"), UserImagePath)); } TempData["SuccessMsg"] = "Data Updated Successfully."; break; } } } catch (Exception ex) { TempData["ErrorMsg"] = "Data is not saved due to " + ExceptionMsg(ex); } return(RedirectToAction("Index")); }