public async Task <IActionResult> Create([Bind("id,number,pole,available_bikes,code_insee,lng,availability,availabilitycode,etat,startdate,langue,bike_stands,last_update,available_bike_stands,gid,titre,status,commune,description,nature,bonus,address2,address,lat,last_update_fme,enddate,name,banking,nmarrond")] Stations stations) { if (ModelState.IsValid) { _context.Add(stations); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(stations)); }
public async Task <ActionResult <Developer> > Post(Developer developer) { if (developer == null) { return(BadRequest()); } db.Developers.Add(developer); await db.SaveChangesAsync(); return(Ok(developer)); }
public async Task <ActionResult <Post> > Post(Post post) { if (post == null) { return(BadRequest()); } db.Posts.Add(post); await db.SaveChangesAsync(); return(Ok(post)); }
public async Task <ActionResult <Game> > Post(Game game) { if (game == null) { return(BadRequest()); } db.Games.Add(game); await db.SaveChangesAsync(); return(Ok(game)); }
public async Task <ActionResult <Country> > Post(Country country) { if (country == null) { return(BadRequest()); } db.Countries.Add(country); await db.SaveChangesAsync(); return(Ok(country)); }
public async Task <ActionResult <Platform> > Post(Platform platform) { if (platform == null) { return(BadRequest()); } db.Platforms.Add(platform); await db.SaveChangesAsync(); return(Ok(platform)); }
public async Task <bool> Post(FuelPrelevement myPrelevement) { using (var db = new StationContext()) { if (myPrelevement.PrelevementGuid == Guid.Empty) { myPrelevement.PrelevementGuid = Guid.NewGuid(); } var citerneGuid = db.Pompes.Find(myPrelevement.PompeGuid).CiterneGuid; if (citerneGuid != null) { myPrelevement.CiterneGuid = (Guid)citerneGuid; } else { throw new ArgumentException("CAN_NOT_FIND_CITERNE"); } myPrelevement.CurrentPrice = (await FuelManager.GetFuelCurrentPrice(db.Pompes.Find(myPrelevement.PompeGuid).Citerne.FuelGuid)); myPrelevement.DateAdded = DateTime.Now; myPrelevement.LastEditDate = DateTime.Now; db.Set <FuelPrelevement>().Add(myPrelevement); return(await db.SaveChangesAsync() > 0); } }
public async Task <bool> Post(Fuel myFuel) { using (var db = new StationContext()) { if (myFuel.FuelGuid == Guid.Empty) { myFuel.FuelGuid = Guid.NewGuid(); } myFuel.DateAdded = DateTime.Now; myFuel.LastEditDate = DateTime.Now; db.Fuels.Add(myFuel); if (!myFuel.Prices.Any()) { return(db.SaveChanges() > 0); } if (myFuel.Prices.First().PriceGuid == Guid.Empty) { myFuel.Prices.First().PriceGuid = Guid.NewGuid(); } myFuel.Prices.First().ProductGuid = myFuel.FuelGuid; myFuel.Prices.First().FromDate = DateTime.Now; db.Set <Price>().Add(myFuel.Prices.First()); return(await db.SaveChangesAsync() > 0); } }
public async Task <bool> Post(Purchase myPurchase) { using (var db = new StationContext()) { switch (myPurchase.ProductType) { case ProductType.Fuel: myPurchase.Sum = myPurchase.Quantity * (await FuelManager.GetFuelCurrentPrice(myPurchase.ProductGuid)); myPurchase.Description = $"{myPurchase.Quantity.ToString("0.##\\ L")} {(await db.Fuels.FindAsync(myPurchase.ProductGuid)).Libel}"; break; case ProductType.Oil: myPurchase.Sum = myPurchase.Quantity * (await OilManager.StaticGet(myPurchase.ProductGuid)).CurrentUnitPrice; myPurchase.Description = $"{"Bidon".ToQuantity((int) myPurchase.Quantity)} {(await db.Oils.FindAsync(myPurchase.ProductGuid)).Libel}"; break; } if (myPurchase.PurchaseGuid == Guid.Empty) { myPurchase.PurchaseGuid = Guid.NewGuid(); } if (myPurchase.PurchaseState == PurchaseState.Paid) { myPurchase.PurchaseDate = DateTime.Now; } myPurchase.DateAdded = myPurchase.PurchaseDate; myPurchase.LastEditDate = DateTime.Now; db.Purchases.Add(myPurchase); return(await db.SaveChangesAsync() > 0); } }
public async Task <bool> Put(Fuel myFuel) { using (var db = new StationContext()) { myFuel.LastEditDate = DateTime.Now; db.Fuels.Attach(myFuel); db.Entry(myFuel).State = EntityState.Modified; return(await db.SaveChangesAsync() > 0); } }
public async Task <bool> Put(Company myCompany) { bool result; using (var db = new StationContext()) { myCompany.LastEditDate = DateTime.Now; db.Companies.Attach(myCompany); db.Entry(myCompany).State = EntityState.Modified; result = await db.SaveChangesAsync() > 0; } return(result); }
public async Task <bool> Post(FuelDelivery fuelDelivery) { using (var db = new StationContext()) { if (fuelDelivery.FuelDeliveryGuid == Guid.Empty) { fuelDelivery.FuelDeliveryGuid = Guid.NewGuid(); } fuelDelivery.DateAdded = DateTime.Now; fuelDelivery.LastEditDate = DateTime.Now; db.FuelDeliverys.Add(fuelDelivery); return(await db.SaveChangesAsync() > 0); } }
public async Task <bool> Post(Citerne myCiternes) { using (var db = new StationContext()) { if (myCiternes.CiterneGuid == Guid.Empty) { myCiternes.CiterneGuid = Guid.NewGuid(); } myCiternes.DateAdded = DateTime.Now; myCiternes.LastEditDate = DateTime.Now; db.Citernes.Add(myCiternes); return(await db.SaveChangesAsync() > 0); } }
public async Task <bool> ChangePrice(Guid oilGuid, double newPrice) { using (var db = new StationContext()) { var myOil = db.Oils.Find(oilGuid); myOil.CurrentUnitPrice = newPrice; myOil.LastPriceUpdate = DateTime.Now; myOil.LastEditDate = DateTime.Now; db.Oils.Attach(myOil); db.Entry(myOil).State = EntityState.Modified; return(await db.SaveChangesAsync() > 0); } }
public async Task <bool> DeletePurchase(Guid purchaseGuid) { using (var db = new StationContext()) { var myPurchase = await db.Purchases.FindAsync(purchaseGuid); if (myPurchase == null) { throw new InvalidOperationException("PURCHASE_NOT_FOUND"); } myPurchase.LastEditDate = DateTime.Now; myPurchase.IsDeleted = true; db.Purchases.Attach(myPurchase); db.Entry(myPurchase).State = EntityState.Modified; return(await db.SaveChangesAsync() > 0); } }
public async Task <bool> Delete(Guid fuelGuid) { using (var db = new StationContext()) { var myObject = await db.Fuels.FindAsync(fuelGuid); if (myObject == null) { throw new InvalidOperationException("FUEL_NOT_FOUND"); } myObject.LastEditDate = DateTime.Now; myObject.IsDeleted = true; db.Fuels.Attach(myObject); db.Entry(myObject).State = EntityState.Modified; return(await db.SaveChangesAsync() > 0); } }
public async Task <bool> DeletePrelevement(Guid oilPrelevementGuid) { using (var db = new StationContext()) { var myObject = await db.OilPrelevements.FindAsync(oilPrelevementGuid); if (myObject == null) { throw new InvalidOperationException("PRELEVEMENT_NOT_FOUND"); } myObject.LastEditDate = DateTime.Now; myObject.DeleteDate = DateTime.Now; myObject.IsDeleted = true; db.OilPrelevements.Attach(myObject); db.Entry(myObject).State = EntityState.Modified; return(await db.SaveChangesAsync() > 0); } }
public async Task <bool> AddStaff(Staff myStaff) { using (var db = new StationContext()) { if (myStaff.StaffGuid == Guid.Empty) { myStaff.StaffGuid = Guid.NewGuid(); } if (myStaff.Person.PersonGuid == Guid.Empty) { myStaff.Person.PersonGuid = Guid.NewGuid(); } await myStaff.Person.Validate(); db.Set <Person>().Add(myStaff.Person); db.Staffs.Add(myStaff); return(await db.SaveChangesAsync() > 0); } }
public async Task <bool> CheckOut(Guid purchaseGuid, PurchaseState purchaseState = PurchaseState.Paid) { using (var db = new StationContext()) { var myPurchase = await db.Purchases.FindAsync(purchaseGuid); if (myPurchase == null) { throw new InvalidOperationException("ITEM_NOT_FOUND"); } if (myPurchase.PurchaseState == purchaseState) { throw new InvalidOperationException("ITEM_ALREADY_PAID"); } myPurchase.PurchaseState = purchaseState; db.Purchases.Attach(myPurchase); db.Entry(myPurchase).State = EntityState.Modified; return(await db.SaveChangesAsync() > 0); } }
public async Task <bool> Post(Price newPrice) { using (var db = new StationContext()) { if (!db.Fuels.Any(f => f.FuelGuid == newPrice.ProductGuid)) { throw new InvalidOperationException("FUEL_REFERENCE_NOT_FOUND"); } if (newPrice.PriceGuid == Guid.Empty) { newPrice.PriceGuid = Guid.NewGuid(); } newPrice.DateAdded = DateTime.Now; newPrice.LastEditDate = DateTime.Now; db.Set <Price>().Add(newPrice); return(await db.SaveChangesAsync() > 0); } }
public async Task <bool> Post(Company newCompany) { using (var db = new StationContext()) { if (newCompany.CompanyGuid == Guid.Empty) { newCompany.CompanyGuid = Guid.NewGuid(); } if (newCompany.AddressGuid == Guid.Empty) { newCompany.AddressGuid = Guid.NewGuid(); } newCompany.Address.AddressGuid = newCompany.AddressGuid; newCompany.DateAdded = DateTime.Now; newCompany.LastEditDate = DateTime.Now; db.Companies.Add(newCompany); db.Set <Address>().Add(newCompany.Address); return(await db.SaveChangesAsync() > 0); } }
public async Task <bool> Post(List <OilPrelevement> oilPrelevements, DateTime fromDate) { using (var db = new StationContext()) { foreach (var prelevement in oilPrelevements) { if (prelevement.OilPrelevementGuid == Guid.Empty) { prelevement.OilPrelevementGuid = Guid.NewGuid(); } prelevement.CurrentPrice = db.Oils.Find(prelevement.OilGuid).CurrentUnitPrice; var lastOne = StaticGetLastPrelevement(prelevement.OilGuid); prelevement.Result = -prelevement.Meter + lastOne.Meter + GetDeliveries(prelevement.OilGuid, lastOne.DatePrelevement.GetValueOrDefault(), fromDate); if (prelevement.Result < 0) { throw new CoolException( $"{db.Oils.Find(prelevement.OilGuid).Libel} : Le stock restant ne doit pas etre Supérieur a " + lastOne.Meter + GetDeliveries(prelevement.OilGuid, lastOne.DatePrelevement.GetValueOrDefault(), fromDate)); } if (prelevement.Result > StaticGetOilBalance(prelevement.OilGuid)) { throw new CoolException( $"{db.Oils.Find(prelevement.OilGuid).Libel}: Le stock restant ne doit pas etre Supérieur a " + StaticGetOilBalance(prelevement.OilGuid)); } prelevement.DatePrelevement = fromDate; prelevement.DateAdded = DateTime.Now; prelevement.LastEditDate = DateTime.Now; db.OilPrelevements.Add(prelevement); } return(await db.SaveChangesAsync() > 0); } }