public void BindRequisitionSummary() { TechnicalBAL objtechBAL = new TechnicalBAL(); DataSet dsReqSumm = new DataSet(); try { dsReqSumm = objtechBAL.GetRequisitionSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["Vessel_Code"].ToString()); if (dsReqSumm.Tables[0].Rows.Count > 0) { lblReqsntype.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["ReqsnType"]); txtCatalogueCode.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["System_Code"]); lblCatalog.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["Catalog"]); lblReqNo.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["RequistionCode"]); //lblTotalItem.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["TotalItems"]); lblToDate.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["ToDate"]); lblFunction.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["DeptName"]); lblReason.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["ReqComents"]); lblDeliveryPort.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["DeliveryPort"]); lblDeliveryDate.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["DELIVERY_DATE"]); btnAccountType.Text = "Account Type :" + " " + Convert.ToString(dsReqSumm.Tables[0].Rows[0]["VARIABLE_NAME"]); ddlAccountType.SelectedValue = dsReqSumm.Tables[0].Rows[0]["Account_Type"].ToString(); chkSendTovessel.Checked = Convert.ToBoolean(dsReqSumm.Tables[0].Rows[0]["Send_To_Vessel"]); ViewState["OnHold"] = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["OnHold"]); gvReqsnItems.DataSource = dsReqSumm.Tables[1]; gvReqsnItems.DataBind(); GridViewHelper helper = new GridViewHelper(this.gvReqsnItems); helper.RegisterGroup("Subsystem_Description", true, true); helper.GroupHeader += new GroupEvent(helper_GroupHeader); var Listselected = dsReqSumm.Tables[1].AsEnumerable().Select(r => r.Field <string>("ItemID")).ToArray(); hdnSelectedCde.Value = string.Join(",", Listselected); rpAttachment.DataSource = dsReqSumm.Tables[2]; rpAttachment.DataBind(); } else { String msg = String.Format("alert('This Requisition is not valid !'); window.close();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg156", msg, true); } if (UDFLib.ConvertToInteger(dsReqSumm.Tables[3].Rows[0][0].ToString()) > 0 && BLL_PURC_Common.Get_Bulk_Reqsn_Finalized(Request.QueryString["REQUISITION_CODE"]) > 0) { btnBulkPurchase.Enabled = true; } else { btnBulkPurchase.Enabled = false; } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
private void BindDataOnPostback() { DataSet dsReqSumm = objtechBAL.GetRequisitionSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["Vessel_Code"].ToString()); rpAttachment.DataSource = dsReqSumm.Tables[2]; rpAttachment.DataBind(); gvReqsnItems.DataSource = dsReqSumm.Tables[1]; gvReqsnItems.DataBind(); }
protected void imgbtnExportReqsnItems_Click(object s, EventArgs e) { BindDataOnPostback(); TechnicalBAL objtechBAL = new TechnicalBAL(); DataSet dsReqSumm = new DataSet(); dsReqSumm = objtechBAL.GetRequisitionSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["Vessel_Code"].ToString()); DataTable dtexportdata = dsReqSumm.Tables[1]; string[] HeaderCaptions = new string[] { "Sr No", "Sub Catalogue", "Drawing Number", "Part Number", " Short Description", "Long Description", "Unit", "Requested Qty" }; string[] DataColumnsName = new string[] { "SrNo", "Subsystem_Description", "Drawing_Number", "Part_Number", "ItemDesc", "Long_Description", "ItemUnit", "ReqestedQty" }; string FileHeaderName = "Items of requisition number : " + Request.QueryString["REQUISITION_CODE"]; string FileName = Request.QueryString["REQUISITION_CODE"]; GridViewExportUtil.ShowExcel(dtexportdata, HeaderCaptions, DataColumnsName, FileName, FileHeaderName); }
public void imgbtnDelete_Click(object s, EventArgs e) { BindDataOnPostback(); try { BLL_PURC_Purchase objAttch = new BLL_PURC_Purchase(); int ID = int.Parse(((ImageButton)s).CommandArgument.Split(new char[] { ',' })[0]); int res = objAttch.Purc_Delete_Reqsn_Attachments(ID); if (res > 0) { File.Delete(Server.MapPath(((ImageButton)s).CommandArgument.Split(new char[] { ',' })[1])); } LoadFiles(null, null); DataSet dsReqSumm = new DataSet(); TechnicalBAL objtechBAL = new TechnicalBAL(); dsReqSumm = objtechBAL.GetRequisitionSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["Vessel_Code"].ToString()); rpAttachment.DataSource = dsReqSumm.Tables[2]; rpAttachment.DataBind(); } catch { } }
protected void Page_Load(object sender, EventArgs e) { string strRptPath = Server.MapPath("."); string Selection = Request.QueryString["RptType"].ToString(); DataSet dsReqSumm; TechnicalBAL objtechBAL; ConnectionInfo cInfo = new ConnectionInfo(); TableLogOnInfo logOnInfo = new TableLogOnInfo(); string connstring = System.Configuration.ConfigurationManager.ConnectionStrings["smsconn"].ToString(); string[] conn = connstring.ToString().Split(';'); string[] serverInfo = conn[0].ToString().Split('='); string[] DbInfo = conn[1].ToString().Split('='); string[] userInfo = conn[2].ToString().Split('='); string[] passwordInfo = conn[3].ToString().Split('='); cInfo.ServerName = serverInfo[1].ToString(); cInfo.DatabaseName = DbInfo[1].ToString(); cInfo.UserID = userInfo[1].ToString(); cInfo.Password = passwordInfo[1].ToString(); switch (Selection) { //For Requistion Summary case "ReqSumry": objtechBAL = new TechnicalBAL(); dsReqSumm = new DataSet(); dsReqSumm = objtechBAL.GetRequisitionSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["Vessel_Code"].ToString()); ReportDocument rptSumryDoc = new ReportDocument(); rptSumryDoc.Load(strRptPath + "\\RptRequisitionSummary.rpt"); rptSumryDoc.OpenSubreport("Items").SetDataSource(dsReqSumm.Tables[1]); rptSumryDoc.SetDataSource(dsReqSumm.Tables[0]); SummaryReportViewer.ReportSource = rptSumryDoc; SummaryReportViewer.DisplayGroupTree = false; SummaryReportViewer.DisplayToolbar = true; break; //For Quotation Summary case "QtnSumry": objtechBAL = new TechnicalBAL(); dsReqSumm = new DataSet(); dsReqSumm = objtechBAL.GetRequQuotationSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["Vessel_Code"].ToString(), Request.QueryString["QUOTATION_CODE"].ToString()); ReportDocument rptSumryDocQtn = new ReportDocument(); rptSumryDocQtn.Load(strRptPath + "\\RptQuotationSummary.rpt"); rptSumryDocQtn.OpenSubreport("RptSubRFQSent").SetDataSource(dsReqSumm.Tables[3]); rptSumryDocQtn.OpenSubreport("RptSubQuotationReceived").SetDataSource(dsReqSumm.Tables[2]); rptSumryDocQtn.SetDataSource(dsReqSumm.Tables[0]); SummaryReportViewer.ReportSource = rptSumryDocQtn; SummaryReportViewer.DisplayGroupTree = false; SummaryReportViewer.DisplayToolbar = true; break; //For Delivery Order Summary case "DelvSumry": objtechBAL = new TechnicalBAL(); dsReqSumm = new DataSet(); dsReqSumm = objtechBAL.GetDeliveryOrderSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["Vessel_Code"].ToString(), Request.QueryString["DELIVERY_CODE"].ToString()); ReportDocument rptSumryDelv = new ReportDocument(); rptSumryDelv.Load(strRptPath + "\\RptDeliverOrderSummary.rpt"); rptSumryDelv.OpenSubreport("RptSubDeliverOrderSummaryItem").SetDataSource(dsReqSumm.Tables[2]); rptSumryDelv.OpenSubreport("RptSubDeliverOrderSummaryAttachment").SetDataSource(dsReqSumm.Tables[1]); rptSumryDelv.SetDataSource(dsReqSumm.Tables[0]); SummaryReportViewer.ReportSource = rptSumryDelv; SummaryReportViewer.DisplayGroupTree = false; SummaryReportViewer.DisplayToolbar = true; break; } }