public string Update(AircraftViewModel model) { string msg = string.Empty; try { AircraftType aircraft = _context.AsQueryable <AircraftType>().Where(x => x.ID == model.ID).FirstOrDefault(); bool isExists = false; #region Check if new name changed if (aircraft.Name.Trim().ToUpper() != model.Name.Trim().ToUpper()) { int ctr = _context.AsQueryable <AircraftType>().Where(x => x.Name.Trim() == model.Name.Trim()).Count(); if (ctr > 0) { isExists = true; } } #endregion if (isExists) { msg = "Aircraft name already exists."; } else { if (!string.IsNullOrEmpty(model.Name)) { aircraft.Name = model.Name; } if (!string.IsNullOrEmpty(model.Description)) { aircraft.Description = model.Description; } aircraft.DateModified = DateTime.Now; if (aircraft != null) { _context.Update <AircraftType>(aircraft); _context.SaveChanges(); } msg = "Aircraft updated."; } } catch (Exception ex) { LogsViewModel error = new LogsViewModel() { ActionType = ActionType.Error.ToString(), Description = ex.Message + "\n" + ex.StackTrace, ModifiedBy = "Aircraft Service Error : Update()", DateModified = DateTime.Now.ToString("MM/dd/yyyy HH:mm") }; new LogsService().Create(error); msg = "Unexpected error encountered. Please contact your system administrator."; //log error } return(msg); }
public string Update(CalendarViewModel model) { string msg = string.Empty; try { #region Update Calendar Schedule var calendar = _context.AsQueryable <Schedule>().Where(x => x.ID == model.ID).FirstOrDefault(); if (calendar != null) { if (model.IsChangeSchedOnly == false) { if (!string.IsNullOrEmpty(model.Title)) { calendar.Name = model.Title; } if (model.AircraftID > 0) { calendar.AircraftID = model.AircraftID; } if (model.RegistrationID > 0) { calendar.RegistrationID = model.RegistrationID; } if (!string.IsNullOrEmpty(model.Start)) { calendar.StartDate = DateTime.Parse(model.Start); } if (!string.IsNullOrEmpty(model.End)) { calendar.EndDate = DateTime.Parse(model.End); } if (model.RouteStartID > 0) { calendar.RouteStartID = model.RouteStartID; } if (model.DestinationID > 0) { calendar.RouteDestinationID = model.DestinationID; } if (model.RouteEndID > 0) { calendar.RouteEndID = model.RouteEndID; } if (model.PilotID > 0) { calendar.PilotID = model.PilotID; } if (model.CopilotID > 0) { calendar.AssistantPilotID = model.CopilotID; } if (!string.IsNullOrEmpty(model.Notes)) { calendar.Notes = model.Notes; } if (!string.IsNullOrEmpty(model.Passengers)) { calendar.Passengers = model.Passengers; } if (!string.IsNullOrEmpty(model.FlightInfo)) { calendar.FlightInfo = model.FlightInfo; } if (!string.IsNullOrEmpty(model.TechnicalStops)) { calendar.TechnicalStops = model.TechnicalStops; } if (!string.IsNullOrEmpty(model.ETC)) { calendar.ETC = model.ETC; } if (!string.IsNullOrEmpty(model.WaitingStart)) { calendar.WaitingStart = DateTime.Parse(model.WaitingStart); } if (!string.IsNullOrEmpty(model.WaitingEnd)) { calendar.WaitingEnd = DateTime.Parse(model.WaitingEnd); } _context.Update(calendar); _context.SaveChanges(); #region Update Crew //delete crew first this.DeleteCrewBySchedule(calendar.ID, model.LoggedUserID); string crewids = model.CrewIDs.Remove(model.CrewIDs.Length - 1); string[] ids = crewids.Split(','); foreach (var crewid in ids) { if (!string.IsNullOrEmpty(crewid)) { CrewViewModel crewmodel = new CrewViewModel() { CrewID = Convert.ToInt32(crewid), ScheduleID = calendar.ID }; this.CreateCrews(crewmodel); } } #endregion } else { //change sched only string newStart = "", newEnd = "", updatedEnd = "", newStart2 = "", updatedStart2 = "", newEnd2 = "", updatedEnd2 = ""; newStart = DateTime.Parse(model.Start).ToString("yyyy-MM-dd HH:mm"); newEnd = DateTime.Parse(calendar.EndDate.ToString()).ToString("yyyy-MM-dd HH:mm"); newStart2 = DateTime.Parse(calendar.WaitingStart.ToString()).ToString("yyyy-MM-dd HH:mm"); newEnd2 = DateTime.Parse(calendar.WaitingEnd.ToString()).ToString("yyyy-MM-dd HH:mm"); #region Get diffrence double diff1 = 0; diff1 = calendar.StartDate.Date.Subtract(calendar.EndDate).Days; //((DateTime)calendar.WaitingEnd).Date.Subtract( calendar.StartDate.Date ).Days; #endregion if (diff1 > 0) { updatedEnd = DateTime.Parse(newStart).AddDays(diff1).ToString("yyyy-MM-dd HH:mm").Substring(0, 10) + newEnd.Substring(10); } else { updatedEnd = newStart.Substring(0, 10) + newEnd.Substring(10); } updatedStart2 = newStart.Substring(0, 10) + newStart2.Substring(10); updatedEnd2 = newEnd2.Substring(0, 10) + newEnd2.Substring(10); calendar.StartDate = DateTime.Parse(model.Start); calendar.EndDate = DateTime.Parse(updatedEnd); calendar.WaitingStart = DateTime.Parse(updatedStart2); calendar.WaitingEnd = DateTime.Parse(updatedEnd2); _context.Update(calendar); _context.SaveChanges(); } msg = "Schedule updated."; } #endregion #region Log Create string fullname = string.Empty; var user = _userService.GetAll().Where(x => x.ID == model.LoggedUserID).FirstOrDefault(); if (user != null) { fullname = string.Format("{0}, {1}", user.LastName, user.FirstName); LogsViewModel log = new LogsViewModel() { ActionType = ActionType.DataModification.ToString(), Description = string.Format("Schedule Updated. <br /> ScheduleID:{0} <br /> LoggedUserID: {1}", model.ID, user.ID), ModifiedBy = fullname, DateModified = DateTime.Now.ToString("MM/dd/yyyy HH:mm") }; new LogsService().Create(log); } #endregion } catch (Exception ex) { LogsViewModel error = new LogsViewModel() { ActionType = ActionType.Error.ToString(), Description = ex.Message + "\n" + ex.StackTrace, ModifiedBy = "Calendar Service Error : Update()", DateModified = DateTime.Now.ToString("MM/dd/yyyy HH:mm") }; new LogsService().Create(error); msg = "Unexpected error encountered. Please contact your system administrator."; } return(msg); }
public string Update(UserViewModel model) { string msg = string.Empty; try { User user = _context.AsQueryable <User>().Where(x => x.ID == model.ID).FirstOrDefault(); bool isExists = false; #region check if current username and email is not equal to new value isExists = this.IsExists(user.ID, user.Username, model.Username, user.Email, model.Email); #endregion if (isExists) { msg = "Your profile email or username already exists."; } else { if (!string.IsNullOrEmpty(model.Password)) { user.Password = ThreeDES.Encrypt(model.Password); } if (!string.IsNullOrEmpty(model.Username)) { user.Username = model.Username; } if (!string.IsNullOrEmpty(model.FirstName)) { user.FirstName = model.FirstName; } if (!string.IsNullOrEmpty(model.LastName)) { user.LastName = model.LastName; } if (!string.IsNullOrEmpty(model.MiddleName)) { user.MiddleName = model.MiddleName; } if (!string.IsNullOrEmpty(model.Address)) { user.Address = model.Address; } if (!string.IsNullOrEmpty(model.Phone)) { user.Phone = model.Phone; } if (!string.IsNullOrEmpty(model.Email)) { user.Email = model.Email; } if (!string.IsNullOrEmpty(model.SSS)) { user.SSS = model.SSS; } if (!string.IsNullOrEmpty(model.TIN)) { user.TIN = model.TIN; } if (model.RoleID != 0) { user.RoleID = model.RoleID; } user.DateModified = DateTime.Now; if (user != null) { _context.Update <User>(user); _context.SaveChanges(); } msg = "Profile updated."; } } catch (Exception ex) { msg = "Unexpected error encountered. Please contact your system administrator."; LogsViewModel error = new LogsViewModel() { ActionType = ActionType.Error.ToString(), Description = ex.Message + "\n" + ex.StackTrace, ModifiedBy = "User Service Error : Update()", DateModified = DateTime.Now.ToString("MM/dd/yyyy HH:mm") }; new LogsService().Create(error); } return(msg); }