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;
}
}
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;
}
}
