private void BindCity(Int64 UserIdno)
{
BindDropdownDAL obj = new BindDropdownDAL();
var FrmCity = obj.BindCityUserWise(UserIdno);
drpToCity.DataSource = FrmCity;
drpToCity.DataTextField = "CityName";
drpToCity.DataValueField = "CityIdno";
drpToCity.DataBind();
objGRDAL = null;
drpToCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindCity()
{
GRRepDAL obj = new GRRepDAL();
var FrmCity = obj.BindFromCity();
drpToCity.DataSource = FrmCity;
drpToCity.DataTextField = "City_Name";
drpToCity.DataValueField = "City_Idno";
drpToCity.DataBind();
objGRDAL = null;
drpToCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindSenderName()
{
GRRepDAL obj = new GRRepDAL();
var SenderName = obj.BindSender();
ddlSender.DataSource = SenderName;
ddlSender.DataTextField = "Acnt_Name";
ddlSender.DataValueField = "Acnt_Idno";
ddlSender.DataBind();
objGRDAL = null;
ddlSender.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindDelvrPlce()
{
GRRepDAL obj = new GRRepDAL();
var DelvrPlace = obj.BindDelvryPlace();
ddlDelvPlce.DataSource = DelvrPlace;
ddlDelvPlce.DataTextField = "City_Name";
ddlDelvPlce.DataValueField = "City_Idno";
ddlDelvPlce.DataBind();
objGRDAL = null;
ddlDelvPlce.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindDestination()
{
BindDropdownDAL obj = new BindDropdownDAL();
var DestiCity = obj.BindAllToCity();
ddlDestination.DataSource = DestiCity;
ddlDestination.DataTextField = "City_Name";
ddlDestination.DataValueField = "City_Idno";
ddlDestination.DataBind();
objGRDAL = null;
ddlDestination.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"]);
}
Int64 iREcvrIDNO = (ddlRecvr.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlRecvr.SelectedValue));
Int64 iSenderIDNO = (ddlSender.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlSender.SelectedValue));
Int64 iDElvryIDNO = (ddlDelvPlce.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlDelvPlce.SelectedValue));
Int32 iGRTypIDNO = (ddlGRType.SelectedIndex <= 0 ? 0 : Convert.ToInt32(ddlGRType.SelectedValue));
Int64 iFromCityIDNO = (drpBaseCity.SelectedIndex <= 0 ? 0 : Convert.ToInt64(drpBaseCity.SelectedValue));
GRRepDAL obj = new GRRepDAL();
DataTable list1 = obj.SelectRep("SelectRep", Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), iREcvrIDNO,
iSenderIDNO, iFromCityIDNO, iDElvryIDNO, iGRTypIDNO, UserIdno, conString);
lblTotalRecord.Text = "T. Record (s): " + Convert.ToString(list1.Rows.Count);
}
}
private void BindGrid()
{
GRRepDAL obj = new GRRepDAL();
Int64 iREcvrIDNO = (ddlRecvr.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlRecvr.SelectedValue));
Int64 iSenderIDNO = (ddlSender.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlSender.SelectedValue));
Int64 iDElvryIDNO = (ddlDelvPlce.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlDelvPlce.SelectedValue));
Int32 iGRTypIDNO = (ddlGRType.SelectedIndex <= 0 ? 0 : Convert.ToInt32(ddlGRType.SelectedValue));
Int64 iFromCityIDNO = (drpBaseCity.SelectedIndex <= 0 ? 0 : Convert.ToInt64(drpBaseCity.SelectedValue));
string strreporttypr = "";
if (ddlreporttype.SelectedValue == "1")
{
strreporttypr = "SelectRep";
}
else
{
strreporttypr = "SelectRepItemWise";
}
string UserClass = Convert.ToString(Session["Userclass"]);
Int64 UserIdno = 0;
if (UserClass != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
DataTable list = obj.SelectRep(strreporttypr, Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)),
Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), iREcvrIDNO,
iSenderIDNO, iFromCityIDNO, iDElvryIDNO, iGRTypIDNO, UserIdno, conString);
if ((list != null) && (list.Rows.Count > 0))
{
ViewState["CSVdt"] = list;
grdMain.DataSource = list;
grdMain.DataBind();
Double TotalNetAmount = 0, TotGrossAmnt = 0, TotSurcharge = 0, TotWages = 0, TotServTax = 0;
for (int i = 0; i < list.Rows.Count; i++)
{
TotGrossAmnt += Convert.ToDouble(list.Rows[i]["Gross_Amnt"]);
TotSurcharge += Convert.ToDouble(list.Rows[i]["Surcrg_Amnt"]);
TotWages += Convert.ToDouble(list.Rows[i]["Wages_Amnt"]);
TotServTax += Convert.ToDouble(list.Rows[i]["ServTax_Amnt"]);
TotalNetAmount += Convert.ToDouble(list.Rows[i]["Net_Amnt"]);
}
lblGrossAmnt.Text = TotGrossAmnt.ToString("N2");
lblSurcharge.Text = TotSurcharge.ToString("N2");
lblWages.Text = TotWages.ToString("N2");
lblServtax.Text = TotServTax.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 " + list.Rows.Count.ToString();
lblcontant.Visible = true;
imgBtnExcel.Visible = true;
divpaging.Visible = true;
lblTotalRecord.Text = "T. Record (s): " + list.Rows.Count;
if (ddlreporttype.SelectedValue == "1")
{
grdMain.Columns[7].Visible = false;
grdMain.Columns[8].Visible = false;
//grdMain.Columns[9].Visible = false;
grdMain.Columns[10].Visible = false;
grdMain.Columns[11].Visible = false;
grdMain.Columns[12].Visible = false;
grdMain.Columns[13].Visible = false;
}
else
{
grdMain.Columns[7].Visible = true;
grdMain.Columns[8].Visible = true;
//grdMain.Columns[9].Visible = true;
grdMain.Columns[10].Visible = true;
grdMain.Columns[11].Visible = true;
grdMain.Columns[12].Visible = true;
grdMain.Columns[13].Visible = true;
}
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
imgBtnExcel.Visible = false;
lblTotalRecord.Text = "T. Record (s): 0 ";
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
