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