public FinancialReport(DataSet Ds, string Month, int YYYY, string filepath, string logfilepath)
{
InitializeComponent();
ReportUtility objrep = new ReportUtility();
textBox13.Visible = true;
textBox9.Visible = true;
textBox9.Value = "RUN DATE :" + DateTime.Now.ToString("MM/dd/yyyy");
objrep.LogFile(textBox9.Value, "textBox9.Value +" + textBox9.Value + "", "FinancialReport", "", logfilepath);
textBox13.Value = "For Financial Month :" + Month + ' ' + YYYY;
objrep.LogFile(textBox13.Value, "textBox13.Value + " + textBox13.Value + " ", "FinancialReport", "", logfilepath);
if (Ds.Tables[0].Rows.Count > 0)
{
// Image image1 = Image.FromFile(filepath);
// this.pictureBox1.Value = image1;
Ds.Tables[0].Rows[0].Delete();
textBox2.Value = Ds.Tables[1].Rows[0]["CompanyName"].ToString();
textBox4.Value = Ds.Tables[1].Rows[0]["CompanyAdd1"].ToString();
textBox6.Value = Ds.Tables[1].Rows[0]["CompanyAdd2"].ToString();
textBox8.Value = Ds.Tables[1].Rows[0]["CompanyAdd3"].ToString();
textBox10.Value = Ds.Tables[1].Rows[0]["CompanyAdd4"].ToString();
textBox1.Value = Ds.Tables[1].Rows[0]["Email"].ToString();
textBox3.Value = Ds.Tables[1].Rows[0]["RegNo"].ToString();
textBox5.Value = Ds.Tables[1].Rows[0]["GSTCode"].ToString();
table2.DataSource = Ds;
}
}
public BalanceSheet(DataSet Ds, string Month, int YYYY, string filepath, DataSet DsComp, string logfilepath)
{
InitializeComponent();
ReportUtility objrep = new ReportUtility();
textBox13.Visible = true;
textBox9.Visible = true;
textBox9.Value = "RUN DATE :" + DateTime.Now.ToString("dd/MM/yyyy");
objrep.LogFile(textBox9.Value, "textBox9.Value +" + textBox9.Value + "", "BalanceSheet", "", logfilepath);
textBox13.Value = "For Financial Month :" + Month + ' ' + YYYY;
objrep.LogFile(textBox13.Value, "textBox13.Value +" + textBox13.Value + "", "BalanceSheet", "", logfilepath);
//if (string.IsNullOrEmpty(filepath))
//{
// pictureBox1.Visible = false;
//}
//else
//{
// Image image1 = Image.FromFile(filepath);
// this.pictureBox1.Value = image1;
//}
if (Ds.Tables[0].Rows.Count > 0)
{
Ds.Tables[0].Rows[0].Delete();
table2.DataSource = Ds;
}
if (Ds.Tables[1].Rows.Count > 0)
{
//textBox2.Value = Ds.Tables[1].Rows[0]["CompanyName"].ToString();
//textBox4.Value = Ds.Tables[1].Rows[0]["CompanyAdd1"].ToString();
//textBox6.Value = Ds.Tables[1].Rows[0]["CompanyAdd2"].ToString();
//textBox8.Value = Ds.Tables[1].Rows[0]["CompanyAdd3"].ToString();
//textBox10.Value = Ds.Tables[1].Rows[0]["CompanyAdd4"].ToString();
//textBox1.Value = Ds.Tables[1].Rows[0]["Email"].ToString();
//textBox3.Value = Ds.Tables[1].Rows[0]["RegNo"].ToString();
//textBox5.Value = Ds.Tables[1].Rows[0]["GSTCode"].ToString();
textBox2.Value = Ds.Tables[1].Rows[0]["CompanyName"].ToString();
textBox4.Value = Convert.ToString(Ds.Tables[1].Rows[0]["CompanyAdd1"]) + " " + Convert.ToString(Ds.Tables[1].Rows[0]["CompanyAdd2"]) + " " + Convert.ToString(Ds.Tables[1].Rows[0]["CompanyAdd3"]) + " " + Convert.ToString(Ds.Tables[1].Rows[0]["CompanyAdd4"]);
textBox6.Value = Ds.Tables[1].Rows[0]["RegNo"].ToString();
if (!string.IsNullOrEmpty(Convert.ToString(Ds.Tables[1].Rows[0]["GSTCode"])))
{
textBox8.Value = Convert.ToString(Ds.Tables[1].Rows[0]["GSTCode"]);
}
}
}
//START - Method for Generate Batch Printing(Vouchers) Report :---------------------
public VoucherLawton(DataRow header, DataTable dt, string ReportType)
{
InitializeComponent();
txtCompanyName.Value = Convert.ToString(header["CompanyName"]);
txtAddress.Value = Convert.ToString(header["CompanyAddress"]);
txtDescription.Value = Convert.ToString(header["Description"]);
txtVoucherNo.Value = Convert.ToString(header["VouRefNo"]);
txtVoucherDate.Value = Convert.ToString(header["VoucherDate"]);
if (ReportType.Trim().ToUpper() == "P")
{
txtReportType.Value = "Payment Journal";
}
else if (ReportType.Trim().ToUpper() == "J")
{
txtReportType.Value = "General Journal";
}
int rowCount = dt.Rows.Count;
for (int i = 1; i <= 24 - (rowCount % 20); i++)
{
dt.Rows.Add(dt.NewRow());
}
table1.DataSource = dt;
double total = 0.0;
for (int i = 0; i < rowCount; i++)
{
try
{
total += double.Parse(dt.Rows[i]["TranAmountCr"].ToString());
}
catch (Exception ex)
{
}
}
ReportUtility reportUtility = new ReportUtility();
txtAmountinWord.Value = reportUtility.DecimalToWords(total);
}
public VoucherLawton(DataSet DS, string ReportType)
{
//
// Required for telerik Reporting designer support
//
InitializeComponent();
txtCompanyName.Value = DS.Tables[1].Rows[0]["CompanyName"].ToString();
txtAddress.Value = DS.Tables[1].Rows[0]["CompanyAddress"].ToString();
txtDescription.Value = DS.Tables[1].Rows[0]["Description"].ToString();
txtVoucherNo.Value = DS.Tables[1].Rows[0]["VouRefNo"].ToString();
txtVoucherDate.Value = DS.Tables[1].Rows[0]["VoucherDate"].ToString();
if (ReportType.Trim().ToUpper() == "P")
{
txtReportType.Value = "Payment Journal";
}
else if (ReportType.Trim().ToUpper() == "J")
{
txtReportType.Value = "General Journal";
}
int rowCount = DS.Tables[0].Rows.Count;
for (int i = 1; i <= 24 - (rowCount % 20); i++)
{
DS.Tables[0].Rows.Add(DS.Tables[0].NewRow());
}
table1.DataSource = DS.Tables[0];
double total = 0.0;
for (int i = 0; i < rowCount; i++)
{
try
{
total += double.Parse(DS.Tables[0].Rows[i]["TranAmountCr"].ToString());
}
catch (Exception ex)
{
}
}
ReportUtility reportUtility = new ReportUtility();
txtAmountinWord.Value = reportUtility.DecimalToWords(total);
//
// TODO: Add any constructor code after InitializeComponent call
//
}