protected void Test_Click(object sender, EventArgs e) { Invoicing_Service.Invoicing_ServiceSoapClient objClient = new Invoicing_Service.Invoicing_ServiceSoapClient(); string result = objClient.TestLastInvoiceNo(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('" + result + "')", true); }
protected void btnLogin_Click(object sender, EventArgs e) { Invoicing_Service.Invoicing_ServiceSoapClient objClient = new Invoicing_Service.Invoicing_ServiceSoapClient(); System.Data.DataTable dt = objClient.ValidateLogin(txtUserName.Value, txtPassword.Value); if (dt != null && dt.Rows.Count > 0) { Session["UserID"] = dt.Rows[0]["UserID"].ToString(); Session["UserName"] = txtUserName.Value; Session["DefaultValue"] = dt.Rows[0]["StateID"].ToString(); Session["StateName"] = dt.Rows[0]["StateName"].ToString(); } else { lblPassMessage.Attributes.Remove("d-none"); lblPassMessage.Attributes.Add("class", "d -block"); // ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Incorrect UserName or Password')", true); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserID"] == null) { Response.Redirect("Home.aspx"); } if (Page.IsPostBack) { Response.Write("Page psoted back"); } if (!IsPostBack) { if (Request.QueryString["InvoiceID"] != null) { string InvoiceID = Request.QueryString["InvoiceID"].ToString(); Invoicing_Service.Invoicing_ServiceSoapClient objService = new Invoicing_Service.Invoicing_ServiceSoapClient(); txtBindInvoiceID.Value = objService.GetInvoiceNumber(InvoiceID); // ClientScript.RegisterStartupScript(this.GetType(), "updateProgress", "Test('" + InvoiceID + "');", true); } } }
public bool LoadReport() { string invoiceID = Session["InvoiceID"].ToString(); string PartyID = Session["PartyID"].ToString(); string IGST = Session["IGST"].ToString(); //string invoiceID = "108"; //string PartyID = "12"; //string IGST = "0"; //string invoiceID = "3"; //string PartyID = "1"; //string IGST = "0"; Invoicing_Application.Invoicing_Service.Invoicing_ServiceSoapClient ObjClient = new Invoicing_Service.Invoicing_ServiceSoapClient(); try { ReportViewer1.ProcessingMode = ProcessingMode.Local; if (IGST == "1") { ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report/RDLC_Files/InvoiceReport_IGST.rdlc"); } else { ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report/RDLC_Files/InvoiceReport.rdlc"); } DataSet dsReportData = ObjClient.GetReportData(invoiceID, PartyID); DataTable dtInvoiceMaster = dsReportData.Tables[0]; DataTable dtSalesDetails = dsReportData.Tables[1]; DataTable dtInvoiceOther = dsReportData.Tables[2]; DataTable dtPartyDetails = dsReportData.Tables[3]; DataTable dtMyprofile = dsReportData.Tables[4]; DataTable dtBankDetails = dsReportData.Tables[5]; strInvoiceID = dtInvoiceMaster.Rows[0]["InvoiceNumber"].ToString(); InvoiceDate = Convert.ToDateTime(dtInvoiceMaster.Rows[0]["InvoiceDate"]); ReportParameter pCGST_Percent = new ReportParameter("pCGST_Percent", "(" + dtInvoiceMaster.Rows[0]["CGST_Percent"].ToString() + "%)"); ReportParameter pSGST_Percent = new ReportParameter("pSGST_Percent", "(" + dtInvoiceMaster.Rows[0]["SGST_Percent"].ToString() + "%)"); ReportParameter pIGST_Percent = new ReportParameter("pIGST_Percent", "(" + dtInvoiceMaster.Rows[0]["IGST_Percent"].ToString() + "%)"); ReportParameter pAddress = new ReportParameter("pAddress", "" + dtMyprofile.Rows[0]["Address"].ToString()); ReportParameter pEmail = new ReportParameter("pEmail", "Email :" + dtMyprofile.Rows[0]["EmailID"].ToString()); ReportParameter pMobile = new ReportParameter("pMobile", "Mobile: " + dtMyprofile.Rows[0]["MobileNo"].ToString()); ReportParameter pGST = new ReportParameter("pGST", "GSTIN :" + dtMyprofile.Rows[0]["GSTNO"].ToString()); ReportParameter pInvoiceNo = new ReportParameter("pInvoiceNo", dtInvoiceMaster.Rows[0]["InvoiceNumber"].ToString()); ReportParameter pInvoiceDate = new ReportParameter("pInvoiceDate", InvoiceDate.ToString("dd-MM-yyyy")); ReportParameter pOwnerState = new ReportParameter("pOwnerState", dtMyprofile.Rows[0]["StateName"].ToString()); ReportParameter parmOwnerStateCode = new ReportParameter("parmOwnerStateCode", dtInvoiceMaster.Rows[0]["GSTStateCode"].ToString()); ReportParameter pPartyState = new ReportParameter("pPartyState", dtPartyDetails.Rows[0]["StateName"].ToString()); ReportParameter parmNote = new ReportParameter("parmNote", dtMyprofile.Rows[0]["TermCondition"].ToString()); ReportParameter pReverseCharge; ReportParameter pTransportationMode; ReportParameter pVechicleNo; ReportParameter pDateofSupply; ReportParameter pPlaceofSupply; ReportParameter pConName; ReportParameter pConAddress; ReportParameter pConGST; ReportParameter pConStateCode; ReportParameter pConState; ReportParameter parmBankName = null; ReportParameter parmAccountNo = null;; ReportParameter parmIFSCCode = null;; ReportParameter ParmBranch = null;; if (dtBankDetails.Rows.Count > 0) { parmBankName = new ReportParameter("parmBankName", "Bank Name: " + dtBankDetails.Rows[0]["BankName"].ToString()); parmAccountNo = new ReportParameter("parmAccountNo", "Account No: " + dtBankDetails.Rows[0]["AccountNo"].ToString()); parmIFSCCode = new ReportParameter("parmIFSCCode", "IFSC Code: " + dtBankDetails.Rows[0]["IFSC_Code"].ToString()); ParmBranch = new ReportParameter("ParmBranch", "Branch : " + dtBankDetails.Rows[0]["Branch"].ToString()); } if (dtInvoiceOther.Rows.Count > 0) { pReverseCharge = new ReportParameter("pReverseCharge", dtInvoiceOther.Rows[0]["ReverseCharge"].ToString()); pTransportationMode = new ReportParameter("pTransportationMode", dtInvoiceOther.Rows[0]["Transportation_Mode"].ToString()); pVechicleNo = new ReportParameter("pVechicleNo", dtInvoiceOther.Rows[0]["Vehicle_Number"].ToString()); pDateofSupply = new ReportParameter("pDateofSupply", Convert.ToDateTime(dtInvoiceOther.Rows[0]["SupplyDate"]).ToString("dd-MM-yyyy")); pPlaceofSupply = new ReportParameter("pPlaceofSupply", dtInvoiceOther.Rows[0]["SupplyPlace"].ToString()); pConName = new ReportParameter("pConName", dtInvoiceOther.Rows[0]["Consignee_Name"].ToString()); pConAddress = new ReportParameter("pConAddress", dtInvoiceOther.Rows[0]["Consignee_Address"].ToString()); pConGST = new ReportParameter("pConGST", dtInvoiceOther.Rows[0]["Consignee_GST"].ToString()); pConStateCode = new ReportParameter("pConStateCode", dtInvoiceOther.Rows[0]["GSTStateCode"].ToString()); pConState = new ReportParameter("pConState", dtInvoiceOther.Rows[0]["StateName"].ToString()); } else { pReverseCharge = new ReportParameter("pReverseCharge", ""); pTransportationMode = new ReportParameter("pTransportationMode", ""); pVechicleNo = new ReportParameter("pVechicleNo", ""); pDateofSupply = new ReportParameter("pDateofSupply", ""); pPlaceofSupply = new ReportParameter("pPlaceofSupply", ""); pConName = new ReportParameter("pConName", ""); pConAddress = new ReportParameter("pConAddress", ""); pConGST = new ReportParameter("pConGST", ""); pConStateCode = new ReportParameter("pConStateCode", ""); pConState = new ReportParameter("pConStateCode", ""); } string GrandTotal = dtInvoiceMaster.Rows[0]["AmountAfterGST"].ToString(); string NetAmt = new NumberToEnglish().changeCurrencyToWords(GrandTotal) + "/-"; ReportParameter pNetAmount = new ReportParameter("pNetAmount", NetAmt); ReportParameter pPartyName = new ReportParameter("pPartyName", dtPartyDetails.Rows[0]["CustomerName"].ToString()); ReportParameter pPartyAddress = new ReportParameter("pPartyAddress", dtPartyDetails.Rows[0]["Address"].ToString()); ReportParameter pPartyGST = new ReportParameter("pPartyGST", dtPartyDetails.Rows[0]["GSTNO"].ToString()); ReportParameter pPartyStateCode = new ReportParameter("pPartyStateCode", dtPartyDetails.Rows[0]["GSTStateCode"].ToString()); strpartyName = dtPartyDetails.Rows[0]["CustomerName"].ToString(); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.SetParameters(pAddress); ReportViewer1.LocalReport.SetParameters(pEmail); ReportViewer1.LocalReport.SetParameters(pMobile); ReportViewer1.LocalReport.SetParameters(pGST); ReportViewer1.LocalReport.SetParameters(pInvoiceNo); ReportViewer1.LocalReport.SetParameters(pInvoiceDate); ReportViewer1.LocalReport.SetParameters(pOwnerState); ReportViewer1.LocalReport.SetParameters(pPartyState); ReportViewer1.LocalReport.SetParameters(pReverseCharge); ReportViewer1.LocalReport.SetParameters(pTransportationMode); ReportViewer1.LocalReport.SetParameters(pVechicleNo); ReportViewer1.LocalReport.SetParameters(pDateofSupply); ReportViewer1.LocalReport.SetParameters(pPlaceofSupply); ReportViewer1.LocalReport.SetParameters(pPartyName); ReportViewer1.LocalReport.SetParameters(pPartyAddress); ReportViewer1.LocalReport.SetParameters(pPartyGST); ReportViewer1.LocalReport.SetParameters(pPartyStateCode); ReportViewer1.LocalReport.SetParameters(pConName); ReportViewer1.LocalReport.SetParameters(pConAddress); ReportViewer1.LocalReport.SetParameters(pConGST); ReportViewer1.LocalReport.SetParameters(pConState); ReportViewer1.LocalReport.SetParameters(pConStateCode); ReportViewer1.LocalReport.SetParameters(pNetAmount); ReportViewer1.LocalReport.SetParameters(parmBankName); ReportViewer1.LocalReport.SetParameters(parmAccountNo); ReportViewer1.LocalReport.SetParameters(parmIFSCCode); ReportViewer1.LocalReport.SetParameters(ParmBranch); ReportViewer1.LocalReport.SetParameters(parmNote); ReportViewer1.LocalReport.SetParameters(pCGST_Percent); ReportViewer1.LocalReport.SetParameters(pSGST_Percent); ReportViewer1.LocalReport.SetParameters(pIGST_Percent); ReportViewer1.LocalReport.SetParameters(parmOwnerStateCode); DataTable dtGST = new DataTable(); dtGST.Columns.Add("Percent"); dtGST.Columns.Add("Amount"); DataRow dRow = dtGST.NewRow(); dRow["Percent"] = "Percent"; dRow["Amount"] = "Amount"; dtGST.Rows.Add(dRow); ReportDataSource datasource1 = new ReportDataSource("ds_SalesDetails", dtSalesDetails); ReportDataSource datasource2 = new ReportDataSource("ds_TaxCalculation", dtInvoiceMaster); ReportDataSource datasource3 = new ReportDataSource("ds_GST", dtGST); ReportViewer1.LocalReport.DataSources.Add(datasource1); ReportViewer1.LocalReport.DataSources.Add(datasource2); ReportViewer1.LocalReport.DataSources.Add(datasource3); return(true); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('" + ex.ToString() + "');", true);; Response.Write(ex.ToString()); return(false); } }