private void BindItemName()
{
TyreMoveRpt obj = new TyreMoveRpt();
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"]);
}
TyreMoveRpt obj = new TyreMoveRpt();
Int64 list1 = obj.TotalRecords(Convert.ToDateTime(ApplicationFunction.mmddyyyy(Datefrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(Dateto.Text)), Convert.ToInt32(ddlDateRange.SelectedIndex), 0, "");
lblTotalRecord.Text = "T. Record (s): " + Convert.ToString(list1);
}
}
private void BindGrid()
{
TyreMoveRpt obj = new TyreMoveRpt();
DateTime? dtfrom = null;
DateTime? dtto = null;
Int64 ItemIdno = Convert.ToInt64(ddlItemName.SelectedValue);
string serialNo = txtSerialNo.Text.Trim();
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));
var lstGridData = obj.SelectTyreMovementReport(dtfrom, dtto, yearidno, ItemIdno, serialNo);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("Item Name", typeof(string));
dt.Columns.Add("Location", typeof(string));
dt.Columns.Add("In Type", typeof(string));
dt.Columns.Add("Doc No.", typeof(string));
dt.Columns.Add("Doc Date", typeof(string));
dt.Columns.Add("Out Type", typeof(string));
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["Item Name"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "ItemName"));
dr["Location"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Location"));
dr["In Type"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "StckIn"));
dr["Doc No."] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DocNo"));
dr["Doc Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "DocDate")).ToString("dd-MM-yyyy");
dr["Out Type"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "StckOut"));
dt.Rows.Add(dr);
if (i == lstGridData.Count - 1)
{
DataRow drr = dt.NewRow();
drr["Item Name"] = "";
drr["Location"] = "";
drr["In Type"] = "";
drr["Doc No."] = "";
drr["Doc Date"] = "";
drr["Out Type"] = "";
dt.Rows.Add(drr);
}
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record(s): " + lstGridData.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 " + lstGridData.Count.ToString();
lblcontant.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;
}
}
