public ServiceLocationModel GetLocationSourceData(int Id) { ShomaRMEntities db = new ShomaRMEntities(); ServiceLocationModel model = new ServiceLocationModel(); var GetLocationData = db.tbl_ServiceLocation.Where(p => p.LocationID == Id).FirstOrDefault(); if (GetLocationData != null) { model.LocationID = GetLocationData.LocationID; model.Location = GetLocationData.Location; } model.LocationID = Id; return(model); }
public ServiceLocationModel GetServiceLocationInfo(int ID = 0) { ShomaRMEntities db = new ShomaRMEntities(); ServiceLocationModel model = new ServiceLocationModel(); var ServiceLocation = db.tbl_ServiceLocation.Where(p => p.LocationID == ID).FirstOrDefault(); if (ServiceLocation != null) { model.LocationID = ServiceLocation.LocationID; model.Location = ServiceLocation.Location; } return(model); }
public long SaveUpdateServiceLocation(ServiceLocationModel model) { ShomaRMEntities db = new ShomaRMEntities(); var userNameExists = db.tbl_ServiceLocation.Where(p => p.LocationID != model.LocationID && p.Location == model.Location).FirstOrDefault(); if (userNameExists == null) { if (model.LocationID == 0) { var LocationData = new tbl_ServiceLocation() { Location = model.Location }; db.tbl_ServiceLocation.Add(LocationData); db.SaveChanges(); model.LocationID = LocationData.LocationID; } else { var LocationData = db.tbl_ServiceLocation.Where(p => p.LocationID == model.LocationID).FirstOrDefault(); if (LocationData != null) { LocationData.Location = model.Location; db.SaveChanges(); } else { throw new Exception(model.Location + " not exists in the system."); } } return(model.LocationID); } else { throw new Exception(model.Location + " already exists in the system."); } }