Пример #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (Session["usuario"] == null)
                {
                    Response.Redirect("login.aspx");
                }
                else
                {
                    lblusuario.Text = Session["usuario"].ToString();
                }
                if (!IsPostBack)
                {
                    Class_Vendedor vend = new Class_Vendedor();       // cria o objeto vendedor
                    DropDownList1.DataSource     = vend.visualizar(); // carrega os vendedores
                    DropDownList1.DataTextField  = "nome";            //associa o campo nome do banco de dados ao dropdown
                    DropDownList1.DataValueField = "matricula";       //associa o campo Matricula do banco de dados ao dropdown
                    DropDownList1.DataBind();                         //constroi os dados na tela

                    Class_Venda venda = new Class_Venda();            // cria o objeto venda
                    GridView1.DataSource = venda.visualizar();        //carrega todos as venda
                    GridView1.DataBind();                             //constroi os dados na tela
                }
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
            }
        }
 protected void btn_Excluir_Click(object sender, EventArgs e)
 {
     try
     {
         Class_Vendedor vend = new Class_Vendedor();
         vend.matricula = txtmatricula.Text;
         vend.deletar();
     }
     catch (Exception ex)
     {
         Response.Write(ex.Message);
     }
 }
 protected void btn_Visualizar_Click(object sender, EventArgs e)
 {
     try
     {
         Class_Vendedor vend = new Class_Vendedor();
         GridView1.DataSource = vend.visualizar();
         GridView1.DataBind();
     }
     catch (Exception ex)
     {
         Response.Write(ex.Message);
     }
 }
 protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
 {
     try
     {
         GridView1.EditIndex = e.NewEditIndex;
         Class_Vendedor vend = new Class_Vendedor();
         GridView1.DataSource = vend.visualizar();
         GridView1.DataBind();
     }
     catch (Exception ex)
     {
         Response.Write(ex.Message);
     }
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         if (!IsPostBack)
         {
             Class_Vendedor vend = new Class_Vendedor();
             GridView1.DataSource = vend.visualizar();
             GridView1.DataBind();
         }
     }
     catch (Exception ex)
     {
         Response.Write(ex.Message);
     }
 }
        protected void btn_Alterar_Click(object sender, EventArgs e)
        {
            try
            {
                Class_Vendedor vend = new Class_Vendedor();
                vend.matricula = txtmatricula.Text;
                vend.nome      = txtnome.Text;
                vend.datanasc  = DateTime.Parse(txtdatanasc.Text);
                vend.comissao  = decimal.Parse(txtcomissao.Text);

                vend.alterar_dados();
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
            }
        }
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            try
            {
                Class_Vendedor vend = new Class_Vendedor();
                vend.matricula = e.Values[0].ToString();
                vend.deletar();

                GridView1.EditIndex  = -1;
                GridView1.DataSource = vend.visualizar();
                GridView1.DataBind();
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
            }
        }
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            try
            {
                Class_Vendedor vend = new Class_Vendedor();
                vend.matricula = e.NewValues[0].ToString();
                vend.nome      = e.NewValues[1].ToString();
                vend.datanasc  = DateTime.Parse(e.NewValues[2].ToString());
                vend.comissao  = decimal.Parse(e.NewValues[3].ToString());

                vend.alterar_dados();

                GridView1.EditIndex = -1;

                GridView1.DataSource = vend.visualizar();
                GridView1.DataBind();
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
            }
        }