public static bool Update(CrewViewModel model) { bool result = true; try { using (var db = new FleetManagementContext()) { if (model.Id == 0) { MstCrew crw = new MstCrew(); crw.CrewId = model.CrewId; crw.CrewName = model.CrewName; crw.DrivingLicenseNumber = model.DrivingLicenseNumber; crw.Address = model.Address; crw.PlaceOfBirth = model.PlaceOfBirth; crw.DateOfBirth = model.DateOfBirth; crw.Gender = model.Gender; crw.Role = model.Role; crw.IsActive = model.IsActive; db.MstCrews.Add(crw); db.SaveChanges(); } else { MstCrew crw = db.MstCrews.Where(o => o.Id == model.Id).FirstOrDefault(); if (crw != null) { crw.CrewId = model.CrewId; crw.CrewName = model.CrewName; crw.DrivingLicenseNumber = model.DrivingLicenseNumber; crw.Address = model.Address; crw.PlaceOfBirth = model.PlaceOfBirth; crw.DateOfBirth = model.DateOfBirth; crw.Gender = model.Gender; crw.Role = model.Role; crw.IsActive = model.IsActive; db.SaveChanges(); } } } } catch (Exception Ex) { Message = Ex.Message; result = false; } return(result); }
public static bool Delete(int id) { bool result = true; try { using (var db = new FleetManagementContext()) { MstCrew crw = db.MstCrews.Where(o => o.Id == id).FirstOrDefault(); if (crw != null) { db.MstCrews.Remove(crw); db.SaveChanges(); } } } catch (Exception Ex) { Message = Ex.Message; result = false; } return(result); }