public IActionResult UpdateCar([FromQuery] int id, [FromBody] TblCar car)
{
if (id == 0)
{
return(BadRequest());
}
int rowsAffected;
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Id", id);
parameters.Add("@Brand", car.Brand);
parameters.Add("@Model", car.Model);
parameters.Add("@Price", car.Price);
rowsAffected = con.Execute("USP_EditCar", parameters, commandType: CommandType.StoredProcedure);
if (rowsAffected != 0)
{
return(Ok());
}
else
{
return(BadRequest());
}
}
public IActionResult AddCar(TblCar car)
{
int rowsAffected;
//DynamicParameters parameters = new DynamicParameters(); //normal way
//parameters.Add("@Brand",car.Brand);
//parameters.Add("@Model",car.Model);
//parameters.Add("@Price",car.Price);
DataTable data = new DataTable(); // using Datatable
data.Columns.Add("Brand", typeof(string));
data.Columns.Add("Model", typeof(string));
data.Columns.Add("Price", typeof(int));
data.Rows.Add(car.Brand, car.Model, car.Price);
//rowsAffected = con.Execute("USP_AddCar", parameters , commandType: CommandType.StoredProcedure);
rowsAffected = con.Execute("USP_AddCar", new { car = data.AsTableValuedParameter("dbo.UDT_Car") }, commandType: CommandType.StoredProcedure);
if (rowsAffected != 0)
{
return(Ok());
}
else
{
return(BadRequest());
}
}
//Add
private void OnAdd(object sender, RoutedEventArgs e)
{
if (ValidateForm())
{
using (DbCarContext _context = new DbCarContext())
{
var car = _context.TblCar.Find((CarDG.SelectedItem as TblCar).Id);
bool carExists = (car != null) ? true : false;
if (!carExists)
{
TblCar tblCar = new TblCar()
{
Brand = Brand.Text,
Model = Model.Text,
Price = int.Parse(Price.Text)
};
_context.TblCar.Add(tblCar);
}
else
{
TblCar EditCar = _context.TblCar.Find((CarDG.SelectedItem as TblCar).Id);
EditCar.Brand = Brand.Text;
EditCar.Model = Model.Text;
EditCar.Price = int.Parse(Price.Text);
_context.TblCar.Update(EditCar);
}
_context.SaveChanges();
}
ResetForm();
LoadData();
}
}
//Edit button clicked
private void OnEdit(object sender, RoutedEventArgs e)
{
int id = (CarDG.SelectedItem as TblCar).Id;
using (DbCarContext _context = new DbCarContext())
{
TblCar car = _context.TblCar.Find(id);
Brand.Text = car.Brand;
Model.Text = car.Model;
Price.Text = car.Price.ToString();
}
}
//Delete button clicked
private void OnDelete(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Are you sure you want to delete this record?", "Confirm Delete", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
int id = (CarDG.SelectedItem as TblCar).Id;
using (DbCarContext _context = new DbCarContext())
{
TblCar car = new TblCar()
{
Id = id
};
_context.TblCar.Attach(car);
_context.TblCar.Remove(car);
_context.SaveChanges();
}
LoadData();
}
}
