public ReceiptVoucher(DataSet DsComp, DataSet DsClient, DataSet DsVoucher, DataSet DsBank) { InitializeComponent(); string _customizedClient = String.Empty; BusinessAccessLayer.Common.clsCommon _cmn = new BusinessAccessLayer.Common.clsCommon(); _customizedClient = _cmn.GetCustomizedClient(); string _client = String.Empty; _client = _cmn.GetClient(); if (_customizedClient.ToUpper() == "HOWDEN" || _customizedClient.ToUpper() == "HOWDENSG") { textBox61.Value = "Medium Reference Number"; textBox62.Value = "Medium Reference Date"; } // textBox1.Value = DS.Tables[0].Rows[0]["ClientName"].ToString(); textBox1.Value = DsClient.Tables[0].Rows[0]["AccountDate"].ToString(); textBox3.Value = DsClient.Tables[0].Rows[0]["ClientName"].ToString(); textBox10.Value = DsClient.Tables[0].Rows[0]["VoucherNo"].ToString(); textBox11.Value = DsClient.Tables[0].Rows[0]["ClientAdd1"].ToString(); textBox12.Value = DsClient.Tables[0].Rows[0]["ClientAdd2"].ToString(); textBox30.Value = DsClient.Tables[0].Rows[0]["ClientAdd3"].ToString(); //textBox15.Visible = false if (DsClient.Tables[0].Rows[0]["ClientAdd4"].ToString() == "") { textBox16.Value = DsClient.Tables[0].Rows[0]["Country"].ToString(); textBox25.Visible = false; } else { textBox16.Value = DsClient.Tables[0].Rows[0]["ClientAdd4"].ToString(); textBox25.Value = DsClient.Tables[0].Rows[0]["Country"].ToString(); } textBox18.Value = DsClient.Tables[0].Rows[0]["ClientCode"].ToString(); textBox14.Value = DsClient.Tables[0].Rows[0]["VoucherDate"].ToString(); txtCompany41.Value = DsComp.Tables[0].Rows[0]["CompName"].ToString(); txtAddress42.Value = DsComp.Tables[0].Rows[0]["Add1"].ToString() + " " + DsComp.Tables[0].Rows[0]["Add2"].ToString() + " " + DsComp.Tables[0].Rows[0]["Add3"].ToString(); //txtAddress43.Value = DS.Tables[0].Rows[0]["Add2"].ToString(); //textBox1.Value = DS.Tables[0].Rows[0]["Add3"].ToString(); textBox6.Value = DsComp.Tables[0].Rows[0]["Add4"].ToString(); textBox5.Value = DsComp.Tables[0].Rows[0]["Add5"].ToString(); textBox7.Value = DsComp.Tables[0].Rows[0]["Add7"].ToString(); //textBox58.Value = DsComp.Tables[0].Rows[0]["Currency"].ToString(); //textBox59.Value = DsComp.Tables[0].Rows[0]["TranAmount"].ToString(); if (DsClient.Tables[0].Rows[0]["VoucherDescription"].ToString() != "") { textBox19.Value = DsClient.Tables[0].Rows[0]["VoucherDescription"].ToString(); } else { textBox19.Visible = false; } //if (DS.Tables[0].Columns.Contains("ChequeNo")) //{ // textBox33.Value = DS.Tables[0].Rows[0]["ChequeNo"].ToString(); // textBox31.Value = DS.Tables[0].Rows[0]["Amount"].ToString(); // textBox32.Value = DS.Tables[0].Rows[0]["CurrencyCode"].ToString(); // textBox34.Value = DS.Tables[0].Rows[0]["ExchangeRate"].ToString(); // textBox35.Value = DS.Tables[0].Rows[0]["Amount"].ToString(); // textBox40.Value = DS.Tables[0].Rows[0]["ChequeDate"].ToString(); // //object SumAmount; // //SumAmount = DS.Tables[0].Compute("Sum(Amount)", ""); // //textBox38.Value = SumAmount.ToString(); // textBox38.Value = DS.Tables[0].Rows[0]["Amount"].ToString(); //} //else //{ // // textBox24.Visible = false; // textBox33.Visible = false; // textBox31.Visible = false; // textBox32.Visible = false; // textBox34.Visible = false; // textBox35.Visible = false; // textBox38.Visible = false; // textBox25.Visible = false; // // textBox27.Visible = false; // textBox28.Visible = false; // textBox29.Visible = false; // textBox30.Visible = false; // textBox38.Visible = false; // textBox36.Visible = false; // textBox37.Visible = false; // textBox39.Visible = false; // textBox4.Visible = false; // textBox40.Visible = false; //} if (_client.ToUpper() == "STARACCLAIM") { table3.Visible = false; table2.Visible = true; if (DsVoucher.Tables[0].Rows.Count > 0) { table2.DataSource = DsVoucher.Tables[0]; } else { table2.Visible = false; } } else { table2.Visible = false; table3.Visible = true; if (DsVoucher.Tables[0].Rows.Count > 0) { table3.DataSource = DsVoucher.Tables[0]; } else { table3.Visible = false; } } if (_client.ToUpper() == "STARACCLAIM") { table4.Visible = true; table1.Visible = false; if (DsBank.Tables[0].Rows.Count > 0) { table4.DataSource = DsBank.Tables[0];; } else { table4.Visible = false; } } else { table1.Visible = true; table4.Visible = false; if (DsBank.Tables[0].Rows.Count > 0) { table1.DataSource = DsBank.Tables[0];; } else { table1.Visible = false; } } }
public BatchPrintCreditNote(string Param1, string Param2) { InitializeComponent(); DsCompDtl = GetCompanyDetails(); string _client = String.Empty; BusinessAccessLayer.Common.clsCommon _cmn = new BusinessAccessLayer.Common.clsCommon(); _client = _cmn.GetClient(); if (DsCompDtl.Tables[0].Rows.Count > 0) { textBox4.Value = DsCompDtl.Tables[0].Rows[0]["CompName"].ToString(); textBox9.Value = DsCompDtl.Tables[0].Rows[0]["Add1"].ToString() + " " + DsCompDtl.Tables[0].Rows[0]["Add2"].ToString() + " " + DsCompDtl.Tables[0].Rows[0]["Add3"].ToString(); textBox12.Value = DsCompDtl.Tables[0].Rows[0]["Add4"].ToString(); textBox15.Value = DsCompDtl.Tables[0].Rows[0]["Add5"].ToString(); textBox18.Value = DsCompDtl.Tables[0].Rows[0]["Add7"].ToString(); textBox19.Value = "Please make cheque payable to " + DsCompDtl.Tables[0].Rows[0]["CompName"].ToString(); } DsreportDetails = GetBatchPrintForDebitNote(Param1, Param2); if (_client.ToUpper() == "STARACCLAIM") { textBox5.Value = "CREDIT NOTE"; } if (DsreportDetails.Tables[0].Rows.Count > 0) { textBox29.Value = DsreportDetails.Tables[0].Rows[0]["CusM_Name"].ToString(); if (string.IsNullOrEmpty(textBox29.Value)) { textBox29.Visible = false; } textBox26.Value = DsreportDetails.Tables[0].Rows[0]["CusM_Address1"].ToString(); if (string.IsNullOrEmpty(textBox26.Value)) { textBox26.Visible = false; } textBox24.Value = DsreportDetails.Tables[0].Rows[0]["CusM_Address2"].ToString(); if (string.IsNullOrEmpty(textBox24.Value)) { textBox24.Visible = false; } textBox21.Value = DsreportDetails.Tables[0].Rows[0]["CusM_Address3"].ToString(); if (string.IsNullOrEmpty(textBox21.Value)) { textBox21.Visible = false; } textBox25.Value = DsreportDetails.Tables[0].Rows[0]["CusM_Address4"].ToString(); if (string.IsNullOrEmpty(textBox25.Value)) { textBox25.Visible = false; } textBox27.Value = DsreportDetails.Tables[0].Rows[0]["DrCrNo"].ToString(); textBox22.Value = DsreportDetails.Tables[0].Rows[0]["DrCrDate"].ToString(); textBox6.Value = DsreportDetails.Tables[0].Rows[0]["CusM_ID"].ToString(); if (_client.ToUpper() == "STARACCLAIM") { table2.Visible = true; table3.Visible = false; textBox34.Value = DsreportDetails.Tables[0].Rows[0]["DrCrDescription"].ToString(); textBox35.Value = ConvertIntoNumeric(Convert.ToDecimal(DsreportDetails.Tables[0].Rows[0]["Amount"].ToString())); textBox31.Value = ConvertIntoNumeric(Convert.ToDecimal(DsreportDetails.Tables[0].Rows[0]["LocalAmount"].ToString())); textBox47.Value = ConvertIntoNumeric(Convert.ToDecimal(DsreportDetails.Tables[0].Rows[0]["GST"].ToString()));; } else { table3.Visible = true; table2.Visible = false; textBox40.Value = DsreportDetails.Tables[0].Rows[0]["DrCrDescription"].ToString(); textBox37.Value = ConvertIntoNumeric(Convert.ToDecimal(DsreportDetails.Tables[0].Rows[0]["LocalAmount"].ToString())); textBox30.Value = ConvertIntoNumeric(Convert.ToDecimal(DsreportDetails.Tables[0].Rows[0]["LocalAmount"].ToString()));; } } }