private void BindSenderName()
{
outsndngBillRepDAL obj = new outsndngBillRepDAL();
var SenderName = obj.BindSender();
drpSenderName.DataSource = SenderName;
drpSenderName.DataTextField = "Acnt_Name";
drpSenderName.DataValueField = "Acnt_Idno";
drpSenderName.DataBind();
objInvcDAL = null;
drpSenderName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindCity(Int64 UserId)
{
BindDropdownDAL obj = new BindDropdownDAL();
var FrmCity = obj.BindCityUserWise(UserId);
drpBaseCity.DataSource = FrmCity;
drpBaseCity.DataTextField = "CityName";
drpBaseCity.DataValueField = "CityIdno";
drpBaseCity.DataBind();
objInvcDAL = null;
drpBaseCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void TotalRecords()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
string UserClass = Convert.ToString(Session["Userclass"]);
Int64 UserIdno = 0;
if (UserClass != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
outsndngBillRepDAL obj = new outsndngBillRepDAL();
DataTable list1 = obj.SelectRep("SelectRep", Convert.ToString(txtDateFrom.Text), Convert.ToString(txtDateTo.Text), 0, 0, 0, UserIdno, ApplicationFunction.ConnectionString(), Convert.ToString(txtPrefixNo.Text.Trim()));
lblTotalRecord.Text = "T. Record (s): " + Convert.ToString(list1.Rows.Count);
}
}
private void BindGrid()
{
try
{
outsndngBillRepDAL obj = new outsndngBillRepDAL();
string userclass = Convert.ToString(Session["Userclass"]);
Int64 UserIdno = 0;
if (userclass != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
Int64 iFromCityIDNO = (Convert.ToString(drpBaseCity.SelectedValue) == "" ? 0 : Convert.ToInt64(drpBaseCity.SelectedValue));
Int64 iSenderIDNO = (Convert.ToString(drpSenderName.SelectedValue) == "" ? 0 : Convert.ToInt64(drpSenderName.SelectedValue));
Int32 iInvoiceNo = (Convert.ToString(txtInvoiceNo.Text) == "" ? 0 : Convert.ToInt32(txtInvoiceNo.Text));
DataTable DsGrdetail = obj.SelectRep("SelectRep", Convert.ToString(txtDateFrom.Text), Convert.ToString(txtDateTo.Text), iFromCityIDNO, iSenderIDNO, iInvoiceNo, UserIdno, ApplicationFunction.ConnectionString(), Convert.ToString(txtPrefixNo.Text.Trim()));
if ((DsGrdetail != null) && (DsGrdetail.Rows.Count > 0))
{
ViewState["dtCSV"] = DsGrdetail;
grdMain.DataSource = DsGrdetail;
grdMain.DataBind();
Double TotalNetAmount = 0, RecivdAmnt = 0, PendingAmnt = 0, TDSAmnt = 0, DBNoteAmnt = 0;
for (int i = 0; i < DsGrdetail.Rows.Count; i++)
{
RecivdAmnt += Convert.ToDouble(DsGrdetail.Rows[i]["Tot_Recvd"]);
PendingAmnt += Convert.ToDouble(DsGrdetail.Rows[i]["cur_Bal"]);
TDSAmnt += Convert.ToDouble(DsGrdetail.Rows[i]["TDS_Amount"]);
DBNoteAmnt += Convert.ToDouble(DsGrdetail.Rows[i]["DB_Note"]);
TotalNetAmount += Convert.ToDouble(DsGrdetail.Rows[i]["Amount"]);
}
lblNetTotalRecivdAmnt.Text = RecivdAmnt.ToString("N2");
lblNetTotallblPendingAmnt.Text = PendingAmnt.ToString("N2");
lblNetTotalTDSAmnt.Text = TDSAmnt.ToString("N2");
lblNetTotalDBNoteAmnt.Text = DBNoteAmnt.ToString("N2");
lblNetTotalAmount.Text = TotalNetAmount.ToString("N2");
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + DsGrdetail.Rows.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
imgBtnExcel.Visible = true;
lblTotalRecord.Text = "T. Record(s) : " + Convert.ToString(DsGrdetail.Rows.Count);
}
else
{
ViewState["dtCSV"] = null;
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
lblcontant.Visible = false;
divpaging.Visible = false;
imgBtnExcel.Visible = false;
}
}
catch (Exception Ex)
{
throw (Ex);
}
}
