public void ReportGrid(string RepCondition)
{
try
{
DataSet DsGrd = new DataSet();
DsGrd = Obj_MaterialInwardReg.GetInwardDetailsReport(RepCondition, out StrError);
if (DsGrd.Tables.Count > 0 && DsGrd.Tables[0].Rows.Count > 0)
{
if (!FlagPrint)
{
ImgBtnPrint.Visible = true;
}
if (!FlagPrint)
{
ImgBtnExport.Visible = true;
}
GridInwordDetails.DataSource = DsGrd.Tables[0];
GridInwordDetails.DataBind();
lblCount.Text = DsGrd.Tables[0].Rows.Count + " Record Found";
lblCount.Visible = true;
}
else
{
GridInwordDetails.DataSource = null;
GridInwordDetails.DataBind();
lblCount.Text = DsGrd.Tables[0].Rows.Count + " Record Found";
lblCount.Visible = true;
SetInitialRow();
}
//Obj_Quot = null;
DsGrd = null;
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
protected void GridInword_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
switch (e.CommandName)
{
case ("Select"):
{
DataSet DSInwardDetails = new DataSet();
DSInwardDetails = Obj_MaterialInwardReg.GetInwordDetailsReport(Convert.ToString(GridInword.Rows[Convert.ToInt32(e.CommandArgument)].Cells[2].Text.Trim()), out StrError);
if (DSInwardDetails.Tables.Count > 0 && DSInwardDetails.Tables[0].Rows.Count > 0)
{
GridInwordDetails.Visible = true;
GRIDDETAILS.Visible = true;
GridInwordDetails.DataSource = DSInwardDetails.Tables[0];
GridInwordDetails.DataBind();
}
else
{
GridInwordDetails.Visible = false;
GRIDDETAILS.Visible = false;
GridInwordDetails.DataSource = null;
GridInwordDetails.DataBind();
}
}
break;
}
}
catch (Exception ex)
{
}
}
//========Important Required for Excel Export Must=============
protected void GridInwordDetails_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
try
{
this.GridInwordDetails.PageIndex = e.NewPageIndex;
DataSet DsGrd = new DataSet();
StrCondition = string.Empty;
if (ChkFrmDate.Checked == true)
{
StrCondition = StrCondition + " and IR.InwardDate between '" + Convert.ToDateTime(txtFromDate.Text).ToString("MM-dd-yyyy") + "' AND '" + Convert.ToDateTime(txtToDate.Text).ToString("MM-dd-yyyy") + "' ";
}
else
{
StrCondition = StrCondition + " AND IR.InwardDate between '01-01-1975' AND '" + DateTime.Now.ToString("MM-dd-yyyy") + "' ";
}
if (Convert.ToInt32(ddlSupp.SelectedValue) > 0)
{
StrCondition = StrCondition + " and SM.SuplierId =" + Convert.ToInt32(ddlSupp.SelectedValue);
}
if (Convert.ToInt32(ddlInwardNo.SelectedValue) > 0)
{
StrCondition = StrCondition + " and IR.InwardId=" + Convert.ToInt32(ddlInwardNo.SelectedValue);
}
if (!string.IsNullOrEmpty(ddlItemName.Text) && Convert.ToInt32(ddlItemName.SelectedValue) > 0)
{
StrCondition = StrCondition + " and IM.ItemId=" + Convert.ToInt32(ddlItemName.SelectedValue);
}
if (!string.IsNullOrEmpty(ddlCategory.Text) && Convert.ToInt32(ddlCategory.SelectedValue) > 0)
{
StrCondition = StrCondition + " And IC.CategoryId=" + Convert.ToInt32(ddlCategory.SelectedValue);
}
// //if (!Convert.ToBoolean(Session["IsCentral"].ToString()))
// //{
// StrCondition = StrCondition + " AND IR.Location=" + Convert.ToInt32(Session["CafeteriaId"].ToString());
//// }
DsGrd = Obj_MaterialInwardReg.GetInwardDetailsReport(StrCondition, out StrError);
if (DsGrd.Tables.Count > 0 && DsGrd.Tables[0].Rows.Count > 0)
{
GridInwordDetails.DataSource = DsGrd.Tables[0];
GridInwordDetails.DataBind();
lblCount.Text = DsGrd.Tables[0].Rows.Count + " Record Found";
lblCount.Visible = true;
}
else
{
GridInwordDetails.DataSource = null;
GridInwordDetails.DataBind();
lblCount.Text = DsGrd.Tables[0].Rows.Count + " Record Found";
lblCount.Visible = true;
SetInitialRow();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void SetInitialRow()
{
try
{
DataTable dt = new DataTable();
DataRow dr = null;
//dt.Columns.Add(new DataColumn("#", typeof(int)));
dt.Columns.Add(new DataColumn("InwardNo", typeof(string)));
dt.Columns.Add(new DataColumn("InwardDate", typeof(string)));
dt.Columns.Add(new DataColumn("PONO", typeof(string)));
dt.Columns.Add(new DataColumn("type", typeof(string)));
dt.Columns.Add(new DataColumn("SuplierName", typeof(string)));
dt.Columns.Add(new DataColumn("ItemName", typeof(string)));
dt.Columns.Add(new DataColumn("Unit", typeof(string)));
dt.Columns.Add(new DataColumn("InwardQty", typeof(decimal)));
dt.Columns.Add(new DataColumn("OrderQty", typeof(decimal)));
dt.Columns.Add(new DataColumn("PendingQty", typeof(decimal)));
dt.Columns.Add(new DataColumn("InwardRate", typeof(decimal)));
dt.Columns.Add(new DataColumn("PORate", typeof(decimal)));
dt.Columns.Add(new DataColumn("Diffrence", typeof(decimal)));
dt.Columns.Add(new DataColumn("Amount", typeof(decimal)));
dt.Columns.Add(new DataColumn("TaxPer", typeof(decimal)));
dt.Columns.Add(new DataColumn("DiscPer", typeof(decimal)));
dt.Columns.Add(new DataColumn("DiscAmt", typeof(decimal)));
dt.Columns.Add(new DataColumn("TaxAmount", typeof(decimal)));
dt.Columns.Add(new DataColumn("NetAmount", typeof(decimal)));
dr = dt.NewRow();
//dr["#"] = 0;
dr["InwardNo"] = "";
dr["InwardDate"] = "";
dr["PONO"] = "";
dr["type"] = "";
dr["Unit"] = "";
dr["SuplierName"] = "";
dr["ItemName"] = "";
dr["InwardQty"] = 0;
dr["OrderQty"] = 0;
dr["InwardRate"] = 0;
dr["PORate"] = 0;
dr["Diffrence"] = 0;
dr["Amount"] = 0;
dr["TaxPer"] = 0;
dr["TaxAmount"] = 0;
dr["DiscPer"] = 0;
dr["DiscAmt"] = 0;
dr["NetAmount"] = 0;
dt.Rows.Add(dr);
ViewState["CurrentTable"] = dt;
GridInwordDetails.DataSource = dt;
GridInwordDetails.DataBind();
dt = null;
dr = null;
}
catch (Exception ex)
{
throw;
}
}
protected void ImgBtnExport_Click(object sender, ImageClickEventArgs e)
{
try
{
DataSet DsGrd = new DataSet();
StrCondition = string.Empty;
if (ChkFrmDate.Checked == true)
{
StrCondition = StrCondition + " and IR.InwardDate between '" + Convert.ToDateTime(txtFromDate.Text).ToString("MM-dd-yyyy") + "' AND '" + Convert.ToDateTime(txtToDate.Text).ToString("MM-dd-yyyy") + "' ";
}
else
{
StrCondition = StrCondition + " AND IR.InwardDate between '01-01-1975' AND '" + DateTime.Now.ToString("MM-dd-yyyy") + "' ";
}
if (!string.IsNullOrEmpty(ddlItemName.Text) && Convert.ToInt32(ddlItemName.SelectedValue) > 0)
{
StrCondition = StrCondition + " and IM.ItemId=" + Convert.ToInt32(ddlItemName.SelectedValue);
}
if (!Convert.ToBoolean(Session["IsCentral"].ToString()))
{
StrCondition = StrCondition + " AND IR.Location =" + Convert.ToInt32(Session["CafeteriaId"].ToString());
}
if (!string.IsNullOrEmpty(ddlSubCategory.Text) && Convert.ToInt32(ddlSubCategory.SelectedValue) > 0)
{
StrCondition = StrCondition + " And IM.SubCategoryId=" + Convert.ToInt32(ddlSubCategory.SelectedValue);
}
DsGrd = Obj_ArticleHistory.GetInwardDetailsReport(StrCondition, out StrError);
if (DsGrd.Tables.Count > 0 && DsGrd.Tables[0].Rows.Count > 0)
{
//========Call Register
GridView GridExp = new GridView();
GridExp.DataSource = DsGrd.Tables[0];
GridExp.DataBind();
obj_Comman.Export("ArticlesHistory.xls", GridExp);
}
else
{
obj_Comman.ShowPopUpMsg("No Data Found To Export..!", this.Page);
DsGrd.Dispose();
GridInwordDetails.DataSource = null;
GridInwordDetails.DataBind();
}
//ds = null;
}
catch (ThreadAbortException tex)
{
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void SetInitialRow()
{
try
{
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("InwardDate", typeof(string)));
dt.Columns.Add(new DataColumn("Category", typeof(string)));
dt.Columns.Add(new DataColumn("ItemName", typeof(string)));
dt.Columns.Add(new DataColumn("ItemDesc", typeof(string)));
dt.Columns.Add(new DataColumn("Unit", typeof(string)));
dt.Columns.Add(new DataColumn("InwardQty", typeof(decimal)));
dt.Columns.Add(new DataColumn("InwardRate", typeof(decimal)));
dt.Columns.Add(new DataColumn("Amount", typeof(decimal)));
dr = dt.NewRow();
dr["InwardDate"] = "";
dr["Category"] = "";
dr["ItemName"] = "";
dr["ItemDesc"] = "";
dr["Unit"] = "";
dr["InwardQty"] = 0;
dr["InwardRate"] = 0;
dr["Amount"] = 0;
dt.Rows.Add(dr);
ViewState["CurrentTable"] = dt;
GridInwordDetails.DataSource = dt;
GridInwordDetails.DataBind();
dt = null;
dr = null;
}
catch (Exception ex)
{
throw;
}
}
