public int Add(TblVeiculoDAO entity)
{
try
{
parameters = new List <SqlParameter>
{
new SqlParameter("@P0", entity.descVehicle),
new SqlParameter("@P1", entity.board),
new SqlParameter("@P2", entity.idCompany),
new SqlParameter("@P3", entity.kilometro),
new SqlParameter("@P4", entity.year)
};
return(ExecuteNonQuery(insert));
}
catch (Exception ex)
{
throw ex;
}
}
public string saveChange()
{
string message = "";
try
{
TblVeiculoDAO tblVeiculoDataRepository = new TblVeiculoDAO();
{
tblVeiculoDataRepository.idVehicle = idVehicle;
tblVeiculoDataRepository.descVehicle = descVehicle;
tblVeiculoDataRepository.board = board;
tblVeiculoDataRepository.idCompany = idCompany;
tblVeiculoDataRepository.kilometro = kilometro;
tblVeiculoDataRepository.year = year;
}
switch (State)
{
//Execulta reglas comerciais / calculos
case EntityState.Add:
veiculoRepository.Add(tblVeiculoDataRepository);
message = "Usuário Cadastrado com sucesso!";
break;
case EntityState.Modified:
veiculoRepository.Edit(tblVeiculoDataRepository);
message = "Usuário alterado com sucesso!";
break;
case EntityState.Delete:
veiculoRepository.Remove((int)idVehicle);
message = "Usuário removido com sucesso!";
break;
}
return(message);
}
catch (Exception ex)
{
return(ex.Message);
}
}
