public int Add(TblPecasDAO entity)
{
try
{
parameters = new List <SqlParameter>
{
new SqlParameter("@P0", entity.price),
new SqlParameter("@P1", entity.descPiece),
new SqlParameter("@P2", entity.dtBuy),
new SqlParameter("@P3", entity.dtStart)
};
return(ExecuteNonQuery(insert));
}
catch (Exception ex)
{
throw ex;
}
}
public string saveChange()
{
string message = "";
try
{
TblPecasDAO tblPecasDataRepository = new TblPecasDAO
{
idPiece = idPiece,
dtBuy = dtBuy,
dtFinish = dtFinish,
dtStart = dtStart,
price = price,
descPiece = descPiece
};
switch (State)
{
//Execulta reglas comerciais / calculos
case EntityState.Add:
pecasRepository.Add(tblPecasDataRepository);
message = "Usuário Cadastrado com sucesso!";
break;
case EntityState.Modified:
pecasRepository.Edit(tblPecasDataRepository);
message = "Usuário alterado com sucesso!";
break;
case EntityState.Delete:
pecasRepository.Remove((int)idPiece);
message = "Usuário removido com sucesso!";
break;
}
return(message);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public int Edit(TblPecasDAO entity)
{
try
{
parameters = new List <SqlParameter>
{
new SqlParameter("@P0", entity.idPiece),
new SqlParameter("@P1", entity.price),
new SqlParameter("@P2", entity.descPiece),
new SqlParameter("@P3", entity.dtBuy),
new SqlParameter("@P4", entity.dtStart),
new SqlParameter("@P5", entity.dtFinish)
};
return(ExecuteNonQuery(update));
}
catch (Exception ex)
{
throw ex;
}
}
public int Edit(TblPecasDAO entity)
{
throw new NotImplementedException();
}
