public void GetPurchaseOrder()
{
try
{
int POId = Convert.ToInt32(Request.QueryString["Id"]);
DSdtls = obj_IssueRegister.GetIRForPrint(POId, out StrError);
if (DSdtls.Tables.Count > 0)
{
if (DSdtls.Tables[0].Rows.Count > 0)
{
lblIssueNo.Text = Obj_Comm.ToTitleCase(DSdtls.Tables[0].Rows[0]["IssueNo"].ToString());
lblIssueDate.Text = Obj_Comm.ToTitleCase(DSdtls.Tables[0].Rows[0]["IssueDate"].ToString());
lblSuplier.Text = Obj_Comm.ToTitleCase(DSdtls.Tables[0].Rows[0]["Cafeteria"].ToString());
lblForRequisition.Text = Obj_Comm.ToTitleCase(DSdtls.Tables[0].Rows[0]["RequisitionNo"].ToString());
ReqDate.Text = Obj_Comm.ToTitleCase(DSdtls.Tables[0].Rows[0]["RequisitionDate"].ToString());
lblIssBy.Text = Obj_Comm.ToTitleCase(DSdtls.Tables[0].Rows[0]["UserName"].ToString());
}
if (DSdtls.Tables[1].Rows.Count > 0)
{
IssueRegGrid.DataSource = DSdtls.Tables[1];
IssueRegGrid.DataBind();
getLastRow();
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void GetTemplate()
{
try
{
int POId = Convert.ToInt32(Request.QueryString["Id"]);
DSdtls = obj_Template.BindForReport(POId, out StrError);
if (DSdtls.Tables.Count > 0)
{
if (DSdtls.Tables[0].Rows.Count > 0)
{
lblCafeteria.Text = Obj_Comm.ToTitleCase(DSdtls.Tables[0].Rows[0]["TemplateName"].ToString());
lblIssueDate.Text = Obj_Comm.ToTitleCase(DSdtls.Tables[0].Rows[0]["TemplateDate"].ToString());
}
if (DSdtls.Tables[1].Rows.Count > 0)
{
IssueRegGrid.DataSource = DSdtls.Tables[1];
IssueRegGrid.DataBind();
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
