private void LoadGrid(string DCNumber, string PONumber, string DealerCode) { DataTable dtParts = new DataTable(); DataTable dt = new DataTable(); DataSet dsParts = new DataSet(); SqlDataReader dr = null; string mPONo = ""; string mDCNo = ""; if (PONumber == "") { mPONo = Session["PONumber"].ToString(); } else { mPONo = PONumber; } if (DCNumber == "") { mDCNo = Session["DCNumber"].ToString(); } else { mDCNo = DCNumber; } try { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 10), new SqlParameter("@PONO", SqlDbType.Char, 10) }; param[0].Value = this.Session["DealerCode"].ToString(); param[1].Value = mPONo; myFunc.ExecuteSP("Sp_2W_GetPO_ForDC", param, ref dr); dtParts.Load(dr); //ds = (DataSet)ViewState["ObjPOds"]; dt = (DataTable)this.Session["DCTable"]; dt.Rows.Clear(); if (dtParts.Rows.Count != 0) { foreach (DataRow dRow in dtParts.Rows) { SqlParameter[] paramPO_Parts = { new SqlParameter("@PONO", SqlDbType.Char, 10), new SqlParameter("@DealerCode", SqlDbType.Char, 10), new SqlParameter("@ItemCode", SqlDbType.Char, 10) }; paramPO_Parts[0].Value = mPONo; paramPO_Parts[1].Value = this.Session["DealerCode"].ToString(); paramPO_Parts[2].Value = dRow["ItemCode"].ToString(); dsParts = myFunc.FillDataSet("SP_Spare_Get_PartPOInfo_New", paramPO_Parts); DataRow row = dt.NewRow(); row["Sno"] = dt.Rows.Count + 1; row["PartItemNo"] = dsParts.Tables[0].Rows[0]["PartItemNo"].ToString(); row["PartItemName"] = dsParts.Tables[0].Rows[0]["ItemDesc"].ToString(); row["unit"] = dsParts.Tables[0].Rows[0]["Unit"].ToString(); row["POQuantity"] = dsParts.Tables[0].Rows[0]["POQty"].ToString(); row["BalanceQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString(); row["DCQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString(); //row["Selected"] = true; dt.Rows.Add(row); } } Session["DCTable"] = dt; gv_DC.DataSource = dt; gv_DC.DataSourceID = null; gv_DC.DataBind(); } catch (Exception ex) { //ObjGeneral.UserMsg(LbErr, Color.Red, "Error: " + ex.Message, txtDCNo); } }
protected void Page_Load(object sender, EventArgs e) { if (this.Session["UserName"] == null) { Response.Redirect("~/Main/login.aspx"); } rpt = new ReportDocument(); String StrReportID, Type; Type = Request.QueryString["Type"]; StrReportID = Request.QueryString["ReportID"]; if (StrReportID == "PaymentReceiptReport") { rpt.Load(Server.MapPath("rptPaymentReceiptPrint.rpt")); strCriteria = "{PaymentReceiptMaster.ReceiptNo}='" + Request.QueryString["ReceiptNo"] + "' " + "AND {PaymentReceiptMaster.DealerCode}='" + Session["DealerCode"].ToString() + "' " + "AND {PaymentReceiptMaster.DelFlag} = 'N' "; //rpt.RecordSelectionFormula = strCriteria; rpt.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'"; rpt.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; rpt.DataDefinition.FormulaFields["ReportTitle"].Text = "'Payment Receipt'"; rpt.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'"; rpt.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'"; rpt.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'"; rpt.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'"; //rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + grl.GetStringValuesAgainstCodes("CusCode", SessionInformation.LoginID, "CellNo", "Customer") + "'"; // CrystalReportViewer1.ReportSource = rpt; } if (StrReportID == "CustomerEstimate") { //ReportDocument RD; //string strCriteria, rptTitle; //DateTime FromDate, ToDate; //SqlDataReader rder; //CustEstimateCode SysFunctions myFunc = new SysFunctions(); Data.DSReports DsRpt = new Data.DSReports(); //DataSet1 dsRpt1 = new DataSet1(); SqlDataReader rder = null; rpt = new ReportDocument(); string CCon = CConnection.GetConnectionString(); DataSet ds = new DataSet(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@CustomerEstimateCode", SqlDbType.Char), //1 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = Request.QueryString["CustEstimateCode"].ToString(); DsRpt.EnforceConstraints = false; ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_CustomerEstimateMaster_Print '" + this.Session["DealerCode"].ToString() + "','" + Request.QueryString["CustEstimateCode"].ToString() + "'"); DsRpt.sp_CustomerEstimateMaster_Print.Load(ds.CreateDataReader()); DsRpt.EnforceConstraints = false; ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_CustomerEstimateDetail_Print '" + this.Session["DealerCode"].ToString() + "','" + Request.QueryString["CustEstimateCode"].ToString() + "'"); DsRpt.sp_CustomerEstimateDetail_Print.Load(ds.CreateDataReader()); DsRpt.EnforceConstraints = false; ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_CustomerEstimateDetailSup_Print '" + this.Session["DealerCode"].ToString() + "','" + Request.QueryString["CustEstimateCode"].ToString() + "'"); DsRpt.sp_CustomerEstimateDetailSup_Print.Load(ds.CreateDataReader()); DsRpt.EnforceConstraints = false; ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_CustomerEstimateLubricates_Print '" + this.Session["DealerCode"].ToString() + "','" + Request.QueryString["CustEstimateCode"].ToString() + "'"); DsRpt.sp_CustomerEstimateLubricates_Print.Load(ds.CreateDataReader()); DsRpt.EnforceConstraints = false; ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_CustomerEstimateLubricatesSup_Print '" + this.Session["DealerCode"].ToString() + "','" + Request.QueryString["CustEstimateCode"].ToString() + "'"); DsRpt.sp_CustomerEstimateLubricatesSup_Print.Load(ds.CreateDataReader()); DsRpt.EnforceConstraints = false; ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_CustomerEstimateParts_Print '" + this.Session["DealerCode"].ToString() + "','" + Request.QueryString["CustEstimateCode"].ToString() + "'"); DsRpt.sp_CustomerEstimateParts_Print.Load(ds.CreateDataReader()); DsRpt.EnforceConstraints = false; ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_CustomerEstimatePartsSup_Print '" + this.Session["DealerCode"].ToString() + "','" + Request.QueryString["CustEstimateCode"].ToString() + "'"); DsRpt.sp_CustomerEstimatePartsSup_Print.Load(ds.CreateDataReader()); DsRpt.EnforceConstraints = false; myFunc.ExecuteSP("sp_CustomerEstimateBoutParts_Print", param, ref rder); DsRpt.sp_CustomerEstimateBoutParts_Print.Load(rder); DsRpt.EnforceConstraints = false; myFunc.ExecuteSP("sp_EstimateSubletDetail_Print", param, ref rder); DsRpt.sp_JobCardSubletDetail_Print.Load(rder); rpt.Load(Server.MapPath("~/Modules/Service/ServiceReports/rptCustomerEstimatePrint.rpt")); rpt.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; rpt.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; rpt.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; rpt.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; if (Type == "Insurance") { rpt.DataDefinition.FormulaFields["ReportTitle"].Text = "'Insurance Estimate'"; } else { rpt.DataDefinition.FormulaFields["ReportTitle"].Text = "'Customer Estimate'"; } rpt.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; rpt.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'"; rpt.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'"; rpt.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '"; //rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'"; rpt.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; rpt.Database.Tables[0].SetDataSource(DsRpt); //CrystalReportViewer1.ReportSource = rpt; // rpt.SetDataSource(DsRpt.sp_CustomerEstimateMaster_Print.DataSet); Session["RDService"] = rpt; } else { rpt = (ReportDocument)Session["RD"]; } //var connectionInfo = new ConnectionInfo(); //connectionInfo.ServerName = "localhost"; //connectionInfo.DatabaseName = "BMS"; //connectionInfo.Password = "******"; //connectionInfo.UserID = "sa"; //connectionInfo.Type = ConnectionInfoType.SQL; //connectionInfo.IntegratedSecurity = false; //for (int i = 0; i < CrystalReportViewer1.LogOnInfo.Count; i++) //{ // CrystalReportViewer1.LogOnInfo[i].ConnectionInfo = connectionInfo; //} //if (Environment.MachineName == "AZHARDELL") //{ // rpt.SetDatabaseLogon("sa", "100372", "localhost", "BMS"); //} //else //{ // rpt.SetDatabaseLogon("sa", "tiger", "akramali-pc", "BMS"); //} string FilePath = Server.MapPath("~") + "\\Download\\"; string FileName = "Report.pdf"; string File = FilePath + FileName; PdfDocument outputDocument = new PdfDocument(); Stream stream = rpt.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(); rpt.Dispose(); rpt.Close(); Session["RDService"] = rpt; string embed = "<object data=\"{0}\" type=\"application/pdf\" width=\"1000px\" height=\"800px\">"; embed += "If you are unable to view file, you can download from <a href = \"{0}\">here</a>"; embed += " or download <a target = \"_blank\" href = \"http://get.adobe.com/reader/\">Adobe PDF Reader</a> to view the file."; embed += "</object>"; ltEmbed.Text = string.Format(embed, ResolveUrl("~/Download/Report.pdf")); //CrystalReportViewer1.ReportSource = rpt; //CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None; }
private void AddNewRow() { SqlDataReader dr = null; //DataSet ds = new DataSet(); DataTable dt = new DataTable(); //DropDownList ddlParts = (DropDownList)GvMain.FooterRow.FindControl("ddlParts"); //TextBox txtFooterQty = (TextBox)GvMain.FooterRow.FindControl("txtFooterQty"); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), new SqlParameter("@SIRNo", SqlDbType.Char, 8), }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddlSirNo.SelectedValue.ToString(); SysFunc.ExecuteSP("Sp_SirDetail_Items_Select", param, ref dr); if (dr.HasRows) { dt.Load(dr); GvMain.DataSource = dt; GvMain.DataBind(); } else { createPartsDT(); } //ds = (DataSet)Session["dsParts"]; //DataRow row = ds.Tables[0].NewRow(); //foreach (DataRow drTable in dt.Rows) //{ // ////Get OH stock // //DataSet dsOHStock = new DataSet(); // //dsOHStock = SysFunc.PartStock(drTable["ItemCode"].ToString(), Session["DealerCode"].ToString()); // //decimal DTotalStock = Convert.ToDecimal(dsOHStock.Tables[0].Rows[0]["Balance"]); // /////////////////////////////////////////////////////// // //Get Avg Cost // DataSet dsAvgCost = new DataSet(); // decimal DAvgCost = 0; // dsAvgCost = SysFunc.ItemAvgCost(drTable["ItemCode"].ToString(), Session["DealerCode"].ToString()); // if (dsAvgCost.Tables[0].Rows.Count != 0) // { // DAvgCost = Convert.ToDecimal(dsAvgCost.Tables[0].Rows[0]["Cost"]); // } // ////////////////////////////////////////////////////// // row["ItemCode"] = drTable["ItemCode"].ToString(); // row["PartItemNo"] = drTable["PartItemNo"].ToString(); // row["ItemDesc"] = drTable["ItemDesc"].ToString(); // row["Location"] = drTable["Location"].ToString(); // row["Quantity"] = drTable["Quantity"].ToString(); // row["BalQty"] = drTable["BalQty"].ToString(); // //row["OHStock"] = "0"; // row["OLStock"] = "0"; // row["AvgCost"] = DAvgCost.ToString(); // row["Amount"] = "0"; // ds.Tables[0].Rows.Add(row); //} //GvMain.DataSource = dt; //GvMain.DataBind(); //Session["dsParts"] = ds; ////////////////////// }
protected void Page_Load(object sender, EventArgs e) { if (this.Session["UserName"] == null) { Response.Redirect("~/Main/login.aspx"); } RD = new ReportDocument(); ReportID = Request.QueryString["ReportID"]; if (ReportID == "GSTInvoiceCounterSale") { SqlParameter[] param = { new SqlParameter("@SaleInvNo", SqlDbType.Char, 10), new SqlParameter("@dealerCode", SqlDbType.Char, 10) }; param[0].Value = Request.QueryString["CounterNo"]; param[1].Value = Session["DealerCode"].ToString(); dsRpt = myFunc.SP_Spare_Get_rptGSTInvoiceCounterSale(param); RD.Load(Server.MapPath("~/Modules/Reports/SpareReports/rptGSTInvoiceCounterSale.rpt")); } if (ReportID == "PartStock") { string ReportIDStock = ""; ReportIDStock = Request.QueryString["abc"]; //ReportDocument RD = new ReportDocument(); DataSet dsRpt = new DataSet(); //DataSet objDsReports = new DataSet(); DataSetPartStockReport objDSReports = new DataSetPartStockReport(); //DSReports objDsReports = new DSReports(); //DSReports objDsReports = new DSReports(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@Param", SqlDbType.VarChar, 20), //0 }; param[0].Value = this.Session["DealerCode"].ToString(); //param[1].Value = ReportIDStock; param[1].Value = "--Select--"; //ds = myFunc.ExecuteSP_NonQuery("sp_PartsStockSourceWiseNew", param); if (myFunc.ExecuteSP("sp_PartsStockSourceWiseNew", param, ref rder)) { objDSReports.sp_PartsStockSourceWiseNew.Load(rder); } // if (myFunc.ExecuteSP_NonQuery("sp_PartsStockSourceWiseNew", param)) // { // //objDsReports.sp_PartsStockSourceWiseNew.Load(rder); // objDSReports.sp_PartsStockSourceWiseNew.Load(rder); // //rder.Close(); // objDSReports = myFunc.FillDataSet("sp_PartsStockSourceWiseNew", param); // objDsReports = myFunc.FillDataSet("sp_PartsStockSourceWiseNew", param); // sql = "exec sp_PartsStockSourceWiseNew '00001','--Select--'"; // dt = myFunc.GetData(sql); // int tr = dt.Rows.Count; ////W:\Work\imran suhail\BMS\DXBMS\DXBMS\Modules\Reports\SpareReports\rptPartsStockStatusNew.rpt ////W:\Work\imran suhail\BMS\DXBMS\DXBMS\Modules\Criteria\POView.aspx // } RD.PrintOptions.PaperSize = PaperSize.PaperA4; RD.Load(Server.MapPath("~/Modules/Reports/SpareReports/rptPartsStockStatusNew.rpt")); RD.DataDefinition.FormulaFields["UserID"].Text = "'" + this.Session["UserName"].ToString() + "'"; //RD.DataDefinition.FormulaFields["FromDate"].Text = "'" + Request.QueryString["FrmDate"].ToString() + "'"; //RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + Request.QueryString["ToDate"].ToString() + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "C.I Standard Report" + "\""; RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].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.Database.Tables[0].SetDataSource(objDSReports); //RD.Database.Tables[0].SetDataSource(dt); //CrystalReportViewer1.ReportSource = RD; //RD.Database.Tables[0].SetDataSource(objDsReports); } CrystalReportViewer1.ReportSource = RD; //CrystalReportViewer1.ShowFirstPage(); var connectionInfo = new ConnectionInfo(); connectionInfo.ServerName = "AZHARDELL"; connectionInfo.DatabaseName = "BMS"; connectionInfo.Password = "******"; connectionInfo.UserID = "sa"; connectionInfo.Type = ConnectionInfoType.SQL; connectionInfo.IntegratedSecurity = false; for (int i = 0; i < CrystalReportViewer1.LogOnInfo.Count; i++) { CrystalReportViewer1.LogOnInfo[i].ConnectionInfo = connectionInfo; } Session["RDSpare"] = RD; //crReportDocument = new ReportDocument(); //crReportDocument = (ReportDocument)Session["RDSpare"]; //CrystalReportViewer1.ReportSource = crReportDocument; }
/// <summary> /// Will work after load JobCard or Invoice Data ddl /// </summary> private void DisplayItem() { string SIRNo = string.Empty; DataSet dsAvg = new DataSet(); try { SqlDataReader dr = null; txtItemCode.Text = ddlParts.SelectedValue.ToString().Trim(); if (rdCounterSale.Checked) { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), new SqlParameter("@IssueNo", SqlDbType.Char, 8), new SqlParameter("@ItemCode", SqlDbType.Char, 8), new SqlParameter("@SaleInvNo", SqlDbType.Char, 8) }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = txtIssueNo.Text.Trim(); param[2].Value = txtItemCode.Text.Trim(); param[3].Value = ddlSaleInvNo.SelectedValue.ToString(); SysFunc.ExecuteSP("sp_Part_Info_SalesReturn_CS", param, ref dr); if (dr.HasRows) { dr.Read(); txtLocCode.Text = dr["PartsTransLocCode"].ToString(); txtLocDesc.Text = dr["PartsTransLocDesc"].ToString(); txtRate.Text = dr["Rate"].ToString(); txtInvQuantity.Text = dr["IssueQty"].ToString(); txtUnitCode.Text = dr["UnitCode"].ToString(); txtUnit.Text = dr["UnitDesc"].ToString(); txtAvgCost.Text = dr["AvgCost"].ToString(); txtRemainingQty.Text = dr["Remaining_Qty"].ToString(); } } else if (rdJobCard.Checked) { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), new SqlParameter("@IssueNo", SqlDbType.Char, 8), new SqlParameter("@ItemCode", SqlDbType.Char, 8), new SqlParameter("@JobCardCode", SqlDbType.Char, 8) }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = txtIssueNo.Text.Trim(); param[2].Value = txtItemCode.Text.Trim(); param[3].Value = ddlSaleInvNo.SelectedValue.ToString(); SysFunc.ExecuteSP("sp_Part_Info_SalesReturn_JC", param, ref dr); if (dr.HasRows) { dr.Read(); txtLocCode.Text = dr["PartsTransLocCode"].ToString(); txtLocDesc.Text = dr["PartsTransLocDesc"].ToString(); txtRate.Text = dr["Price"].ToString(); txtInvQuantity.Text = dr["IssueQty"].ToString(); txtUnitCode.Text = dr["UnitCode"].ToString(); txtUnit.Text = dr["UnitDesc"].ToString(); txtAvgCost.Text = dr["AvgCost"].ToString(); txtRemainingQty.Text = dr["Remaining_Qty"].ToString(); } } } catch (Exception ex) { LbErr.Text = ex.Message; } }
protected void PrintReport(string sp_Name, string ReportTitle, string ReportName) { RD = new ReportDocument(); ReportID = "PartStock"; string ReportIDStock = ""; //ReportIDStock = Request.QueryString["abc"]; ReportIDStock = radioItemType.SelectedItem.Value.ToString(); DataSet dsRpt = new DataSet(); DataSetPartStockReport objDSReports = new DataSetPartStockReport(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@Param", SqlDbType.VarChar, 20), //0 new SqlParameter("@FromPartItemNo", SqlDbType.VarChar, 20), new SqlParameter("@ToPartItemNo", SqlDbType.VarChar, 20) }; param[0].Value = this.Session["DealerCode"].ToString(); //param[1].Value = ReportIDStock; param[1].Value = ReportIDStock; if (!chkAllItem.Checked) { //param[2].Value = ddlFromCode.SelectedValue; //param[3].Value = ddlToCode.SelectedValue; param[2].Value = txtFromItemcode.Text; param[3].Value = txtToItemcode.Text; } else { param[2].Value = ""; param[3].Value = "Z"; } //ds = myFunc.ExecuteSP_NonQuery("sp_PartsStockSourceWiseNew", param); if (myFunc.ExecuteSP(sp_Name, param, ref rder)) { objDSReports.sp_PartsStockSourceWiseNew.Load(rder); } else { lblErr.Text = "No record found!"; return; } rder.Close(); RD.PrintOptions.PaperSize = PaperSize.PaperA4; RD.Load(Server.MapPath("../" + ReportName + ".rpt")); RD.DataDefinition.FormulaFields["UserID"].Text = "'" + this.Session["UserName"].ToString() + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + GlobalVar.mUserIPAddress + "'"; RD.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'"; RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; //RD.DataDefinition.FormulaFields["FromDate"].Text = "'" + Request.QueryString["FrmDate"].ToString() + "'"; //RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + Request.QueryString["ToDate"].ToString() + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + ReportTitle + "\""; RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; 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["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'"; RD.Database.Tables[0].SetDataSource(objDSReports); Session["RD"] = RD; //RD.Database.Tables[0].SetDataSource(objDsReports); 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); //crReportDocument = new ReportDocument(); //crReportDocument = (ReportDocument)Session["RDSpare"]; //string FilePath = Server.MapPath("~") + "\\Download\\"; //string FileName = Request.QueryString["ReportID"] + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf"; //string File = FilePath + FileName; ////crReportDocument.SetDatabaseLogon("SDMS", "sdms161", "192.168.1.47", "SDMS"); ////crReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, File); //string URL; //URL = "../../../../Download/rptViewerService.aspx?FileName=" + FileName; ////URL = FilePath + "OpenPdf.aspx?FileName=" + FileName; ////txtPartItemDesc.Text = URL; //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 PrintReport(string sp_Name, string ReportTitle, string ReportName) { RD = new ReportDocument(); ReportID = "PartStock"; string ReportIDStock = ""; //ReportIDStock = Request.QueryString["abc"]; ReportIDStock = radioItemType.SelectedItem.Value.ToString(); DataSet dsRpt = new DataSet(); DataSetPartStockReport objDSReports = new DataSetPartStockReport(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@Param", SqlDbType.VarChar, 20), //0 new SqlParameter("@@FromPartItemNo", SqlDbType.VarChar, 20), new SqlParameter("@@ToPartItemNo", SqlDbType.VarChar, 20) }; param[0].Value = this.Session["DealerCode"].ToString(); //param[1].Value = ReportIDStock; param[1].Value = ReportIDStock; if (!chkAllItem.Checked) { param[2].Value = glFromItemPartNo.Text; param[3].Value = glToItemPartNo.Text; } else { param[2].Value = ""; param[3].Value = "Z"; } //ds = myFunc.ExecuteSP_NonQuery("sp_PartsStockSourceWiseNew", param); if (myFunc.ExecuteSP(sp_Name, param, ref rder)) { objDSReports.sp_PartsStockSourceWiseNew.Load(rder); } else { lblErr.Text = "No record found!"; return; } RD.PrintOptions.PaperSize = PaperSize.PaperA4; //RD.Load(Server.MapPath("~/Modules/Reports/SpareReports/rptPartsStockStatusNew.rpt")); //txtPartItemDesc.Text = Server.MapPath("~/Modules/Reports/SpareReports/rptPartsStockStatusNew.rpt"); //return; RD.Load(Server.MapPath("../" + ReportName + ".rpt")); RD.DataDefinition.FormulaFields["UserID"].Text = "'" + this.Session["UserName"].ToString() + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + GlobalVar.mUserIPAddress + "'"; RD.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'"; RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; //RD.DataDefinition.FormulaFields["FromDate"].Text = "'" + Request.QueryString["FrmDate"].ToString() + "'"; //RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + Request.QueryString["ToDate"].ToString() + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + ReportTitle + "\""; RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; 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["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'"; RD.Database.Tables[0].SetDataSource(objDSReports); //RD.Database.Tables[0].SetDataSource(dt); //CrystalReportViewer1.ReportSource = RD; //CrystalReportViewer1.ReportSource = RD; ////CrystalReportViewer1.ShowFirstPage(); //var connectionInfo = new ConnectionInfo(); //connectionInfo.ServerName = "AZHARDELL"; //connectionInfo.DatabaseName = "BMS"; //connectionInfo.Password = "******"; //connectionInfo.UserID = "sa"; //connectionInfo.Type = ConnectionInfoType.SQL; //connectionInfo.IntegratedSecurity = false; //for (int i = 0; i < CrystalReportViewer1.LogOnInfo.Count; i++) //{ // CrystalReportViewer1.LogOnInfo[i].ConnectionInfo = connectionInfo; //} Session["RDSpare"] = RD; //RD.Database.Tables[0].SetDataSource(objDsReports); crReportDocument = new ReportDocument(); crReportDocument = (ReportDocument)Session["RDSpare"]; string FilePath = Server.MapPath("~") + "\\Download\\"; string FileName = Request.QueryString["ReportID"] + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf"; string File = FilePath + FileName; //crReportDocument.SetDatabaseLogon("SDMS", "sdms161", "192.168.1.47", "SDMS"); crReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, File); string URL; URL = "../../../../Download/OpenPdf.aspx?FileName=" + FileName; //URL = FilePath + "OpenPdf.aspx?FileName=" + FileName; //txtPartItemDesc.Text = URL; 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); }
private void LoadGrid(string DCNumber, string PONumber, string DealerCode) { DataTable dtParts = new DataTable(); DataSet ds = new DataSet(); DataSet dsParts = new DataSet(); SqlDataReader dr = null; string mPONo = ""; string mDCNo = ""; if (PONumber == "") { mPONo = this.Session["PONumber"].ToString(); } else { mPONo = PONumber; } //if (DCNumber == "") //{ // mDCNo = this.Session["DCNumber"].ToString(); //} //else //{ // mDCNo = DCNumber; //} try { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 10), new SqlParameter("@PONO", SqlDbType.Char, 10) }; param[0].Value = this.Session["DealerCode"].ToString(); param[1].Value = mPONo; myFunc.ExecuteSP("Sp_2W_GetPO_ForDC", param, ref dr); dtParts.Load(dr); //ds = (DataSet)ViewState["ObjPOds"]; ds = (DataSet)this.Session["DCDataSet"]; ds.Tables["DCItems"].Rows.Clear(); if (dtParts.Rows.Count != 0) { foreach (DataRow dRow in dtParts.Rows) { SqlParameter[] paramPO_Parts = { new SqlParameter("@PONO", SqlDbType.Char, 10), new SqlParameter("@DealerCode", SqlDbType.Char, 10), new SqlParameter("@ItemCode", SqlDbType.Char, 10) }; paramPO_Parts[0].Value = mPONo; paramPO_Parts[1].Value = this.Session["DealerCode"].ToString(); paramPO_Parts[2].Value = dRow["ItemCode"].ToString(); dsParts = myFunc.FillDataSet("SP_Spare_Get_PartPOInfo", paramPO_Parts); DataRow row = ds.Tables["DCItems"].NewRow(); row["Sno"] = ds.Tables["DCItems"].Rows.Count + 1; row["PartItemNo"] = myFunc.GetStringValuesAgainstCodes("ItemCode", paramPO_Parts[2].Value.ToString(), "PartItemNo", "Item"); row["PartItemName"] = myFunc.GetStringValuesAgainstCodes("ItemCode", paramPO_Parts[2].Value.ToString(), "ItemDesc", "Item"); row["unit"] = myFunc.GetStringValuesAgainstCodes("UnitCode='" + dRow["UnitCode"].ToString() + "'", "unit", "UnitDesc"); row["POQuantity"] = dsParts.Tables[0].Rows[0]["POQty"].ToString(); row["BalanceQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString(); if (DCNumber == "") { row["DCQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString(); } else { row["DCQuantity"] = myFunc.GetDCQty(DCNumber, dRow["ItemCode"].ToString()); } row["Selected"] = true; ds.Tables["DCItems"].Rows.Add(row); } //if (GridViewDC.VisibleRowCount > 0) //{ // CheckBox chkSelect; // TextBox txtDCQty; // Label lblBalQty; // foreach (GridViewRow gvr in GridViewDC.Rows) // { // chkSelect = (CheckBox)gvr.Cells[0].FindControl("ChkSelect"); // txtDCQty = (TextBox)gvr.Cells[6].FindControl("txtDCQuantity"); // lblBalQty = (Label)gvr.Cells[5].FindControl("LbBalanceQuantity"); // chkSelect.Checked = true; // txtDCQty.Text = lblBalQty.Text; // //chkSelect.Enabled = false; // } //} //txtVendorNo.Text = dsVendorInfo.Tables[0].Rows[0]["vendorCode"].ToString(); //txtVendorDesc.Text = dsVendorInfo.Tables[0].Rows[0]["vendorDesc"].ToString(); } Session["DCDataSet"] = ds; GridViewDC.DataSource = ds.Tables["DCItems"]; GridViewDC.DataSourceID = null; GridViewDC.DataBind(); } catch (Exception ex) { //ObjGeneral.UserMsg(LbErr, Color.Red, "Error: " + ex.Message, txtDCNo); } }