public int Add(TblInfracaoDAO entity)
{
try
{
parameters = new List <SqlParameter>
{
new SqlParameter("@P0", entity.descInfraction),
new SqlParameter("@P1", entity.nmInfraction)
};
return(ExecuteNonQuery(insert));
}
catch (Exception ex)
{
throw ex;
}
}
public int Edit(TblInfracaoDAO entity)
{
try
{
parameters = new List <SqlParameter>
{
new SqlParameter("@P0", entity.descInfraction),
new SqlParameter("@P1", entity.nmInfraction),
new SqlParameter("@P2", entity.isActive)
};
return(ExecuteNonQuery(update));
}
catch (Exception ex)
{
throw ex;
}
}
public string saveChange()
{
string message = "";
try
{
TblInfracaoDAO tblInfracaoDataRepository = new TblInfracaoDAO();
{
tblInfracaoDataRepository.idInfraction = idInfraction;
tblInfracaoDataRepository.nmInfraction = nmInfraction;
tblInfracaoDataRepository.descInfraction = descInfraction;
tblInfracaoDataRepository.isActive = isActive;
}
switch (State)
{
//Execulta reglas comerciais / calculos
case EntityState.Add:
InfracaoRepository.Add(tblInfracaoDataRepository);
message = "Usuário Cadastrado com sucesso!";
break;
case EntityState.Modified:
InfracaoRepository.Edit(tblInfracaoDataRepository);
message = "Usuário alterado com sucesso!";
break;
case EntityState.Delete:
InfracaoRepository.Remove((int)idInfraction);
message = "Usuário removido com sucesso!";
break;
}
return(message);
}
catch (Exception ex)
{
return(ex.Message);
}
}
