/// <summary> /// GetCustomerName :Private method used to get customer name /// </summary> private void GetCustomerName() { try { string strWhere = string.Empty; string strTable = string.Empty; if (Request.QueryString["CASMode"] == null) { strWhere = "CustNo='" + Request.QueryString["CustNo"].Trim().Replace("||", "&") + "'"; strTable = "CAS_CustomerData"; } else { strWhere = "Chain='" + Request.QueryString["Chain"].Trim().Replace("||", "&") + "'"; strTable = "CAS_ChainData"; } PFC.Intranet.BusinessLogicLayer.CustomerActivitySheet customerData = new PFC.Intranet.BusinessLogicLayer.CustomerActivitySheet(); DataTable dtSalesDetails = customerData.GetCustomerActivityDetail(strWhere, "CustName,BranchNo,BranchDesc", strTable); if (dtSalesDetails.Rows.Count > 0) { Session["CustomerName"] = dtSalesDetails.Rows[0]["CustName"].ToString(); if (Request.QueryString["Branch"].Trim() == "0") { StrBranch = dtSalesDetails.Rows[0]["BranchNo"].ToString() + "-" + dtSalesDetails.Rows[0]["BranchDesc"].ToString(); } else { StrBranch = Request.QueryString["BranchName"].Trim(); } } else { Session["CustomerName"] = ""; if (Request.QueryString["Branch"].Trim() == "0") { StrBranch = Request.QueryString["BranchName"].Trim(); } } } catch (Exception ex) { Response.Write(ex.ToString()); } }
/// <summary> /// Function to fill the customer contact notes /// </summary> public void FilllNotes() { try { string strWhere = "CustNo='" + Request.QueryString["CustNo"].Trim().Replace("||", "&") + "'"; // Initailize the class customer activity sheet PFC.Intranet.BusinessLogicLayer.CustomerActivitySheet customerData = new PFC.Intranet.BusinessLogicLayer.CustomerActivitySheet(); // Get the data's in the datatable by calling the class function dtContactNotes = customerData.GetCustomerActivityDetail(strWhere, strNotesColumns, strNotesTable); // Get the datas in the datatable to bind the data in a single row DataTable dt = new DataTable(); dt.Columns.Add("PreviousNote", typeof(string)); dt.Columns.Add("LastOutRepNote", typeof(string)); dt.Columns.Add("LastInRepNote", typeof(string)); DataRow drow = dt.NewRow(); if (dtContactNotes != null && dtContactNotes.Rows.Count != 0) { dtContactNotes.DefaultView.RowFilter = "NoteType='Previous Visit Note'"; drow[0] = (dtContactNotes.DefaultView.ToTable().Rows.Count != 0) ? dtContactNotes.DefaultView.ToTable().Rows[0][0].ToString() : ""; dtContactNotes.DefaultView.RowFilter = "NoteType='Last Outside Sales Rep Notes'"; drow[1] = (dtContactNotes.DefaultView.ToTable().Rows.Count != 0) ? dtContactNotes.DefaultView.ToTable().Rows[0][0].ToString() : ""; dtContactNotes.DefaultView.RowFilter = "NoteType='Last Inside Sales Rep Notes'"; drow[2] = (dtContactNotes.DefaultView.ToTable().Rows.Count != 0) ? dtContactNotes.DefaultView.ToTable().Rows[0][0].ToString() : ""; } else { drow[0] = ""; drow[1] = ""; drow[2] = ""; } dt.Rows.Add(drow); // Code to bind the datatable in the datagrid dgContactNotes.DataSource = dt; dgContactNotes.DataBind(); } catch (Exception ex) { } }
/// <summary> /// Function to fill the customer details /// </summary> public void FillCustomerDetails() { try { string strWhere = "curmonth=" + Request.QueryString["Month"].Trim() + " and " + "curYear=" + Request.QueryString["Year"].Trim() + " and CustNo='" + Request.QueryString["CustNo"].Trim().Replace("||", "&") + "'"; strTable = Request.QueryString["CASMode"] == null ? strTable : "CAS_ChainData"; // Initailize the class customer activity sheet PFC.Intranet.BusinessLogicLayer.CustomerActivitySheet customerData = new PFC.Intranet.BusinessLogicLayer.CustomerActivitySheet(); // Get the data's in the datatable by calling the class function dtCustomerData = customerData.GetCustomerActivityDetail(strWhere, strDisplayColumns, strTable); // Bind the datagrid with datatables dgCas.DataSource = dtCustomerData; dgCas.DataBind(); } catch (Exception ex) { Response.Write(ex.Message.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { SystemCheck systemCheck = new SystemCheck(); systemCheck.SessionCheck(); try { // Get the mode in the variable string strMode = Request.QueryString["mode"].Trim(); // Get the url of the pages in the string string strUrl = Request.QueryString["URL"].Trim(); strUrl = strUrl.Replace("~", "&"); string[] url = strUrl.Split(','); strDetailType = Session["DetailType"] != null ? Session["DetailType"].ToString() : "PFC Employee"; // Using HTTP Post get the content of the pages in the array for (int i = 0; i < url.Length; i++) { WebRequest req = WebRequest.Create(Global.IntranetSiteURL + "CustomerActivitySheet/" + url[i].Trim().Replace('`', ',') + "&ChartType=" + Session["ChartType"].ToString() + "&ChartPalette=" + Session["ChartPalette"].ToString() + "&CustomerType=" + Session["CustomerType"].ToString() + "&mode=" + strMode + "&DetailType=" + strDetailType + "&PrintMode=Print"); WebResponse resp = req.GetResponse(); StreamReader reader = new StreamReader(resp.GetResponseStream(), System.Text.Encoding.ASCII); // Get the page content in the string string strHtml = reader.ReadToEnd(); string[] strhtm = strHtml.Split('~'); strHtml = strhtm[1].ToString(); strHtml = strHtml.Replace("|>", ""); strHtml = strHtml.Replace("|\">", ""); strHtml = strHtml.Replace("</html>", ""); strHtml = strHtml.Replace("</form>", ""); strHtml = strHtml.Replace("</body>", ""); if ((i == url.Length - 1) && (url[i].ToString().IndexOf("SalesCategoryDetail") != -1)) { strHtml = strHtml.Replace("style=\"page-break-after:always;\"", ""); } else { strHtml = (i == url.Length - 1) ? strHtml.Replace("page-break-after:always", "") : strHtml; } // Assing the page content in to the div strHtml = strHtml.Replace("???", "-"); strHtml = strHtml.Replace("??", " "); divContent.InnerHtml = divContent.InnerHtml + "<form>" + strHtml + "</form>"; } if (strMode.Trim() == "Print") { // Script to print the current form Response.Write("<script>window.print();</script>"); } else { // Code to export the pages to pdf string strFilename = DateTime.Now.ToString().Replace("/", ""); strFilename = strFilename.Replace(" ", ""); strFilename = strFilename.Replace(":", ""); // Get the HTML FileName in a string string strHTMLFilename = "CAS" + Session["SessionID"].ToString() + strFilename + ".htm"; // Get the PDF FileName in a string string strPDFilename = "CAS" + Session["SessionID"].ToString() + strFilename + ".pdf"; string strContent = divContent.InnerHtml.Replace("style=\"width:100%;border-collapse:collapse;\"", "style=\"width:100%;border-collapse:collapse;border-left:1px;border-right:1px;border-bottom:1px;border-top:1px\""); // Code to create the HTML File FileInfo fn = new FileInfo(Server.MapPath(strHTMLFilename)); StreamWriter writeHTML = fn.CreateText(); writeHTML.WriteLine("<html>"); writeHTML.WriteLine("<head>"); writeHTML.WriteLine("<link href=\"../CustomerActivitySheet/Styles/Styles.css\" rel=\"stylesheet\" type=\"text/css\" />" + "<link href=\"../SalesAnalysisReport/StyleSheet/Styles.css\" rel=\"stylesheet\" type=\"text/css\" />"); writeHTML.WriteLine("</head>"); writeHTML.WriteLine("<body>"); writeHTML.WriteLine(strContent.Replace("class=DashBoardBk", "")); writeHTML.WriteLine("</body>"); writeHTML.WriteLine("</html>"); writeHTML.Close(); // Initialize the class variable Customeractivitysheet PFC.Intranet.BusinessLogicLayer.CustomerActivitySheet cs = new PFC.Intranet.BusinessLogicLayer.CustomerActivitySheet(); // Code to create the pdf file cs.CreatePDF(Global.IntranetSiteURL + "CustomerActivitySheet/" + strHTMLFilename, Server.MapPath("PDF/" + strPDFilename)); // Code to save or open the pdf file string pathFileName = Server.MapPath("PDF/" + strPDFilename); fStream = new System.IO.FileStream(pathFileName, System.IO.FileMode.Open, System.IO.FileAccess.Read, System.IO.FileShare.Read); Byte[] b; if (fStream.Length > 0) { b = new Byte[fStream.Length]; Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/unknown"; fStream.Read(b, 0, (int)fStream.Length - 1); Response.AddHeader("Content-Disposition", "attachment;filename=" + strPDFilename); Response.BinaryWrite(b); Response.End(); fStream.Close(); } } } catch (Exception ex) { fStream.Close(); } finally { } }