public async Task <ActionResult <CarsModel> > PostCarsModel([FromBody] CarsModel carsModel) { _context.CarsTable.Add(carsModel); await _context.SaveChangesAsync(); return(CreatedAtAction("GetCarsModel", new { id = carsModel.car_id }, carsModel)); }
private void BtnDelete_Click(object sender, EventArgs e) { var obj = new CarsModel(); if (CheckInputMasterDataForms()) { obj.Id = Convert.ToInt32(TbId.Text); obj.ModelName = TbModelName.Text; obj.ModelYear = Convert.ToInt32(TbModelYear.Text); obj.NumberCar = TbCarNumber.Text; obj.RentCost = Convert.ToDecimal(TbRentCost.Text); try { if (crud.DeleteCar(obj) > 0) { LoadData(); SetEmptyForm(); } else { MessageBox.Show("Error Delete data"); } } catch (Exception err) { MessageBox.Show("Error Delete data " + err.Message); throw err; } } else { MessageBox.Show("Text Box cannot be empty! "); } }
public static object SaveModel(CarsModel scParam) { object data = new { }; CarsModel item = new CarsModel() { ModelID = scParam.ModelID, MakerID = scParam.MakerID, TypeNameEn = scParam.TypeNameEn, TypeNameAr = scParam.TypeNameAr, CarSizeID = scParam.CarSizeID }; bool status = new ModelsManager().SaveItem(item); if ((item.ModelID > 0 && item.TypeNameEn != null) || status) { //HttpContext.Current.Cache.Remove("Models"); data = new { Status = true, Message = Resources.AdminResources_ar.SuccessSave }; } else { data = new { Status = false, Message = Resources.AdminResources_ar.ErrorSave } }; return(data); }
public async Task <ActionResult> Save(CarsModel model, CancellationToken cancellationToken) { if (ModelState.IsValid) { //VehicleMakeD car = new VehicleMakeD(model.ID, model.BrandName, model.BrandName); VehicleMakeD car = new VehicleMakeD { BrandName = model.BrandName, Abrv = model.Abrv }; await _vehicleRepository.CreateAsync(car, cancellationToken); VehicleModelD modelcar = new VehicleModelD { VehicleMakeID = car.ID, ModelName = model.ModelName, Abrv = model.Abrv }; await _vehicleRepository.CreateAsyncM(modelcar, cancellationToken); } return(View()); }
public async Task <IActionResult> Edit(long id, [Bind("Id,Tm,V,VN,Cf,VT,Img,FImg")] CarsModel carsModel) { if (id != carsModel.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(carsModel); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CarsModelExists(carsModel.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(carsModel)); }
//Week 5 -> U update DB public ActionResult DeleteCar(int Id) { //Instantiate object class to hold object CarsModel newcar = new CarsModel(); try { //create our statment SqlCommand myReadCommand = new SqlCommand("SELECT CarModels.CarId , CarModels.CarName FROM CarModels WHERE CarId =" + Id, cnn); //open our connection cnn.Open(); //read from db SqlDataReader dataThatIveRead = myReadCommand.ExecuteReader(); //-while we read load data into our list while (dataThatIveRead.Read()) { newcar.ID = (int)dataThatIveRead["CarId"]; newcar.Name = (string)dataThatIveRead["CarName"]; } } catch (Exception ex) { ViewBag.Message = ex; } finally { cnn.Close(); } return(View(newcar)); }
public async Task <IActionResult> PutCarsModel([FromRoute] int id, [FromBody] CarsModel carsModel) { if (id != carsModel.car_id) { return(BadRequest()); } _context.Entry(carsModel).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CarsModelExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
private void SaveModelInformation() { CarsModel ModelToSave = new CarsModel(); try { if (hfID.Value != "") { ModelToSave.ModelID = Convert.ToInt32(hfID.Value); } ModelToSave.Marker_ID = Convert.ToInt32(ddlMarkers.SelectedValue); ModelToSave.TypeNameEn = txtNameEn.Text; ModelToSave.TypeNameAr = txtNameAr.Text; ModelToSave.Priority = Convert.ToInt32(txtPriority.Text); ModelToSave.Active = cbActive.Checked; ModelToSave.System_Add_Date = DateTime.Now; ModelToSave.System_LastAction_IP = ClientSession.Current.IP; // perform saving method. if (new ModelManager().SaveModel(ModelToSave)) { lblError.Text = Resources.AdminResources_en.SuccessSave; ResetControls(); FillModelsList(); // refresh data. } else { lblError.Text = Resources.AdminResources_en.ErrorSave; } } catch { lblError.Text = Resources.AdminResources_en.ErrorSave; } }
public ActionResult DeleteConfirmed(int id) { CarsModel carsModel = db.cars.Find(id); db.cars.Remove(carsModel); db.SaveChanges(); return(RedirectToAction("Index")); }
public CarsController() { Model = new CarsModel(); AddCarCommand = new DelegateCommand(Model.CarToAdd, (_) => Model.AddCar(), e => Model.CarToAdd.Name != null); EditCarCommand = new DelegateCommand(Model, (_) => Model.EditCar(), e => 0 == 0); DeleteCarCommand = new DelegateCommand(Model, (_) => Model.DeleteCar(), e => 0 == 0); }
public CarsViewModel() { CurrentModel = new CarsModel(); Cars = new ObservableCollection <Car>(CurrentModel.Cars); Cars.CollectionChanged += Cars_CollectionChanged; //AddCar = new AddCarCommand(this); AddCar = new AddCarCommand(); AddCar.CarAdded += AddCar_CadAdded; }
public bool SaveItem(CarsModel item) { try { ctxWrite.CarsModel_InsertUpdate(item.ModelID, item.MakerID, item.TypeNameEn, item.TypeNameAr, item.CarSizeID, item.Active); return(true); } catch { return(false); } }
public void ChekingForCorrectCarModelById() { var request = new RestRequest("/cars/1"); var response = _restClient.Get(request); var currentCarModel = CarsModel.FromJson(response.Content); Assert.IsTrue(response.IsSuccessful); Assert.AreEqual("Ferrari", currentCarModel.Model); }
public void Update(CarsViewModel carsViewModel) { var updatecar = new CarsModel { Id = 1, Name = "BestCar" }; _cardetailscontroller.Update(updatecar); }
public CarsViewModel(CarsModel carsModel) { CarsModel = carsModel; collectionViewSourceCars = new CollectionViewSource { Source = CarsModel.Cars }; collectionViewSourceCars.View.Filter = (o) => FilterCar((Car)o); Cars = collectionViewSourceCars.View; }
public ActionResult Edit([Bind(Include = "ID,Name,ReleaseDate,Model,Price")] CarsModel carsModel) { if (ModelState.IsValid) { db.Entry(carsModel).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(carsModel)); }
public bool SaveModel(CarsModel item) { try { ctxWrite.Models_AddEdit(item.ModelID, item.Marker_ID, item.TypeNameEn, item.TypeNameAr, item.Priority, item.Active, item.System_Who_Add, item.System_LastAction_IP); return(true); } catch { return(false); } }
//Week 3 -> R Reading from DB public ActionResult ReadCars() { //without Model Binding //create a list that can hold the values you are reading //List<string> CarsRead = new List<string>(); //with Model Binding //create a list of Model type List <CarsModel> cars = new List <CarsModel>(); ViewBag.Message = TempData["Rows"] as string; //try etc try { //create our statment SqlCommand myReadCommand = new SqlCommand("SELECT * FROM CarModels", cnn); //open our connection cnn.Open(); //read from db SqlDataReader dataThatIveRead = myReadCommand.ExecuteReader(); //-while we read load data into our list while (dataThatIveRead.Read()) { //this is without Model Binding // CarsRead.Add((string)dataThatIveRead["CarName"] + " " + (string)dataThatIveRead["CarModel"] + " " + (string)dataThatIveRead["CarPrice"]); //with Model Binding //create anew instance of a car CarsModel newcar = new CarsModel(); newcar.ID = (int)dataThatIveRead["CarId"]; newcar.Name = (string)dataThatIveRead["CarName"]; newcar.Model = (string)dataThatIveRead["CarModel"]; newcar.Price = (string)dataThatIveRead["CarPrice"]; cars.Add(newcar); } } catch (Exception ex) { TempData["Message"] = ex; return(RedirectToAction("Home", "Home")); } finally { //finally close our connection cnn.Close(); } return(View(cars)); }
public ActionResult Create([Bind(Include = "ID,Name,ReleaseDate,Model,Price")] CarsModel carsModel) { if (ModelState.IsValid) { db.cars.Add(carsModel); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(carsModel)); }
public async Task <IActionResult> Create([Bind("Id,Tm,V,VN,Cf,VT,Img,FImg")] CarsModel carsModel) { if (ModelState.IsValid) { _context.Add(carsModel); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(carsModel)); }
public async Car <IActionResult> Index() { var items = await _CarsItemService.GetIncompleteItemsAsync(); var model = new CarsModel() { Items = items }; return(View(model)); }
protected override void OnNavigatedTo(System.Windows.Navigation.NavigationEventArgs e) { base.OnNavigatedTo(e); string carIDStr; NavigationContext.QueryString.TryGetValue("id", out carIDStr); this.carID = int.Parse(carIDStr); //load settings for units string distance, volume, average, currency; bool avgmethod; IsolatedStorageSettings.ApplicationSettings.TryGetValue("distance", out distance); IsolatedStorageSettings.ApplicationSettings.TryGetValue("volume", out volume); IsolatedStorageSettings.ApplicationSettings.TryGetValue("average", out average); IsolatedStorageSettings.ApplicationSettings.TryGetValue("currency", out currency); IsolatedStorageSettings.ApplicationSettings.TryGetValue("avgmethod", out avgmethod); stMpgUnits.Text = distance.ToLower() + "/" + volume.ToLower(); FuelsModel fm = new FuelsModel(this.carID); listBoxFuel.ItemsSource = fm.GetRecords(); fuelOverallMpg.Text = fm.OverallFuelConsumption().ToString("F2") + " " + distance.ToLower() + "/" + volume.ToLower(); /* * tFuelCS.Text = fm.totalCost.ToString("F2"); * tFCPD.Text = (fm.totalCost / fm.GetTotalTimeSpan().Days).ToString(); * tAvgFuelCS.Text = (fm.totalCost/fm.totalFuel).ToString("F2"); * tFCPM.Text = (fm.totalCost / fm.GetTotalTimeSpan().Days * 30).ToString(); * tMilesPD.Text = (fm.totalMiles / fm.GetTotalTimeSpan().Days).ToString(); * tMilesPM.Text = (fm.totalMiles / fm.GetTotalTimeSpan().Days * 30).ToString(); */ //tFuelCS.Text = fm.totalCost.ToString("F2"); stMpg.Text = fm.OverallFuelConsumption().ToString("F2"); stCostpd.Text = currency + (fm.totalCost / fm.GetTotalTimeSpan().Days).ToString("F2") + " /day"; stCostpm.Text = currency + (fm.totalCost / fm.GetTotalTimeSpan().Days * 30).ToString("F2") + " /month"; stMilepd.Text = (fm.totalMiles / fm.GetTotalTimeSpan().Days).ToString("F2") + " " + distance + "/day"; stMilepm.Text = (fm.totalMiles / fm.GetTotalTimeSpan().Days * 30).ToString("F2") + " " + distance + "/month"; tFuelC.Text = currency + (fm.totalCost).ToString("F2"); MaintsModel mm = new MaintsModel(this.carID); listBoxMaint.ItemsSource = mm.GetRecords(); tTotalCostMaint.Text = currency + " " + mm.GetTotalCost().ToString(); tMaintCS.Text = currency + mm.GetTotalCost().ToString("F2"); tMaintParts.Text = "Parts: " + currency + " " + mm.TotalPartsCost.ToString("F2"); tMaintLabor.Text = "Labor: " + currency + " " + mm.TotalLaborCost.ToString("F2"); CarsModel cm = new CarsModel(this.carID); carInfo car = cm.GetCar(); tCarname.Text = car.CarModel; }
public CarViewModel(CarsModel carsModel, Car car) { this.carsModel = carsModel; this.car = car; if (car != null) { Brand = car.Brand; Type = car.Type; MaxSpeed = car.MaxSpeed; ProductionDate = car.ProductionDate; } }
/// <summary> /// Query Get Car data with filter id /// </summary> /// <param name="car"></param> /// <returns></returns> public IEnumerable <CarsModel> GetAllCarsFilter(CarsModel car) { var db = new SqliteDbAccess(); string query = "SELECT * FROM CarsModel where Id = @id"; Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary.Add("@id", car.Id); IEnumerable <CarsModel> hasil = db.Get <CarsModel>(query, dictionary); db.Dispose(); return(hasil); }
// GET: CarsModels/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CarsModel carsModel = db.cars.Find(id); if (carsModel == null) { return(HttpNotFound()); } return(View(carsModel)); }
public Car(CarsModel model, CarsType type, CarsEngine engine, string name, int power, int maxSpeed, double milage, DateTime year, bool available) { Id = Guid.NewGuid(); Model = model; Type = type; Engine = engine; Name = name; Power = power; MaxSpeed = maxSpeed; Milage = milage; YearOfProduction = year; isAvailable = available; }
public Task <CarsModel[]> GetNewCarsAsync() { var Car1 = new CarsModel { CarName = "BMW", Year = 2012 }; var Car2 = new CarsModel { CarName = "F150", Year = 2014 }; return(Task.FromResult(new[] { Car1, iCar2 })); }
/// <summary> /// CRUD - Delete Car Data Methode /// </summary> /// <param name="car"></param> /// <returns></returns> public int DeleteCar(CarsModel car) { var db = new SqliteDbAccess(); string query = "DELETE FROM CarsModel WHERE Id = @id"; Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary.Add("@id", car.Id); int hasil = db.Execution(query, dictionary); db.Dispose(); return(hasil); }
public void GetAllCarsFilterTest() { //Arrange var bm = new CRUDProcessors(); var carmodel = new CarsModel(); carmodel.Id = 7; // this ID value on Table data is Refer to Row 6, Toyota Car Model //Act obj.CarModels = bm.GetAllCarsFilter(carmodel); //Assert Assert.IsNotNull(obj.CarModels); bm.Dispose(); }
public void DeleteCarTest() { //Arrange var bm = new CRUDProcessors(); var carmodel = new CarsModel(); carmodel.Id = 12; // this ID value on Table data is Refer to Row 11, KIA Car Model obj.VarIntOutput = 0; //Act obj.VarIntOutput = bm.DeleteCar(carmodel); //Assert Assert.IsTrue(obj.VarIntOutput > 0, "The actual deletion was success on more than 1 row data"); bm.Dispose(); }