public List <Group> getGroupID(int?pid) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var result = from t in db.Groups where t.IsActive == true && t.ProjectID == pid select t; return(result.ToList()); }
public ActionResult ViewRoles() { var isReporting = (bool)Session["IsRerportingPerson"]; ModelState.Clear(); int userId = int.Parse(Session["UserID"].ToString()); DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); DSRCManagementSystem.Models.Manage obj = new DSRCManagementSystem.Models.Manage(); List <Manage> RoleValue = new List <Manage>(); var RoleName = MasterEnum.NewuserRole.NewEmployeeRole; ViewBag.RoleName = RoleName; var RoleID = db.Master_Roles.FirstOrDefault(o => o.RoleName == RoleName).RoleID; RoleValue = (from p in db.Master_Roles where (p.IsActive == true) select new Manage() { RoleID = p.RoleID, RoleName = p.RoleName }).ToList(); return(View(RoleValue)); }
public ActionResult ViewRoles(FormCollection form) { List <Manage> RoleValue = new List <Manage>(); if (ModelState.IsValid) { var isReporting = (bool)Session["IsRerportingPerson"]; int userId = int.Parse(Session["UserID"].ToString()); DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); bool status = form["Inactive"].Contains("true"); DSRCManagementSystem.Models.Manage obj = new DSRCManagementSystem.Models.Manage(); if (Convert.ToInt32(Session["RoleID"]) == 59) { RoleValue = (from p in db.Master_Roles select new Manage() { RoleID = p.RoleID, RoleName = p.RoleName }).ToList(); } RoleValue = RoleValue.Distinct().ToList(); return(View(RoleValue)); } else { DSRCManagementSystem.Models.Manage obj = new DSRCManagementSystem.Models.Manage(); return(View(RoleValue)); } }
public ActionResult GetDepartments(int BranchId) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); IEnumerable <SelectListItem> FilterDepart = new List <SelectListItem>(); try { if (BranchId != 0) { List <int> validDepart = new List <int>(); validDepart = db.Departments.Where(d => d.BranchID == BranchId && d.IsActive == true).Select(d => d.DepartmentId).ToList(); FilterDepart = (from lt in db.Departments.Where(o => validDepart.Contains(o.DepartmentId)) select new FilterDepartment() { DepartmentId = lt.DepartmentId, DepartmentName = lt.DepartmentName }).AsEnumerable().Select(m => new SelectListItem() { Value = Convert.ToString(m.DepartmentId), Text = m.DepartmentName }); } return(Json(new SelectList(FilterDepart, "Value", "Text"), JsonRequestBehavior.AllowGet)); } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } return(View()); }
public ActionResult AssignRole() { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var userId = (int)Session["UserId"]; return(View()); }
public string SaveApplicationSetting(EmailConfigure data) { try { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var Host = db.Master_ApplicationSettings.FirstOrDefault(o => o.AppKey == "Host Name"); Host.AppValue = data.Host; var Port = db.Master_ApplicationSettings.FirstOrDefault(o => o.AppKey == "Port"); Port.AppValue = data.Port.ToString(); var UserName = db.Master_ApplicationSettings.FirstOrDefault(o => o.AppKey == "UserName"); UserName.AppValue = data.UserName.Trim(); var Password = db.Master_ApplicationSettings.FirstOrDefault(o => o.AppKey == "Password"); Password.AppValue = data.Password; var From = db.Master_ApplicationSettings.FirstOrDefault(o => o.AppKey == "From"); From.AppValue = data.From.Trim(); var To = db.Master_ApplicationSettings.FirstOrDefault(o => o.AppKey == "To"); To.AppValue = data.To.Trim(); db.SaveChanges(); return("success"); } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); return("failed"); } }
public ActionResult ManageRoll() { try { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var rolldetails = (from u in db.CustomReports where u.IsActive == true select new ReportMOD() { ReportID = u.ReportID, Name = u.ReportName, Description = u.ReportDescription, sp = u.ReportQuery }).ToList(); return(View(rolldetails)); } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); return(Json("Failed", JsonRequestBehavior.AllowGet)); } }
public ActionResult GetProjectMembers(int id) { try { var EmployeeList = new List <SelectListItem>(); using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1()) { var Employees = (from a in db.UserProjects where a.ProjectID == id join b in db.Users on a.UserID equals b.UserID select new { EmployeeId = b.UserID, EmployeeName = (b.FirstName + " " + (b.LastName ?? "")).Trim() }).ToList(); foreach (var item in Employees) { EmployeeList.Add(new SelectListItem { Text = item.EmployeeName, Value = item.EmployeeId.ToString() }); } } return(Json(EmployeeList, JsonRequestBehavior.AllowGet)); } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); throw Ex; } }
private List <SelectListItem> GetRoles() { try { var RoleList = new List <SelectListItem>(new[] { new SelectListItem { Text = "---Select---", Value = "0" } }); using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1()) { List <RoleType> Names = (from data in db.Master_Roles select new RoleType { RoleID = data.RoleID, RoleName = data.RoleName, }).ToList(); foreach (var item in Names) { RoleList.Add(new SelectListItem { Text = item.RoleName, Value = item.RoleID.ToString() }); } } return(RoleList); } catch (Exception ex) { throw ex; } }
public ActionResult EmployeeTimeSheet(EmployeeTimeSheet model) { var selectedtimeSheetData = new List <SelectedTimeSheet>(); try { //int uid = int.Parse(Session["UserID"].ToString()); int pid = Convert.ToInt32(model.ProjectName); using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1()) { selectedtimeSheetData = (from data in dbHrms.TimesheetDatas join userdata in dbHrms.Users on data.UserID equals userdata.UserID join projectdata in dbHrms.Projects on data.ProjectID equals projectdata.ProjectID where data.UserID == model.EmployeeId && data.ProjectID == pid && EntityFunctions.TruncateTime(data.DateOFSheet) >= model.StartDate && EntityFunctions.TruncateTime(data.DateOFSheet) <= model.EndDate select new SelectedTimeSheet() { EmployeeName = ((userdata.FirstName) + " " + (userdata.LastName ?? "")).Trim(), ProjectName = projectdata.ProjectName, Date = data.DateOFSheet, ProjectId = data.ProjectID, UserId = data.UserID }).ToList(); return(Json(selectedtimeSheetData, JsonRequestBehavior.AllowGet)); } } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } return(Json(selectedtimeSheetData, JsonRequestBehavior.AllowGet)); }
public ActionResult ViewTimeSheetValues(string Value) { bool?type = null; var json_serializer = new JavaScriptSerializer(); SelectedTimeSheet val = json_serializer.Deserialize <SelectedTimeSheet>(Value); try { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); type = (from t in db.TimesheetTypes where t.ProjectID == val.ProjectId select t.IsGrouped).SingleOrDefault(); } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } if (type.Value) { return(RedirectToAction("ViewGroupedtimeSheet", new { ProjectId = val.ProjectId, Date = val.Date })); } else { return(RedirectToAction("ViewNonGroupedtimeSheet", new { ProjectId = val.ProjectId, Date = val.Date })); } }
public ActionResult CalculateAggregate(int TrainingID) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); int?Id = TrainingID; db.Sp_FeedbackCalculation(Id); var AggreList = (from fa in db.TrainingFeedbackAggregates join tfc in db.TrainingFeedBackCalcs on fa.TrainingId equals tfc.TrainingId where fa.TrainingId == TrainingID select new FeedbackAggregareModel { ContentRating = fa.ContentRating, PresentRating = fa.PresentRating, FacultyRating = fa.FacultyQRating, OverallRating = fa.OverAllRating, learntinprog = tfc.LearntInPgm }).FirstOrDefault(); //AggreList.Comments = db.TrainingFeedBackCalcs.Where(x => x.TrainingId == TrainingID).Select(o => o.Comments).ToList(); AggreList.Comments = db.TrainingFeedBackCalcs.Where(x => x.TrainingId == TrainingID && x.Comments != "Not given yet ").Select(o => o.Comments).ToList(); AggreList.Learn = db.TrainingFeedBackCalcs.Where(x => x.TrainingId == TrainingID && x.LearntInPgm != "Not given yet ").Select(o => o.LearntInPgm).ToList(); return(View(AggreList)); }
public ActionResult Edit(int TrainingID) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); DateTime myDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day); var obj = (from rc in db.Trainings where rc.IsActive == true && rc.TrainingId == TrainingID join l in db.Master_TrainingLevel on rc.LevelId equals l.LevelId join t in db.Master_TrainingTechnology on rc.TechnologyId equals t.TechnologyId join s in db.Master_TrainingStatus on rc.StatusId equals s.StatusId join i in db.Users on rc.InstructorId equals i.UserID select new ManageTrainingModel() { TrainingID = rc.TrainingId, SeatingCapacity = rc.SeatingCapacity, ScheduledDate = rc.ScheduledDate, Starttime = rc.StartTime, TrainingName = rc.TrainingName, Technology = t.TechnologyName, Level = l.LevelName, Instructor = ((i.FirstName.Length > 0 ? i.FirstName : "") + " " + (i.LastName.Length > 0 ? i.LastName : "")), Nominations = rc.NumberOfNominated, StatusID = rc.StatusId, Status = s.StatusName, Endtime = rc.EndTime, IsToday = (rc.ScheduledDate <= myDate) ? true : false, MailDepartments = rc.MailDepartments, NotifyUsers = rc.NotifyUsers }).OrderByDescending(o => o.ScheduledDate.Value.Year).ThenByDescending(o => o.ScheduledDate.Value.Month).ThenByDescending(o => o.ScheduledDate.Value.Day).FirstOrDefault(); return(View(obj)); }
public List <Master_ColumnTypes> getColumnTypeID() { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var result = from t in db.Master_ColumnTypes select t; return(result.ToList()); }
public static List <TeamMember> GetTeamMemberList(int UserId) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); int BranchId = (int)db.Users.FirstOrDefault(o => o.UserID == UserId).BranchId; List <TeamMember> memberList = new List <TeamMember>(); using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1()) { memberList = (from usr_ropt in dbHrms.UserReportings join usr in dbHrms.Users.Where(o => o.IsActive != false) on usr_ropt.UserID equals usr.UserID where usr_ropt.ReportingUserID == UserId && usr_ropt.UserID != UserId && usr.BranchId == BranchId select new TeamMember() { MemberId = usr.EmpID, MemberName = ((usr.FirstName + " " + usr.LastName) ?? "").Trim() // added on 9/12 }).Where(usr => usr.MemberName != null && usr.MemberName != "").OrderBy(o => o.MemberName).ToList(); memberList.Insert(0, new TeamMember() { MemberId = "0", MemberName = "All" } ); return(memberList); } }
public static List <MenuList> GetMenuList() { List <DSRCManagementSystem.Models.MenuList> menulist = new List <DSRCManagementSystem.Models.MenuList>(); using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1()) { //menulist = (from function_module in db.FunctionModules // join modules in db.Modules on function_module.PageModuleID equals modules.PageModuleID // select new DSRCManagementSystem.Models.MenuList // { // FunctionId = function_module.FunctionID, // PageModuleId = function_module.PageModuleID, // ModuleName = modules.ModuleName // }).OrderBy(x => x.FunctionId).ToList(); menulist = (from function_module in db.FunctionModules join modules in db.Modules on function_module.PageModuleID equals modules.PageModuleID join defaultmodulesceorder in db.DefaultModulePrecedanceOrders on modules.PageModuleID equals defaultmodulesceorder.PageModuleID where modules.IsActive == true orderby defaultmodulesceorder.PreceedanceOrder ascending select new DSRCManagementSystem.Models.MenuList { FunctionId = function_module.FunctionID, PageModuleId = function_module.PageModuleID, ModuleName = modules.ModuleName }).ToList(); } return(menulist); }
public ActionResult SendMail() { EmailConfigure MailObj = new EmailConfigure(); try{ DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var AppSettings = db.Master_ApplicationSettings.Select(o => o).ToList(); MailObj.Host = AppSettings.FirstOrDefault(o => o.AppKey == "Host Name").AppValue; MailObj.Port = Convert.ToInt32(AppSettings.FirstOrDefault(o => o.AppKey == "Port").AppValue); MailObj.UserName = AppSettings.FirstOrDefault(o => o.AppKey == "UserName").AppValue; MailObj.Password = AppSettings.FirstOrDefault(o => o.AppKey == "Password").AppValue; MailObj.ConfirmPassword = AppSettings.FirstOrDefault(o => o.AppKey == "Password").AppValue; MailObj.From = AppSettings.FirstOrDefault(o => o.AppKey == "From").AppValue; MailObj.To = AppSettings.FirstOrDefault(o => o.AppKey == "To").AppValue; } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } return(View(MailObj)); }
public ActionResult AddExpenditure() { List <DSRCManagementSystem.Models.Expenditure> UserList = new List <DSRCManagementSystem.Models.Expenditure>(); try { int ExpenditureId = Convert.ToInt32(Session["ExpenditureID"]); ModelState.Clear(); DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); DSRCManagementSystem.Models.Expenditure objUser = new DSRCManagementSystem.Models.Expenditure(); UserList = (from u in db.Expenditures.Where(o => o.IsActive != false) select new DSRCManagementSystem.Models.Expenditure() { ExpenditureID = u.ExpenseID, ExpenseDescription = u.ExpenseDescription, ExpenseDate = u.ExpenseDate, ExpenseAmount = u.ExpenseAmount, IsActive = u.IsActive, CreatedAt = u.CreatedAt, }).OrderByDescending(o => o.ExpenseDate.Value.Year) .ThenByDescending(o => o.ExpenseDate.Value.Month) .ThenByDescending(o => o.ExpenseDate.Value.Day) .ToList(); } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } return(View(UserList)); }
public ActionResult ChangeColor(string ColorId) { int ID = 0; DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); try { if (ColorId == "") { ID = 1; } else { ID = Convert.ToInt32(ColorId); } var Themecolor = objdb.Master_ApplicationSettings.Where(x => x.AppID == 6).Select(o => o).FirstOrDefault(); if (Themecolor != null) { Themecolor.AppValue = objdb.Master_ThemeColors.Where(x => x.ColorId == ID).Select(o => o.ColorName).FirstOrDefault(); objdb.SaveChanges(); Session["Theme"] = Themecolor.AppValue; } } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } return(Json(ID, JsonRequestBehavior.AllowGet)); }
public static List <WorkData> GetTimeWorked(int userId) { try { using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1()) { var UserDetails = dbHrms.Users.FirstOrDefault(x => x.UserID == userId); var EmpId = UserDetails.EmpID; var BranchId = UserDetails.BranchId; DateTime dt1 = DateTime.Parse(TimeSpan.FromMinutes(330).ToString()); DateTime dt2 = DateTime.Parse(TimeSpan.FromMinutes(330).ToString()); var WorkingHoursData = dbHrms.TimeManagements.Where(x => x.EmpID == EmpId && x.BranchId == BranchId).OrderByDescending(x => x.Date).Take(10).Select(x => new WorkData { Date = EntityFunctions.TruncateTime(x.Date) ?? DateTime.Now, //minsWorked = x.OutTimeMin == 0 ? null : x.OutTimeMin - x.InTimeMin, minsWorked = x.TotalTime == 0 ? null : x.TotalTime, //Convert.ToInt32(Convert.ToDateTime(InTime).TimeOfDay.TotalMinutes); IsOutEntry = (x.OutTimeMin != 0), IsAbsent = (x.OutTimeMin == 0 && x.InTimeMin == 0), InTime = x.InTime, OutTime = x.OutTime, InTmieMin = x.InTimeMin }).ToList(); return(WorkingHoursData); } } catch { return(new List <WorkData>()); } }
public ActionResult ReportsPermission(List <int> From, List <int> To) { try { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var deleteuser = db.ReportsPermissions.Where(x => x.IsAuthorized == true).Select(o => o).ToList(); foreach (var deluser in deleteuser) { db.ReportsPermissions.DeleteObject(deluser); } db.SaveChanges(); for (int j = 0; j < To.Count(); j++) { DSRCManagementSystem.ReportsPermission objaccess = new DSRCManagementSystem.ReportsPermission(); objaccess.UserId = To[j]; objaccess.IsAuthorized = true; db.AddToReportsPermissions(objaccess); db.SaveChanges(); } return(Json("Authorize", JsonRequestBehavior.AllowGet)); } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); return(Json("Failed", JsonRequestBehavior.AllowGet)); } }
public static List <MessageUpdates> GetMessages(int userId) { try { using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1()) { DateTime currentDate = DateTime.Now; //EntityFunctions.TruncateTime(x.DateTimeStart) == currentDate.Date var Messages = dbHrms.UserMessages.Where(user => user.EmployeeId == userId && user.Status == null).Join(dbHrms.communicationMessages. Where(x => (EntityFunctions.TruncateTime(x.Valid_From) <= currentDate.Date && EntityFunctions.TruncateTime(x.Valid_To) >= currentDate.Date)), x => x.MessageId, y => y.MessageId, (x, y) => new MessageUpdates() { messageId = y.MessageId, messageText = y.MessageText.Replace("<br />", "\n"), messageType = (commMessageType)y.MessageType, showComments = y.ShowComments, Comments = x.Comments ?? "" } ).ToList(); return(Messages); } } catch { return(new List <MessageUpdates>()); } }
public ActionResult Delete(int ID) { using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1()) { var obj = db.Assets.FirstOrDefault(x => x.AssetID == ID); obj.ISDelete = true; db.SaveChanges(); var obj1 = db.Assets.Where(x1 => x1.AssetID == ID).Select(s => s.Name_Model_No).FirstOrDefault(); string va = Convert.ToString(obj1); var obj2 = db.Assets.Where(c => c.Name_Model_No == va).ToList(); foreach (var items in obj2) { var update = db.Assets.Where(x => x.AssetID == items.AssetID).FirstOrDefault(); update.Name_Model_No = null; TryUpdateModel(update); db.SaveChanges(); } bool exis = db.ComputerAssigneds.Any(s => s.UPSID == obj1); if (exis) { var updateComputer = db.ComputerAssigneds.Where(m => m.UPSID == obj1).ToList(); foreach (var items in updateComputer) { var update = db.ComputerAssigneds.Where(m => m.Assignid == items.Assignid).FirstOrDefault(); update.UPSID = null; TryUpdateModel(update); db.SaveChanges(); } } db.SaveChanges(); return(Json("Success", JsonRequestBehavior.AllowGet)); } }
public static List <ViewMessage> ViewMessage(int UserId, int messageid) { dynamic messages; using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1()) { messages = (from message in dbHrms.communicationMessages.Where(o => o.UserID == UserId) join usermessage in dbHrms.UserMessages.Where(o => o.Comments != null || o.Comments == null) on message.MessageId equals usermessage.MessageId join user in dbHrms.Users on usermessage.EmployeeId equals user.UserID select new ViewMessage { UserId = user.UserID, MessageId = message.MessageId, UserName = user.FirstName + " " + user.LastName, Message = message.MessageText.Replace("<br />", "\n"), Comment = usermessage.Comments, MessageinitiatesDate = EntityFunctions.TruncateTime(message.Valid_From), MessageValidUpto = EntityFunctions.TruncateTime(message.Valid_To), Isreplyable = message.ShowComments, IsYesOrNo = usermessage.IsYesPressed, MessageType = message.MessageType //}).Where(o => o.MessageId == messageid).ToList(); }).OrderByDescending(o => o.MessageinitiatesDate).ToList(); } return(messages); }
public ActionResult AssignNewRoles(AssignRole model) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var UserIDs = model.unemployees.Split(','); var DataId = model.RoleID; var Data = Convert.ToInt32(DataId); foreach (string userID in UserIDs) { int RoleID = Convert.ToByte(Data); int UserID = Convert.ToInt32(userID); var x = db.UserRoles.Where(o => o.UserID == UserID).ToList(); foreach (var y in x) { db.UserRoles.DeleteObject(y); db.SaveChanges(); var user = db.UserRoles.CreateObject(); int z = Convert.ToInt32(y.UserID); user.UserID = z; user.RoleID = db.Master_Roles.FirstOrDefault(o => o.RoleName == MasterEnum.NewuserRole.NewEmployeeRole).RoleID; db.UserRoles.AddObject(user); db.SaveChanges(); } } return(Json("Success", JsonRequestBehavior.AllowGet)); }
public static List <ViewMessage> GetNewMessageOnly() // public static ViewMessage GetNewMessageOnly() { dynamic messages; using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1()) { messages = (from message in dbHrms.communicationMessages join usermessage in dbHrms.UserMessages on message.MessageId equals usermessage.MessageId join user in dbHrms.Users on usermessage.EmployeeId equals user.UserID // where usermessage.time>= EntityFunctions.AddSeconds(DateTime.Now,-3) select new ViewMessage { UserId = user.UserID, UserName = user.FirstName + " " + user.LastName, Message = message.MessageText.Replace("<br />", "\n"), Comment = usermessage.Comments, MessageinitiatesDate = EntityFunctions.TruncateTime(message.Valid_From).Value, MessageValidUpto = EntityFunctions.TruncateTime(message.Valid_To), Isreplyable = message.ShowComments, IsYesOrNo = usermessage.IsYesPressed, MessageType = message.MessageType //}).ToList(); }).OrderByDescending(o => o.MessageinitiatesDate).ToList(); } return(messages); }
public ActionResult EditRole(Manage model) { DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); var Name = model.Name.Trim(); int ID = model.ID; var temp = objdb.Master_Roles.Where(r => r.RoleID != ID && r.IsActive == true).Select(f => f.RoleName); foreach (var Edit in temp) { if (Edit == Name) { ModelState.AddModelError("RoleName", "Role Name Already Exists"); @ViewBag.ID = ID; return(Json("Warning", JsonRequestBehavior.AllowGet)); } } //if (temp == Name) //{ // ModelState.AddModelError("RoleName", "Role Name Already Exists"); // @ViewBag.ID = ID; // return Json("Warning", JsonRequestBehavior.AllowGet); //} //else { var x = objdb.Master_Roles.Where(o => o.RoleID == ID).FirstOrDefault(); x.RoleName = Name; objdb.SaveChanges(); } return(Json("Success1", JsonRequestBehavior.AllowGet)); }
public static void SendMessage(communicationModel commModel, DateTime validFrom, DateTime validTo, int UserID) { using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1()) { communicationMessage commMessage = new communicationMessage(); commMessage.MessageText = commModel.Message.Replace(System.Environment.NewLine, "<br />"); commMessage.UserID = UserID; commMessage.ShowComments = commModel.showComments; commMessage.ShowToAll = commModel.showToAll; commMessage.Valid_From = validFrom /*commModel.dateFrom*/; commMessage.Valid_To = validTo /*commModel.dateTo*/; commMessage.MessageType = commModel.messageTypeId; dbHrms.AddTocommunicationMessages(commMessage); dbHrms.SaveChanges(); //commModel.selectedMembers.ForEach(x => commModel.UserList.ForEach(x => { UserMessage userMessage = new UserMessage(); userMessage.EmployeeId = Convert.ToInt32(x); userMessage.MessageId = commMessage.MessageId; dbHrms.AddToUserMessages(userMessage); dbHrms.SaveChanges(); }); } }
public List <Master_ProjectTypes> GetProjectTypeList() { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var projectTypes = from t in db.Master_ProjectTypes select t; return(projectTypes.ToList()); }
private List <SelectListItem> GetProjects() { try { var ProjectList = new List <SelectListItem>(); using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1()) { int UserID = int.Parse(Session["UserID"].ToString()); List <DSRCProjects> projects = (from usrproj in db.UserProjects join proj in db.Projects on usrproj.ProjectID equals proj.ProjectID where usrproj.UserID == UserID select new DSRCProjects { ProjectId = usrproj.ProjectID, ProjectName = proj.ProjectName }).ToList(); foreach (var item in projects) { ProjectList.Add(new SelectListItem { Text = item.ProjectName, Value = item.ProjectId.ToString() }); } } return(ProjectList); } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); throw Ex; } }