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); } }