Exemple #1
0
 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);
            }
        }