private void BindLedger()
{
DayBookReportDAL obj = new DayBookReportDAL();
var PartyDet = obj.FillPartyDetail();
ddlCashAc.DataSource = PartyDet;
ddlCashAc.DataTextField = "Acnt_Name";
ddlCashAc.DataValueField = "Acnt_Idno";
ddlCashAc.DataBind();
ddlCashAc.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindGrid()
{
if (ddlCashAc.SelectedIndex > 0)
{
dsFinal = null; OpenBal = ClBal = iPayment = iReceipt = 0; dt = null;
double db, cr, dbopbal, cropbal, totdb, totcr;
db = cr = dbopbal = cropbal = totdb = totcr = 0;
dt = new DataTable("DayBookSumRep"); DataTable dt1 = new DataTable();
DataColumn dtCol; dtCol = new DataColumn("Particular1", typeof(string));
dt.Columns.Add(dtCol); dtCol = new DataColumn("Payment", typeof(string));
dt.Columns.Add(dtCol); dtCol = new DataColumn("Particular2", typeof(string));
dt.Columns.Add(dtCol); dtCol = new DataColumn("Receipt", typeof(string));
dt.Columns.Add(dtCol);
DayBookReportDAL obj = new DayBookReportDAL();
DataColumn dtCol1 = new DataColumn("PertiDebit", typeof(string));
dt1.Columns.Add(dtCol1); dtCol1 = new DataColumn("Debit", typeof(string));
dt1.Columns.Add(dtCol1); dtCol1 = new DataColumn("PertiCredit", typeof(string));
dt1.Columns.Add(dtCol1); dtCol1 = new DataColumn("Credit", typeof(string));
dt1.Columns.Add(dtCol1);
ds.Tables.Add(dt1);
dsOuter = obj.SelectOpenPayRecWithBnk(ApplicationFunction.ConnectionString(), "SelectLdgrDetOneById", Convert.ToInt64(ddlCashAc.SelectedValue), Datefor.Text.Trim(), Convert.ToInt64(ddlDateRange.SelectedValue));
if (dsOuter != null && dsOuter.Tables.Count > 0 && dsOuter.Tables[1].Rows.Count > 0)
{
for (int x = 0; x < dsOuter.Tables[1].Rows.Count; x++)
{
dsTemp = null;
dsTemp = obj.SelectLdgrDetOne(ApplicationFunction.ConnectionString(), "SelectLdgrDetOne", Convert.ToInt64(ddlCashAc.SelectedValue), Convert.ToInt64(dsOuter.Tables[1].Rows[x]["VCHR_IDNO"]), Convert.ToInt64(ddlDateRange.SelectedValue));
if (dsTemp != null && dsTemp.Tables.Count > 0 && dsTemp.Tables[1].Rows.Count > 0)
{
for (int i = 0; i < dsTemp.Tables[1].Rows.Count; i++)
{
if (dsTemp.Tables[1].Rows.Count > 1)
{
ds.Tables[0].Rows.Add(Convert.ToString(dsTemp.Tables[1].Rows[i]["PertiDebit"]), Convert.ToString(dsTemp.Tables[1].Rows[i]["Debit"]),
Convert.ToString(dsTemp.Tables[1].Rows[i]["PertiCredit"]), Convert.ToString(dsTemp.Tables[1].Rows[i]["Credit"]));
}
else
{
ds.Tables[0].Rows.Add(Convert.ToString(dsTemp.Tables[1].Rows[i]["PertiDebit"]), Convert.ToString(dsTemp.Tables[1].Rows[i]["Debit"]),
Convert.ToString(dsTemp.Tables[1].Rows[i]["PertiCredit"]), Convert.ToString(dsTemp.Tables[1].Rows[i]["Credit"]));
}
}
}
}
}
if (ds != null)
{
if (ds.Tables.Count > 0)
{
dsOuter.Tables[0].TableName = "OpeningBal"; ds.Tables[0].TableName = "PayRec";
if (dsOuter.Tables["OpeningBal"].Rows.Count > 0)
{
OpenBal = Convert.ToDouble(dsOuter.Tables["OpeningBal"].Rows[0][0]);
}
//if (ds.Tables["PayRec"].Rows.Count > 0)
//{
DateTime DateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Datefor.Text.Trim().ToString()));
db = obj.SELECTCRDR(ApplicationFunction.ConnectionString(), "SELECTCRDR", 2, Convert.ToInt64(ddlCashAc.SelectedValue), Datefor.Text.Trim(), Convert.ToInt64(ddlDateRange.SelectedValue));
cr = obj.SELECTCRDR(ApplicationFunction.ConnectionString(), "SELECTCRDR", 1, Convert.ToInt64(ddlCashAc.SelectedValue), Datefor.Text.Trim(), Convert.ToInt64(ddlDateRange.SelectedValue));
dbopbal = obj.SELECTOPBAL(ApplicationFunction.ConnectionString(), "SELECTOPBAL", 2, Convert.ToInt64(ddlCashAc.SelectedValue), Convert.ToInt64(ddlDateRange.SelectedValue));
cropbal = obj.SELECTOPBAL(ApplicationFunction.ConnectionString(), "SELECTOPBAL", 1, Convert.ToInt64(ddlCashAc.SelectedValue), Convert.ToInt64(ddlDateRange.SelectedValue));
totdb = db + dbopbal; totcr = cr + cropbal;
OpenBal = totdb - totcr;
List = dt1.Clone();
DataRow drNew1 = List.NewRow();
drNew1.BeginEdit();
drNew1[0] = "Opening Balance";
if (OpenBal > 0)
{
drNew1[1] = OpenBal.ToString("N2");
}
else
{
drNew1[3] = Math.Abs(OpenBal).ToString("N2");
}
List.Rows.Add(drNew1);
DataRow drNew2 = List.NewRow();
drNew2.BeginEdit();
drNew2[0] = "";
drNew2[1] = "";
List.Rows.Add(drNew2);
DataRow drNew7 = List.NewRow();
drNew7.BeginEdit();
drNew7[0] = ""; drNew7[2] = "";
drNew7[1] = ""; drNew7[3] = "";
List.Rows.Add(drNew7);
for (int i = 3, j = 2, cnt = 0; cnt < ds.Tables["PayRec"].Rows.Count; cnt++)
{
if (Convert.ToString(ds.Tables["PayRec"].Rows[cnt][0]) != "")
{
DataRow drNew4 = List.NewRow();
drNew4.BeginEdit();
drNew4[0] = Convert.ToString(ds.Tables["PayRec"].Rows[cnt][0]);
drNew4[1] = Convert.ToString(ds.Tables["PayRec"].Rows[cnt][1]);
List.Rows.Add(drNew4);
iPayment = iPayment + Convert.ToDouble(ds.Tables["PayRec"].Rows[cnt][1]); i++;
}
else if (Convert.ToString(ds.Tables["PayRec"].Rows[cnt][2]) != "")
{
List.Rows[j][2] = Convert.ToString(ds.Tables["PayRec"].Rows[cnt][2]);
List.Rows[j][3] = Convert.ToString(ds.Tables["PayRec"].Rows[cnt][3]);
iReceipt = iReceipt + Convert.ToDouble(ds.Tables["PayRec"].Rows[cnt][3]); j++;
}
}
ClBal = (OpenBal + iReceipt) - iPayment;
DataRow drNew6 = List.NewRow();
drNew6.BeginEdit();
drNew6[0] = "Total Debit"; drNew6[2] = "Total Credit";
drNew6[1] = Convert.ToDouble(iPayment).ToString("N2"); drNew6[3] = Convert.ToDouble(iReceipt).ToString("N2");
List.Rows.Add(drNew6);
DataRow drNew5 = List.NewRow();
drNew5.BeginEdit();
drNew5[1] = "";
List.Rows.Add(drNew5);
double ClBalnew = Math.Abs(ClBal);
List.Rows[List.Rows.Count - 1][0] = "Closing Balance";
if (ClBal < 0)
{
List.Rows[List.Rows.Count - 1][1] = ClBalnew.ToString("N2");
}
else
{
List.Rows[List.Rows.Count - 1][3] = ClBalnew.ToString("N2");
}
grdMain.Width = new Unit("1065px");
//gridRowDel();
ViewState["Dt"] = List;
grdMain.DataSource = List;
grdMain.DataBind();
//lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
//lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
//lblcontant.Visible = true;
imgBtnExcel.Visible = true;
divpaging.Visible = true;
//}
//else
//{
// grdMain.DataSource = null;
// grdMain.DataBind();
// lblTotalRecord.Text = "T. Record (s): 0 ";
// imgBtnExcel.Visible = false;
// lblcontant.Visible = false;
// divpaging.Visible = false;
//}
}
else
{
//
}
}
}
}
