protected void OrgName_CheckedChanged(object sender, EventArgs e) { try { if (OrgName.Checked) { this.code = 0; Label1.Text = "Select OrgName:"; populateLstBoxBusinessUnitName(); if (rbtnInputForm.Checked) { pnlInputForm.Visible = true; pnlContainer.Visible = false; QMReportsClass objQMReports = new QMReportsClass(); string BizCode = objQMReports.getSelectedValues(LstBoxBusinessUnitName); btnNext.Enabled = true; populateInputFormLstBox(); } else if (rbtnContainer.Checked) { pnlContainer.Visible = true; } } } catch (Exception ex) { Response.Write(ex.Message.ToString()); } }
protected void GBUName_CheckedChanged(object sender, EventArgs e) { try { if (GBUName.Checked) { this.code = 2; Label1.Text = "Select GBUName:"; populateLstBoxBusinessUnitName(); // rbtnCheck_CheckedChanged(object sender, EventArgs e); if (rbtnInputForm.Checked) { pnlInputForm.Visible = true; pnlContainer.Visible = false; QMReportsClass objQMReports = new QMReportsClass(); string BizCode = objQMReports.getSelectedValues(LstBoxBusinessUnitName); //OrgCode = OrgCode.Trim(); btnNext.Enabled = true; populateInputFormLstBox(); //Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "ClientScript", "alert('No InputForm is available for. Please select another );", true); } else if (rbtnContainer.Checked) { pnlContainer.Visible = true; } } } catch (Exception ex) { Response.Write(ex.ToString()); } }
protected void btnNext_Click(object sender, EventArgs e) { try { QMReportsClass objQMReports = new QMReportsClass(); string InputFormID = getSelectedInputForm(lstboxInputFormName); string BizCode = objQMReports.getSelectedValues(LstBoxBusinessUnitName); string regionCode = objQMReports.getSelectedValues(LstBoxRegionName); if (BizCode == null || regionCode == null || InputFormID == null) { StringBuilder errormsg = new StringBuilder(); errormsg.Append(String.Empty); errormsg.Append("Please Select :"); if (BizCode == null) { errormsg.Append(" " + Label1.Text); } if (regionCode == null) { errormsg.Append(" regionCode"); } if (InputFormID == null) { errormsg.Append(" InputFormName"); } Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "ClientScript", "alert('" + errormsg + "');", true); btnNext.Enabled = false; } else { Response.Redirect("QM_InputForms.aspx?InputFormIds=" + InputFormID + "&BizCode=" + BizCode + "&Code=" + code + "®ionCode=" + regionCode); } } catch (Exception ex) { Response.Write(ex.ToString()); } }
protected void rbtnInputForm_CheckedChanged(object sender, EventArgs e) { try { if (rbtnInputForm.Checked) { pnlInputForm.Visible = true; pnlContainer.Visible = false; QMReportsClass objQMReports = new QMReportsClass(); string BizCode = objQMReports.getSelectedValues(LstBoxBusinessUnitName); populateInputFormLstBox(); } } catch (Exception ex) { Response.Write(ex.ToString()); } }
protected void submit2_Click(object sender, EventArgs e) { try { ErrorMsg1.Visible = false; Database dbObj = new Database(HyperCatalog.Business.ApplicationSettings.Components["Datawarehouse_DB"].ConnectionString); DataSet ds = new DataSet(); QMReportsClass QS = new QMReportsClass(); String Biz1 = QS.getSelectedValues(BusinessList1); String Cultures1 = QS.getSelectedValues(CulturesList1); if (Biz1.Length == 0 || Cultures1.Length == 0) { ErrorMsg1.Text = "Invalid selection"; Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "ClientScript", "alert('" + ErrorMsg1.Text + "');", true); //ErrorMsg.Visible = true; } else { ds = dbObj.RunSPReturnDataSet("Non_Compatibilities_Generate", new SqlParameter("@Business", Biz1), new SqlParameter("@RegionName", Cultures1), new SqlParameter("@Code", this.code1)); // QC777 If the number of rows returned by the dataset is less than 65536, the report will be generated in excel format if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows.Count < 65536) { string BizList1 = ""; string Regions1 = ""; QMReportsClass objQMReports = new QMReportsClass(); BizList1 = objQMReports.GetSelectedBiz_Reg(1, Biz1, this.code1); Regions1 = objQMReports.GetSelectedBiz_Reg(0, Cultures1, 0); System.IO.StringWriter tw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw); System.Text.StringBuilder sb = new System.Text.StringBuilder(string.Empty); sb.Append("<html><head>"); // sb.Append("<meta http-equiv='Content-Type' content='text/html; charset=" + page.Request.ContentEncoding.WebName+ "'>"); sb.Append("</head><body style='font-size: 14; font-family:Arial Unicode MS'>"); // item name sb.Append("<table style='font-size: 14; font-family:Arial Unicode MS' border = '1'>"); // sb.Append("<tr>"); sb.Append("PRODUCTS WITHOUT COMPATIBILITIES REPORT" + "<br>"); sb.Append("Selected " + BUType1.Text + ": " + BizList1 + "<br>"); sb.Append("Selected " + Label2.Text + ": " + Regions1 + "<br>"); sb.Append("Exported On: " + SessionState.User.FormatUtcDate(DateTime.UtcNow, true, "MM/dd/yyyy") + "<br>"); sb.Append("Generated By:" + SessionState.User.FullName + "<br>"); DataTable dt = ds.Tables[0]; sb.Append("</TR>"); #region "Header" DataColumnCollection tableColumns = ds.Tables[0].Columns; DataRowCollection tableRows = ds.Tables[0].Rows; sb.Append("<tr>"); foreach (DataColumn c in tableColumns) { sb.Append("<th>" + c.ColumnName.ToString() + "</th>"); } #endregion foreach (DataRow dr in dt.Rows) { sb.Append("<tr>"); foreach (DataColumn dc in dt.Columns) { sb.Append("<td>" + dr[dc].ToString() + "</td>"); } sb.Append("</tr>"); } sb.Append("</table>"); sb.Append("</body></html>"); Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.Charset = string.Empty; Response.AddHeader("content-disposition", "attachment;filename=" + "Products_Without_Compatibilities" + ".xls"); Response.ContentType = "application/vnd.ms-excel;"; //page.Response.ContentType = "application/vnd.ms-excel;charset=UTF-8"; //Fix for CR 5109 - Prabhu R S Response.ContentEncoding = System.Text.Encoding.UTF8; //page.Response.AppendHeader("Content-Length", System.Text.Encoding.UTF8.GetByteCount(exportContent).ToString()); EnableViewState = false; Response.Write(sb.ToString()); } // QC777 If the number of rows returned by the dataset is greater than 65536, the report will be generated in CSV format else if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows.Count > 65536) { char csvSeparator = ','; string BizList1 = ""; string Regions1 = ""; QMReportsClass objQMReports = new QMReportsClass(); BizList1 = objQMReports.GetSelectedBiz_Reg(1, Biz1, code1); Regions1 = objQMReports.GetSelectedBiz_Reg(0, Cultures1, 0); ListItemCollection lstItemCol = new ListItemCollection(); lstItemCol.Add(new ListItem("Selected " + BUType1.Text + ": " + BizList1 + "")); lstItemCol.Add(new ListItem("Selected " + Label2.Text + ": " + Regions1 + "")); string s = Utils.ExportDataTableToCSVForSpecificReport(ds.Tables[0], csvSeparator.ToString(), lstItemCol, "PRODUCTS WITHOUT COMPATIBILITIES REPORT").ToString(); System.Text.UTF8Encoding encoding = new System.Text.UTF8Encoding(); byte[] contentBytes = encoding.GetBytes(s); Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("Accept-Header", contentBytes.Length.ToString()); Response.ContentType = "application/txt"; //Fix for CR 5109 - Prabhu R S Response.ContentEncoding = System.Text.Encoding.UTF8; Response.AppendHeader("Content-Disposition", "attachment;filename=\"Products_Without_Compatibilities.csv\"; " + "size=" + s.Length.ToString() + "; " + "creation-date=" + DateTime.Now.ToString("R") + "; " + "modification-date=" + DateTime.Now.ToString("R") + "; " + "read-date=" + DateTime.Now.ToString("R")); Response.OutputStream.Write( contentBytes, 0, Convert.ToInt32(contentBytes.Length)); Response.Flush(); try { Response.End(); } catch { } } //QC 777 end else { ErrorMsg1.Text = "No Records to be exported"; Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "ClientScript", "alert('" + ErrorMsg1.Text + "');", true); //ErrorMsg1.Visible = true; } } } catch (Exception ex) { Response.Write(ex.Message.ToString()); } }
protected void btnSubmit_Click(object sender, EventArgs e) { Database dbObj = new Database(HyperCatalog.Business.ApplicationSettings.Components["Datawarehouse_DB"].ConnectionString, 1000); ErrorMsg.Visible = false; try { ErrorMsg.Visible = false; QMReportsClass Obj_QMReportsClass = new QMReportsClass(); String Biz = Obj_QMReportsClass.getSelectedValues(BusinessList); if (Biz == null) { ErrorMsg.Text = "Invalid selection"; Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "ClientScript", "alert('" + ErrorMsg.Text + "');", true); } DataSet ds4 = new DataSet(); if (this.code == 3) { ds4 = dbObj.RunSPReturnDataSet("Report_GetAccessAttributePl", new SqlParameter("@PLCode", Biz), new SqlParameter("@ShortCode", ddlGeography.SelectedValue)); } else { ds4 = dbObj.RunSPReturnDataSet("Report_GetAccessAttributeOrg", new SqlParameter("@OrgId", Biz), new SqlParameter("@ShortCode", ddlGeography.SelectedValue), new SqlParameter("@Code", this.code)); } if (ds4.Tables[0].Rows.Count > 0) { DataTable objDt = new DataTable(); objDt.Columns.Add(new DataColumn("ProductNumber")); objDt.Columns.Add(new DataColumn("ProductName")); objDt.Columns.Add(new DataColumn("ProductLineNo")); objDt.Columns.Add(new DataColumn("Status")); objDt.Columns.Add(new DataColumn("LiveDate")); objDt.Columns.Add(new DataColumn("ObsoleteDate")); objDt.Columns.Add(new DataColumn(Convert.ToString(ds4.Tables[0].Rows[0]["ContainerName"]))); for (int rowIndex = 1; rowIndex < ds4.Tables[0].Rows.Count; rowIndex++) { string curColumn = ds4.Tables[0].Rows[rowIndex]["ContainerName"].ToString(); if (!objDt.Columns.Contains(curColumn)) { objDt.Columns.Add(new DataColumn(curColumn)); } } for (int i = 0; i < ds4.Tables[0].Rows.Count; i++) { DataRow[] drCol = objDt.Select("ProductNumber='" + ds4.Tables[0].Rows[i]["ProductNumber"].ToString() + "'"); if (drCol.Length > 0) { drCol[0]["ProductNumber"] = ds4.Tables[0].Rows[i]["ProductNumber"]; drCol[0]["ProductName"] = ds4.Tables[0].Rows[i]["ProductName"]; drCol[0]["ProductLineNo"] = ds4.Tables[0].Rows[i]["ProductLineNo"]; drCol[0]["Status"] = ds4.Tables[0].Rows[i]["Status"]; drCol[0]["LiveDate"] = ds4.Tables[0].Rows[i]["LiveDate"]; drCol[0]["ObsoleteDate"] = ds4.Tables[0].Rows[i]["ObsoleteDate"]; drCol[0][ds4.Tables[0].Rows[i]["ContainerName"].ToString()] = ds4.Tables[0].Rows[i]["ChunkValue"]; } else { DataRow newRow = objDt.NewRow(); newRow[0] = ds4.Tables[0].Rows[i]["ProductNumber"].ToString(); newRow[ds4.Tables[0].Rows[i]["ContainerName"].ToString()] = ds4.Tables[0].Rows[i]["ChunkValue"]; objDt.Rows.Add(newRow); } objDt.AcceptChanges(); } System.Text.StringBuilder sb = new System.Text.StringBuilder(string.Empty); sb.Append("<html><head>"); sb.Append("</head><body style='font-size: 14; font-family:Arial Unicode MS'>"); sb.Append("<table style='font-size: 14; font-family:Arial Unicode MS' border = '1'>"); sb.Append("Accessories with Attributes Report" + "<br>"); string BizList = Obj_QMReportsClass.GetSelectedBiz_Reg(1, Biz, code); sb.Append("Selected " + BUType.Text + ": " + BizList + "<br>"); sb.Append("Selected Region :" + ddlGeography.SelectedItem + "<br>"); sb.Append("Exported On: " + SessionState.User.FormatUtcDate(DateTime.UtcNow, true, "MM/dd/yyyy") + "<br>"); sb.Append("Exported By: " + SessionState.User.FullName + "<br>"); sb.Append("</TR>"); #region "Header" DataColumnCollection tableColumns = objDt.Columns; DataRowCollection tableRows = objDt.Rows; sb.Append("<tr>"); foreach (DataColumn c in tableColumns) { sb.Append("<th style='font-size: 14; font-family:Arial Unicode MS'>" + c.ColumnName.ToString() + "</th>"); } #endregion foreach (DataRow dr in objDt.Rows) { sb.Append("<tr>"); foreach (DataColumn dc in objDt.Columns) { sb.Append("<td>" + dr[dc].ToString() + "</td>"); } sb.Append("</tr>"); } sb.Append("</table>"); sb.Append("</body></html>"); Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.Charset = string.Empty; Response.AddHeader("content-disposition", "attachment;filename=" + "Accessories With Attributes" + ".xls"); Response.ContentType = "application/vnd.ms-excel;"; //Fix for CR 5109 - Prabhu R S Response.ContentEncoding = System.Text.Encoding.UTF8; EnableViewState = false; Response.Write(sb.ToString()); } else { ErrorMsg.Text = "No Records to be exported"; Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "ClientScript", "alert('" + ErrorMsg.Text + "');", true); } } catch (Exception ex) { Response.Write(ex.Message.ToString()); } }
//This method refreshes the ContainerSerach Results protected void refreshContainerSearch() { uwgSearchRes.Visible = false; Database dbObj = new Database(HyperCatalog.Business.ApplicationSettings.Components["Datawarehouse_DB"].ConnectionString); if (txtContainer.Text != null) { txtContainer.Text = txtContainer.Text.Trim(); } if (txtContainer.Text.Length != 0) { DataSet dsSearchResult = dbObj.RunSPReturnDataSet("dbo._Reports_QM_ContainerSearch", new SqlParameter[] { new SqlParameter("@InputText", txtContainer.Text.Trim() + "*") }); string contNameId = ""; QMReportsClass objQMReports = new QMReportsClass(); string regionCode = objQMReports.getSelectedValues(LstBoxRegionName); string BizCode = objQMReports.getSelectedValues(LstBoxBusinessUnitName); //OrgCode = OrgCode.Trim(); string url = ""; DataSet dsContainerResults; if (BizCode != null && regionCode != null) { if (dsSearchResult.Tables[0].Rows.Count != 0) { for (int i = 0; i < dsSearchResult.Tables[0].Rows.Count; i++) { contNameId = Convert.ToString(dsSearchResult.Tables[0].Rows[i]["ContainerId"]).Trim(); dsSearchResult.Tables[0].Rows[i]["ContainerName"] = "<a href='QM_SingleContainerReport.aspx?ContainerId=" + contNameId + "&BizCode=" + BizCode + "&Code=" + code + "®ionCode=" + regionCode + "'>" + Convert.ToString(dsSearchResult.Tables[0].Rows[i]["ContainerName"]) + "</a>"; dsSearchResult.AcceptChanges(); uwgSearchRes.DataSource = dsSearchResult; uwgSearchRes.DataBind(); uwgSearchRes.Visible = true; } } else { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "ClientScript", "alert('No Mandatory Containers are found for the search. Please try once again' );", true); uwgSearchRes.Visible = false; } } else { StringBuilder ErrorMessage = new StringBuilder(); if (BizCode == null) { string BizUnit = ""; if (this.code == 0) { BizUnit = "OrgName"; } else if (this.code == 1) { BizUnit = "GroupName"; } else if (this.code == 2) { BizUnit = "GBUName"; } ErrorMessage.Append("Please Select atleast one " + BizUnit + "\\n"); } if (regionCode == null) { ErrorMessage.Append("Please Select atleast one region"); } Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "ClientScript", "alert('" + ErrorMessage.ToString() + "' );", true); uwgSearchRes.Visible = false; } } else { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "ClientScript", "alert('Please enter Container Name' );", true); uwgSearchRes.Visible = false; } }
//This method populates the InputForm ListBox protected void populateInputFormLstBox() { rbtnInputForm.Enabled = true; string Biz = ""; Database dbObj = new Database(HyperCatalog.Business.ApplicationSettings.Components["Datawarehouse_DB"].ConnectionString); QMReportsClass objQMReports = new QMReportsClass(); string BizCode = objQMReports.getSelectedValues(LstBoxBusinessUnitName); if (BizCode != null) { DataSet ds = dbObj.RunSPReturnDataSet("dbo._Reports_QM_GetInputFormsByOrganization", new SqlParameter("@BizCode", BizCode), new SqlParameter("@Code", this.code)); if (ds.Tables[0].Rows.Count != 0) { //******************************************************************************* // code added by kanthi.J to shrink the sizeof of the inputform ListBox so that // the ListBox box doesnot display blank space if the rows returned by the dataset is // less than the 15.(180 px can accomodate 14 rows) //******************************************************************************* if (ds.Tables[0].Rows.Count < 15) { lstboxInputFormName.Height = ds.Tables[0].Rows.Count * 13; } else { lstboxInputFormName.Height = Unit.Pixel(180); } lstboxInputFormName.DataSource = ds; lstboxInputFormName.DataValueField = "InputFormId"; lstboxInputFormName.DataTextField = "Name"; lstboxInputFormName.DataBind(); lstboxInputFormName.SelectedIndex = 0; dbObj.CloseConnection(); dbObj.Dispose(); } else { BizCode = objQMReports.getSelectedValues(LstBoxBusinessUnitName); if (code == 0) { Biz = "OrgName"; } else if (code == 1) { Biz = "GroupName"; } else if (code == 2) { Biz = "GBUName"; } StringBuilder sb = new StringBuilder(); sb.Append("alert('No InputForm is available for the selected Input. Please select another " + Biz + "');"); Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "ClientScript", sb.ToString(), true); lstboxInputFormName.Items.Clear(); btnNext.Enabled = false; } } else { string BizUnit = ""; if (this.code == 0) { BizUnit = "OrgName"; } else if (this.code == 1) { BizUnit = "GroupName"; } else if (this.code == 2) { BizUnit = "GBUName"; } string ErrorMessage = "Please Select atleast one " + BizUnit; Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "ClientScript", "alert('" + ErrorMessage + "' );", true); lstboxInputFormName.Items.Clear(); btnNext.Enabled = false; } }