private void BindItemName()
{
TyreStockRpt obj = new TyreStockRpt();
var itmName = obj.BindActiveItemName();
ddlItemName.DataSource = itmName;
ddlItemName.DataTextField = "Item_name";
ddlItemName.DataValueField = "Item_idno";
ddlItemName.DataBind();
ddlItemName.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"]);
}
TyreStockRpt obj = new TyreStockRpt();
Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedIndex);
DataTable list1 = obj.SelectTyreStockReport(ApplicationFunction.ConnectionString(), Datefrom.Text.Trim(), Dateto.Text.Trim(), 0, Convert.ToInt64(0), 0, Convert.ToInt64(ddlLocation.SelectedValue));
lblTotalRecord.Text = "T. Record (s): " + Convert.ToString(list1.Rows.Count);
}
}
private void BindGrid()
{
TyreStockRpt obj = new TyreStockRpt();
DateTime? dtfrom = null;
DateTime? dtto = null;
Int64 ItemIdno = Convert.ToInt64(ddlItemName.SelectedValue);
//string serialNo = txtSerialNo.Text.Trim();
Int32 tyreType = string.IsNullOrEmpty(Convert.ToString(ddlTyreType.SelectedValue)) ? 0 : Convert.ToInt32(ddlTyreType.SelectedValue);
if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Datefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Dateto.Text));
}
Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedValue == "" ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue));
DataTable dt = obj.SelectTyreStockReport(ApplicationFunction.ConnectionString(), Datefrom.Text.Trim(), Dateto.Text.Trim(), yearidno, ItemIdno, tyreType, Convert.ToInt64(ddlLocation.SelectedValue));
obj = null;
if (dt != null && dt.Rows.Count > 0)
{
Double TotalIssue = 0, TotalOpening = 0, TotalPur = 0, TotSale = 0, Total = 0, TotalBal = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
TotalOpening += Convert.ToDouble(dt.Rows[i]["OPN"]);
TotalPur += Convert.ToDouble(dt.Rows[i]["PB"]);
TotalIssue += Convert.ToDouble(dt.Rows[i]["ISSUED"]);
TotSale += Convert.ToDouble(dt.Rows[i]["SB"]);
Total += Convert.ToDouble(dt.Rows[i]["TTL"]);
TotalBal += Convert.ToDouble(dt.Rows[i]["BAL"]);
}
lblTotOpening.Text = TotalOpening.ToString();
lblTotPur.Text = TotalPur.ToString();
lblTotSale.Text = TotSale.ToString();
lblTotal.Text = Total.ToString();
lblTotIssue.Text = TotalIssue.ToString();
lblBalance.Text = TotalBal.ToString();
lblTotRecv.Text = Convert.ToString(dt.Compute("Sum(RECV)", ""));
lblTotTran.Text = Convert.ToString(dt.Compute("Sum(TRAN)", ""));
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
grdMain.DataSource = dt;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record(s): " + dt.Rows.Count;
imgBtnExcel.Visible = true;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + dt.Rows.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;
}
}
