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