protected void LoadMasterData() { if (ddlDRNo.SelectedIndex == 0) { clearAll(); return; } SqlDataReader dr_emp = null; DataTable dt = new DataTable(); SqlParameter[] dsParam = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), new SqlParameter("@FIRCode", SqlDbType.Char, 8) }; dsParam[0].Value = Session["DealerCode"].ToString(); dsParam[1].Value = ddlDRNo.SelectedValue.Trim(); sysfunc.ExecuteSP("sp_GetFIRMaster", dsParam, ref dr_emp); dt.Load(dr_emp); txtSRNo.Text = dt.Rows[0]["FIRCode"].ToString().Trim(); txtDate.Text = dt.Rows[0]["FIRDate"].ToString().Trim(); txtRegNo.Text = dt.Rows[0]["RegNo"].ToString().Trim(); txtModelCode.Text = dt.Rows[0]["VersionCode"].ToString().Trim(); txtEngineNo.Text = dt.Rows[0]["EngineNo"].ToString().Trim(); ddlVinNo.SelectedValue = dt.Rows[0]["ChassisNo"].ToString().Trim(); txtKM.Text = dt.Rows[0]["KM"].ToString().Trim(); txtSubject.Text = dt.Rows[0]["Subject"].ToString().Trim(); txtFailedPart.Text = dt.Rows[0]["ItemCode"].ToString(); txtFailureDate.Text = dt.Rows[0]["ProblemDate"].ToString().Trim(); txtInspDate.Text = dt.Rows[0]["InspectionDate"].ToString().Trim(); txtPrblmCause.Text = dt.Rows[0]["Problem"].ToString().Trim(); txtCorAction.Text = dt.Rows[0]["CorrectiveAction"].ToString().Trim(); txtCustComp.Text = dt.Rows[0]["CusComment"].ToString().Trim(); txtCustName.Text = dt.Rows[0]["CusDesc"].ToString().Trim(); txtAddress.Text = dt.Rows[0]["address"].ToString().Trim(); txtPhnNo.Text = dt.Rows[0]["Phone1"].ToString().Trim(); txtWarantyBookNo.Text = dt.Rows[0]["InvoiceNo"].ToString().Trim(); txtDelDate.Text = dt.Rows[0]["DeliveryDate"].ToString().Trim(); txtPart1.Text = dt.Rows[0]["Part1"].ToString().Trim(); txtPart1Desc.Text = dt.Rows[0]["Part1D"].ToString().Trim(); txtPart2.Text = dt.Rows[0]["Part2"].ToString().Trim(); txtPart2Desc.Text = dt.Rows[0]["Part2D"].ToString().Trim(); txtPart3.Text = dt.Rows[0]["Part3"].ToString().Trim(); txtPart3Desc.Text = dt.Rows[0]["Part3D"].ToString().Trim(); txtPart4.Text = dt.Rows[0]["Part4"].ToString().Trim(); txtPart4Desc.Text = dt.Rows[0]["Part4D"].ToString().Trim(); ddlStatus.SelectedValue = dt.Rows[0]["Status"].ToString(); ddlResult.SelectedValue = dt.Rows[0]["Result"].ToString(); txtRoNo.Text = dt.Rows[0]["RoNo"].ToString(); txtRepairDate.Text = dt.Rows[0]["RoDate"].ToString(); txtRequest.Text = dt.Rows[0]["Request"].ToString(); txtFollowUpDate.Text = dt.Rows[0]["followupdate"].ToString(); txtKeyNo.Text = dt.Rows[0]["KeyNo"].ToString(); txtSerial.Text = dt.Rows[0]["SerialNo"].ToString(); }
public ActionResult GatePass() { DSReports data = new DSReports(); ReportDocument RD = new ReportDocument(); string DealerCode = Session["DealerCode"].ToString(); string old = grl.GetStringValuesAgainstCodes("TransCode", Session["TransCode"].ToString(), "GatePassCode", "GatePassTemp", " and Module='Sales'", Session["DealerCode"].ToString()); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), new SqlParameter("@DONo", SqlDbType.VarChar) }; param[0].Value = DealerCode; param[1].Value = old; SqlDataReader rder = null; SysFunction sysFunc = new SysFunction(); if (sysFunc.ExecuteSP("SP_DeliveryOrderGatePass", param, ref rder)) { data.SP_DeliveryOrderGatePass.Load(rder); } RD.Load(Server.MapPath("~/Reports/rptGatePass.rpt")); //RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Delivery Order Gate Pass'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'"; //RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'"; //RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '"; //rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'"; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; //RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; RD.Database.Tables[0].SetDataSource(data); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "ProductReceiptReport.pdf")); } catch { throw; } }
protected void btnShow_Click(object sender, EventArgs e) { SysFunction sysFunc = new SysFunction(); Data.DSReports data = new Data.DSReports(); ReportDocument RD = new ReportDocument(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@TicketNo", SqlDbType.Char), //0 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = txtTicketNo.Text; SqlDataReader rder = null; // Store Procedure check and load if (sysFunc.ExecuteSP("SP_Report_Complaint", param, ref rder)) //Database SP { data.EnforceConstraints = false; data.SP_Report_Complaint.Load(rder); // DataSet SP } // Load in crystal report //RD.Load(Server.MapPath("../PurchaseSaleReturnReport.rpt")); RD.Load(Server.MapPath("/Reports/rptComplaint.rpt")); RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAdress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; //RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; // RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Complain'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'"; RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'"; // RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '"; //rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'"; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; //RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; // RD.DataDefinition.FormulaFields["ComplaintTypeCode"] = "'"+txtTicketNo.Text+"'"; // mention paper size //RD.PrintOptions.PaperSize = PaperSize.PaperA4; RD.Database.Tables[0].SetDataSource(data); string FilePath = Server.MapPath("~/Download/"); string FileName = "CounterSalesDetail" + Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf"; string File = FilePath + FileName; Session["RD"] = RD; string URL; URL = "../../../Download/rptViewerService.aspx?FileName=" + FileName; string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');"; ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true); }
protected void btnPrint_Click(object sender, EventArgs e) { Data.DSReports data = new Data.DSReports(); ReportDocument RD = new ReportDocument(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@PPRCOde", SqlDbType.Char), //1 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddlPRNo.SelectedValue; SqlDataReader rder = null; SysFunction sysFunc = new SysFunction(); if (sysFunc.ExecuteSP("SP_PPR_Report", param, ref rder)) { data.SP_PPR_Report.Load(rder); } RD.Load(Server.MapPath("~\\Modules\\Service\\ServiceReports\\TRReport.rpt")); RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerFax"].Text = "'" + Session["DealerFax"].ToString() + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Warranty Report'"; RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; //RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'"; //RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '"; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; //RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'"; //RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; RD.Database.Tables[0].SetDataSource(data); // convert and show string FilePath = Server.MapPath("~") + "\\Download\\"; string FileName = "TRReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf"; string File = FilePath + FileName; Session["RD"] = RD; //RD.ExportToDisk(ExportFormatType.PortableDocFormat, File); string URL; URL = "../../../Download/rptViewerService.aspx?FileName=" + FileName; string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');"; ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true); }
public ActionResult Exports( ) { DSReports data = new DSReports(); ReportDocument RD = new ReportDocument(); string dealerCode = Session["DealerCode"].ToString(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //new SqlParameter("@BuyingCode",SqlDbType.Char) }; param[0].Value = dealerCode; // param[1].Value = EnquiryId; SqlDataReader rder = null; SysFunction sysFunc = new SysFunction(); try { if (sysFunc.ExecuteSP("Select_DealFailYes", param, ref rder)) { data.EnforceConstraints = false; data.Select_DealFailYes.Load(rder); } RD.Load(Server.MapPath("~/Reports/Sale/DealFailReport.rpt")); // RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; //RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; //RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Deal Fail Evaluation Details'"; //RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'"; //RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'"; //RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '"; //rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'"; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; // RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; //RD.DataDefinition.FormulaFields["FrontImg"].Text = "'" + data.Select_BuyingCodeReport.Rows[0]["Pic01"].ToString() + "'"; //RD.DataDefinition.FormulaFields["BackImg"].Text = "'" + data.Select_BuyingCodeReport.Rows[0]["Pic02"].ToString() + "'"; //RD.DataDefinition.FormulaFields["LeftImg"].Text = "'" + data.Select_BuyingCodeReport.Rows[0]["Pic03"].ToString() + "'"; //RD.DataDefinition.FormulaFields["RightImg"].Text = "'" + data.Select_BuyingCodeReport.Rows[0]["Pic04"].ToString() + "'"; //RD.DataDefinition.FormulaFields["TopImg"].Text = "'" + data.Select_BuyingCodeReport.Rows[0]["Pic05"].ToString() + "'"; RD.Database.Tables[0].SetDataSource(data); Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "InstallmentReceiptReport.pdf")); } catch { throw; } }
public static string Get_DeliveryChkList(string enquiryId, string dealerCode, string type) { string json = ""; var Serializer = new JavaScriptSerializer(); SqlDataReader rder = null;; List <DeliveryCheckListVM> lst = new List <DeliveryCheckListVM>(); try { SqlParameter[] sqlParam = { new SqlParameter("@DealerCode", dealerCode), //1 new SqlParameter("@JobCardCode", enquiryId) //1 }; if (sysfun.ExecuteSP("sp_DeliveryDocList", sqlParam, ref rder)) { while (rder.Read()) { byte[] myimg = (byte[])rder["DocImage"]; lst.Add(new DeliveryCheckListVM { BookChkListCode = rder["DelChkListCode"].ToString(), DelChkListDesc = rder["DelChkListDesc"].ToString(), //ContentType = sdr["ContentType"].ToString(), Image = "data:image/png;base64," + Convert.ToBase64String(myimg, 0, myimg.Length), }); // Session["Image"] = "data:image/png;base64," + Convert.ToBase64String(myimg, 0, myimg.Length); } } json = Serializer.Serialize(lst); } catch (Exception ex) { throw; } //try //{ // string sql = "Select DelChkListCode from VehicleDelChkList where DeliveryNo = '" + enquiryId + "' and DealerCode ='"+ dealerCode + "' and Type = '"+ type + "'"; // dt = sysfun.GetData(sql); // if (dt != null && dt.Rows.Count > 0) // { // lst = EnumerableExtension.ToList<DeliveryCheckListVM>(dt); // } // json = Serializer.Serialize(lst); //} //catch (Exception ex) //{ // throw; //} return(json); }
public ActionResult Export(string EnquiryId, string DealerCode) { DSReports data = new DSReports(); ReportDocument RD = new ReportDocument(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), new SqlParameter("@CusCode", SqlDbType.VarChar) }; param[0].Value = DealerCode; param[1].Value = EnquiryId; SqlDataReader rder = null; SysFunction sysFunc = new SysFunction(); if (sysFunc.ExecuteSP("SP_InstallmentLedgerReport", param, ref rder)) { data.SP_InstallmentLedgerReport.Load(rder); } RD.Load(Server.MapPath("~/Reports/InstallmentLedgerReport.rpt")); RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'CUSTOMER INSTALLMENT LEDGER'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'"; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; RD.Database.Tables[0].SetDataSource(data); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "ProductReceiptReport.pdf")); } catch { throw; } }
public static string Get_BookingChkList(string enquiryId, string DealerCode) { string json = ""; var Serializer = new JavaScriptSerializer(); SqlDataReader rder = null; List <DeliveryCheckListVM> lst = new List <DeliveryCheckListVM>(); try { SqlParameter[] sqlParam = { new SqlParameter("@DealerCode", DealerCode), //1 new SqlParameter("@JobCardCode", enquiryId) //1 }; if (sysfun.ExecuteSP("sp_BookOrdDocList", sqlParam, ref rder)) { while (rder.Read()) { byte[] myimg = (byte[])rder["DocImage"]; lst.Add(new DeliveryCheckListVM { BookChkListCode = rder["BookChklistCode"].ToString(), DelChkListDesc = rder["DelChkListDesc"].ToString(), //ContentType = sdr["ContentType"].ToString(), Image = "data:image/png;base64," + Convert.ToBase64String(myimg, 0, myimg.Length), }); // Session["Image"] = "data:image/png;base64," + Convert.ToBase64String(myimg, 0, myimg.Length); } } json = Serializer.Serialize(lst); } catch (Exception ex) { throw; } return(json); }
public void InvoicePrint(string EnquiryId, string DealerCode) { DSReports data = new DSReports(); ReportDocument RD = new ReportDocument(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), new SqlParameter("@EnquiryId", SqlDbType.VarChar) }; param[0].Value = DealerCode; param[1].Value = EnquiryId; SqlDataReader rder = null; SysFunction sysFunc = new SysFunction(); if (sysFunc.ExecuteSP("SP_EventDetail_Select", param, ref rder)) { data.SP_EventDetail_Select.Load(rder); } this.HttpContext.Session["rptSource"] = data; }
public ActionResult ExportBuyingDetail(string todate, string fromdate) { string dealerCode = Session["DealerCode"].ToString(); DSReports data = new DSReports(); ReportDocument RD = new ReportDocument(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), new SqlParameter("@fromDate", SqlDbType.DateTime), new SqlParameter("@ToDate", SqlDbType.DateTime), }; param[0].Value = dealerCode; param[1].Value = sysfunc.SaveDate(todate); param[2].Value = sysfunc.SaveDate(fromdate); SqlDataReader rder = null; SysFunction sysFunc = new SysFunction(); if (sysFunc.ExecuteSP("Select_ExchangeVehicle_DetailReportData", param, ref rder)) { data.EnforceConstraints = false; data.Select_ExchangeVehicle_DetailReportData.Load(rder); } RD.Load(Server.MapPath("~/Reports/VehicleExchangeDetail.rpt")); RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; //RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; //RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Exchange Details '"; //RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'"; //RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'"; //RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '"; //rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'"; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; // RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; RD.DataDefinition.FormulaFields["FromDate"].Text = "'" + fromdate + "'"; RD.DataDefinition.FormulaFields["ToDate"].Text = "'" + todate + "'"; RD.Database.Tables[0].SetDataSource(data); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "InstallmentReceiptReport.pdf")); } catch { throw; } }
protected void btnShow_Click(object sender, EventArgs e) { if (!sec.UserRight("2580", "006")) { Response.Redirect("~/Test.aspx"); } try { if (txtFromDate.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select From Date"); return; } else if (txtToDate.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select To Date"); return; } //if (ddlVendorCode.SelectedIndex == 0) //{ // sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select Vendor Option"); // return; //} SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@FromDate", SqlDbType.VarChar), //1 new SqlParameter("@ToDate", SqlDbType.VarChar), //2 new SqlParameter("@VendorCode", SqlDbType.VarChar) //3 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = sysFunc.SaveDate(txtFromDate.Text); param[2].Value = sysFunc.SaveDate(txtToDate.Text); param[3].Value = ddlVendorCode.SelectedValue.ToString().Trim(); SqlDataReader rder = null; //SP_VendorLedger_Report // Store Procedure check and load if (sysFunc.ExecuteSP("SP_VendorLedger_Report", param, ref rder)) //Database SP { data.SP_VendorLedger_Report.Load(rder); // DataSet SP } // Load in crystal report //RD.Load(Server.MapPath("../PurchaseSaleReturnReport.rpt")); RD.Load(Server.MapPath("../crptVendorLedgerReport.rpt")); // mention paper size RD.PrintOptions.PaperSize = PaperSize.PaperA4; //RD.Load(Server.MapPath("../../SpareReports/rptInvoices.rpt")); // RD.Load(Server.MapPath("../rptJobHistory.rpt")); //RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Phone1", "Dealer") + "'"; // RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Email", "Dealer") + "'"; RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'"; RD.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'"; //RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'"; //RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Vendor Ledger Report" + "\""; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; //RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'"; //RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; RD.Database.Tables[0].SetDataSource(data); string FilePath = Server.MapPath("~") + "\\Download\\"; string FileName = "Report.pdf"; string File = FilePath + FileName; PdfDocument outputDocument = new PdfDocument(); Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); DirectoryInfo info = new DirectoryInfo(FilePath); if (!info.Exists) { info.Create(); } string path = Path.Combine(FilePath, FileName); using (FileStream outputFileStream = new FileStream(path, FileMode.Create)) { stream.CopyTo(outputFileStream); } stream.Dispose(); stream.Close(); string URL = "../../../../Download/PrintReport.aspx"; string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');"; ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true); //// convert and show //string FilePath = Server.MapPath("~") + "\\Download\\"; //string FileName = "VendorLedgerReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf"; //string File = FilePath + FileName; //Session["RD"] = RD; ////RD.ExportToDisk(ExportFormatType.PortableDocFormat, File); //string URL; //URL = "../../../../Download/rptViewerService.aspx?FileName=" + FileName; //string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');"; //ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true); } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }
protected void ddlEmployee_SelectedIndexChanged(object sender, EventArgs e) { if (ddlEmployee.SelectedIndex == 0) { cleardata(); cbActive.Checked = false; return; } try { btn_save.Text = "Update"; DataTable dt = new DataTable(); SqlDataReader dr_emp = null; SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@EmpCode", SqlDbType.Char), //1 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddlEmployee.SelectedItem.Value; SysFunc.ExecuteSP("SP_Select_DealerEmp", param, ref dr_emp); dt.Load(dr_emp); if (dt.Rows[0]["Active"].ToString() == "Y") { cbActive.Checked = true; } else { cbActive.Checked = false; } txtEmpID.Text = dt.Rows[0]["EmpID"].ToString().Trim(); txtEmp_name.Text = dt.Rows[0]["EmpName"].ToString(); txtdob.Text = dt.Rows[0]["DOB"].ToString(); txtcontact_no.Text = dt.Rows[0]["ContactNo"].ToString(); txtnic_no.Text = dt.Rows[0]["CNIC"].ToString(); txtjoining_date.Text = dt.Rows[0]["JoiningDate"].ToString(); txtleaving_date.Text = dt.Rows[0]["LeavingDate"].ToString(); ddldesig_code.SelectedValue = dt.Rows[0]["DesigCode"].ToString(); ddldep_code.SelectedValue = dt.Rows[0]["DeptCode"].ToString(); txtexp.Text = dt.Rows[0]["Experience"].ToString(); txtremarks.Text = dt.Rows[0]["Remarks"].ToString(); txtEmail.Text = dt.Rows[0]["Email"].ToString(); if (!string.IsNullOrEmpty(dt.Rows[0]["Picture"].ToString())) { Image1.ImageUrl = dt.Rows[0]["Picture"].ToString(); } else { Image1.ImageUrl = "~/Images/BlankProfile.jpg"; } } catch (Exception ex) { success_add_item.Visible = true; success_add_item.ForeColor = Color.Red; success_add_item.Text = ex.Message; } }
protected void Print(object sender, EventArgs e) { Data.DSReports data = new Data.DSReports(); ReportDocument RD = new ReportDocument(); SysFunction sysFunc = new SysFunction(); DateTime fromDate = DateTime.ParseExact(txtFromDate.Text, "yyyy-MM-dd", null); DateTime toDate = DateTime.ParseExact(txtToDate.Text, "yyyy-MM-dd", null); //string FDate = sysFunc.SaveDate(txtFromDate.Text).ToString(); //string TDate = sysFunc.SaveDate(txtToDate.Text).ToString(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@FromDate", SqlDbType.VarChar), //1 new SqlParameter("@ToDate", SqlDbType.VarChar), //2 new SqlParameter("@Satisfied", SqlDbType.Char) }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = fromDate; param[2].Value = toDate; param[3].Value = ddlStatus.SelectedValue.ToString().Trim(); SqlDataReader rder = null; if (sysFunc.ExecuteSP("sp_PostServiceFollowup_Rpt", param, ref rder)) { data.sp_PostServiceFollowup_Rpt.Load(rder); } RD.Load(Server.MapPath("../PSFReport.rpt")); RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerFax"].Text = "'" + Session["DealerFax"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserID"].ToString() + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + " POST SERVICE FOLLOWUP SUMMARY" + "\""; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; //RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; //RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\Images\\havoline.png'"; //RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'"; RD.Database.Tables[0].SetDataSource(data); // convert and show string FilePath = Server.MapPath("~") + "\\Download\\"; string FileName = "crtPSF" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf"; string File = FilePath + FileName; Session["RD"] = RD; //RD.ExportToDisk(ExportFormatType.PortableDocFormat, File); string URL; URL = "../../../../Download/rptViewerService.aspx?FileName=" + FileName; string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1200,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');"; ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true); }
protected void btnBillReport_Click(object sender, EventArgs e) { if (!sec.UserRight("2583", "006")) { Response.Redirect("~/Test.aspx"); } Data.DSReports data = new Data.DSReports(); ReportDocument RD = new ReportDocument(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@BillingNo", SqlDbType.VarChar) //1 }; param[0].Value = Session["DealerCode"].ToString(); if (ddlBillingNo.SelectedIndex == 0) { lblMessage.Text = "Please Select Billing No. first"; return; } else { param[1].Value = ddlBillingNo.SelectedValue.ToString().Trim(); } SqlDataReader rder = null; if (sysFunc.ExecuteSP("Sp_JENBillingRpt", param, ref rder)) { data.EnforceConstraints = false; data.Sp_JENBillingRpt.Load(rder); } RD.Load(Server.MapPath("~/Modules/Service/ServiceReports/rptClaimMemo.rpt")); RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerFax"].Text = "'" + Session["DealerFax"].ToString() + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Warranty Claim Memo'"; RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; //RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'"; //RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; RD.Database.Tables[0].SetDataSource(data); // convert and show string FilePath = Server.MapPath("~") + "\\Download\\"; string FileName = "BillingReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf"; string File = FilePath + FileName; Session["RD"] = RD; //RD.ExportToDisk(ExportFormatType.PortableDocFormat, File); string URL; URL = "../../../../Download/rptViewerService.aspx?FileName=" + FileName; string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');"; ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true); }
public ActionResult Export(string EnquiryId, string Type, string FromDate, string ToDate) { DSReports data = new DSReports(); ReportDocument RD = new ReportDocument(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), // new SqlParameter("@FromDate", SqlDbType.VarChar), //1 new SqlParameter("@ToDate", SqlDbType.VarChar), //2 new SqlParameter("@Type", SqlDbType.VarChar) }; param[0].Value = dealerCode; param[1].Value = sysfunc.SaveDate(FromDate); param[2].Value = sysfunc.SaveDate(ToDate); param[3].Value = Type; try { SqlDataReader rder = null; if (EnquiryId == "Vehicle Receipt") { sysfunc.ExecuteSP("SP_ProdRecMaster_Report", param, ref rder); data.EnforceConstraints = false; data.SP_ProdRecMaster_Report.Load(rder); RD.Load(Server.MapPath("~/Reports/crptProdRecMasterReport.rpt")); RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Vehicle Receipt Detail'"; } else if (EnquiryId == "Delivery Order") { sysfunc.ExecuteSP("SP_VehicleDeliveryMaster_Report", param, ref rder); data.EnforceConstraints = false; data.SP_VehicleDeliveryMaster_Report.Load(rder); RD.Load(Server.MapPath("~/Reports/crptVehicleDeliveryReport.rpt")); RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Delivery Order Detail'"; } else if (EnquiryId == "Pending Booking Number") { sysfunc.ExecuteSP("SP_Select_PendingBookingNumber", param, ref rder); data.EnforceConstraints = false; data.SP_Select_PendingBookingNumber.Load(rder); RD.Load(Server.MapPath("~/Reports/PendingBookingNo.rpt")); RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Pending Booking Number'"; } else if (EnquiryId == "Pending Invoice Number") { sysfunc.ExecuteSP("SP_Select_PendingVehicleReceipt", param, ref rder); data.EnforceConstraints = false; data.SP_Select_PendingVehicleReceipt.Load(rder); RD.Load(Server.MapPath("~/Reports/PendingInvoice.rpt")); RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Pending Vehicle Receipt'"; } else if (EnquiryId == "Pending Payments") { sysfunc.ExecuteSP("SP_PendingPaymentsReport", param, ref rder); data.EnforceConstraints = false; data.SP_PendingPaymentsReport.Load(rder); RD.Load(Server.MapPath("~/Reports/PendingPaymentsReport.rpt")); RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Pending Payments'"; } else { sysfunc.ExecuteSP("SP_BookingOrderDetailReport", param, ref rder); data.EnforceConstraints = false; data.SP_BookingOrderDetailReport.Load(rder); RD.Load(Server.MapPath("~/Reports/BookingOrderDetailReport.rpt")); RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Booking Order Detail'"; } RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'"; //RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'"; //RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '"; //rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'"; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; //RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; RD.Database.Tables[0].SetDataSource(data); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "ProductReceiptReport.pdf")); } catch { throw; } }
protected void btnShowReport_Click(object sender, EventArgs e) { if (!sec.UserRight("2586", "006")) { Response.Redirect("~/Test.aspx"); } if (dtFrom.Text == "" || dtTo.Text == "") { MessageBox.Show("Please select dates", "Message"); return; } Data.DSReports data = new Data.DSReports(); SqlDataReader rder = null; DataTable dt = new DataTable(); ReportDocument RD = new ReportDocument(); DateTime FromDate; DateTime ToDate; string FDate = myFunc.SaveDate(dtFrom.Text).ToString(); string TDate = myFunc.SaveDate(dtTo.Text).ToString(); FromDate = Convert.ToDateTime(FDate); ToDate = Convert.ToDateTime(TDate); //ReportDocument RD = new ReportDocument(); //DataSet dsRpt = new DataSet(); DXBMS.Data.DataSet1 objDsReports = new Data.DataSet1(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), // new SqlParameter("@FromDate", SqlDbType.VarChar), //1 new SqlParameter("@ToDate", SqlDbType.VarChar), //2 new SqlParameter("@VehicleCategory", SqlDbType.VarChar), new SqlParameter("@ChassisNo", SqlDbType.VarChar), //2 new SqlParameter("@EngineNo", SqlDbType.VarChar), new SqlParameter("@RegNo", SqlDbType.VarChar), new SqlParameter("@RptType", SqlDbType.VarChar), }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = FromDate; param[2].Value = ToDate; param[3].Value = rbStatus.SelectedItem.Value.ToString(); param[4].Value = ""; param[5].Value = ""; param[6].Value = ""; param[7].Value = "Warranty"; if (sysfunc.ExecuteSP("SP_PPR_Detail_Report", param, ref rder)) { //data.SP_selectjobcategorydetail.Load(rder); data.EnforceConstraints = false; data.SP_PPR_Detail_Report.Load(rder); } RD.Load(Server.MapPath("~/Modules/Service/ServiceReports/rptWarrantyDetailHCV.rpt")); // RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; // RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Warranty Claim Report'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'"; //RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'"; //RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '"; //rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'"; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; //RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'"; //RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; //RD.DataDefinition.FormulaFields["Pic1"].Text = "'" + Server.MapPath("~") + dt.Rows[0]["item"].ToString() + "'"; RD.Database.Tables[0].SetDataSource(data); string FilePath = Server.MapPath("~") + "\\Download\\"; string FileName = "Report.pdf"; string File = FilePath + FileName; PdfDocument outputDocument = new PdfDocument(); Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); DirectoryInfo info = new DirectoryInfo(FilePath); if (!info.Exists) { info.Create(); } string path = Path.Combine(FilePath, FileName); using (FileStream outputFileStream = new FileStream(path, FileMode.Create)) { stream.CopyTo(outputFileStream); } stream.Dispose(); stream.Close(); string URL = "../../../../Download/PrintReport.aspx"; string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');"; ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true); //convert and show //string FilePath = Server.MapPath("~") + "\\Download\\"; //string FileName = "BillingReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf"; //string File = FilePath + FileName; //Session["RD"] = RD; //string URL; //URL = "../../../../Download/rptViewerService.aspx?FileName=" + FileName; //string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');"; //ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true); }
public ActionResult Export(string Type, string rptType, string FromDate, string ToDate) { DSReports data = new DSReports(); ReportDocument RD = new ReportDocument(); SqlDataReader rder = null; SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), // new SqlParameter("@FromDate", SqlDbType.VarChar), //1 new SqlParameter("@ToDate", SqlDbType.VarChar), //2 new SqlParameter("@Type", SqlDbType.VarChar), new SqlParameter("@RptType", SqlDbType.VarChar) }; if (rptType == "VS") { param[0].Value = dealerCode; param[1].Value = sysfunc.SaveDate(FromDate); param[2].Value = sysfunc.SaveDate(ToDate); param[3].Value = Type; param[4].Value = "VS"; sysfunc.ExecuteSP("SP_VehicleStock_Report_New", param, ref rder); data.EnforceConstraints = false; data.SP_VehicleStock_Report.Load(rder); RD.Load(Server.MapPath("~/Reports/VehicleStockReport.rpt")); RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Vehicle Stock'"; } else if (rptType == "ID") { param[0].Value = dealerCode; param[1].Value = sysfunc.SaveDate(FromDate); param[2].Value = sysfunc.SaveDate(ToDate); param[3].Value = Type; param[4].Value = "ID"; sysfunc.ExecuteSP("SP_VehicleStock_Report_New", param, ref rder); data.EnforceConstraints = false; data.SP_VehicleStock_Report.Load(rder); RD.Load(Server.MapPath("~/Reports/VehicleStockReport.rpt")); RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Invoice Detail'"; } else { param[0].Value = dealerCode; param[1].Value = sysfunc.SaveDate(FromDate); param[2].Value = sysfunc.SaveDate(ToDate); param[3].Value = Type; param[4].Value = "PI"; sysfunc.ExecuteSP("SP_VehicleStock_Report_New", param, ref rder); data.EnforceConstraints = false; data.SP_VehicleStock_Report.Load(rder); RD.Load(Server.MapPath("~/Reports/VehicleStockReport.rpt")); RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Pending Invoice Detail'"; } try { RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'"; //RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'"; //RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '"; //rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + sysfunc.GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'"; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; //RD.DataDefinition.FormulaFields["Pic"].Text = "'F:\CRM\CRM_V3\CRM_V3\assets\images" + Session["Logo"] + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; RD.Database.Tables[0].SetDataSource(data); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "ProductReceiptReport.pdf")); } catch { throw; } }
public ActionResult Export(string EnquiryId, string DealerCode) { DSReports data = new DSReports(); ReportDocument RD = new ReportDocument(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), new SqlParameter("@EnquiryId", SqlDbType.VarChar) }; param[0].Value = DealerCode; param[1].Value = EnquiryId; SqlDataReader rder = null; SysFunction sysFunc = new SysFunction(); if (sysFunc.ExecuteSP("SP_Select_ProdRec_Print", param, ref rder)) { data.EnforceConstraints = false; data.SP_Select_ProdRec_Print.Load(rder); } // SqlParameter[] param2 = //{ // new SqlParameter("@DealerCode",SqlDbType.Char), // new SqlParameter("@DONo",SqlDbType.VarChar), // new SqlParameter("@Type",SqlDbType.VarChar) // }; // param2[0].Value = DealerCode; // param2[1].Value = EnquiryId; // param2[2].Value = "VR"; // if (sysFunc.ExecuteSP("SP_GetDeliveryCheckList", param2, ref rder)) // { // data.SP_GetDeliveryCheckList.Load(rder); // } RD.Load(Server.MapPath("~/Reports/VehicleReceipt.rpt")); RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Vehicle Receipt Report'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'"; //RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'"; //RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '"; //rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'"; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; //RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; //RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; RD.Database.Tables[0].SetDataSource(data); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "ProductReceiptReport.pdf")); } catch { throw; } }
protected void btnShow_Click(object sender, EventArgs e) { if (!sec.UserRight("2567", "006")) { Response.Redirect("~/Test.aspx"); } try { if (txtFromDate.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select From Date"); return; } else if (txtToDate.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select To Date"); return; } if (ddlUtilityAudit.SelectedIndex == 0) { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select Utility Audit Option"); return; } SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@FromDate", SqlDbType.VarChar), //1 new SqlParameter("@ToDate", SqlDbType.VarChar) //2 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = sysFunc.SaveDate(txtFromDate.Text); param[2].Value = sysFunc.SaveDate(txtToDate.Text); SqlDataReader rder = null; if (ddlUtilityAudit.SelectedValue == "Estimate") { if (sysFunc.ExecuteSP("SP_EstimateReport_pSelect", param, ref rder)) //Database SP { data.EnforceConstraints = false; data.SP_JobCardMaster.Load(rder); // DataSet SP } } if (ddlUtilityAudit.SelectedValue == "JobCard") { if (sysFunc.ExecuteSP("SP_JobCardReport_pSelect", param, ref rder)) //Database SP { data.EnforceConstraints = false; data.SP_JobCardMaster.Load(rder); // DataSet SP } } else if (ddlUtilityAudit.SelectedValue == "CounterSale") { if (sysFunc.ExecuteSP("SP_CounterSaleMaster_pSelect", param, ref rder)) //Database SP { data.SP_JobCardMaster.Load(rder); // DataSet SP } } else if (ddlUtilityAudit.SelectedValue == "CustomerInvoice") { if (sysFunc.ExecuteSP("SP_CustomerInvoice_pSelect", param, ref rder)) //Database SP { data.SP_JobCardMaster.Load(rder); // DataSet SP } } else if (ddlUtilityAudit.SelectedValue == "PayRec") { if (sysFunc.ExecuteSP("SP_CustomerInvoice_pSelect", param, ref rder)) //Database SP { data.SP_JobCardMaster.Load(rder); // DataSet SP } } else if (ddlUtilityAudit.SelectedValue == "GRN") { if (sysFunc.ExecuteSP("SP_GRNMaster_pSelect", param, ref rder)) //Database SP { data.SP_JobCardMaster.Load(rder); // DataSet SP } } else if (ddlUtilityAudit.SelectedValue == "ChargeOut") { if (sysFunc.ExecuteSP("SP_ChargeOutMaster_pSelect", param, ref rder)) //Database SP { data.SP_JobCardMaster.Load(rder); // DataSet SP } } RD.Load(Server.MapPath("../crpUtilityAuditReport.rpt")); // mention paper size RD.PrintOptions.PaperSize = PaperSize.PaperA4; RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'"; RD.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'"; //RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'"; //RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'"; //RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'"; if (ddlUtilityAudit.SelectedValue == "Estimate") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Customer Estimate Report" + "\""; } if (ddlUtilityAudit.SelectedValue == "JobCard") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Job Card Report" + "\""; } else if (ddlUtilityAudit.SelectedValue == "CounterSale") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Counter Sale Report" + "\""; } else if (ddlUtilityAudit.SelectedValue == "CustomerInvoice") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Customer Invoice Report" + "\""; } else if (ddlUtilityAudit.SelectedValue == "PayRec") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Payment Receipt Report" + "\""; } else if (ddlUtilityAudit.SelectedValue == "GRN") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "GRN Report" + "\""; } else if (ddlUtilityAudit.SelectedValue == "ChargeOut") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Stock Adjustment Report" + "\""; } //RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; //RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'"; // RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; RD.Database.Tables[0].SetDataSource(data); string FilePath = Server.MapPath("~") + "\\Download\\"; string FileName = "Report.pdf"; string File = FilePath + FileName; PdfDocument outputDocument = new PdfDocument(); Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); DirectoryInfo info = new DirectoryInfo(FilePath); if (!info.Exists) { info.Create(); } string path = Path.Combine(FilePath, FileName); using (FileStream outputFileStream = new FileStream(path, FileMode.Create)) { stream.CopyTo(outputFileStream); } stream.Dispose(); stream.Close(); string URL = "../../../../Download/PrintReport.aspx"; string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');"; ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true); //// convert and show //string FilePath = Server.MapPath("~") + "\\Download\\"; //string FileName = "UtilityAuditReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf"; //string File = FilePath + FileName; //Session["RD"] = RD; //string URL; //URL = "../../../../Download/rptViewerService.aspx?ReportID=" + FileName; //string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');"; //ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true); } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }
protected void BtnPrint_Click(object sender, EventArgs e) { Data.DSReports data = new Data.DSReports(); ReportDocument RD = new ReportDocument(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@FeedBackCode", SqlDbType.Char, 8), //1 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddlfeedbackNo.SelectedValue.Trim(); SqlDataReader rder = null; // Stored Procedure check and load if (sysFunc.ExecuteSP("SP_FeedBackMaster_Print", param, ref rder)) //Database SP { data.SP_FeedBackMaster_Print.Load(rder); // DataSet SP } // Load in crystal report //RD.Load(Server.MapPath("../PurchaseSaleReturnReport.rpt")); //RD.Load(Server.MapPath("../crtStockAdjustment.rpt")); RD.Load(Server.MapPath("Reports/FeedBackReport.rpt")); // mention paper size RD.PrintOptions.PaperSize = PaperSize.PaperA4; ////RD.Load(Server.MapPath("../../SpareReports/rptInvoices.rpt")); //// RD.Load(Server.MapPath("../rptJobHistory.rpt")); ////RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Phone1", "Dealer") + "'"; //// RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Email", "Dealer") + "'"; //RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "DealerDesc", "Dealer") + "'"; //RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Address1", "Dealer") + "" + // sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Address2", "Dealer") + "" + // sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Address3", "Dealer") + " (" + // sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Phone1", "Dealer") + ") '"; //RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "SaleTaxNo", "Dealer") + "'"; //RD.DataDefinition.FormulaFields["NTN"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "NTN", "Dealer") + "'"; ////RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'"; ////RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'"; ////RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'"; //RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'"; //RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "STOCK ADJUSTMENT REPORT" + "\""; ////RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; ////RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'"; //// RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; RD.Database.Tables[0].SetDataSource(data); // convert and show string FilePath = Server.MapPath("~") + "\\Download\\"; string FileName = "FeedBackQuestions" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf"; string File = FilePath + FileName; RD.ExportToDisk(ExportFormatType.PortableDocFormat, File); string URL; URL = "../../Download/OpenPDF.aspx?FileName=" + FileName; string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');"; ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true); }