/// <summary> /// Used to bind repeter of RFQ Sent,Quotation Recieve and Attachment /// </summary> public void BindQuotationSummary() { try { TechnicalBAL objtechBAL = new TechnicalBAL(); DataSet 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()); if (dsReqSumm.Tables[0].Rows.Count > 0) { 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"]); lblVessel.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["VesselName"]); txtComments.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["ReqComents"]); //--File Attachements. rpAttachment.DataSource = dsReqSumm.Tables[1]; rpAttachment.DataBind(); //----Quotation Sent RepeaterRfqSent.DataSource = dsReqSumm.Tables[3]; RepeaterRfqSent.DataBind(); //----Quotation Received RepeaterQtnRcv.DataSource = dsReqSumm.Tables[2]; RepeaterQtnRcv.DataBind(); foreach (RepeaterItem item in RepeaterQtnRcv.Items) { if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem) { System.Web.UI.HtmlControls.HtmlTableCell tdOrderLabel = (System.Web.UI.HtmlControls.HtmlTableCell)item.FindControl("tdOrderLabel"); tdOrderLabel.Visible = false; } } ViewState["QuotationItemsDetails"] = true; ViewState["QuotationItemsDetails"] = dsReqSumm.Tables[4]; } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
/// <summary> /// This Method is used to bind additional details RFQ RECIEVE /// </summary> /// <param name="Quotation_Code"></param> public void BindAdditionalDetails(string Quotation_Code) { try { TechnicalBAL objtechBAL = new TechnicalBAL(); clsQuotationBLL objQuoBLL = new clsQuotationBLL(); DataSet dsReqSumm = new DataSet(); dsReqSumm = objtechBAL.GetRequQuotationSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["Vessel_Code"].ToString(), Quotation_Code.ToString()); if (dsReqSumm.Tables[5].Rows.Count > 0) { lblMaker.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Maker"]); lblSystemParticulars.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Particulars"]); lblModel.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Model"]); lblSerialNumber.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["System_Serial_Number"]); lblBargeWorkboatCost.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Barge_Workboat_Cost"]); lblTruckCost.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Truck_Cost"]); lblOtherCost.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Other_Charges"]); lblROC.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Other_Charges_Reason"]); lblTruckingFreightCost.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Freight_Cost"]); lblPKGHandlingCost.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Packing_Handling_Charges"]); lblTotalDiscount.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["DISCOUNT"]); lblSQR.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Supplier_Quotation_Reference"]); lblSRemark.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["QUOTATION_REMARKS"]); lblReasonPHC.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["REASON_TRANS_PKG"]); lblAccountCode.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["ACCOUNT_CODE"]); } if (dsReqSumm.Tables[6].Rows.Count > 0) { lblVATGST.Text = Convert.ToString(dsReqSumm.Tables[6].Rows[0]["Vat"]); } if (dsReqSumm.Tables[7].Rows.Count > 0) { lblTotalPrice.Text = Math.Round(Convert.ToDecimal(dsReqSumm.Tables[7].Rows[0]["TotalPrice"]), 2).ToString(); } CalculateDiscount(); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
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; } }