public int Edit(TblEnderecoDAO entity) { parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@P0", entity.street)); parameters.Add(new SqlParameter("@P1", entity.number)); parameters.Add(new SqlParameter("@P2", entity.codeZip)); parameters.Add(new SqlParameter("@P3", entity.neighborhood)); parameters.Add(new SqlParameter("@P4", entity.city)); parameters.Add(new SqlParameter("@P5", entity.nmState)); return(ExecuteNonQuery(update)); }
public string saveChange() { string message = ""; try { TblEnderecoDAO tblEndenrecoDataRepository = new TblEnderecoDAO { idAddress = idAddress, neighborhood = neighborhood, nmState = nmState, number = number, street = street, city = city, codeZip = codeZip }; switch (State) { //Execulta reglas comerciais / calculos case EntityState.Add: tblEnderecoRepository.Add(tblEndenrecoDataRepository); message = "Usuário Cadastrado com sucesso!"; break; case EntityState.Modified: tblEnderecoRepository.Edit(tblEndenrecoDataRepository); message = "Usuário alterado com sucesso!"; break; case EntityState.Delete: tblEnderecoRepository.Remove((int)idAddress); message = "Usuário removido com sucesso!"; break; } return(message); } catch (Exception ex) { return(ex.Message); } }