public void GetRequisition()
{
try
{
int POId = Convert.ToInt32(Request.QueryString["Id"]);
DSdtls = Obj_StockMasterReport.GetStockForPrint(POId, out StrError);
if (DSdtls.Tables.Count > 0)
{
if (DSdtls.Tables[0].Rows.Count > 0)
{
lblStockNo.Text = obj_Comman.ToTitleCase(DSdtls.Tables[0].Rows[0]["StockNo"].ToString());
lblStockDate.Text = obj_Comman.ToTitleCase(DSdtls.Tables[0].Rows[0]["StockDate"].ToString());
lblRefNo.Text = obj_Comman.ToTitleCase(DSdtls.Tables[0].Rows[0]["Refno"].ToString());
lblfrom.Text = obj_Comman.ToTitleCase(DSdtls.Tables[0].Rows[0]["RequestFrom"].ToString());
LblPrepareBy.Text = obj_Comman.ToTitleCase(DSdtls.Tables[0].Rows[0]["UserName"].ToString());
LblIssusedBy.Text = obj_Comman.ToTitleCase(DSdtls.Tables[0].Rows[0]["UserName"].ToString());
}
if (DSdtls.Tables[1].Rows.Count > 0)
{
ReqGrid.DataSource = DSdtls.Tables[1];
ReqGrid.DataBind();
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void GetRequisition()
{
try
{
int POId = Convert.ToInt32(Request.QueryString["Id"]);
DSdtls = obj_RequisitionCafeteria.BindForReport(POId, out StrError);
ViewState["ImportExel"] = DSdtls.Tables[1];
if (DSdtls.Tables.Count > 0)
{
if (DSdtls.Tables[0].Rows.Count > 0)
{
lblReqNo.Text = Obj_Comm.ToTitleCase(DSdtls.Tables[0].Rows[0]["RequisitionNo"].ToString());
lblReqDate.Text = Obj_Comm.ToTitleCase(DSdtls.Tables[0].Rows[0]["RequisitionDate"].ToString());
lblEmp.Text = Obj_Comm.ToTitleCase(DSdtls.Tables[0].Rows[0]["UserName"].ToString());
}
if (DSdtls.Tables[1].Rows.Count > 0)
{
ReqGrid.DataSource = DSdtls.Tables[1];
ReqGrid.DataBind();
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
