protected void Page_Load(object sender, EventArgs e)
{
clsElectricMeters oClsElectricMeters = new clsElectricMeters();
if (!IsPostBack)
{
FillGestorMedicion();
DataTable dtAllGroups;
oClsElectricMeters.intActive = 1;
oClsElectricMeters.IdGMedicion = 0;
dtAllGroups = oClsElectricMeters.GetAllDistinctGroup();
ddl_Grupos.DataSource = dtAllGroups;
ddl_Grupos.DataTextField = "Grupo";
ddl_Grupos.DataValueField = "IdGrupo";
ddl_Grupos.DataBind();
// CargaDDL();
//CargarCentral();
ddl_Grupos.Items.Add("-- TODOS --");
ddl_Grupos.SelectedValue = "-- TODOS --";
//buscar();
// System.Data.DataTable dtGR = new System.Data.DataTable();
//clsGeneralReport oclsGeneralReport = new clsGeneralReport();
//if (!IsPostBack)
//{
// dtGR = oclsGeneralReport.GetGeneralReport( "1","", toggleConvenios.Checked?"0":"1", toggleComunicacion.Checked ? "0" : "1", toggleMedicion.Checked ? "0" : "1");
// if (dtGR != null && (dtGR.Rows.Count > 0))
// {
// Session["dtGR"] = dtGR;
// strHTMLElectric = oclsGeneralReport.CreateTableHTML(dtGR);
// DBDataPlaceHolder.Controls.Add(new Literal { Text = strHTMLElectric.ToString() });
// }
}
}
public void CargarGrupo()
{
clsElectricMeters oClsElectricMeters = new clsElectricMeters();
string strIdGMedicion = cboGestorMedicion.Items[cboGestorMedicion.SelectedIndex].Value;
DataTable dtAllGroups;
if (strIdGMedicion == "-- TODOS --")
{
oClsElectricMeters.IdGMedicion = 0;
}
else
{
oClsElectricMeters.IdGMedicion = Convert.ToInt32(strIdGMedicion);
}
oClsElectricMeters.intActive = 1;
dtAllGroups = oClsElectricMeters.GetAllDistinctGroup();
ddl_Grupos.DataSource = dtAllGroups;
ddl_Grupos.DataTextField = "Grupo";
ddl_Grupos.DataValueField = "IdGrupo";
ddl_Grupos.DataBind();
// CargaDDL();
//CargarCentral();
ddl_Grupos.Items.Add("-- TODOS --");
ddl_Grupos.SelectedValue = "-- TODOS --";
}
protected void Page_Load(object sender, EventArgs e)
{
clsElectricMeters oClsElectricMeters = new clsElectricMeters();
try {
if (!IsPostBack)
{
FillGestorMedicion();
DataTable dtAllGroups;
oClsElectricMeters.intActive = 1;
oClsElectricMeters.IdGMedicion = 0;
dtAllGroups = oClsElectricMeters.GetAllDistinctGroup();
cmbGroup.DataSource = dtAllGroups;
cmbGroup.DataTextField = "Grupo";
cmbGroup.DataValueField = "IdGrupo";
cmbGroup.DataBind();
// CargaDDL();
//CargarCentral();
cmbGroup.Items.Add("-- TODOS --");
cmbGroup.SelectedValue = "-- TODOS --";
}
//CargaDDL();
}
catch (Exception ex)
{
clsError.logMessage = ex.ToString();
clsError.logModule = "Page_Load";
clsError.LogWrite();
}
}
//public void CargaDDL()
//{
// clsElectricMeters oClsElectricMeters = new clsElectricMeters();
// DataTable dtGetLadingCharge;
// try
// {
// string strGroup = cmbGroup.Items[cmbGroup.SelectedIndex].Value;
// if (!string.IsNullOrEmpty(strGroup))
// {
// if (strGroup == "-- TODOS --")
// {
// //cmbLoadingCharge.Items.Clear();
// ddl.Items.Clear();
// oClsElectricMeters.intActive = 1;
// dtGetLadingCharge = oClsElectricMeters.GetAllGroup();
// if (dtGetLadingCharge == null)
// {
// //msgErrNew.InnerHtml = "";
// //msgErrNew.Style.Add("display", "none");
// //msgErrNew.InnerHtml = "Error al recuperar los datos";
// ScriptManager.RegisterStartupScript(this, GetType(), "muestraError", "swal('Error','Error al recuperar los datos.','error');", true);
// }
// else
// {
// if (dtGetLadingCharge.Rows.Count > 0)
// {
// DataSet dsAll = new DataSet(); dsAll.Tables.Add(dtGetLadingCharge.Copy());
// ddl.DataSource = dsAll;
// ddl.DataTextField = "RPUPuntoCarga";
// ddl.DataValueField = "RPU";
// ddl.DataBind();
// //ddl.Items.Add("-- TODOS --");
// //ddl.SelectedValue = "-- TODOS --";
// }
// }
// }
// else
// {
// oClsElectricMeters.strGroup = strGroup;
// oClsElectricMeters.intActive = 1;
// dtGetLadingCharge = oClsElectricMeters.GetLoadingCharge();
// if (dtGetLadingCharge == null)
// {
// //msgErrNew.InnerHtml = "";
// //msgErrNew.Style.Add("display", "none");
// //msgErrNew.InnerHtml = "Error al recuperar los datos";
// ScriptManager.RegisterStartupScript(this, GetType(), "muestraError", "swal('Error','Error al recuperar los datos.','error');", true);
// }
// else
// {
// if (dtGetLadingCharge.Rows.Count > 0)
// {
// DataSet ds = new DataSet(); ds.Tables.Add(dtGetLadingCharge.Copy());
// ddl.DataSource = ds;
// ddl.DataTextField = "RPUPuntoCarga";
// ddl.DataValueField = "RPU";
// ddl.DataBind();
// // ddl.Items.Add("-- TODOS --");
// //ddl.SelectedValue = "-- TODOS --";
// }
// }
// }
// }
// }
// catch (Exception ex)
// {
// clsError.logMessage = ex.ToString();
// clsError.logModule = "itemSelected";
// clsError.LogWrite();
// //msgErrNew.InnerHtml = "";
// //msgErrNew.Style.Add("display", "none");
// //msgErrNew.InnerHtml = ex.ToString();
// JavaScriptSerializer serializer = new JavaScriptSerializer();
// string mensaje = serializer.Serialize(ex.Message);
// ScriptManager.RegisterStartupScript(this, GetType(), "muestraError", "swal('Error Detalle: " + mensaje + "');", true);
// }
//}
//protected void itemSelected(object sender, EventArgs e)
//{
// clsElectricMeters oClsElectricMeters = new clsElectricMeters();
// DataTable dtGetLadingCharge;
// try
// {
// if (IsPostBack)
// {
// string strGroup = cmbGroup.Items[cmbGroup.SelectedIndex].Value;
// if (!string.IsNullOrEmpty(strGroup))
// {
// if (strGroup == "-- TODOS --")
// {
// //cmbLoadingCharge.Items.Clear();
// ddl.Items.Clear();
// oClsElectricMeters.intActive = 1;
// dtGetLadingCharge = oClsElectricMeters.GetAllGroup();
// if (dtGetLadingCharge == null)
// {
// //msgErrNew.InnerHtml = "";
// //msgErrNew.Style.Add("display", "none");
// //msgErrNew.InnerHtml = "Error al recuperar los datos";
// ScriptManager.RegisterStartupScript(this, GetType(), "muestraError", "swal('Error','Error al recuperar los datos.','error');", true);
// }
// else
// {
// if (dtGetLadingCharge.Rows.Count > 0)
// {
// DataSet dsAll = new DataSet(); dsAll.Tables.Add(dtGetLadingCharge.Copy());
// ddl.DataSource = dsAll;
// ddl.DataTextField = "RPUPuntoCarga";
// ddl.DataValueField = "RPU";
// ddl.DataBind();
// //ddl.Items.Add("-- TODOS --");
// //ddl.SelectedValue = "-- TODOS --";
// }
// }
// }
// else
// {
// oClsElectricMeters.strGroup = strGroup;
// oClsElectricMeters.intActive = 1;
// dtGetLadingCharge = oClsElectricMeters.GetLoadingCharge();
// if (dtGetLadingCharge == null)
// {
// //msgErrNew.InnerHtml = "";
// //msgErrNew.Style.Add("display", "none");
// //msgErrNew.InnerHtml = "Error al recuperar los datos";
// ScriptManager.RegisterStartupScript(this, GetType(), "muestraError", "swal('Error','Error al recuperar los datos.','error');", true);
// }
// else
// {
// if (dtGetLadingCharge.Rows.Count > 0)
// {
// DataSet ds = new DataSet(); ds.Tables.Add(dtGetLadingCharge.Copy());
// ddl.DataSource = ds;
// ddl.DataTextField = "RPUPuntoCarga";
// ddl.DataValueField = "RPU";
// ddl.DataBind();
// // ddl.Items.Add("-- TODOS --");
// //ddl.SelectedValue = "-- TODOS --";
// }
// else if (dtGetLadingCharge.Rows.Count == 0)
// {
// ddl.Items.Clear();
// //ScriptManager.RegisterStartupScript(this, GetType(), "muestraError", "swal('','Grupo sin puntos de carga','warning');", true);
// }
// }
// }
// }
// }
// }
// catch (Exception ex)
// {
// clsError.logMessage = ex.ToString();
// clsError.logModule = "itemSelected";
// clsError.LogWrite();
// //msgErrNew.InnerHtml = "";
// //msgErrNew.Style.Add("display", "none");
// //msgErrNew.InnerHtml = ex.ToString();
// JavaScriptSerializer serializer = new JavaScriptSerializer();
// string mensaje = serializer.Serialize(ex.Message);
// ScriptManager.RegisterStartupScript(this, GetType(), "muestraError", "swal('Error Detalle: " + mensaje + "');", true);
// }
//}
protected void btnSearch_Click(object sender, EventArgs e)
{
clsElectricMeters oClsElectricMeters = new clsElectricMeters();
StringBuilder strHTMLElectric = new StringBuilder();
string strLoadingCharge = "";// string.Empty;
DataTable tdReqElectric;
try {
msgErrNew.InnerText = "";
msgErrNew.Style.Add("display", "none");
string strGrupo = cmbGroup.Items[cmbGroup.SelectedIndex].Value;
//string strCentral = cmbCentral.Items[cmbCentral.SelectedIndex].Value;
string strGestorComercial = cboGestorMedicion.Items[cboGestorMedicion.SelectedIndex].Value;
//if (ddl.SelectedIndex != -1)
//{
// strLoadingCharge = ddl.Items[ddl.SelectedIndex].Value;
//}
//if (ddl.Text =="")
//{
// ScriptManager.RegisterStartupScript(this, GetType(), "muestraError", "swal({title: 'Error',html: $('<div>').addClass('some-class').text('Debe seleccionar un punto de carga.'),animation: true,customClass:'animated tada'});", true);
//}
//else
//{
oClsElectricMeters.strGroup = strGrupo;
oClsElectricMeters.strLoadingCharges = strLoadingCharge;
oClsElectricMeters.strRPU = strLoadingCharge;
oClsElectricMeters.strGestorMedicion = strGestorComercial;
oClsElectricMeters.intActive = 1;
tdReqElectric = oClsElectricMeters.SearchByFilter(strGrupo, strGestorComercial);
oClsElectricMeters.dtElectricMeters = tdReqElectric;
if (tdReqElectric.Rows.Count > 0)
{
strHTMLElectric = oClsElectricMeters.CreateTableHTML();
DBDataPlaceHolder.Controls.Add(new Literal {
Text = strHTMLElectric.ToString()
});
//Get Contacts from division and zone
tdReqElectric = null;
tdReqElectric = oClsElectricMeters.GetContactsCFE(strLoadingCharge);
}
else
{
//msgErrNew.InnerText = "";
//msgErrNew.Style.Add("display", "inline");
//msgErrNew.InnerText = "No hay datos para mostrar";
ScriptManager.RegisterStartupScript(this, GetType(), "muestraError", "swal({title: 'Error',html: $('<div>').addClass('some-class').text('No hay datos para mostrar.'),animation: false,customClass: 'animated tada'});", true);
}
//}
tdReqElectric = null;
tdReqElectric = oClsElectricMeters.GetContactsCFE(strLoadingCharge);
if (tdReqElectric.Rows.Count > 0)
{
strHTMLElectric = oClsElectricMeters.CreateTableHTML4Contacts(tdReqElectric);
//PlaceHolder1.Controls.Add(new Literal { Text = strHTMLElectric.ToString() });
}
}
catch (Exception ex)
{
clsError.logMessage = ex.ToString();
clsError.logModule = "btnSearch_Click";
clsError.LogWrite();
//msgErrNew.InnerText = "";
//msgErrNew.Style.Add("display", "inline");
//msgErrNew.InnerHtml = ex.ToString();
JavaScriptSerializer serializer = new JavaScriptSerializer();
string mensaje = serializer.Serialize(ex.Message);
ScriptManager.RegisterStartupScript(this, GetType(), "muestraError", "swal('Error Detalle: " + mensaje + "');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
clsElectricMeters oClsElectricMeters = new clsElectricMeters();
Class.Encrypt oclsEncrypt = new Class.Encrypt();
DataTable dtGetLadingCharge;
try
{
string strRpu = Request["rpu"];
string strgp = Request["gp"];
string strlch = Request["lch"];
if (!IsPostBack)
{
DataTable dtAllGroups;
oClsElectricMeters.intActive = 1;
dtAllGroups = oClsElectricMeters.GetAllDistinctGroup();
cmbGroup.DataSource = dtAllGroups;
cmbGroup.DataTextField = "Grupo";
cmbGroup.DataValueField = "IdGrupo";
cmbGroup.DataBind();
CargaDDl();
//cmbGroup.Items.Add("-- TODOS --");
//cmbGroup.SelectedValue = "-- TODOS --";
//if variable are not empty fill combo with input variable
if (!string.IsNullOrEmpty(strRpu) && !string.IsNullOrEmpty(strgp) && !string.IsNullOrEmpty(strlch))
{
oclsEncrypt.strData = strRpu;
strRpu = oclsEncrypt.DecryptData();
//oclsEncrypt.strData = strgp;
//strgp = oclsEncrypt.DecryptData();
//oclsEncrypt.strData = strlch;
//strlch = oclsEncrypt.DecryptData();
_strgp = strgp;
_strlch = strlch;
_strRpu = strRpu;
oClsElectricMeters.strGroup = strgp;
oClsElectricMeters.intActive = 1;
dtGetLadingCharge = oClsElectricMeters.SearchRPU(strRpu);
if (dtGetLadingCharge == null)
{
ScriptManager.RegisterStartupScript(this, GetType(), "muestraError", "swal('','Error al recuperar los datos','error');", true);
//msgErrNew.InnerHtml = "";
//msgErrNew.Style.Add("display", "none");
//msgErrNew.InnerHtml = "";
}
else
{
if (dtGetLadingCharge.Rows.Count > 0)
{
dtGetLadingCharge.Rows.Add("-- TODOS --");
DataSet ds = new DataSet(); ds.Tables.Add(dtGetLadingCharge.Copy());
//cmbLoadingCharge.DataSource = ds;
//cmbLoadingCharge.DataTextField = "RPUPuntoCarga";
//cmbLoadingCharge.DataValueField = "RPU";
//cmbLoadingCharge.SelectedIndex =0;
ddl.DataSource = ds;
ddl.DataTextField = "PuntoCarga";
ddl.DataValueField = "RPU";
ddl.DataBind();
//cmbLoadingCharge.DataBind();
ddl.Items.Add("");
foreach (DataRow renglon in ds.Tables[0].Rows)
{
strgp = renglon["Grupo"].ToString();
strlch = renglon["PuntoCarga"].ToString();
break;
}
ddl.SelectedValue = strRpu;
cmbGroup.SelectedValue = strgp;
}
}
}
}
}
catch (Exception ex)
{
clsError.logMessage = ex.ToString();
clsError.logModule = "Page_Load";
clsError.LogWrite();
}
}
protected void itemSelected(object sender, EventArgs e)
{
clsElectricMeters oClsElectricMeters = new clsElectricMeters();
DataTable dtGetLadingCharge;
try
{
if (IsPostBack)
{
string strGroup = cmbGroup.Items[cmbGroup.SelectedIndex].Value;
if (!string.IsNullOrEmpty(strGroup))
{
if (strGroup == "-- TODOS --")
{
//cmbLoadingCharge.Items.Clear();
ddl.Items.Clear();
oClsElectricMeters.intActive = 1;
dtGetLadingCharge = oClsElectricMeters.GetAllGroup();
if (dtGetLadingCharge == null)
{
ScriptManager.RegisterStartupScript(this, GetType(), "muestraError", "swal('','Error al recuperar los datos','error');", true);
// msgErrNew.InnerHtml = "";
// msgErrNew.Style.Add("display", "none");
// msgErrNew.InnerHtml = "Error al recuperar los datos";
}
else
{
if (dtGetLadingCharge.Rows.Count > 0)
{
//dtGetLadingCharge.Rows.Add("-- TODOS --");
DataSet dsAll = new DataSet(); dsAll.Tables.Add(dtGetLadingCharge.Copy());
ddl.DataSource = dsAll;
ddl.DataTextField = "RPUPuntoCarga";
ddl.DataValueField = "RPU";
ddl.DataBind();
//ddl.Items.Add("-- TODOS --");
//ddl.SelectedValue = "-- TODOS --";
}
}
}
else
{
oClsElectricMeters.strGroup = strGroup;
oClsElectricMeters.intActive = 1;
dtGetLadingCharge = oClsElectricMeters.GetLoadingCharge();
if (dtGetLadingCharge == null)
{
ScriptManager.RegisterStartupScript(this, GetType(), "muestraError", "swal('','Error al recuperar los datos','error');", true);
// msgErrNew.InnerHtml = "";
// msgErrNew.Style.Add("display", "none");
// msgErrNew.InnerHtml = "Error al recuperar los datos";
}
else
{
if (dtGetLadingCharge.Rows.Count > 0)
{
//dtGetLadingCharge.Rows.Add("-- TODOS --");
DataSet ds = new DataSet(); ds.Tables.Add(dtGetLadingCharge.Copy());
ddl.DataSource = ds;
ddl.DataTextField = "RPUPuntoCarga";
ddl.DataValueField = "RPU";
ddl.DataBind();
//ddl.Items.Add("-- TODOS --");
//ddl.SelectedValue = "-- TODOS --";
}
else if (dtGetLadingCharge.Rows.Count == 0)
{
ddl.Items.Clear();
}
}
}
}
}
}
catch (Exception ex)
{
clsError.logMessage = ex.ToString();
clsError.logModule = "itemSelected";
clsError.LogWrite();
JavaScriptSerializer serializer = new JavaScriptSerializer();
string mensaje = serializer.Serialize(ex.Message);
ScriptManager.RegisterStartupScript(this, GetType(), "muestraError", "swal('Error Detalle: " + mensaje + "');", true);
//msgErrNew.InnerHtml = "";
//msgErrNew.Style.Add("display", "none");
//msgErrNew.InnerHtml = ex.ToString();
}
}
