private void Report()
{
double opamount = Convert.ToDouble(textBox1.Text);
double clamount = Convert.ToDouble(textBox2.Text);
CHTMLDocument ds = new CHTMLDocument();
CHTMLText txt = new CHTMLText(" Profit And Loss Account ");
txt.setItalic(true);
CHTMLHorizontalRule hr = new CHTMLHorizontalRule();
CHTMLInput input = new CHTMLInput();
//
//
//
CHTMLTable table = new CHTMLTable();
table.setBorder(1);
table.setCaption(new CHTMLText(" Profit And Loss Account "));
CHTMLTableRow row = null;
row = new CHTMLTableRow();
CHTMLTableCell cell = null;
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(" Expenses "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(" Account Rs "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(" Income "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(" Account Rs "));
row.addObject(cell);
table.addObject(row);
row = new CHTMLTableRow();
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" To Opening stock "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText(opamount.ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText());
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText());
row.addObject(cell);
row.backgroundColor = "red";
table.addObject(row);
DataTable dt = PandL.ProfitAndLoss2();
DataTable dt1 = PandL.ProfitAndLoss1();
double crTotal = 0;
double drTotal = 0;
int crow = dt1.Rows.Count;
int drow = dt.Rows.Count;
int max = Math.Max(drow, crow);
bool flag1 = false;
bool flag2 = false;
bool equal = (drow == crow) ? true : false;
bool drowempty = drow == 0 ? true : false;
bool crowempty = crow == 0 ? true : false;
int i = 0;
while (i < max)
{
row = new CHTMLTableRow();
if (drow < max)
{
if (i == drow)
{
flag1 = true;
}
}
if (crow < max)
{
if (i == crow)
{
flag2 = true;
}
}
if (flag1 == true && equal == false)
{
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
}
if (i < drow && drowempty == false)
{
DataRow dr = dt.Rows[i];
double amnt = double.Parse(dr["Total"].ToString());
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText("To " + dr["S_DESC"].ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText(amnt.ToString()));
row.addObject(cell);
drTotal += amnt;
}
if (flag2 == true && equal == false)
{
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
}
if (i < crow && crowempty == false)
{
DataRow dr = dt1.Rows[i];
double amnt = double.Parse(dr["Total"].ToString());
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText("By " + dr["S_DESC"].ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
amnt = -amnt;
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText(amnt.ToString()));
row.addObject(cell);
crTotal += amnt;
}
table.addObject(row);
i++;
}
row = new CHTMLTableRow();
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText());
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText());
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" By Closing stock "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText(clamount.ToString()));
row.addObject(cell);
table.addObject(row);
crTotal += clamount;
drTotal += opamount;
row = new CHTMLTableRow();
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" To profit and loss carried down to balance sheet "));
row.addObject(cell);
diff = drTotal - crTotal;
if (drTotal > crTotal)
{
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText());
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText());
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText((diff).ToString()));
row.addObject(cell);
crTotal += diff;
}
else
{
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText((-diff).ToString()));
row.addObject(cell);
drTotal += (-diff);
}
table.addObject(row);
row = new CHTMLTableRow();
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText("Total"));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText(drTotal.ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText());
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText(crTotal.ToString()));
row.addObject(cell);
table.addObject(row);
ds.addObject(table);
string rs = ds.toHTML();
FileStream fs = new FileStream(@"C:\temp\a.html", FileMode.Create);
StreamWriter st = new StreamWriter(fs);
st.Write(rs);
st.Close();
webBrowser1.Navigate(new Uri(@"file://c:\temp\a.html"));
webBrowser1.Refresh();
}
private void Report3()
{
CHTMLDocument ds = new CHTMLDocument();
CHTMLText txt = new CHTMLText("Trial Balance");
txt.setItalic(true);
CHTMLHorizontalRule hr = new CHTMLHorizontalRule();
CHTMLInput input = new CHTMLInput();
//
//
//
CHTMLTable table = new CHTMLTable();
table.setBorder(1);
table.setCaption(new CHTMLText("TRIAL BALANCE"));
CHTMLTableRow row = null;
row = new CHTMLTableRow();
CHTMLTableCell cell = null;
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(" Account "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(" DR "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(" CR "));
row.addObject(cell);
row.backgroundColor = "red";
table.addObject(row);
DataTable dt = TrialBalance.TrialTable();
double crTotal = 0;
double drTotal = 0;
foreach (DataRow dr in dt.Rows)
{
row = new CHTMLTableRow();
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(dr["S_DESC"].ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
double amnt = double.Parse(dr["Total"].ToString());
if (amnt >= 0)
{
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText(amnt.ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
drTotal += amnt;
}
else if (amnt < 0)
{
amnt = -amnt;
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText(amnt.ToString()));
row.addObject(cell);
crTotal += amnt;
}
table.addObject(row);
}
row = new CHTMLTableRow();
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText("Total"));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(drTotal.ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(crTotal.ToString()));
row.addObject(cell);
table.addObject(row);
ds.addObject(table);
string rs = ds.toHTML();
FileStream fs = new FileStream(@"C:\temp\a.html", FileMode.Create);
StreamWriter st = new StreamWriter(fs);
st.Write(rs);
st.Close();
webBrowser1.Navigate(new Uri(@"file://c:\temp\a.html"));
webBrowser1.Refresh();
}
private void Report()
{
double closingstock = Convert.ToDouble(clstocktxt.Text);
double pft = Convert.ToDouble(pltxt.Text);
double crTotal = 0;
double drTotal = 0;
bool flag1 = false;
bool flag2 = false;
bool equal = false;
CHTMLDocument ds = new CHTMLDocument();
CHTMLText txt = new CHTMLText(" BalanceSheet ");
txt.setItalic(true);
CHTMLHorizontalRule hr = new CHTMLHorizontalRule();
CHTMLInput input = new CHTMLInput();
//
//
//
CHTMLTable table = new CHTMLTable();
table.setBorder(1);
table.setCaption(new CHTMLText(" BalanceSheet "));
CHTMLTableRow row = null;
row = new CHTMLTableRow();
CHTMLTableCell cell = null;
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText("Liabilities "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(" Account Rs "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(" Assets "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(" Account Rs "));
row.addObject(cell);
table.addObject(row);
row = null;
if (pft > 0)
{
row = new CHTMLTableRow();
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" Profit "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText((pft).ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
table.addObject(row);
row = null;
crTotal += (pft);
}
else if (pft < 0)
{
row = new CHTMLTableRow();
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText("Loss "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText((-pft).ToString()));
row.addObject(cell);
table.addObject(row);
row = null;
drTotal += -pft;
}
// row.backgroundColor = "red";
//table.addObject(row);
DataTable dt = Balancesheet.ShowBalance2();
DataTable dt1 = Balancesheet.ShowBalance1();
int drow = dt.Rows.Count;
int crow = dt1.Rows.Count;
int max = Math.Max(drow, crow);
equal = (drow == crow) ? true : false;
int i = 0;
while (i < max)
{
row = new CHTMLTableRow();
if (crow < max)
{
if (i == crow)
{
flag1 = true;;
}
}
if (drow < max)
{
if (i == drow)
{
flag2 = true;
}
}
if (flag1 == true && equal == false)
{
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
}
if (i < crow)
{
DataRow dr = dt1.Rows[i];
double amnt = double.Parse(dr["Total"].ToString());
if (amnt < 0)
{
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(dr["S_DESC"].ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText((-amnt).ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
crTotal += -amnt;
}
else
{
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(dr["S_DESC"].ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText((amnt).ToString()));
row.addObject(cell);
table.addObject(row);
row = new CHTMLTableRow();
drTotal += (amnt);
}
}
if (flag2 == true && equal == false)
{
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
}
if (i < drow)
{
DataRow dr = dt.Rows[i];
double amnt = double.Parse(dr["Total"].ToString());
if (amnt > 0)
{
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(dr["S_DESC"].ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText((amnt).ToString()));
row.addObject(cell);
drTotal += (amnt);
}
else if (amnt < 0)
{
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(dr["S_DESC"].ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText((amnt).ToString()));
row.addObject(cell);
crTotal += (amnt);
}
}
table.addObject(row);
row = null;
i++;
}
row = new CHTMLTableRow();
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText("Closing stock"));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText(closingstock.ToString()));
row.addObject(cell);
table.addObject(row);
drTotal += closingstock;
row = new CHTMLTableRow();
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText("Total"));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText(drTotal.ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText());
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText(crTotal.ToString()));
row.addObject(cell);
table.addObject(row);
ds.addObject(table);
string rs = ds.toHTML();
FileStream fs = new FileStream(@"C:\temp\a.html", FileMode.Create);
StreamWriter st = new StreamWriter(fs);
st.Write(rs);
st.Close();
webBrowser1.Navigate(new Uri(@"file://c:\temp\a.html"));
webBrowser1.Refresh();
}
private void Report2(DataTable dt)
{
CHTMLDocument ds = new CHTMLDocument();
CHTMLText txt = new CHTMLText("Ledger");
txt.setItalic(true);
CHTMLHorizontalRule hr = new CHTMLHorizontalRule();
CHTMLInput input = new CHTMLInput();
//
//
//
CHTMLTable table = new CHTMLTable();
table.setBorder(1);
table.setCaption(new CHTMLText("Ledger Of " + _acc_string));
CHTMLTableRow row = null;
row = new CHTMLTableRow();
CHTMLTableCell cell = null;
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(" Date "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(" Account Name "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(" DR "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(" CR "));
row.addObject(cell);
row.backgroundColor = "red";
table.addObject(row);
foreach (DataRow dr in dt.Rows)
{
row = new CHTMLTableRow();
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(dr["J_DATE"].ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.HEADING);
if (dr["J_DRCR"].ToString() == "CR")
{
cell.addObject(new CHTMLText("TO " + dr["S_DESC"].ToString()));
}
else
{
cell.addObject(new CHTMLText("BY " + dr["S_DESC"].ToString()));
}
row.addObject(cell);
if (dr["J_DRCR"].ToString() == "CR")
{
cell = new CHTMLTableCell(alignment.HEADING);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText(dr["J_AMOUNT"].ToString()));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
}
else
{
cell = new CHTMLTableCell(alignment.HEADING);
cell.addObject(new CHTMLText(" "));
row.addObject(cell);
cell = new CHTMLTableCell(alignment.RIGHT);
cell.setHorizontalAlign(alignment.RIGHT);
cell.addObject(new CHTMLText(dr["J_AMOUNT"].ToString()));
row.addObject(cell);
}
table.addObject(row);
}
ds.addObject(table);
string rs = ds.toHTML();
FileStream fs = new FileStream(@"C:\temp\a.html", FileMode.Create);
StreamWriter st = new StreamWriter(fs);
st.Write(rs);
st.Close();
webBrowser1.Navigate(new Uri(@"file://c:\temp\a.html"));
webBrowser1.Refresh();
}