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); } }