public int AddTProviderDAL(TransportationProvider transportationProvider)
{
db.TransportationProviders.Add(transportationProvider);
db.SaveChanges();
int newTProviderID = db.TransportationProviders.Max(p => p.TransportationProviderID);
return(newTProviderID);
}
public IHttpActionResult CreateTProviderC(AddTProviderDTO addTProviderDTO)
{
if (addTProviderDTO == null)
{
return(BadRequest("Please Provide Valid Transportation Providers Details "));
}
if (!ModelState.IsValid)
{
string modelErrors = string.Join(Environment.NewLine, ModelState.Values
.SelectMany(x => x.Errors)
.Select(x => x.ErrorMessage));
return(BadRequest(modelErrors));
}
try
{
TransportationProvider transportationProvider = new TransportationProvider();
transportationProvider.CityID = addTProviderDTO.CityId;
transportationProvider.TransportationProviderName = addTProviderDTO.TransportationProviderName;
transportationProvider.Id = addTProviderDTO.UserId;
var TProviderID = adminTManagerBL.AddTProviderBL(transportationProvider);
List <TransportationPrice> transportationPrices = new List <TransportationPrice>();
foreach (var price in addTProviderDTO.TransportationPrices)
{
transportationPrices.Add(
new TransportationPrice()
{
TransportationProviderID = TProviderID,
TransportationModeID = price.TransportationModeID,
Price = price.Price
});
}
adminTManagerBL.AddTProviderPriceBL(transportationPrices);
return(Ok());
}
catch (Exception ex)
{
if (ex.GetType().IsAssignableFrom(typeof(DbUpdateConcurrencyException)))
{
ModelState.AddModelError("DuplicateTransportPriceAdditionError", "Combination of price and hotel already exist");
return(BadRequest(ModelState));
}
return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Some error occoured while creating a new transportation provider")));
}
}
public void UpdateTProviderDAL(TransportationProvider transportationProvider)
{
db.Entry(transportationProvider).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (Exception)
{
if (!TProviderExists(transportationProvider.TransportationProviderID))
{
throw;
}
throw;
}
}
public IHttpActionResult UpdateTProvider(UpdateTProviderDTO updateTProviderDTO)
{
if (updateTProviderDTO == null)
{
return(BadRequest("Please provide valid details for updating the transportation provider"));
}
if (!ModelState.IsValid)
{
string modelErrors = string.Join(Environment.NewLine, ModelState.Values
.SelectMany(x => x.Errors)
.Select(x => x.ErrorMessage));
return(BadRequest(modelErrors));
}
try
{
TransportationProvider transportationProvider = new TransportationProvider();
transportationProvider.TransportationProviderID = updateTProviderDTO.TransportationProviderID;
transportationProvider.CityID = updateTProviderDTO.CityID;
transportationProvider.Id = updateTProviderDTO.Id;
transportationProvider.TransportationProviderName = updateTProviderDTO.TransportationProviderName;
adminTManagerBL.UpdateTProviderBL(transportationProvider);
List <TransportationPrice> updatedTransportationPrices = new List <TransportationPrice>();
foreach (var updatedPrice in updateTProviderDTO.updatedTProviderPrice)
{
updatedTransportationPrices.Add(new TransportationPrice()
{
TransportationProviderID = updateTProviderDTO.TransportationProviderID,
TransportationPriceID = updatedPrice.TransportationPriceID,
TransportationModeID = updatedPrice.TransportationModeID,
Price = updatedPrice.Price
});
}
adminTManagerBL.UpdateTProviderPrices(updatedTransportationPrices);
return(Ok());
}
catch (Exception ex)
{
return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Some error occoured while updating the transportation provider")));
}
}
//This method is invoked on addition of new transportation providers
//It's returning id to method which is calling it, it get's id from DAL which is returning the max Id as
//it points to the newly inserted records.
//this id is required for creation of price entries in transportationPrice table
public int AddTProviderBL(TransportationProvider transportationProvider)
{
return(adminTManagerDAL.AddTProviderDAL(transportationProvider));
}
public void UpdateTProviderBL(TransportationProvider transportationProvider)
{
adminTManagerDAL.UpdateTProviderDAL(transportationProvider);
}
