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 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 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 ActionResult AddLabel(Label model) { try { var userId = (int)Session["UserId"]; var BranchId = db.Users.Where(r => r.UserID == userId).Select(f => f.BranchId).FirstOrDefault(); var Name = model.LabelName.Trim(); var LabelName = db.Dictionaries.Where(r => r.Name == Name && r.IsActive == true).Select(f => f.Name); foreach (var dpt in LabelName) { if (dpt != null) { return(Json("Warning", JsonRequestBehavior.AllowGet)); } } { var Assignobj = db.Dictionaries.CreateObject(); Assignobj.Name = Name; Assignobj.IsActive = true; db.Dictionaries.AddObject(Assignobj); db.SaveChanges(); } } 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("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 ActionResult AddSkills(Skills Model) { var Id = Model.Id; var Technology = Model.Technology.Trim(); var temp = db.SkillsSpecifications.Where(r => r.Specification == Technology && r.IsActive == true).Select(f => f.Specification); foreach (var check in temp) { if (check == Technology) { return(Json("Warning", JsonRequestBehavior.AllowGet)); } if (check.ToLower() == Technology.ToLower()) { return(Json("Warning", JsonRequestBehavior.AllowGet)); } if (check.ToUpper() == Technology.ToUpper()) { return(Json("Warning", JsonRequestBehavior.AllowGet)); } } { var Assignobj = db.SkillsSpecifications.CreateObject(); Assignobj.Specification = Technology; Assignobj.IsActive = true; db.SkillsSpecifications.AddObject(Assignobj); db.SaveChanges(); } return(Json("Success", JsonRequestBehavior.AllowGet)); }
public ActionResult ManageActivities(ManageActivities model) { try{ var ActivityName = model.ActivityName.Trim(); var ActivityDescription = model.ActivityDescription.Trim(); var temp = db.Activities.Where(r => r.Activity1 == ActivityName && r.IsActive == true).Select(f => f.Activity1); foreach (var check in temp) { if (check == ActivityName) { return(Json("Warning", JsonRequestBehavior.AllowGet)); } } { var Assignobj = db.Activities.CreateObject(); Assignobj.Activity1 = ActivityName; Assignobj.ActivityDescription = ActivityDescription; db.Activities.AddObject(Assignobj); db.SaveChanges(); } } 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("Success", JsonRequestBehavior.AllowGet)); }
public ActionResult Feedback(FeedbackModel model) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); int UserID = Convert.ToInt32(Session["UserID"]); int Id = Convert.ToInt32(model.TrainingId); try { // var Req_Feedback = db.TrainingFeedBackCalcs.CreateObject(); //var Req_Feedback = db.TrainingFeedBackCalcs.FirstOrDefault(o => o.TrainingId == Id && o.UserId == UserID); var Req_Feedback = db.TrainingFeedBackCalcs.Where(o => o.TrainingId == Id && o.UserId == UserID).Select(o => o).FirstOrDefault(); Req_Feedback.TrainingId = Id; Req_Feedback.UserId = UserID; Req_Feedback.ChoiceTopic = model.Choice; Req_Feedback.PgmRelevance = model.Relevance; Req_Feedback.ContentAmt = model.AmountofCourse; Req_Feedback.AdequacyLearning = model.AdeqofLearning; Req_Feedback.AdequacyPreparation = model.AdeqofPreparation; Req_Feedback.ExampleDemo = model.EXpofConcepts; Req_Feedback.ContentPresented = model.contentPres; Req_Feedback.TimeMaintanence = model.Timemain; Req_Feedback.Flag = true; Req_Feedback.LearntInPgm = model.Learn; Req_Feedback.FacultyQuality = model.Quality; Req_Feedback.PgmUseful = (model.PrgUseful == 1) ? true : false; Req_Feedback.Comments = model.Suggestions; int? total = model.Choice + model.Relevance + model.AmountofCourse + model.AdeqofLearning + model.AdeqofPreparation + model.EXpofConcepts + model.contentPres + model.Timemain + model.Quality; float overall = Convert.ToSingle(total) / (9 * 5); float overallperc = overall * 100; Req_Feedback.Overall = overall; Req_Feedback.OverallPerc = overallperc; // db.TrainingFeedBackCalcs.AddObject(Req_Feedback); db.SaveChanges(); int Feedback_Status = db.TrainingFeedBackCalcs.Count(o => o.Flag == false && o.TrainingId == Id); if (Feedback_Status == 0) { var TrainingRef = db.Trainings.FirstOrDefault(o => o.TrainingId == Id); TrainingRef.StatusId = 6; db.SaveChanges(); } } 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("success", JsonRequestBehavior.AllowGet)); }
public ActionResult Report(ReportMOD model) { try{ DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); var Name = model.Name.Trim(); var checkname = objdb.CustomReports.Where(x => x.ReportName == Name && x.IsActive == true).Select(o => o.ReportID).FirstOrDefault(); if (checkname != 0) { return(Json("Warning", JsonRequestBehavior.AllowGet)); } var Desc = ""; if (model.Description != null) { Desc = model.Description.Trim(); } var sp = model.sp; var userId = (int)Session["UserId"]; var ReturnDate = System.DateTime.Now; var roles = model.roles.Split(','); var Parameter = model.Parameter; DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var Assignobj = objdb.CustomReports.CreateObject(); Assignobj.ReportName = Name; Assignobj.ReportDescription = Desc; Assignobj.ReportQuery = sp; Assignobj.CreatedBy = Convert.ToString(userId); Assignobj.CreatedDate = ReturnDate; Assignobj.IsActive = true; objdb.CustomReports.AddObject(Assignobj); objdb.SaveChanges(); model.ReportID = Assignobj.ReportID; var roles1 = model.roles.Split(','); foreach (string userID in roles1) { var Function = objdb.CustomReports_UserMapping.CreateObject(); Function.ReportID = model.ReportID; Function.RoleID = Convert.ToInt32(userID); objdb.CustomReports_UserMapping.AddObject(Function); objdb.SaveChanges(); } } 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("Success", JsonRequestBehavior.AllowGet)); }
public ActionResult AssignNewRole(AssignRole model) { var userId = (int)Session["UserId"]; DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); int BranchId = (int)db.Users.FirstOrDefault(o => o.UserID == userId).BranchId; var userIDs1 = model.unuserid; var UserIDs = model.multiselectemployees.Split(','); var DataId = model.RoleID; var Data = Convert.ToInt32(DataId); List <int> UserID = model.SelectedEmpList; var RoleName = MasterEnum.NewuserRole.NewEmployeeRole; var RoleID = db.Master_Roles.FirstOrDefault(o => o.RoleName == RoleName).RoleID; var employees1 = (from rc in db.Users join p in db.UserRoles on rc.UserID equals p.UserID join r in db.Master_Roles on p.RoleID equals r.RoleID //where (rc.FirstName != null && rc.LastName != null && p.RoleID == Data && r.RoleID != RoleID && rc.BranchId == BranchId) where (p.RoleID == Data && r.RoleID != RoleID && rc.BranchId == BranchId) select new AssignRole() { userid = rc.UserID, }).Distinct().ToList(); List <int> ex = UserID.Except(employees1.Select(e => e.userid)).ToList(); foreach (int userID1 in ex) { var x = db.UserRoles.Where(o => o.UserID == userID1).ToList(); foreach (var y in x) { db.UserRoles.DeleteObject(y); db.SaveChanges(); } } foreach (int userID in ex) { var Assignobj = db.UserRoles.CreateObject(); Assignobj.RoleID = Convert.ToByte(Data); Assignobj.UserID = Convert.ToInt32(userID); db.UserRoles.AddObject(Assignobj); db.SaveChanges(); var UpdateRoleID = db.Users.Where(o => o.UserID == userID).Select(o => o).FirstOrDefault(); if (UpdateRoleID != null) { UpdateRoleID.RoleID = Convert.ToByte(Data); } db.SaveChanges(); } return(Json("Success", JsonRequestBehavior.AllowGet)); }
//public ActionResult FinalizeDefaultTemplate(int ProjectID) //{ // return Json(true, JsonRequestBehavior.AllowGet); //} public ActionResult FinalizeDefaultTemplate() { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); try { var ProjectId = Convert.ToInt32(Session["projectID"].ToString()); var typobj = db.TimesheetTypes.Where(o => o.ProjectID == ProjectId).Select(o => o).FirstOrDefault(); if (typobj == null) { var dataobj = new TimesheetType(); dataobj.ProjectID = ProjectId; dataobj.IsGrouped = false; db.TimesheetTypes.AddObject(dataobj); } else { typobj.IsGrouped = false; } db.SaveChanges(); List <Column> defaultcolumnlist = db.DefaultTemplates.Select(o => new Column { ColumnName = o.ColumnName, ColumnTypeId = o.ColumnTypeID }).ToList(); string columnname; foreach (var item in defaultcolumnlist) { columnname = item.ColumnName.Contains(" ") ? item.ColumnName.Replace(" ", "") : item.ColumnName; var timesheetcolumnobj = db.TimeSheetColumns.CreateObject(); timesheetcolumnobj.ProjectID = ProjectId; timesheetcolumnobj.ColumnNames = columnname; timesheetcolumnobj.ColumnDisplayName = item.ColumnName; timesheetcolumnobj.ColumnTypeID = item.ColumnTypeId; timesheetcolumnobj.IsActive = true; db.TimeSheetColumns.AddObject(timesheetcolumnobj); db.SaveChanges(); } } 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(true, JsonRequestBehavior.AllowGet)); }
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 EditTime(EditTimeEntry model) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); try { if (ModelState.IsValid) { var obj = (from tim_mng in db.TimeManagements where tim_mng.EmpID == model.EmployeeId && tim_mng.BranchId == model.BranchID && EntityFunctions.TruncateTime(tim_mng.Date) == EntityFunctions.TruncateTime(model.Date) select tim_mng ).FirstOrDefault(); obj.InTime = model.InTime; obj.OutTime = model.OutTime; var inTime = DateTime.Parse(model.InTime); var outTime = DateTime.Parse(model.OutTime); obj.InTimeMin = (inTime.Hour * 60) + inTime.Minute; obj.OutTimeMin = (outTime.Hour * 60) + outTime.Minute; obj.TotalTime = obj.OutTimeMin - obj.InTimeMin; db.SaveChanges(); return(Json(true, 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(model)); }
public ActionResult EditSkills(Skills Model) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); int Id = Model.Id; string Technology = Model.Technology.Trim(); var data = db.SkillsSpecifications.Where(o => o.SpecificationId != Id && o.IsActive == true).Select(o => o.Specification); foreach (var check in data) { if (check == Technology) { return(Json("Warning", JsonRequestBehavior.AllowGet)); } if (check.ToLower() == Technology.ToLower()) { return(Json("Warning", JsonRequestBehavior.AllowGet)); } if (check.ToUpper() == Technology.ToUpper()) { return(Json("Warning", JsonRequestBehavior.AllowGet)); } } var datas = db.SkillsSpecifications.Where(o => o.SpecificationId == Id).Select(o => o).FirstOrDefault(); { datas.Specification = Technology; db.SaveChanges(); } return(Json("Success1", JsonRequestBehavior.AllowGet)); }
public ActionResult EditVehicle(AddVehicle model, string Contact_No, string vehicleid) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); if (vehicleid != null) { int vechid = Convert.ToInt32(vehicleid); } var value = db.Vehicles.Where(x => x.VehicleId == model.vehicleid).Select(o => o).FirstOrDefault(); value.VehicleBrand_Id = Convert.ToInt32(model.VehicleBrand); value.VehicleType_Id = Convert.ToInt32(model.VehicleType); value.VehicleModel_Id = Convert.ToInt32(model.VehicleModel); value.VehicleMake = model.VehicleMake; value.Vehicle_Remarks = model.Remarks; value.Model_Year = model.Model_Year; value.No_of_Seat = model.No_of_Seat; value.No_of_Trip = model.Trip; if (value.Vehicle_Photo != null) { value.Vehicle_Photo = true; } db.SaveChanges(); return(Json("Success1", JsonRequestBehavior.AllowGet)); }
public ActionResult Delete(string Id) { int id = Convert.ToInt32(Id); DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); DSRCManagementSystem.Models.Transportation objmodel = new DSRCManagementSystem.Models.Transportation(); //var value = objdb.ManageExpense_Mapping.Where(x => x.VehicleId == id).Select(o => o.ManageExpenseId).FirstOrDefault(); //var objvalue = objdb.ManageExpenses.Where(x => x.ManageExpenseId == id && x.Isactive == true).Select(o => o).FirstOrDefault(); //// var type = objdb.Master_ExpenseType.Where(x => x.ExpenseType_Id == objvalue.ExpenseType).Select(o => o.ExpenseType).FirstOrDefault(); //objvalue.Isactive = false; var objvalue = objdb.ManageExpenses.Where(x => x.ManageExpenseId == id && x.Isactive == true).Select(o => o).FirstOrDefault(); // var type = objdb.Master_ExpenseType.Where(x => x.ExpenseType_Id == objvalue.ExpenseType).Select(o => o.ExpenseType).FirstOrDefault(); var values = objdb.ManageExpense_Mapping.Where(x => x.ManageExpenseId == objvalue.ManageExpenseId).Select(o => o).FirstOrDefault(); objdb.ManageExpense_Mapping.DeleteObject(values); objvalue.Isactive = false; objdb.SaveChanges(); return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); }
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 ActionResult Add(DSRCManagementSystem.Models.Category objmodel) { DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); DSRCManagementSystem.Category obj = new DSRCManagementSystem.Category(); try { obj.CategoryName = objmodel.CategoryName.Trim(); obj.IsActive = true; objdb.AddToCategories(obj); if (!objdb.Categories.Any(cobj => cobj.IsActive == true && cobj.CategoryName.Trim() == obj.CategoryName.Trim())) { objdb.SaveChanges(); } else { return(Json(new { Result = "Already", URL = @Url.Action("AlertPopUp", "Popup") }, 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(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); }
public ActionResult EditCheckList(DSRCManagementSystem.Models.Checklist objmodel) { DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); var res = ""; try { objmodel.CheckListID = Convert.ToInt32(Session["CategoryId"]); var value = objdb.CheckLists.Where(x => x.CheckListID == objmodel.CheckListID).Select(o => o).FirstOrDefault(); if (!objdb.CheckLists.Any(cobj => cobj.IsActive == true && cobj.CheckListName.Trim() == objmodel.CheckListName.Trim())) { value.CheckListName = objmodel.CheckListName; objdb.SaveChanges(); res = "Success"; } else { // return Json(new { Result = "Already", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet); res = "Already"; } } 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(new { Result = res, URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); }
public ActionResult Delete(int ID) { try{ DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var obj = db.computermanagements.Where(x => x.managementid == ID).FirstOrDefault(); obj.ISDelete = true; var obj1 = db.ComputerAssigneds.Where(x => x.Managementid == ID).FirstOrDefault(); if (obj1 != null) { if (obj.managementid == obj1.Managementid) { obj1.ISDelete = true; } } db.SaveChanges(); } 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("Success", JsonRequestBehavior.AllowGet)); }
public ActionResult Edit(ManageComputers model) { try { using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1()) { var obj_Comp = db.computermanagements.Where(o => o.managementid == model.ID).Select(o => o).FirstOrDefault(); obj_Comp.Manufacturer = model.Manufacturer; obj_Comp.CPUID = model.CPUID; obj_Comp.MonitorID = model.MonitorID; obj_Comp.OsId = Convert.ToInt32(model.OS); obj_Comp.Memory = model.Memory; obj_Comp.cpu = model.CPU; obj_Comp.ComputerStatusNew = model.ComputerStatus; obj_Comp.ComputerName = model.ComputerName; obj_Comp.IP = model.IP; db.SaveChanges(); return(Json("Success", 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("Success", JsonRequestBehavior.AllowGet)); }
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 ActionResult RejectRequestEmail(int Id) { int UId = Convert.ToInt32(System.Web.HttpContext.Current.Application["Id"]); var userId = (int)Session["UserId"]; try { using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1()) { var obj_server = db.Skills.Where(o => o.Id == Id).Select(o => o).FirstOrDefault(); ViewBag.IsApproved = obj_server.status == 1 ? true : false; ViewBag.IsRejected = obj_server.status == 3 ? true : false; ViewBag.IsCancelled = obj_server.status == 4 ? true : false; if (ViewBag.IsApproved == false && ViewBag.IsRejected == false && ViewBag.IsCancelled == false) { obj_server.status = 3; obj_server.ApprovedBy = userId; obj_server.ApprovedDate = DateTime.Now; db.SaveChanges(); } } return(View()); } 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 AddExpense(DSRCManagementSystem.Models.Transportation objmodel) { DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); DSRCManagementSystem.ManageExpens objexp = new DSRCManagementSystem.ManageExpens(); DSRCManagementSystem.ManageExpense_Mapping objmap = new DSRCManagementSystem.ManageExpense_Mapping(); //var num =Convert.ToInt32(objmodel.VehicleNumber); var vehicleid = objdb.Vehicles.Where(x => x.Vehicle_No == objmodel.VehicleNumber && x.IsActive == true).Select(o => o.VehicleId).FirstOrDefault(); var objalready = objdb.ManageExpense_Mapping.Where(x => x.VehicleId == vehicleid).Select(o => o.ManageExpenseId).ToList(); if (objalready != null) { for (int i = 0; i < objalready.Count(); i++) { var value = Convert.ToInt32(objalready[i]); int?already = objdb.ManageExpenses.Where(x => x.ManageExpenseId == value && x.Isactive == true).Select(o => o.ExpenseType).FirstOrDefault(); if (already == Convert.ToInt32(objmodel.ExpenseType)) { return(Json(new { Result = "Already", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); } } } objexp.Date = DateTime.Now; objexp.Cost = objmodel.Cost; objexp.ExpenseType = Convert.ToInt32(objmodel.ExpenseType); objexp.Isactive = true; objdb.AddToManageExpenses(objexp); objdb.SaveChanges(); objmap.ManageExpenseId = objexp.ManageExpenseId; objmap.VehicleId = vehicleid; objdb.AddToManageExpense_Mapping(objmap); objdb.SaveChanges(); return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); }
public ActionResult addnew(DSRCManagementSystem.Models.ManageDrivers objmanage) { var DriverName = db.Master_DriverType.ToList(); ViewBag.DriverTypeList = new SelectList(DriverName, "DriverType_Id", "DriverType"); var BloodGroup = db.Master_BloodGroup.ToList(); ViewBag.BloodGroupList = new SelectList(BloodGroup, "BloodGroupID", "BloodGroupName"); var Gender = db.Master_Gender.ToList(); ViewBag.GenderList = new SelectList(Gender, "GenderID", "GenderName"); DSRCManagementSystem.Models.ConvertByte objcb = new Models.ConvertByte(); var picture = objcb.ConvertToBytes(objmanage.Pictures); var Doc = objcb.ConvertToBytes(objmanage.Documents); if (ModelState.IsValid) { var driver = db.Drivers.CreateObject(); driver.First_Name = objmanage.First_Name; driver.Last_Name = objmanage.Last_Name; driver.DOB = objmanage.DOB; driver.Gender = objmanage.Gender; driver.Driver_Licence_No = objmanage.Driver_Licence_No; driver.Driver_Licence_Expire_Date = objmanage.Driver_Licence_Expire_Date; driver.DriverType_Id = objmanage.DriverType_Id; driver.Email_Id = objmanage.Email_Id; driver.Contact_No = objmanage.Contact_No; driver.Blood_Group = objmanage.Blood_Group; driver.Communication_Address = objmanage.Communication_Address; driver.Driver_Batch_No = objmanage.Driver_Batch_No; driver.IsActive = true; driver.Photo = picture; driver.Document_Proof = Doc; db.Drivers.AddObject(driver); db.SaveChanges(); } return(Json("Success", JsonRequestBehavior.AllowGet)); //return RedirectToAction("Manage", "ManageDrivers"); }
public ActionResult AddVehicle(AddVehicle model, string Contact_No) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); // DSRCManagementSystem.Models.AddsVehicle objvehicle = new DSRCManagementSystem.Models.AddsVehicle(); DSRCManagementSystem.Vehicle objvehicle = new DSRCManagementSystem.Vehicle(); try { if (db.Vehicles.Any(R => R.Vehicle_No == model.Vehicle_No)) { ModelState.AddModelError("Vehicle_No", "Vehicle Number Already Exists"); return(Json("Warning", JsonRequestBehavior.AllowGet)); } else if (model.Vehicle_No == null) { ModelState.AddModelError("Vehicle_No", "Vehicle_No"); } else { var value = db.Vehicles.Where(x => x.VehicleId == model.vehicleid).Select(o => o).FirstOrDefault(); objvehicle.Vehicle_No = model.Vehicle_No; objvehicle.VehicleMake = model.VehicleMake; objvehicle.Vehicle_Remarks = model.Remarks; objvehicle.VehicleBrand_Id = Convert.ToInt32(model.VehicleBrand); objvehicle.VehicleType_Id = Convert.ToInt32(model.VehicleType); objvehicle.VehicleModel_Id = Convert.ToInt32(model.VehicleModel); objvehicle.Model_Year = model.Model_Year; objvehicle.No_of_Seat = model.No_of_Seat; objvehicle.No_of_Trip = model.Trip; objvehicle.IsActive = true; if (model.Vehicle_Photo != null) { objvehicle.Vehicle_Photo = true; } objvehicle.Contact_No = model.Contact_No; db.AddToVehicles(objvehicle); db.SaveChanges(); } } 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("Success1", JsonRequestBehavior.AllowGet)); }
public ActionResult AddNewComputer(ManageComputers model, string cmpname) { try { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var Already = db.computermanagements.Where(x => x.ComputerName == model.ComputerName && x.ISDelete == false).Select(o => o).FirstOrDefault(); if (Already != null) { return(Json("Already", JsonRequestBehavior.AllowGet)); } else { if (ModelState.IsValid) { // DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); if (model.ComputerStatus == "1") { model.ComputerStatus = "Active"; } else { model.ComputerStatus = "Inactive"; } var Compobj = db.computermanagements.CreateObject(); Compobj.Manufacturer = model.Manufacturer.Trim(); Compobj.CPUID = model.CPUID.Trim(); Compobj.MonitorID = model.MonitorID.Trim(); Compobj.Memory = model.Memory; Compobj.ComputerStatusNew = model.ComputerStatus; Compobj.ComputerName = model.ComputerName.Trim(); Compobj.ISDelete = false; Compobj.IP = model.IP; Compobj.cpu = model.CPU.Trim(); Compobj.OsId = model.OSID; db.computermanagements.AddObject(Compobj); db.SaveChanges(); return(Json("Success", JsonRequestBehavior.AllowGet)); } else { return(View()); } } } 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 AddNew(Email objmail) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); DSRCManagementSystem.EmailPurpose objpurpose = new DSRCManagementSystem.EmailPurpose(); var already = db.EmailPurposes.Where(x => x.EmailPurposeName == objmail.Purpose && x.IsActive == true).Select(x => x).FirstOrDefault(); if (already != null) { return(Json(new { Result = "Already", JsonRequestBehavior.AllowGet })); } else { var val = db.EmailTemplates.Where(x => x.TemplatePurpose == objmail.Purpose).Select(o => o.EmailTemplateID).FirstOrDefault(); var val1 = db.EmailTemplates.Where(x => x.TemplatePurpose == objmail.Purpose).Select(o => o.TemplatePath).FirstOrDefault(); objmail.Template = val1; //string temp = ""; //int count = objmail.To.Count(); //foreach (var num in objmail.To) //{ // temp += num + ","; //} //string temp1 = ""; //foreach (var num in objmail.CC) //{ // temp1 += num + ","; //} //string temp2 = ""; //foreach (var num in objmail.BCC) //{ // temp2 += num + ","; //} objpurpose.EmailPurposeName = objmail.Purpose; objpurpose.EmailTemplateID = val; objpurpose.To = objmail.To != null ? objmail.To : ""; objpurpose.CC = objmail.CC != null ? objmail.CC : ""; objpurpose.BCC = objmail.BCC != null ? objmail.BCC : ""; objpurpose.Subject = objmail.Subject; objpurpose.IsActive = true; db.AddToEmailPurposes(objpurpose); db.SaveChanges(); return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int ID) { using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1()) { var record = db.ManageServers.FirstOrDefault(x => x.ManageServers_Id == ID); record.ISDelete = true; db.SaveChanges(); return(Json("Success", JsonRequestBehavior.AllowGet)); } }
public ActionResult AddStops(DSRCManagementSystem.Models.StopList objmodel) { DSRCManagementSystem.Stop obj = new DSRCManagementSystem.Stop(); DSRCManagementSystem.Models.StopList obs = new DSRCManagementSystem.Models.StopList(); var val = objdb.Stops.Where(x => x.Stop_Name == objmodel.Stop_Name).Select(o => o).FirstOrDefault(); if (val == null) { obj.Stop_Name = objmodel.Stop_Name; obj.IsActive = true; objdb.AddToStops(obj); objdb.SaveChanges(); } else { return(Json("Warning", JsonRequestBehavior.AllowGet)); } return(Json("Success", JsonRequestBehavior.AllowGet)); }