protected void Page_Load(object sender, EventArgs e)
{
if (ValidarConexionYUsuarioLogueado(sender))
{
try
{
if (Session["DSDISEÑO_CLASSIFICATION"] != null)
{
var reporte = new Report.ReportClassification();
reporte.DataSource = Session["DSDISEÑO_CLASSIFICATION"];
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
if (!Page.IsPostBack)
{
Session["selectedClassification"] = "ALL";
}
if (Session["selectedClassification"] != null)
{
GetClassification(Session["selectedClassification"].ToString());
}
_user = Session["USER"].ToString();
Connection = Session["connectionString"].ToString();
if (Session["BANCOS"] != null)
{
if ((bool)Session["BANCOS"])
{
GetBankNames();
}
else
{
GetInferface();
}
}
else
{
GetInferface();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
}
public void ReportView()
{
try
{
var pResult = "";
var dsEjecucion = _objClassification.GetAllClassification(Session["connectionString"].ToString(), ref pResult);
var dsDiseño = new dsClassification();
if (pResult == "")
{
for (int i = 0; i < dsEjecucion.Tables[0].Rows.Count; i++)
{
var row = dsDiseño.SWIFT_CLASSIFICATION.NewRow();
row[0] = dsEjecucion.Tables[0].Rows[i]["CLASSIFICATION"];
row[1] = dsEjecucion.Tables[0].Rows[i]["NAME_CLASSIFICATION"];
row[2] = dsEjecucion.Tables[0].Rows[i]["PRIORITY_CLASSIFICATION"];
row[3] = dsEjecucion.Tables[0].Rows[i]["VALUE_TEXT_CLASSIFICATION"];
switch (dsEjecucion.Tables[0].Rows[i]["GROUP_CLASSIFICATION"].ToString())
{
case "CUSTOMER":
row[4] = "CLIENTE";
break;
case "SKU":
row[4] = "SKU";
break;
case "PROVIDER":
row[4] = "PROVEEDOR";
break;
case "VEHICLE":
row[4] = "VEHICULO";
break;
case "RECEPTION":
row[4] = "RECEPCION";
break;
case "WEATHER":
row[4] = "CLIMA";
break;
case "LOCATION":
row[4] = "UBICACION";
break;
case "PICKING":
row[4] = "PICKING";
break;
case "DEVOLUTION":
row[4] = "DEVOLUCION";
break;
case "DISPATCH":
row[4] = "DESPACHO";
break;
case "LABEL":
row[4] = "ETIQUETA";
break;
case "MEASURE":
row[4] = "UNIDAD DE MEDIDA";
break;
case "DRIVER":
row[4] = "EMPRESA TRANSPORTISTA";
break;
}
dsDiseño.SWIFT_CLASSIFICATION.Rows.Add(row);
}
var reporte = new Report.ReportClassification {
DataSource = dsDiseño
};
Session["DSDISEÑO_CLASSIFICATION"] = dsDiseño;
ASPxDocumentViewer1.DataBind();
ASPxDocumentViewer1.Report = reporte;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
