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