protected void Page_Load(object sender, EventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
try
{
var reporte = new Report.ReportVehicles {
DataSource = Session["DSDISEÑO"]
};
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
Connection = Session["connectionString"].ToString();
_user = Session["USER"].ToString();
GetVehicles();
GetClassification();
UiVistaVendedoresAsociados.DataSource = VendedoresAsociados;
UiVistaVendedoresAsociados.DataBind();
UiUsuariosNOAsociados.DataSource = VendedoresNoAsociados;
UiUsuariosNOAsociados.DataBind();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
public void ReportView()
{
try
{
if (Session["DS_USER"] != null)
{
var dsDiseño = new dsUsers();
var dsEjecucion = (DataSet)Session["DS_USER"];
for (var i = 0; i < dsEjecucion.Tables[0].Rows.Count; i++)
{
var row = dsDiseño.USERS.NewRow();
row[0] = dsEjecucion.Tables[0].Rows[i]["CORRELATIVE"];
row[1] = dsEjecucion.Tables[0].Rows[i]["LOGIN"];
row[2] = dsEjecucion.Tables[0].Rows[i]["NAME_USER"];
row[3] = dsEjecucion.Tables[0].Rows[i]["TYPE_USER"];
dsDiseño.USERS.Rows.Add(row);
}
Session["DS_USER_DISEÑO"] = dsDiseño;
var reporte = new ReportUser {
DataSource = Session["DS_USER_DISEÑO"]
};
ASPxDocumentViewer1.DataBind();
ASPxDocumentViewer1.Report = reporte;
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
private void GenerarReporte()
{
try
{
if (Session["UiVisOrdenesVenta"] == null)
{
return;
}
var reporte = new Report.ReportPreSale2()
{
DataSource = ListToDataTableClass.ListToDataTable(((IList <OrdenDeVentaEncabezado>)UiVisOrdenesVenta.DataSource).ToList())
,
DataMember = "OrdenDeVentaEncabezado"
};
reporte.Parameters["symbolCurrency"].Value = Session["SYMBOL_CURRENCY"].ToString();
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
public void ReportView()
{
try
{
if (Session["DsDatosLocation"] != null)
{
var dsDiseño = new dsLocation();
var dsEjecucion = (DataSet)Session["DsDatosLocation"];
for (var i = 0; i < dsEjecucion.Tables[0].Rows.Count; i++)
{
var row = dsDiseño.SWIFT_LOCATIONS.NewRow();
row[0] = dsEjecucion.Tables[0].Rows[i]["CODE_WAREHOUSE"];
row[1] = dsEjecucion.Tables[0].Rows[i]["CODE_LOCATION"];
row[2] = dsEjecucion.Tables[0].Rows[i]["CLASSIFICATION_LOCATION"];
row[3] = dsEjecucion.Tables[0].Rows[i]["HALL_LOCATION"];
row[4] = dsEjecucion.Tables[0].Rows[i]["ALLOW_PICKING"];
dsDiseño.SWIFT_LOCATIONS.Rows.Add(row);
}
var reporte = new Report.ReportLocation {
DataSource = dsDiseño
};
Session["DSDISEÑOLOCATION"] = dsDiseño;
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
public void FillReport()
{
string selectedServer = "";
if (this.ServerListFilterListBox.SelectedItems.Count > 0)
{
selectedServer = "";
for (int i = 0; i < this.ServerListFilterListBox.SelectedItems.Count; i++)
{
selectedServer += "'" + this.ServerListFilterListBox.SelectedItems[i].Text + "'" + ",";
}
try
{
selectedServer = selectedServer.Substring(0, selectedServer.Length - 1);
}
catch
{
selectedServer = ""; // throw ex;
}
finally { }
}
DashboardReports.DailyMailVolumeXtraRpt report = new DashboardReports.DailyMailVolumeXtraRpt();
report.Parameters["ServerName"].Value = selectedServer;
//12/18/2015 NS added for VSPLUS-2291
report.Parameters["RptType"].Value = DailyMonthlyRadioButtonList.SelectedItem.Value.ToString();
//26/4/2016 Durga Modified for VSPLUS-2883
report.Parameters["ServerType"].Value = TypeComboBox.Text;
report.CreateDocument();
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
private void GenerarReporte()
{
try
{
List <ConsignacionDetalle> listaConsignacionDetalle = new List <ConsignacionDetalle>();
for (int i = 0; i < UiVistaConsignacion.VisibleRowCount; i++)
{
listaConsignacionDetalle.Add((ConsignacionDetalle)UiVistaConsignacion.GetRow(i));
}
if (listaConsignacionDetalle.Count == 0)
{
return;
}
else
{
var reporte = new Report.ReportConsignmentReport()
{
DataSource = ListToDataTableClass.ListToDataTable(listaConsignacionDetalle)
,
DataMember = "ConsignacionDetalle"
};
reporte.Parameters["symbolCurrency"].Value = Session["SYMBOL_CURRENCY"].ToString();
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
public void ReportView()
{
try
{
if (Session["DsDatos"] != null)
{
var dsDiseño = new dsVehicles();
var dsEjecucion = (DataSet)Session["DsDatos"];
for (var i = 0; i < dsEjecucion.Tables[0].Rows.Count; i++)
{
var row = dsDiseño.SWIFT_VEHICLES.NewRow();
row[0] = dsEjecucion.Tables[0].Rows[i]["VEHICLE"];
row[1] = dsEjecucion.Tables[0].Rows[i]["CODE_VEHICLE"];
row[2] = dsEjecucion.Tables[0].Rows[i]["PLATE_VEHICLE"];
row[3] = dsEjecucion.Tables[0].Rows[i]["VALUE_TEXT_CLASSIFICATION"];
row[4] = dsEjecucion.Tables[0].Rows[i]["MAXIMUM_WEIGHT"] + " " + dsEjecucion.Tables[0].Rows[i]["UNIT"];
row[5] = dsEjecucion.Tables[0].Rows[i]["BRAND"];
row[6] = dsEjecucion.Tables[0].Rows[i]["UNIT"];
dsDiseño.SWIFT_VEHICLES.Rows.Add(row);
}
Session["DsDatos"] = dsDiseño;
var reporte = new Report.ReportVehicles {
DataSource = dsDiseño
};
Session["DSDISEÑO"] = dsDiseño;
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
public void ReportViewer()
{
try
{
if (Session["UiVistaReubicaciones"] == null)
{
return;
}
var reporte = new Report.ReportRelocateInventory()
{
DataSource =
ListToDataTableClass.ListToDataTable(
((IList <Reubicacion>)UiVistaReubicaciones.DataSource).ToList())
,
DataMember = "Reubicaciones"
};
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
if (Session["DSDISEÑO_TAG"] != null)
{
var reporte = new Report.ReportTag
{
DataSource = Session["DATA_TAG"],
DataMember = "SWIFT_TAGS"
};
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
if (Session["DATA_TAG"] != null)
{
ASPxGridView1.DataSource = Session["DATA_TAG"];
ASPxGridView1.DataBind();
}
else
{
GetTags();
}
}
protected new void Page_Load(object sender, EventArgs e)
{
//header info
int vpm = Request.QueryString["vpm"].ToInt32(0);
int modelId = Request.QueryString["model"].ToInt32(0);
int rictype = Request.QueryString["rictype"].ToInt32(0);
int ricId = Request.QueryString["id"].ToInt32(0);
using (AppDb ctx = new AppDb())
{
if (ricId > 0)
{
ric = ctx.RICs.Where(x => x.Id == ricId).FirstOrDefault();
}
else
{
ric = ctx.RICs.Where(x => x.CatalogModelId == modelId && x.RICTypeId == rictype && x.PackingMonth == vpm.ToString()).FirstOrDefault();
}
}
if (ric == null)
{
var panel1 = new System.Web.UI.WebControls.Panel();
panel1.CssClass = "mainContent";
panel1.Controls.Clear();
panel1.Controls.Add(new LiteralControl(string.Format("<h2 class='grid-header'>Invalid Model/Variant/PackingMonth for RIC</h2>")));
masterPage.MainContent.Controls.Add(panel1);
masterPage.PageTitle.Controls.Add(new LiteralControl("Record Implementation Control"));
return;
}
byte[] reportb = ReportRepository.GetReportBinary("Ric");
if (reportb != null)
{
using (var stream = new MemoryStream(reportb))
{
XtraReport report = XtraReport.FromStream(stream, true);
report.Parameters["parameter1"].Value = ric.Id;
report.Parameters["parameter1"].Visible = false;
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
}
else
{
string filePath = HttpContext.Current.ApplicationInstance.Server.MapPath("~/App_Data/rptRic.repx");
DevExpress.XtraReports.UI.XtraReport report = DevExpress.XtraReports.UI.XtraReport.FromFile(filePath, true);
report.Parameters["parameter1"].Value = ric.Id;
report.Parameters["parameter1"].Visible = false;
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
}
public void ReportView()
{
try
{
if (Session["datosPicking"] != null)
{
var dsDiseño = new dsListPicking();
var dsEjecucion = (DataSet)Session["datosPicking"];
for (var i = 0; i < dsEjecucion.Tables[0].Rows.Count; i++)
{
var row = dsDiseño.SWIFT_PICKING_HEADER.NewRow();
row[0] = dsEjecucion.Tables[0].Rows[i]["#Picking"];
row[1] = dsEjecucion.Tables[0].Rows[i]["FECHA"];
row[2] = dsEjecucion.Tables[0].Rows[i]["CLIENTE"];
row[3] = dsEjecucion.Tables[0].Rows[i]["OPERADOR_RESPOSABLE"];
row[4] = dsEjecucion.Tables[0].Rows[i]["ESTATUS"];
dsDiseño.SWIFT_PICKING_HEADER.Rows.Add(row);
}
var reporte = new Report.ReportListPicking {
DataSource = dsDiseño
};
Session["DSDISEÑO_PICKING"] = dsDiseño;
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
public void FillReport()
{
report = new DashboardReports.StalemailboxeRpt();
string selectedServer = "";
if (this.ServerListBox.SelectedItems.Count > 0)
{
for (int i = 0; i < this.ServerListBox.SelectedItems.Count; i++)
{
selectedServer += "'" + this.ServerListBox.SelectedItems[i].Text + "'" + ",";
}
try
{
selectedServer = selectedServer.Substring(0, selectedServer.Length - 1);
}
catch
{
selectedServer = "";
}
finally { }
}
report.Parameters["TypeVal"].Value = selectedServer;
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string seluser = "";
if (!IsPostBack)
{
DataTable dt = new DataTable();
dt = VSWebBL.ReportsBL.ReportsBL.Ins.GetUserNameList();
if (dt.Rows.Count > 0)
{
//11/4/2015 NS modified for VSPLUS-2023
UserListComboBox.DataSource = dt;
UserListComboBox.ValueField = "FullName";
UserListComboBox.TextField = "FullName";
UserListComboBox.DataBind();
seluser = Session["UserFullName"].ToString();
UserListComboBox.Items.FindByText(seluser).Selected = true;
}
}
if (UserListComboBox.SelectedIndex != -1)
{
seluser = UserListComboBox.Items[UserListComboBox.SelectedIndex].Text;
}
ConfiguratorReports.ConfigUserListXtraRpt report = new ConfiguratorReports.ConfigUserListXtraRpt();
report.Parameters["UserName"].Value = seluser;
report.CreateDocument();
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
public void ReportView()
{
try
{
if (Session["DsDatos"] != null)
{
var dsDiseño = new dsDriver();
var dsEjecucion = (DataSet)Session["DsDatos"];
for (int i = 0; i < dsEjecucion.Tables[0].Rows.Count; i++)
{
var row = dsDiseño.SWIFT_DRIVERS.NewRow();
row[0] = dsEjecucion.Tables[0].Rows[i]["CODE_DRIVER"];
row[1] = dsEjecucion.Tables[0].Rows[i]["NAME_DRIVER"];
row[2] = dsEjecucion.Tables[0].Rows[i]["VALUE_TEXT_CLASSIFICATION"];
row[3] = dsEjecucion.Tables[0].Rows[i]["LICENSE_DRIVER"];
row[4] = dsEjecucion.Tables[0].Rows[i]["PHONE_DRIVER"];
dsDiseño.SWIFT_DRIVERS.Rows.Add(row);
}
Session["DsDatos"] = dsDiseño;
var reporte = new Report.ReportDriver {
DataSource = dsDiseño
};
Session["DSDISEÑO"] = dsDiseño;
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
public void ReportView()
{
try
{
var dsDiseño = new dsWarehouse();
var pResult = "";
var dsEjecucion = objWarehouse.GetWarehouseActive(Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
for (var i = 0; i < dsEjecucion.Tables[0].Rows.Count; i++)
{
var row = dsDiseño.SWIFT_WAREHOUSES.NewRow();
row[0] = dsEjecucion.Tables[0].Rows[i]["CODE_WAREHOUSE"]; row[1] = dsEjecucion.Tables[0].Rows[i]["DESCRIPTION_WAREHOUSE"];
row[2] = dsEjecucion.Tables[0].Rows[i]["WEATHER_WAREHOUSE"];
row[4] = dsEjecucion.Tables[0].Rows[i]["NAME_DISTRIBUTION_CENTER"];
row[5] = dsEjecucion.Tables[0].Rows[i]["CODE_WAREHOUSE_3PL"];
dsDiseño.SWIFT_WAREHOUSES.Rows.Add(row);
}
var reporte = new Report.ReportWarehouse {
DataSource = dsDiseño
};
Session["DSDISEÑO"] = 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);
}
}
public void ReportView()
{
try
{
if (Session["DsDatos"] == null)
{
return;
}
var dsDiseño = new dsRoute();
var dsEjecucion = (DataSet)Session["DsDatos"];
for (var i = 0; i < dsEjecucion.Tables[0].Rows.Count; i++)
{
var row = dsDiseño.SWIFT_ROUTES.NewRow();
row[0] = dsEjecucion.Tables[0].Rows[i]["CODE_ROUTE"];
row[1] = dsEjecucion.Tables[0].Rows[i]["NAME_ROUTE"];
row[2] = dsEjecucion.Tables[0].Rows[i]["GEOREFERENCE_ROUTE"];
dsDiseño.SWIFT_ROUTES.Rows.Add(row);
}
Session["DsDatos"] = dsDiseño;
var reporte = new Report.ReportRoute {
DataSource = dsDiseño
};
Session["DSDISEÑO"] = dsDiseño;
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
DashboardReports.ResponseTimeXtraRpt report = new DashboardReports.ResponseTimeXtraRpt();
report.Parameters["TypeVal"].Value = TypeComboBox.SelectedItem.Text;
report.CreateDocument();
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
private void Report(string selectedServer)
{
DashboardReports.O365PasswordSettingsXtraRpt report = new DashboardReports.O365PasswordSettingsXtraRpt();
report.Parameters["ServerName"].Value = selectedServer;
report.CreateDocument();
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
protected void ResetButton_Click(object sender, EventArgs e)
{
ServerListBox.UnselectAll();
DashboardReports.ExchangeUserCountXtraRpt report = new DashboardReports.ExchangeUserCountXtraRpt();
report.Parameters["ServerName"].Value = "";
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
public void ReportView()
{
try
{
if (Session["DS_ROUTE_TRACKING"] != null)
{
//var dsDiseño = new DS.dsRouteTracking();
var fieldValues = ASPxGridView1.GetSelectedFieldValues("ASSIGNED_TO", "DOC_TYPE",
"DOC_TYPE_DESCRIPTION", "CDF_RESOLUCION", "DOC_SERIAL", "DOC_ID", "CLIENT", "CREATED_DATESTAMP",
"UNIDADES_VENDIDAS", "ROUTE", "SALES_ORDER_TYPE");
if (fieldValues.Count != 0)
{
var pResult = "";
var ds = _objOrders.GetSkuByOrder(Session["connectionString"].ToString(),
((object[])fieldValues[0])[1].ToString(), ((object[])fieldValues[0])[3].ToString(),
((object[])fieldValues[0])[4].ToString(), ((object[])fieldValues[0])[5].ToString(),
ref pResult);
if (pResult == "")
{
var reporte = new Report.ReportRouteTracking();
reporte.DataSource = ds.Tables[0];
reporte.DataMember = ds.Tables[0].TableName;
reporte.RequestParameters = false;
reporte.Parameters["assignedTo"].Value = ((object[])fieldValues[0])[0].ToString();
reporte.Parameters["client"].Value = ((object[])fieldValues[0])[6].ToString();
reporte.Parameters["createdDateStamp"].Value = ((object[])fieldValues[0])[7].ToString();
reporte.Parameters["docId"].Value = ((object[])fieldValues[0])[5].ToString();
reporte.Parameters["docType"].Value = ((object[])fieldValues[0])[1].ToString();
reporte.Parameters["docTypeDescripcion"].Value = ((object[])fieldValues[0])[2].ToString();
reporte.Parameters["route"].Value = ((object[])fieldValues[0])[9].ToString();
reporte.Parameters["unidadesVendidas"].Value = ((object[])fieldValues[0])[8];
reporte.Parameters["resolucion"].Value = ((object[])fieldValues[0])[3].ToString();
reporte.Parameters["serie"].Value = ((object[])fieldValues[0])[4].ToString();
reporte.Parameters["SaleOrderType"].Value = ((object[])fieldValues[0])[10].ToString();
reporte.Parameters["symbolCurrency"].Value = Session["SYMBOL_CURRENCY"].ToString();
//Session["DSDISEÑO_ROUTE"] = ds.Tables[0];
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText",
"CallError('" + pResult + "');", true);
}
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText",
"CallError('Error: " + ex.Message + "');", true);
}
}
public void ReportView()
{
try
{
var manifiestoEncabezado = Convert.ToInt32(Session["MANIFEST_HEADER"]);
var centroDeDistribucionId = Convert.ToInt32(UiListaDeCentrosDeDistribucion.GridView.GetRowValues(UiListaDeCentrosDeDistribucion.GridView.FocusedRowIndex, "DISTRIBUTION_CENTER_ID").ToString());
var pResult = "";
var dsEncabezado = _objManifest.GetManifestHeader(Session["connectionString"].ToString(), manifiestoEncabezado, ref pResult);
var dsDetalle = _objManifest.GetManifestDetails(Session["connectionString"].ToString(), manifiestoEncabezado, ref pResult);
var dsConductor = _objManifest.GetDriverAndVehicleByManifest(Session["connectionString"].ToString(), manifiestoEncabezado, centroDeDistribucionId, ref pResult);
if (pResult == "")
{
var centroDeDistribucion = ""; var logo = "";
logo = dsConductor.Rows[0]["LOGO_IMG"].ToString();
centroDeDistribucion = UiListaDeCentrosDeDistribucion.GridView.GetRowValues(UiListaDeCentrosDeDistribucion.GridView.FocusedRowIndex, "NAME_DISTRIBUTION_CENTER").ToString();
if (centroDeDistribucion == "" || centroDeDistribucion == "Ningun Centro de Distribución")
{
logo = Session["LOGO_IMG"].ToString();
}
else
{
logo = UiListaDeCentrosDeDistribucion.GridView.GetRowValues(UiListaDeCentrosDeDistribucion.GridView.FocusedRowIndex, "LOGO_IMG").ToString();
}
var ds = new System.Data.DataSet();
ds.Tables.Add(dsEncabezado);
ds.Tables.Add(dsDetalle);
ds.Tables.Add(dsConductor);
var reporte = new Report.ManifiestoReporte
{
DataSource = ds
};
reporte.Parameters["destination"].Value = UiTextoDestino.Text;
reporte.Parameters["distributionCenter"].Value = centroDeDistribucion;
reporte.Parameters["logoImg"].Value = logo;
reporte.Parameters["manifestHeader"].Value = manifiestoEncabezado;
reporte.Parameters["nameEnterprice"].Value = Session["NAME_ENTERPRISE"].ToString();
Session["DSDISEÑOMANIFEST"] = ds;
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText",
"CallError('Error: " + ex.Message + "');", true);
}
}
protected void UserResetButton_Click(object sender, EventArgs e)
{
this.UserFilterComboBox.SelectedIndex = -1;
DashboardReports.IBMConnCommunityXtraRpt report = new DashboardReports.IBMConnCommunityXtraRpt();
report.Parameters["Name"].Value = "";
report.CreateDocument();
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
protected void ServerListResetButton_Click(object sender, EventArgs e)
{
MailFileTextBox.Text = "";
ConfiguratorReports.MailFileXtraRpt report = new ConfiguratorReports.MailFileXtraRpt();
report.Parameters["FileSize"].Value = "";
report.CreateDocument();
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
protected void ServerListResetButton_Click(object sender, EventArgs e)
{
this.ServerListFilterComboBox.SelectedIndex = -1;
DashboardReports.ConnectionstestXtraRpt report = new DashboardReports.ConnectionstestXtraRpt();
report.Parameters["Name"].Value = "";
report.CreateDocument();
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
protected void ServerListResetButton_Click(object sender, EventArgs e)
{
this.ServerListFilterComboBox.SelectedIndex = -1;
ConfiguratorReports.ServerListTypeXtraRpt report = new ConfiguratorReports.ServerListTypeXtraRpt();
report.Parameters["ServerType"].Value = "";
report.CreateDocument();
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
if (!Page.IsPostBack)
{
try
{
Session["DATA_RECEPTION"] = null;
ASPxDateEdit1.Date = DateTime.Now;
ASPxDateEdit2.Date = DateTime.Now;
//Carga en el GridView
var pResult = "";
var ds = _objIncome.GetAllIncome(Session["connectionString"].ToString(), Convert.ToDateTime(ASPxDateEdit2.Date), Convert.ToDateTime(ASPxDateEdit1.Date), ref pResult);
if (pResult == "")
{
if (ds.Tables[0].Rows.Count > 0)
{
ASPxGridView1.DataSource = ds;
ASPxGridView1.DataBind();
Session["DATA_RECEPTION"] = ds;
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
try
{
if (Session["DSDISEÑO_RECEPTION"] != null)
{
var reporte = new Report.ReportListReception {
DataSource = Session["DSDISEÑO_RECEPTION"]
};
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
if (Session["DATA_RECEPTION"] != null)
{
ASPxGridView1.DataSource = Session["DATA_RECEPTION"];
ASPxGridView1.DataBind();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
private void Report(string selectedServer)
{
DashboardReports.ExchangeMailDBTrendXtraRpt report = new DashboardReports.ExchangeMailDBTrendXtraRpt();
report.Parameters["ServerName"].Value = selectedServer;
report.Parameters["StartDate"].Value = dtPick.FromDate;
report.Parameters["EndDate"].Value = dtPick.ToDate;
report.CreateDocument();
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
protected void ServerListResetButton_Click(object sender, EventArgs e)
{
//this.ServerListFilterComboBox.SelectedIndex = -1;
this.ServerListFilterListBox.UnselectAll();
DashboardReports.DailyMailVolumeXtraRpt report = new DashboardReports.DailyMailVolumeXtraRpt();
report.Parameters["ServerName"].Value = "";
report.CreateDocument();
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
protected void ClusterNameComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
string clustername = "";
clustername = this.ClusterNameComboBox.SelectedItem.Value.ToString();
DashboardReports.DBClusterXtraRpt report = new DashboardReports.DBClusterXtraRpt();
report.Parameters["ClusterName"].Value = clustername;
report.CreateDocument();
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
private void Report(string selectedServer, string selectedStat)
{
DashboardReports.DominoAccessBrowserXtraRpt report = new DashboardReports.DominoAccessBrowserXtraRpt();
report.Parameters["ServerName"].Value = selectedServer;
report.Parameters["StatName"].Value = selectedStat;
report.Parameters["StartDate"].Value = dtPick.FromDate;
report.Parameters["EndDate"].Value = dtPick.ToDate;
report.CreateDocument();
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}