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.");
}
}
