private void metroButton1_Click(object sender, EventArgs e)
{
if (value.Text != "")
{
Domain.Entities.AmountCar amount = new Domain.Entities.AmountCar()
{
idCar = Car.Id,
Amount = decimal.Parse(value.Text),
};
try
{
if (isNew)
{
_appAmount.Insert(amount);
Database.DBCar _appCar = new Database.DBCar();
_appCar.Provide(Car.Id);
MetroMessageBox.Show(this, "Valor Adicionado", "Sucesso", MessageBoxButtons.OK, MessageBoxIcon.Question, 100);
}
else
{
_appAmount.Update(amount);
MetroMessageBox.Show(this, "Valor Editado", "Sucesso", MessageBoxButtons.OK, MessageBoxIcon.Question, 100);
}
this.Close();
}
catch
{
MetroMessageBox.Show(this, "Erro inesperado", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error, 100);
}
}
}
public Domain.Entities.AmountCar GetAmount(string sql)
{
Connect();
cd.Connection = cn;
cd.CommandText = sql;
Domain.Entities.AmountCar amount = new Domain.Entities.AmountCar();
SqlDataReader reader = cd.ExecuteReader();
if (reader.Read())
{
amount = ConstructorAmount(reader);
}
cn.Close();
return(amount);
}
public void Insert(Domain.Entities.AmountCar amount)
{
query = $"insert into AmountsCar(idCar, Amount) values ({amount.idCar}, {(float)amount.Amount})";
_context.CommandWithoutReturn(query);
}
public void Update(Domain.Entities.AmountCar amount)
{
query = $@"update AmountsCar set Amount = {(float)amount.Amount} where idCar = {amount.idCar}";
_context.CommandWithoutReturn(query);
}
