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 { // } } } }