private void BindItemName()
{
AccessoryStockRpt obj = new AccessoryStockRpt();
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"]);
}
AccessoryStockRpt obj = new AccessoryStockRpt();
Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedIndex);
//DataTable list1 = obj.SelectAccStockReport(ApplicationFunction.ConnectionString(), Datefrom.Text.Trim(), Dateto.Text.Trim(), yearidno, Convert.ToInt64(ddlItemName.SelectedValue), 2, Convert.ToInt64(ddlLocation.SelectedValue));
//lblTotalRecord.Text = "T. Record (s): " + Convert.ToString(list1.Rows.Count);
}
}
private void BindGrid()
{
AccessoryStockRpt obj = new AccessoryStockRpt();
DateTime? dtfrom = null;
DateTime? dtto = null;
string strchkDetlValue = string.Empty;
Int64 ItemIdno = Convert.ToInt64(ddlItemName.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));
if (ddlItemName.SelectedValue != "0")
{
DataTable dt = obj.SelectAccStockReport(ApplicationFunction.ConnectionString(), Datefrom.Text.Trim(), Dateto.Text.Trim(), yearidno, Convert.ToString(ddlItemName.SelectedValue), 2, Convert.ToInt64(ddlLocation.SelectedValue));
}
else
{
DataTable grdGrdetals = obj.FetchItemIDno(ApplicationFunction.ConnectionString());
if ((grdGrdetals != null) && (grdGrdetals.Rows.Count > 0))
{
string strchkValue = string.Empty; string sAllItemIdnos = string.Empty;
for (int count = 0; count < grdGrdetals.Rows.Count; count++)
{
strchkDetlValue = strchkDetlValue + grdGrdetals.Rows[count]["ITEM_IDNO"] + ",";
}
if (strchkDetlValue != "")
{
strchkDetlValue = strchkDetlValue.Substring(0, strchkDetlValue.Length - 1);
}
}
DataTable dt = obj.SelectAccStockReport(ApplicationFunction.ConnectionString(), Datefrom.Text.Trim(), Dateto.Text.Trim(), yearidno, strchkDetlValue, 2, Convert.ToInt64(ddlLocation.SelectedValue));
}
DataTable dtnew = obj.FetchAccStockReport(ApplicationFunction.ConnectionString());
obj = null;
if (dtnew != null && dtnew.Rows.Count > 0)
{
Double TotalIssue = 0, TotalOpening = 0, TotalPur = 0, TotSale = 0, Total = 0, TotalBal = 0;
for (int i = 0; i < dtnew.Rows.Count; i++)
{
TotalOpening += Convert.ToDouble(dtnew.Rows[i]["OpenBal"]);
TotalPur += Convert.ToDouble(dtnew.Rows[i]["Purchase"]);
TotalIssue += Convert.ToDouble(dtnew.Rows[i]["MtrlIss"]);
TotSale += Convert.ToDouble(dtnew.Rows[i]["Sale"]);
Total += Convert.ToDouble(dtnew.Rows[i]["Total"]);
TotalBal += Convert.ToDouble(dtnew.Rows[i]["BalQty"]);
}
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(dtnew.Compute("Sum(StkRec)", ""));
lblTotTran.Text = Convert.ToString(dtnew.Compute("Sum(StkTrns)", ""));
if (dtnew != null && dtnew.Rows.Count > 0)
{
ViewState["Dt"] = dtnew;
}
grdMain.DataSource = dtnew;
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 " + dtnew.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;
}
}
