示例#1
0
        protected void btnUDoc_Click(object sender, EventArgs e)
        {
            try
            {
                if (fp_Doc_xls.HasFile)
                {
                    lblEL.Visible      = false;
                    btnUDoc.Enabled    = false;
                    fp_Doc_xls.Enabled = false;
                    if (fp_Doc_xls.FileName.Contains(".xls") | fp_Doc_xls.FileName.Contains(".xlsx"))
                    {
                        var             er   = fp_Doc_xls.FileName.Contains(".xlsx") ? ExcelReaderFactory.CreateOpenXmlReader(fp_Doc_xls.PostedFile.InputStream) : ExcelReaderFactory.CreateBinaryReader(fp_Doc_xls.PostedFile.InputStream);
                        var             excp = er.AsDataSet().Tables["Clientes"].AsEnumerable();
                        Int64           i64;
                        int             inserted = 0;
                        int             cont     = 0;
                        string          res      = "";
                        string          tEx      = "";
                        string          ex       = "";
                        DateTime        dt;
                        List <ICliPTO>  lEx  = new List <ICliPTO>();
                        ServCBloqueados serv = new ServCBloqueados();
                        serv.truncateClients("2");

                        foreach (var a in excp)
                        {
                            if (cont > 0)
                            {
                                tEx = a[2].ToString();
                                if (tEx.ToLower().Trim().CompareTo("cartera vencida") == 0 || tEx.ToLower().Trim().CompareTo("cv") == 0)
                                {
                                    ex = "CV";
                                }
                                else
                                if (tEx.ToLower().Trim().CompareTo("sobrecupo") == 0 || tEx.ToLower().Trim().CompareTo("sc") == 0)
                                {
                                    ex = "SC";
                                }
                                else
                                if (tEx.ToLower().Trim().CompareTo("sobrecupo y cartera vencida") == 0 || tEx.ToLower().Trim().CompareTo("scv") == 0)
                                {
                                    ex = "SCV";
                                }
                                else
                                if (tEx.ToLower().Trim().CompareTo("sin saldo para programar") == 0 || tEx.ToLower().Trim().CompareTo("ssp") == 0)
                                {
                                    ex = "SSP";
                                }

                                if (a[0].ToString().CompareTo("") == 0 || ex.CompareTo("") == 0)
                                {
                                    if (a[0].ToString().CompareTo("") != 0)
                                    {
                                        lEx.Add(new CliPTO(a[0].ToString(), a[1].ToString(), a[2].ToString()));
                                    }
                                }
                                else
                                {
                                    res = serv.insertClient(a[0].ToString(), a[1].ToString(), ((IUsr)Session["Usr"]).usr.CemexId.ToString(), ex, ((IUsr)Session["Usr"]).usr.Pais.IdPais.ToString(), "3");
                                }


                                if (res.CompareTo("0") == 0 && a[0].ToString().CompareTo("") != 0)
                                {
                                    lEx.Add(new CliPTO(a[0].ToString(), a[1].ToString(), a[2].ToString()));
                                }

                                if (res.CompareTo("1") == 0)
                                {
                                    inserted++;
                                }
                            }
                            cont++;
                            ex = "";
                        }

                        if (cont < 1)
                        {
                            lblMsgLDB.Visible = false;
                            lblELDB.Visible   = false;
                            lblEL.ForeColor   = Color.Red;
                            lblEL.Text        = "El archivo no contiene datos Validos";
                            lblEL.Visible     = true;
                        }

                        if (lEx.Count > 0)
                        {
                            gv_Error.DataSource = lEx;
                            gv_Error.DataBind();
                            gv_Error.Visible  = true;
                            lblELDB.ForeColor = Color.Red;
                            lblELDB.Text      = "Datos no Cargados";
                            lblELDB.Visible   = true;
                        }
                        if (lEx.Count == 0 && inserted == 0)
                        {
                            lblMsgLDB.Visible = false;
                            lblELDB.Visible   = false;
                            lblEL.ForeColor   = Color.Red;
                            lblEL.Text        = "El archivo no contiene datos";
                            lblEL.Visible     = true;
                        }
                        else
                        {
                            if (inserted > 0 && lEx.Count == 0)
                            {
                                lblMsgLDB.Visible = false;
                                lblELDB.Visible   = false;
                                lblEL.ForeColor   = Color.Green;
                                lblEL.Text        = "Datos insertados correctamente";
                                lblEL.Visible     = true;
                            }
                        }
                    }
                    else
                    {
                        lblMsgLDB.Visible = false;
                        lblELDB.Visible   = false;
                        lblEL.Text        = "Tipo de archivo no valido";
                        lblEL.Visible     = true;
                    }
                    btnF.Visible = true;
                }
                else
                {
                    lblMsgLDB.Visible = false;
                    lblELDB.Visible   = false;
                    lblEL.Text        = "Por favor seleccione un archivo de clientes a Cargar.";
                    lblEL.Visible     = true;
                }
            }
            catch (Exception exe)
            {
                btnUDoc.Enabled    = true;
                fp_Doc_xls.Enabled = true;
                lblMsgLDB.Visible  = false;
                lblELDB.Visible    = false;
                lblEL.Text         = "Se ha generado un error. Contacte al Administrador de la aplicación";
                lblEL.Visible      = true;
                //throw;
            }
        }
示例#2
0
        protected void gvCliBlo_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            switch (e.CommandName)
            {
            case "Nuevo":
            {
                #region Nuevo

                Session["editOp"] = false;

                MpUp_MA.Hide();

                gvCliBlo.EditIndex = -1;
                Session["dtDoc"]   = null;
                DataTable dt = ((DataTable)Session["dtCBloqueados"]).Copy();
                Session["RANew"] = Convert.ToInt32(e.CommandArgument.ToString());
                if (dt.Rows[0][0].ToString() == "##" & gvCliBlo.Rows.Count == 1)
                {
                    gvCliBlo.EditIndex  = 0;
                    gvCliBlo.DataSource = dt;
                    gvCliBlo.DataBind();
                }
                else
                {
                    DataRow rw = dt.NewRow();
                    for (int i = 0; i <= dt.Columns.Count - 1; i++)
                    {
                        rw[i] = DBNull.Value;
                    }
                    dt.Rows.Add(rw);
                    gvCliBlo.DataSource = dt;
                    gvCliBlo.DataBind();
                    gvCliBlo.PageIndex = gvCliBlo.PageCount;
                    gvCliBlo.DataBind();
                    gvCliBlo.EditIndex = gvCliBlo.Rows.Count - 1;
                    gvCliBlo.DataBind();
                }
                IServCBloqueados serv = new ServCBloqueados();

                var dtTEx = serv.getTypeExceptions();
                LdDdlGv(gvCliBlo, dtTEx, "ddlTExCli | IdTEx | NTEx", 1);

                #endregion
            }
            break;

            case "Buscar":
            {
                #region Buscar


                Session["dtDoc"] = null;
                DataTable dt2 = ((DataTable)Session["dtCBloqueados"]).Copy();
                if (dt2.Rows[0][0].ToString() == "##" & gvCliBlo.Rows.Count == 1)
                {
                    return;
                }
                gvCliBlo.EditIndex = -1;



                gvCliBlo.DataSource = Session["dtCBloqueados"];
                gvCliBlo.DataBind();
                gv_Alertas.DataSource = new DataTable();
                gv_Alertas.DataBind();

                txtIdBusq.Text  = String.Empty;
                txtMSGBusq.Text = String.Empty;

                lblId.Text     = "Id:";
                lblTxtCod.Text = "Codigo:";


                txtIdBusq_TextBoxWatermarkExtender.WatermarkText  = "Id";
                txtMSGBusq_TextBoxWatermarkExtender.WatermarkText = "Cliente";

                gv_Alertas.Visible = true;


                pnlMpBA.Visible = true;
                MpUp_MA.Show();



                #endregion
            }
            break;

            case "Editar":
            {
                #region Editar
                Session["dtDoc"] = null;
                DataTable dt = ((DataTable)Session["dtCBloqueados"]).Copy();

                DropDownList ddl = ((DropDownList)gvCliBlo.Rows[Convert.ToInt32(e.CommandArgument.ToString())].FindControl("ddlTExCli"));

                ServCBloqueados serv = new ServCBloqueados();

                string IdCli = gvCliBlo.Rows[Convert.ToInt32(e.CommandArgument.ToString())].Cells[0].Text.Trim();
                string tEx   = "";
                Session["editOp"] = true;

                MpUp_MA.Hide();

                if (dt.Rows[0][0].ToString() != "##")
                {
                    Session["RANew"]    = 0;
                    gvCliBlo.EditIndex  = Convert.ToInt32(e.CommandArgument.ToString());
                    gvCliBlo.DataSource = Session["dtCBloqueados"];
                    gvCliBlo.DataBind();
                }
                ((TextBox)gvCliBlo.Rows[Convert.ToInt32(e.CommandArgument.ToString())].FindControl("txtIdCli")).Enabled = false;


                var dtTEx = serv.getTypeExceptions();

                var itemSelected = serv.findClient(IdCli.ToString(), "8", ((IUsr)Session["Usr"]).usr.Pais.IdPais.ToString());

                foreach (DataRow row in itemSelected.Rows)
                {
                    tEx = row["IdTEx"].ToString();
                }

                LdDdlGv(gvCliBlo, dtTEx, "ddlTExCli | IdTEx | NTEx", 2, null, tEx);



                #endregion
            }
            break;

            case "Guardar":
            {
                #region Guardar



                var Id     = gvCliBlo.Rows[Convert.ToInt32(e.CommandArgument.ToString())].Cells[0].Text.Trim();
                var IdCli  = ((TextBox)gvCliBlo.Rows[Convert.ToInt32(gvCliBlo.EditIndex)].FindControl("txtIdCli")).Text;
                var deudor = ((TextBox)gvCliBlo.Rows[Convert.ToInt32(e.CommandArgument.ToString())].FindControl("txtDeudor")).Text.Trim();

                ServCBloqueados serv = new ServCBloqueados();

                switch (((int)Session["RANew"]))
                {
                case 0:
                {
                    //Actualizar Cli

                    DropDownList ddl        = ((DropDownList)gvCliBlo.Rows[Convert.ToInt32(gvCliBlo.EditIndex)].FindControl("ddlTExCli"));
                    string       selectedTE = Session["selectedEx"].ToString();
                    string       res        = serv.updateClient(Id, IdCli, deudor, ((IUsr)Session["Usr"]).usr.CemexId, ddl.SelectedValue, selectedTE, ((IUsr)Session["Usr"]).usr.Pais.IdPais.ToString());

                    if (res.CompareTo("0") == 0)
                    {
                        lblEInsUp.ForeColor = Color.Red;
                        lblEInsUp.Text      = "No se ha podido realizar la modificación";
                        lblEInsUp.Visible   = true;
                    }
                    else
                    {
                        Response.Redirect(Request.RawUrl);
                    }
                }

                break;

                case 1:
                {
                    //Nuevo Cli

                    IdCli = ((TextBox)gvCliBlo.Rows[Convert.ToInt32(e.CommandArgument.ToString())].FindControl("txtIdCli")).Text.Trim();

                    DropDownList ddl      = ((DropDownList)gvCliBlo.Rows[Convert.ToInt32(gvCliBlo.EditIndex)].FindControl("ddlTExCli"));
                    string       selected = ddl.SelectedValue;
                    string       res      = "";
                    if (selected.CompareTo("0") == 0 || IdCli.CompareTo("") == 0)
                    {
                        res = "-1";
                    }
                    else
                    {
                        res = serv.insertClient(IdCli, deudor, ((IUsr)Session["Usr"]).usr.CemexId, ddl.SelectedValue, ((IUsr)Session["Usr"]).usr.Pais.IdPais.ToString(), "4");
                    }



                    if (res.CompareTo("0") == 0)
                    {
                        lblEInsUp.ForeColor = Color.Red;
                        lblEInsUp.Text      = "El cliente ya se encuentra registrado con ese tipo de Excepción";
                        lblEInsUp.Visible   = true;
                    }
                    else
                    {
                        if (res.CompareTo("-1") == 0)
                        {
                            lblEInsUp.ForeColor = Color.Red;
                            lblEInsUp.Text      = "Datos Incorrectos";
                            lblEInsUp.Visible   = true;
                        }
                        else
                        {
                            Response.Redirect(Request.RawUrl);
                        }
                    }
                }


                break;
                }
                #endregion
            }
            break;



            case "Borrar":
            {
                #region Borrar
                if (gvCliBlo.EditIndex != -1)
                {
                    return;
                }
                int ent;
                var IdCli = gvCliBlo.Rows[Convert.ToInt32(e.CommandArgument.ToString())].Cells[0].Text.Trim();

                ServCBloqueados serv = new ServCBloqueados();
                string          res  = serv.deleteClient(IdCli, ((IUsr)Session["Usr"]).usr.Pais.IdPais.ToString());

                if (res.CompareTo("0") == 0)
                {
                    lblEInsUp.ForeColor = Color.Red;
                    lblEInsUp.Text      = "No se pudo eliminar el Cliente";
                    lblEInsUp.Visible   = true;
                }
                else
                {
                    Response.Redirect(Request.RawUrl);
                }


                #endregion
            }
            break;

            case "Cancelar":
            {
                #region Cancelar


                MpUp_MA.Hide();

                Session["dtDoc"]    = null;
                lblEInsUp.Visible   = false;
                Session["RANew"]    = 0;
                gvCliBlo.EditIndex  = -1;
                gvCliBlo.DataSource = Session["dtCBloqueados"];
                gvCliBlo.DataBind();
                #endregion
            }
            break;
            }
        }