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