public ActionResult Create([Bind(Exclude = "Id")] Car carToCreate) { if (!ModelState.IsValid) { return(View()); } _db.Cars.Add(carToCreate); _db.SaveChanges(); return(RedirectToAction("Index")); }
// ******************************************************************************************************************************************** // POST: api/orders/admin/add/ // function that get 1 parameter from OrdersTable type and adds it to the table public IHttpActionResult Post([FromBody] OrdersTable order) { using (CarsDBEntities db = new CarsDBEntities()) { db.OrdersTables.Add(order); db.SaveChanges(); return(Ok("the order has been added")); } }
public void addCarToDb(string carName, string carModel, string carTransmission, string carGazType, double carEngLitres, string carType, int carDiscount, string carPhoto1, double carPrice, string carPhoto2, string carPhoto3) { #region getCarManufacturerId string carManufName = carName; var checkId = context.CarManufacturer .Where(x => x.Name == carManufName) .Select(x => new { Id = x.Id }); int[] CarManufacturerId = new int[1]; foreach (var item in checkId) { CarManufacturerId[0] = item.Id; } #endregion if (checkId != null) { Cars CarToAdd = new Cars(); CarToAdd.Name = carManufName; CarToAdd.Model = carModel; CarToAdd.Transmission = carTransmission; CarToAdd.GazType = carGazType; CarToAdd.EngineLitres = carEngLitres; CarToAdd.TypeOfCar = carType; CarToAdd.CarManufacturerId = CarManufacturerId[0]; CarToAdd.Discount = carDiscount; CarToAdd.Photo1 = carPhoto1; CarToAdd.Price = carPrice; CarToAdd.Photo2 = carPhoto2; CarToAdd.Photo3 = carPhoto3; context.Cars.Add(CarToAdd); context.SaveChanges(); MessageBox.Show($"{CarToAdd.Name} \n {CarToAdd.Model} \n {CarToAdd.Transmission} \n {CarToAdd.GazType} \n{CarToAdd.EngineLitres} \n {CarToAdd.TypeOfCar} \n {CarToAdd.CarManufacturerId} \n {CarToAdd.Discount} \n {CarToAdd.Photo1} \n {CarToAdd.Price} \n {CarToAdd.Photo2} \n {CarToAdd.Photo3}"); } else { MessageBox.Show("No such Car manufacturer!"); } }
// ******************************************************************************************************************************************** // DELETE: api/orders/admin/delete/{orderid} // function that get one parameter - orderid searching if there is object with the same orderid // if true it deletes this object from the table and return success // else return bad request public IHttpActionResult Delete(int orderid) { using (CarsDBEntities db = new CarsDBEntities()) { var currentOrder = db.OrdersTables.FirstOrDefault(o => o.OrderID == orderid); if (currentOrder != null) { db.OrdersTables.Remove(currentOrder); db.SaveChanges(); return(Ok("the order #" + orderid + " has been removed")); } return(BadRequest("couldnt find the order #" + orderid)); } }
// ******************************************************************************************************************************************* // POST: api/cars/admin/add/ -- admin using // function that get 1 parameter from CarsTable type // looking if this carLicenseNumber is already exists // if null and carlicense number != from 0 it adds it to the table and return success // else returns badrequest public IHttpActionResult Post([FromBody] CarsTable car) { using (CarsDBEntities db = new CarsDBEntities()) { var currentCar = db.CarsTables.FirstOrDefault(c => c.CarLicenseNumber == car.CarLicenseNumber); if (currentCar == null && car.CarLicenseNumber != 0) { db.CarsTables.Add(car); db.SaveChanges(); return(Ok("The Car Number " + car.CarLicenseNumber + " added to the table")); } return(BadRequest("Cannot Add This Car The Car Id Number" + car.CarLicenseNumber + "is already exists")); } }
public IHttpActionResult Delete(int carmodelID) { using (CarsDBEntities db = new CarsDBEntities()) { var currentCarModel = db.CarModelTables.FirstOrDefault(carmodelVal => carmodelID == carmodelVal.carmodelID); if (currentCarModel != null) { db.CarModelTables.Remove(currentCarModel); db.SaveChanges(); return(Ok("Deleted")); } else { return(BadRequest()); } } }
public IHttpActionResult Post([FromBody] CarModelTable carmodel) { using (CarsDBEntities db = new CarsDBEntities()) { var currentCarModel = db.CarModelTables.FirstOrDefault(carmodelVal => (carmodel.manufacturer == carmodelVal.manufacturer) && (carmodel.model == carmodelVal.model) && (carmodel.year == carmodelVal.year) && (carmodel.gearbox == carmodelVal.gearbox)); if (currentCarModel == null) { db.CarModelTables.Add(carmodel); db.SaveChanges(); return(Ok("The Car Model " + carmodel.manufacturer + " " + carmodel.model + " added to the table")); } else { return(BadRequest("The Car Model " + carmodel.manufacturer + " " + carmodel.model + " cannot added to the table")); } } }
// ******************************************************************************************************************************************** // PUT: api/orders/admin/edit/ // function that get one parameter from orderstable type seach if this id is already exists // if true it changes the property value to the ordertable type object // and return ok and the current user // else return bad request public HttpResponseMessage Put([FromBody] OrdersTable value) { using (CarsDBEntities db = new CarsDBEntities()) { var currentOrder = db.OrdersTables.FirstOrDefault(o => o.OrderID == value.OrderID); if (currentOrder != null) { currentOrder.CarLicenseNumber = value.CarLicenseNumber; currentOrder.EstimatedReturnDate = value.EstimatedReturnDate; currentOrder.OrderID = value.OrderID; currentOrder.ReturnDate = value.ReturnDate; currentOrder.StartDate = value.StartDate; currentOrder.UserID = value.UserID; db.SaveChanges(); return(Request.CreateResponse <OrdersTable>(HttpStatusCode.OK, currentOrder)); } else { return(Request.CreateResponse <string>(HttpStatusCode.BadRequest, "Couldnt find the current order")); } } }
public HttpResponseMessage OrderFinish(int CarLicenseNumber, int OrderID) { using (CarsDBEntities db = new CarsDBEntities()) { var currentCar = db.CarsTables.FirstOrDefault(tmpcar => tmpcar.CarLicenseNumber == CarLicenseNumber); if (currentCar != null) { currentCar.isRentable = true; var currentOrder = db.OrdersTables.FirstOrDefault(tmporder => tmporder.OrderID == OrderID); if (currentOrder != null) { currentOrder.ReturnDate = DateTime.Now.ToString("yyyy-MM-dd"); } db.SaveChanges(); return(Request.CreateResponse <CarsTable>(HttpStatusCode.OK, currentCar)); } else { return(Request.CreateResponse <string>(HttpStatusCode.BadRequest, "Count find that current car")); } } }
// ********************************************************************************************************************************************* // PUT: api/Cars/5 // Function that edits values in CarsTable by getting 1 parameter from CarsTable type // if this car.CarLicenseNumber is found to check the values are true and edits the currentcar values and return success // else return bad request public HttpResponseMessage Put([FromBody] CarsTable car) { using (CarsDBEntities db = new CarsDBEntities()) { var currentCar = db.CarsTables.FirstOrDefault(tmpcar => tmpcar.CarLicenseNumber == car.CarLicenseNumber); if (currentCar != null) { currentCar.carmodelID = car.carmodelID; currentCar.CarLicenseNumber = car.CarLicenseNumber; currentCar.currentKm = car.currentKm; currentCar.Image = car.Image; currentCar.isDamaged = car.isDamaged; currentCar.isRentable = car.isRentable; db.SaveChanges(); return(Request.CreateResponse <CarsTable>(HttpStatusCode.OK, currentCar)); } else { return(Request.CreateResponse <string>(HttpStatusCode.BadRequest, "Count find that current car")); } } }
public IHttpActionResult Put([FromBody] CarModelTable carmodel) { using (CarsDBEntities db = new CarsDBEntities()) { var currentCarModel = db.CarModelTables.FirstOrDefault(carmodelVal => carmodel.carmodelID == carmodelVal.carmodelID); if (currentCarModel != null) { currentCarModel.dailyLateFee = carmodel.dailyLateFee; currentCarModel.dailyPrice = carmodel.dailyPrice; currentCarModel.gearbox = carmodel.gearbox; currentCarModel.manufacturer = carmodel.manufacturer; currentCarModel.model = carmodel.model; currentCarModel.year = carmodel.year; db.SaveChanges(); return(Ok("The Car Model " + carmodel.carmodelID + " has been edited")); } else { return(BadRequest("Cannot find the Car Model With the Id" + carmodel.carmodelID)); } } }
public void Create(T item) { Context.Set <T>().Add(item); Context.SaveChanges(); }