Esempio n. 1
0
        private List <Adenda> GetList()
        {
            try
            {
                Sesion sesion = (Sesion)Session["Sesion" + Session.SessionID];

                List <Adenda> listAdenda   = new List <Adenda>();
                CN_CatAdenda  clsCatAdenda = new CN_CatAdenda();
                Adenda        tipoPrecio   = new Adenda();
                tipoPrecio.Id_Emp = sesion.Id_Emp;
                tipoPrecio.Id_Cd  = sesion.Id_Cd_Ver;
                clsCatAdenda.ConsultaAdenda(tipoPrecio, sesion.Emp_Cnx, ref listAdenda);
                return(listAdenda);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 2
0
        private void CargarAdendas(int Id_Ade)
        {
            try
            {
                DataTable    dt       = DTAddendas;
                Sesion       sesion   = (Sesion)Session["Sesion" + Session.SessionID];
                CN_CatAdenda cnAdenda = new CN_CatAdenda();
                Adenda       adenda   = new Adenda();
                adenda.Id_Emp = sesion.Id_Emp;
                adenda.Id_Cd  = sesion.Id_Cd_Ver;
                adenda.Id_Ade = Id_Ade;
                cnAdenda.ConsultaAdenda(adenda, ref dt, sesion.Emp_Cnx);

                DTAddendas = dt;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 3
0
        private void Guardar()
        {
            try
            {
                Sesion session = (Sesion)Session["Sesion" + Session.SessionID];

                Adenda adenda = new Adenda();
                adenda.Id_Emp          = session.Id_Emp;
                adenda.Id_Cd           = session.Id_Cd_Ver;
                adenda.Id_Ade          = txtId.Text.Trim() == string.Empty ? 0 : Convert.ToInt32(txtId.Text);
                adenda.Tco_Descripcion = txtDescripcion.Text;
                adenda.Tco_Activo      = chkActivo.Checked;

                CN_CatAdenda clsCatAdenda = new CN_CatAdenda();
                int          verificador  = -1;

                DataRow[] Ar_dr;

                //GRIDS DE FACTURAS
                for (int i = 0; i < rgFacturacioncabecera.Items.Count; i++)
                {
                    Ar_dr = DTAddendas.Select("Det='" + (rgFacturacioncabecera.Items[i].FindControl("lblDet") as Label).Text + "' and Tipo='" + (rgFacturacioncabecera.Items[i].FindControl("lblTipo") as Label).Text + "'");
                    Ar_dr[0].BeginEdit();
                    Ar_dr[0]["Requerido"] = (rgFacturacioncabecera.Items[i].FindControl("chkRequerido") as CheckBox).Checked;
                    Ar_dr[0].AcceptChanges();
                }
                for (int i = 0; i < rgFacturacionDetalle.Items.Count; i++)
                {
                    Ar_dr = DTAddendas.Select("Det='" + (rgFacturacionDetalle.Items[i].FindControl("lblDet") as Label).Text + "' and Tipo='" + (rgFacturacionDetalle.Items[i].FindControl("lblTipo") as Label).Text + "'");
                    Ar_dr[0].BeginEdit();
                    Ar_dr[0]["Requerido"] = (rgFacturacionDetalle.Items[i].FindControl("chkRequerido") as CheckBox).Checked;
                    Ar_dr[0].AcceptChanges();
                }

                //GRIDS DE CARGO
                for (int i = 0; i < rgCargocabecera.Items.Count; i++)
                {
                    Ar_dr = DTAddendas.Select("Det='" + (rgCargocabecera.Items[i].FindControl("lblDet") as Label).Text + "' and Tipo='" + (rgCargocabecera.Items[i].FindControl("lblTipo") as Label).Text + "'");
                    Ar_dr[0].BeginEdit();
                    Ar_dr[0]["Requerido"] = (rgCargocabecera.Items[i].FindControl("chkRequerido") as CheckBox).Checked;
                    Ar_dr[0].AcceptChanges();
                }
                for (int i = 0; i < rgCargoDetalle.Items.Count; i++)
                {
                    Ar_dr = DTAddendas.Select("Det='" + (rgCargoDetalle.Items[i].FindControl("lblDet") as Label).Text + "' and Tipo='" + (rgCargoDetalle.Items[i].FindControl("lblTipo") as Label).Text + "'");
                    Ar_dr[0].BeginEdit();
                    Ar_dr[0]["Requerido"] = (rgCargoDetalle.Items[i].FindControl("chkRequerido") as CheckBox).Checked;
                    Ar_dr[0].AcceptChanges();
                }

                //GRIDS DE CREDITO
                for (int i = 0; i < rgCreditocabecera.Items.Count; i++)
                {
                    Ar_dr = DTAddendas.Select("Det='" + (rgCreditocabecera.Items[i].FindControl("lblDet") as Label).Text + "' and Tipo='" + (rgCreditocabecera.Items[i].FindControl("lblTipo") as Label).Text + "'");
                    Ar_dr[0].BeginEdit();
                    Ar_dr[0]["Requerido"] = (rgCreditocabecera.Items[i].FindControl("chkRequerido") as CheckBox).Checked;
                    Ar_dr[0].AcceptChanges();
                }
                for (int i = 0; i < rgCreditoDetalle.Items.Count; i++)
                {
                    Ar_dr = DTAddendas.Select("Det='" + (rgCreditoDetalle.Items[i].FindControl("lblDet") as Label).Text + "' and Tipo='" + (rgCreditoDetalle.Items[i].FindControl("lblTipo") as Label).Text + "'");
                    Ar_dr[0].BeginEdit();
                    Ar_dr[0]["Requerido"] = (rgCreditoDetalle.Items[i].FindControl("chkRequerido") as CheckBox).Checked;
                    Ar_dr[0].AcceptChanges();
                }

                //GRIDS DE REFACTURAS
                for (int i = 0; i < rgRefacturacioncabecera.Items.Count; i++)
                {
                    Ar_dr = DTAddendas.Select("Det='" + (rgRefacturacioncabecera.Items[i].FindControl("lblDet") as Label).Text + "' and Tipo='" + (rgRefacturacioncabecera.Items[i].FindControl("lblTipo") as Label).Text + "'");
                    Ar_dr[0].BeginEdit();
                    Ar_dr[0]["Requerido"] = (rgRefacturacioncabecera.Items[i].FindControl("chkRequerido") as CheckBox).Checked;
                    Ar_dr[0].AcceptChanges();
                }
                for (int i = 0; i < rgRefacturacionDetalle.Items.Count; i++)
                {
                    Ar_dr = DTAddendas.Select("Det='" + (rgRefacturacionDetalle.Items[i].FindControl("lblDet") as Label).Text + "' and Tipo='" + (rgRefacturacionDetalle.Items[i].FindControl("lblTipo") as Label).Text + "'");
                    Ar_dr[0].BeginEdit();
                    Ar_dr[0]["Requerido"] = (rgRefacturacionDetalle.Items[i].FindControl("chkRequerido") as CheckBox).Checked;
                    Ar_dr[0].AcceptChanges();
                }

                //--------
                if (hiddenActualiza.Value == string.Empty)
                {
                    if (!_PermisoGuardar)
                    {
                        Alerta("No tiene permisos para grabar");
                        return;
                    }

                    clsCatAdenda.InsertarAdenda(adenda, session.Emp_Cnx, DTAddendas, ref verificador);
                    if (verificador > 0)
                    {
                        hiddenActualiza.Value = txtId.Text;
                        this.LimpiarCampos();

                        Alerta("Los datos se guardaron correctamente");
                    }
                    else
                    {
                        Alerta("La clave ya existe");
                    }
                }
                else
                {
                    if (!_PermisoModificar)
                    {
                        Alerta("No tiene permisos para modificar");
                        return;
                    }

                    clsCatAdenda.ModificarAdenda(adenda, session.Emp_Cnx, DTAddendas, ref verificador);

                    txtId.Enabled = false;
                    if (verificador > 0)
                    {
                        Alerta("Los datos se modificaron correctamente");
                    }
                    else
                    {
                        Alerta("Ocurrió un error al intentar modificar los datos");
                    }
                }

                rgAdendas.Rebind();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }