コード例 #1
0
        public static void Delete(dtoProcessoDespesa ProcessoDespesa)
        {
            using (SqlConnection connection = new SqlConnection(DataAccess.Configuracao.getConnectionString()))
            {
                string stringSQL = @"DELETE tbProcessoDespesa 
                                      WHERE idProcessoDespesa = @idProcessoDespesa";

                SqlCommand cmdMenu = new SqlCommand(stringSQL, connection);
                cmdMenu.Parameters.Add("idProcessoDespesa", SqlDbType.Int).Value = ProcessoDespesa.idProcessoDespesa;

                try
                {
                    connection.Open();
                    cmdMenu.ExecuteNonQuery();
                }
                catch
                {
                    throw new ApplicationException("Erro ao excluir registro");
                }
                finally
                {
                    connection.Close();
                }
            }
        }
コード例 #2
0
        private static void PreencheCampos(SqlDataReader drProcessoDespesa, ref dtoProcessoDespesa ProcessoDespesa)
        {
            if (drProcessoDespesa["idProcessoDespesa"] != DBNull.Value)
            {
                ProcessoDespesa.idProcessoDespesa = Convert.ToInt32(drProcessoDespesa["idProcessoDespesa"].ToString());
            }

            if (drProcessoDespesa["idProcesso"] != DBNull.Value)
            {
                ProcessoDespesa.idProcesso = Convert.ToInt32(drProcessoDespesa["idProcesso"].ToString());
            }

            if (drProcessoDespesa["Descricao"] != DBNull.Value)
            {
                ProcessoDespesa.Descricao = drProcessoDespesa["Descricao"].ToString();
            }

            if (drProcessoDespesa["Valor"] != DBNull.Value)
            {
                ProcessoDespesa.Valor = Convert.ToSingle(drProcessoDespesa["Valor"].ToString());
            }

            if (drProcessoDespesa["Observacoes"] != DBNull.Value)
            {
                ProcessoDespesa.Observacoes = drProcessoDespesa["Observacoes"].ToString();
            }
        }
コード例 #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                if (Request.QueryString["ID"] == null || Request.QueryString["ID"].Trim() == String.Empty)
                {
                    ConfiguraModoCRUD(DetailsViewMode.Insert);
                }
                else
                {
                    dtoProcessoDespesa processoDespesa = bllProcessoDespesa.Get(Convert.ToInt32(Request.QueryString["ID"]));

                    if (processoDespesa != null && processoDespesa.idProcessoDespesa != 0)
                    {
                        ConfiguraModoCRUD(DetailsViewMode.ReadOnly);
                    }
                }
            }

            InicializaEventos();
            InicializaDefaultButton();

            Master.litCaminhoPrincipal.Text  = "Manutenção > ";
            Master.litCaminhoSecundario.Text = "Processo > Despesa";
        }
コード例 #4
0
 private static void ValidaCampos(ref dtoProcessoDespesa ProcessoDespesa)
 {
     if (String.IsNullOrEmpty(ProcessoDespesa.Descricao))
     {
         ProcessoDespesa.Descricao = String.Empty;
     }
     if (String.IsNullOrEmpty(ProcessoDespesa.Observacoes))
     {
         ProcessoDespesa.Observacoes = String.Empty;
     }
 }
コード例 #5
0
        public static List <dtoProcessoDespesa> GetAll(int idProcesso, string SortExpression)
        {
            List <dtoProcessoDespesa> ProcessoDespesas = new List <dtoProcessoDespesa>();

            using (SqlConnection connection = new SqlConnection(DataAccess.Configuracao.getConnectionString()))
            {
                StringBuilder sbCondicao = new StringBuilder();

                sbCondicao.AppendFormat(@" WHERE (tbProcessoDespesa.idProcesso = {0})", idProcesso.ToString());

                string stringSQL = String.Format(@"SELECT * 
                                                FROM tbProcessoDespesa 
                                                {0} 
                                                ORDER BY {1}",
                                                 sbCondicao.ToString(),
                                                 (SortExpression.Trim() != String.Empty ? SortExpression.Trim() : "idProcessoDespesa"));

                SqlCommand cmdProcessoDespesa = new SqlCommand(stringSQL, connection);

                try
                {
                    connection.Open();
                    SqlDataReader drProcessoDespesa = cmdProcessoDespesa.ExecuteReader();

                    while (drProcessoDespesa.Read())
                    {
                        dtoProcessoDespesa ProcessoDespesa = new dtoProcessoDespesa();

                        PreencheCampos(drProcessoDespesa, ref ProcessoDespesa);

                        ProcessoDespesas.Add(ProcessoDespesa);
                    }
                }
                catch
                {
                    throw new ApplicationException("Erro ao capturar todos os registros");
                }
                finally
                {
                    connection.Close();
                }
            }

            return(ProcessoDespesas);
        }
コード例 #6
0
        public static void Update(dtoProcessoDespesa ProcessoDespesa)
        {
            using (SqlConnection connection = new SqlConnection(DataAccess.Configuracao.getConnectionString()))
            {
                string stringSQL = @"UPDATE tbProcessoDespesa SET 
                                        idProcesso = @idProcesso,
                                        Descricao = @Descricao,
                                        Valor = @Valor,
                                        Observacoes = @Observacoes
                                      WHERE idProcessoDespesa = @idProcessoDespesa";

                SqlCommand cmdProcessoDespesa = new SqlCommand(stringSQL, connection);

                ValidaCampos(ref ProcessoDespesa);

                cmdProcessoDespesa.Parameters.Add("idProcessoDespesa", SqlDbType.Int).Value = ProcessoDespesa.idProcessoDespesa;

                cmdProcessoDespesa.Parameters.Add("idProcesso", SqlDbType.Int).Value      = ProcessoDespesa.idProcesso;
                cmdProcessoDespesa.Parameters.Add("Descricao", SqlDbType.VarChar).Value   = ProcessoDespesa.Descricao;
                cmdProcessoDespesa.Parameters.Add("Valor", SqlDbType.Float).Value         = ProcessoDespesa.Valor;
                cmdProcessoDespesa.Parameters.Add("Observacoes", SqlDbType.VarChar).Value = ProcessoDespesa.Observacoes;

                try
                {
                    connection.Open();
                    cmdProcessoDespesa.ExecuteNonQuery();
                }
                catch
                {
                    throw new ApplicationException("Erro ao atualizar registro");
                }
                finally
                {
                    connection.Close();
                }
            }
        }
コード例 #7
0
        public static int Insert(dtoProcessoDespesa ProcessoDespesa)
        {
            using (SqlConnection connection = new SqlConnection(DataAccess.Configuracao.getConnectionString()))
            {
                string stringSQL = @"INSERT INTO tbProcessoDespesa(idProcesso, Descricao, Valor, Observacoes)
                                            VALUES(@idProcesso, @Descricao, @Valor, @Observacoes);
                                            SET @idProcessoDespesa = SCOPE_IDENTITY()";

                SqlCommand cmdProcessoDespesa = new SqlCommand(stringSQL, connection);

                ValidaCampos(ref ProcessoDespesa);

                cmdProcessoDespesa.Parameters.Add("idProcessoDespesa", SqlDbType.Int);
                cmdProcessoDespesa.Parameters["idProcessoDespesa"].Direction = ParameterDirection.Output;

                cmdProcessoDespesa.Parameters.Add("idProcesso", SqlDbType.Int).Value      = ProcessoDespesa.idProcesso;
                cmdProcessoDespesa.Parameters.Add("Descricao", SqlDbType.VarChar).Value   = ProcessoDespesa.Descricao;
                cmdProcessoDespesa.Parameters.Add("Valor", SqlDbType.Float).Value         = ProcessoDespesa.Valor;
                cmdProcessoDespesa.Parameters.Add("Observacoes", SqlDbType.VarChar).Value = ProcessoDespesa.Observacoes;

                try
                {
                    connection.Open();
                    cmdProcessoDespesa.ExecuteNonQuery();

                    return((int)cmdProcessoDespesa.Parameters["idProcessoDespesa"].Value);
                }
                catch
                {
                    throw new ApplicationException("Erro ao inserir registro");
                }
                finally
                {
                    connection.Close();
                }
            }
        }
コード例 #8
0
        public static dtoProcessoDespesa Get(int idProcessoDespesa)
        {
            dtoProcessoDespesa ProcessoDespesa = new dtoProcessoDespesa();

            using (SqlConnection connection = new SqlConnection(DataAccess.Configuracao.getConnectionString()))
            {
                string stringSQL = @"SELECT *
                                    FROM tbProcessoDespesa
                                    WHERE idProcessoDespesa = @idProcessoDespesa";

                SqlCommand cmdMenu = new SqlCommand(stringSQL, connection);

                cmdMenu.Parameters.Add("idProcessoDespesa", SqlDbType.Int).Value = idProcessoDespesa;

                try
                {
                    connection.Open();
                    SqlDataReader drProcessoDespesa = cmdMenu.ExecuteReader();

                    if (drProcessoDespesa.Read())
                    {
                        PreencheCampos(drProcessoDespesa, ref ProcessoDespesa);
                    }
                }
                catch
                {
                    throw new ApplicationException("Erro ao capturar registro");
                }
                finally
                {
                    connection.Close();
                }
            }

            return(ProcessoDespesa);
        }