protected void fillGrid() { ArrayList rfqProdList = (ArrayList)Session[SessionFactory.ALL_PURCHASE_ALL_RFQ_PROD_QNTY]; ArrayList rfqSpecList = (ArrayList)Session[SessionFactory.ALL_PURCHASE_ALL_RFQ_RFQ_SPEC]; float totalAmountFrom = 0, totalAmountTo = 0; String rfqId = Session[SessionFactory.ALL_PURCHASE_ALL_RFQ_SELECTED_RFQ_ID].ToString(); DataTable dt = new DataTable(); dt.Columns.Add("Hidden"); dt.Columns.Add("CategoryName"); dt.Columns.Add("featureDataTable"); dt.Columns.Add("FromQnty"); dt.Columns.Add("ToQnty"); dt.Columns.Add("FromPrice"); dt.Columns.Add("ToPrice"); dt.Columns.Add("msrmntUnit"); //dt.Columns.Add("HiddenCatId"); dt.Columns.Add("Quote"); // dt.Columns.Add("QuoteUnit"); dt.Columns.Add("Total"); //dt.Columns.Add("Audit"); Dictionary <String, RFQResponseQuotes> rfqRespQuoteDict = BackEndObjects.RFQResponseQuotes. getAllResponseQuotesforRFQandResponseEntityDB(rfqId, Session[SessionFactory.ALL_PURCHASE_ALL_RFQ_SHOW_QUOTE_SELECTED_RESP_ENTITY_ID].ToString()); String contactEntId = ""; for (int i = 0; i < rfqProdList.Count; i++) { BackEndObjects.RFQProdServQnty rfqProdObj = (BackEndObjects.RFQProdServQnty)rfqProdList[i]; dt.Rows.Add(); dt.Rows[i]["Hidden"] = rfqProdObj.getProdCatId(); dt.Rows[i]["CategoryName"] = BackEndObjects.ProductCategory. getProductCategorybyIdwoFeaturesDB(rfqProdObj.getProdCatId()).getProductCategoryName(); //dt.Rows[i]["featureDataTable"] = dtSpec; dt.Rows[i]["FromQnty"] = rfqProdObj.getFromQnty(); dt.Rows[i]["ToQnty"] = rfqProdObj.getToQnty(); dt.Rows[i]["FromPrice"] = rfqProdObj.getFromPrice(); dt.Rows[i]["ToPrice"] = rfqProdObj.getToPrice(); dt.Rows[i]["msrmntUnit"] = rfqProdObj.getMsrmntUnit(); RFQResponseQuotes rfqRespObj = new RFQResponseQuotes(); try { rfqRespObj = rfqRespQuoteDict[rfqProdObj.getProdCatId()]; contactEntId = rfqRespObj.getResponseEntityId(); String respQuote = rfqRespObj.getQuote().Equals("") ? "0" : rfqRespObj.getQuote();; dt.Rows[i]["Quote"] = respQuote; //dt.Rows[i]["QuoteUnit"] = rfqRespObj.getUnitName(); totalAmountFrom = totalAmountFrom + (rfqProdObj.getFromQnty() * float.Parse(respQuote)); totalAmountTo = totalAmountTo + (rfqProdObj.getToQnty() * float.Parse(respQuote)); dt.Rows[i]["Total"] = (rfqProdObj.getFromQnty() * float.Parse(respQuote)) + " to " + (rfqProdObj.getToQnty() * float.Parse(respQuote)); } catch (KeyNotFoundException e) { //If no response given to this RFQ by this entity so far dt.Rows[i]["Quote"] = "0"; dt.Rows[i]["Total"] = "0"; } } Label_RFQ_Name.Text = rfqId; //Label_Vendor.Text = Dictionary <String, Object> contactDict = ActionLibrary.customerDetails.getContactDetails(contactEntId, Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString()); if (contactDict.ContainsKey(ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_CONTACT_DETAILS)) { Label_Vendor.Text = ((BackEndObjects.Contacts)contactDict[ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_CONTACT_DETAILS]).getContactName(); } else { Label_Vendor.Text = ((BackEndObjects.MainBusinessEntity)contactDict[ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_MAIN_BUSINESS_ENTITY]).getEntityName(); } GridView1.DataSource = dt; GridView1.DataBind(); GridView1.Columns[0].Visible = false; foreach (GridViewRow gVR in GridView1.Rows) { DataTable dtSpec = new DataTable(); dtSpec.Columns.Add("Hidden"); dtSpec.Columns.Add("FeatName"); dtSpec.Columns.Add("SpecText"); dtSpec.Columns.Add("FromSpec"); dtSpec.Columns.Add("ToSpec"); int rowCount = 0; for (int j = 0; j < rfqSpecList.Count; j++) { BackEndObjects.RFQProductServiceDetails rfqSpecObj = (BackEndObjects.RFQProductServiceDetails)rfqSpecList[j]; if (rfqSpecObj.getPrdCatId().Equals(((Label)gVR.Cells[1].FindControl("Label_Hidden")).Text)) { dtSpec.Rows.Add(); String featName = BackEndObjects.Features.getFeaturebyIdwoSpecDB(rfqSpecObj.getFeatId()).getFeatureName(); dtSpec.Rows[rowCount]["Hidden"] = rfqSpecObj.getFeatId(); dtSpec.Rows[rowCount]["FeatName"] = (featName != null ? featName.Trim() : ""); dtSpec.Rows[rowCount]["SpecText"] = rfqSpecObj.getSpecText(); if (!rfqSpecObj.getFromSpecId().Equals("")) { dtSpec.Rows[rowCount]["FromSpec"] = BackEndObjects.Specifications. getSpecificationDetailbyIdDB(rfqSpecObj.getFromSpecId()).getSpecName(); } if (!rfqSpecObj.getToSpecId().Equals("")) { dtSpec.Rows[rowCount]["ToSpec"] = BackEndObjects.Specifications. getSpecificationDetailbyIdDB(rfqSpecObj.getToSpecId()).getSpecName(); } rowCount++; } } ((GridView)gVR.Cells[2].FindControl("GridView1_Inner")).DataSource = dtSpec; ((GridView)gVR.Cells[2].FindControl("GridView1_Inner")).DataBind(); ((GridView)gVR.Cells[2].FindControl("GridView1_Inner")).Visible = true; ((GridView)gVR.Cells[2].FindControl("GridView1_Inner")).Columns[1].Visible = false; } GridView1.Visible = true; Session[SessionFactory.ALL_PURCHASE_ALL_RFQ_RESP_QUOTE_GRID_DATA] = dt; Label_Total.Text = totalAmountFrom + " to " + totalAmountTo; }
protected void generateLead() { if (DropDownList_Level1.SelectedValue.Equals("_")) { Label_Status.Text = "Please select one product category"; Label_Status.ForeColor = System.Drawing.Color.Red; Label_Status.Visible = true; Button_Submit_Next0.Enabled = true; Button_Submit_Next.Enabled = true; Button_Submit_Extra_Prd_Srv.Enabled = true; } else { BackEndObjects.RFQDetails rfqObj = new BackEndObjects.RFQDetails(); BackEndObjects.Id idGen = new BackEndObjects.Id(); String rfqId = ""; if (Session[SessionFactory.CREATE_LEAD_RFQ_ID] == null) { rfqId = idGen.getNewId(BackEndObjects.Id.ID_TYPE_RFQ_STRING); Session[SessionFactory.CREATE_LEAD_RFQ_ID] = rfqId; //store the newly created RFQ id in the session } if (!TextBox_Spec.Text.Equals("")) { getAddintionalProdSrvList(); TextBox_Spec.Text = ""; } ArrayList rfqSpecObjList = (ArrayList)Session[SessionFactory.CREATE_LEAD_SELECTED_RFQ_SPEC_MAP]; //Set the RFQ id for all the spec objects if (rfqSpecObjList != null) { for (int i = 0; i < rfqSpecObjList.Count; i++) { ((BackEndObjects.RFQProductServiceDetails)rfqSpecObjList[i]).setRFQId(rfqId); } } rfqObj.setRFQProdServList(rfqSpecObjList); rfqObj.setRFQId(rfqId); rfqObj.setCreatedUsr(User.Identity.Name); rfqObj.setActiveStat(BackEndObjects.RFQDetails.RFQ_ACTIVE_STAT_ACTIVE); rfqObj.setDueDate(TextBox_Within_Date.Text); //For Manually Created Lead entity id and CreateEntityId is different for the same rfq/lead object rfqObj.setEntityId(DropDownList_Contacts.SelectedValue); rfqObj.setCreatedEntity(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString()); // FileUpload1=(FileUpload1 == null ? (FileUpload)Session[SessionFactory.CREATE_RFQ_NDA_FILE] : FileUpload1); String localId = (!DropDownList_Locality.SelectedValue.Equals("_") && !DropDownList_Locality.SelectedValue.Equals("") ? DropDownList_Locality.SelectedValue : (!DropDownList_City.SelectedValue.Equals("_") && !DropDownList_City.SelectedValue.Equals("") ? DropDownList_City.SelectedValue : (!DropDownList_State.SelectedValue.Equals("_") && !DropDownList_State.SelectedValue.Equals("") ? DropDownList_State.SelectedValue : (!DropDownList_Country.SelectedValue.Equals("_") && !DropDownList_Country.SelectedValue.Equals("") ? DropDownList_Country.SelectedValue:"")))); rfqObj.setLocalityId(localId); rfqObj.setSubmitDate(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); rfqObj.setTermsandConds(TextBox_TnC.Text); rfqObj.setRFQName(TextBox_Reqr_Name.Text); rfqObj.setCreateMode(RFQDetails.CREATION_MODE_MANUAL); rfqObj.setCurrency(DropDownList_Curr.SelectedValue); BackEndObjects.RFQProdServQnty rfqPrdQnty = new BackEndObjects.RFQProdServQnty(); rfqPrdQnty.setRFQId(rfqObj.getRFQId()); rfqPrdQnty.setFromPrice(TextBox_Price_Range_From.Text); rfqPrdQnty.setToPrice(TextBox_Price_Range_To.Text); rfqPrdQnty.setFromQnty(float.Parse(TextBox_Prod_Qnty_From.Text)); rfqPrdQnty.setToQnty(float.Parse(TextBoxrod_Qnty_To.Text)); rfqPrdQnty.setMsrmntUnit(DropDownList_Unit_Of_Msrmnt.SelectedValue); rfqPrdQnty.setProdCatId(Session[SessionFactory.CREATE_LEAD_SELECTED_PRODUCT_CAT].ToString()); //ArrayList rfqPrdQntyList = new ArrayList(); //rfqPrdQntyList.Add(rfqPrdQnty); ArrayList prodSrvQntyList = (ArrayList)Session[SessionFactory.CREATE_LEAD_PROD_SRV_QNTY_LIST]; if (prodSrvQntyList == null) { prodSrvQntyList = new ArrayList(); } prodSrvQntyList.Add(rfqPrdQnty); //Ensure that all objects in the arraylist has an associated rfqid for (int i = 0; i < prodSrvQntyList.Count; i++) { BackEndObjects.RFQProdServQnty temp = (RFQProdServQnty)prodSrvQntyList[i]; if (temp.getRFQId() == null || temp.getRFQId().Equals("")) { temp.setRFQId(rfqObj.getRFQId()); } } rfqObj.setRFQProdServQntyList(prodSrvQntyList); Dictionary <String, String> reqSpecUniqnessValidation = new Dictionary <string, string>(); if (rfqSpecObjList != null) { for (int i = 0; i < rfqSpecObjList.Count; i++) { BackEndObjects.RFQProductServiceDetails rfqSpecObj = (BackEndObjects.RFQProductServiceDetails)rfqSpecObjList[i]; if (reqSpecUniqnessValidation.ContainsKey(rfqSpecObj.getPrdCatId() + ":" + rfqSpecObj.getFeatId())) { rfqSpecObjList.RemoveAt(i);//Remove the current RFQ spec object from the list - otherwise it will cause exception at DB layer while inserting } else { reqSpecUniqnessValidation.Add(rfqSpecObj.getPrdCatId() + ":" + rfqSpecObj.getFeatId(), ""); if (rfqSpecObj.getFileStream() != null) { rfqSpecObj.setImgPathInFileStore(rfqObj.getEntityId()); } } } } BackEndObjects.RFQResponse leadRespObj = new RFQResponse(); leadRespObj.setRespEntityId(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString()); leadRespObj.setRFQId(Session[SessionFactory.CREATE_LEAD_RFQ_ID].ToString()); leadRespObj.setRespDate(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); leadRespObj.setNextFollowupDate(TextBox_Fwp_Date.Text); leadRespObj.setAssignedTo(DropDownList_Users.SelectedValue); //Load the document for the lead response if (FileUpload1 != null && FileUpload1.HasFile) { leadRespObj.setFileStream(FileUpload1); leadRespObj.setNDADocPathInFileStore(leadRespObj.getRespEntityId()); } else if ((FileUpload)Session[SessionFactory.CREATE_LEAD_NDA_FILE] != null && ((FileUpload)Session[SessionFactory.CREATE_LEAD_NDA_FILE]).HasFile) { leadRespObj.setFileStream((FileUpload)Session[SessionFactory.CREATE_LEAD_NDA_FILE]); leadRespObj.setNDADocPathInFileStore(leadRespObj.getRespEntityId()); } ArrayList leadRespQuoteList = (ArrayList)Session[SessionFactory.CREATE_LEAD_RESP_QUOTE_LIST]; if (leadRespQuoteList == null) { leadRespQuoteList = new ArrayList(); } BackEndObjects.RFQResponseQuotes respQuoteObj = new RFQResponseQuotes(); respQuoteObj.setPrdCatId(Session[SessionFactory.CREATE_LEAD_SELECTED_PRODUCT_CAT].ToString()); respQuoteObj.setQuote((TextBox_Quote_Amnt.Text.Equals("") ? "0" : TextBox_Quote_Amnt.Text)); respQuoteObj.setResponseEntityId(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString()); respQuoteObj.setResponseUsrId(User.Identity.Name); //respQuoteObj.setUnitName(Session[SessionFactory.CREATE_LEAD_QUOTE_UNIT].ToString()); respQuoteObj.setUnitName(Label_Per_Unit.Text); respQuoteObj.setProductName((!TextBox_Prod_Name.Text.Equals("") ? TextBox_Prod_Name.Text.Trim() : DropDownList_Prod_List.SelectedItem.Text)); leadRespQuoteList.Add(respQuoteObj); //Ensure that all objects in the arraylist has an associated rfqid for (int i = 0; i < leadRespQuoteList.Count; i++) { BackEndObjects.RFQResponseQuotes temp = (RFQResponseQuotes)leadRespQuoteList[i]; if (temp.getRFQId() == null || temp.getRFQId().Equals("")) { temp.setRFQId(rfqObj.getRFQId()); } } leadRespObj.setResponseQuoteList(leadRespQuoteList); ActionLibrary.SalesActions._createLeads cL = new ActionLibrary.SalesActions._createLeads(); LeadRecord leadObj = new LeadRecord(); leadObj.setRFQProdServList(rfqObj.getRFQProdServList()); leadObj.setRFQId(rfqObj.getRFQId()); leadObj.setActiveStat(rfqObj.getActiveStat()); leadObj.setApprovalStat(rfqObj.getApprovalStat()); leadObj.setCreatedEntity(rfqObj.getCreatedEntity()); leadObj.setCreatedUsr(rfqObj.getCreatedUsr()); leadObj.setCreateMode(rfqObj.getCreateMode()); leadObj.setDueDate(rfqObj.getDueDate()); leadObj.setEntityId(rfqObj.getEntityId()); leadObj.setFileStream(rfqObj.getFileStream()); leadObj.setLocalityId(rfqObj.getLocalityId()); leadObj.setNDADocPath(rfqObj.getNDADocPath()); leadObj.setReqId(rfqObj.getReqId()); leadObj.setRFQName(rfqObj.getRFQName()); leadObj.setRFQProdServQntyList(rfqObj.getRFQProdServQntyList()); leadObj.setSubmitDate(rfqObj.getSubmitDate()); leadObj.setTermsandConds(rfqObj.getTermsandConds()); leadObj.setCurrency(rfqObj.getCurrency()); leadObj.setLeadResp(leadRespObj); try { cL.createNewLead(leadObj, Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString(), User.Identity.Name); Label_Status.Text = "Lead created successfully"; Label_Status.ForeColor = System.Drawing.Color.Green; Label_Status.Visible = true; DataTable dt = (DataTable)Session[SessionFactory.ALL_SALE_ALL_LEAD_GRID_DATA]; Dictionary <String, Currency> allCurrList = (Dictionary <String, Currency>)Session[SessionFactory.CURRENCY_LIST]; //DateUtility dU = new DateUtility(); dt.Rows.Add(); int count = dt.Rows.Count - 1; dt.Rows[count]["RFQNo"] = leadObj.getRFQId(); dt.Rows[count]["RFQName"] = leadObj.getRFQName(); String alertRequired = "true"; for (int j = 0; j < leadRespQuoteList.Count; j++) { RFQResponseQuotes QuoteObj = (RFQResponseQuotes)leadRespQuoteList[j]; if (!QuoteObj.getQuote().Equals("0")) { alertRequired = "false"; break; } } DateUtility dU = new DateUtility(); dt.Rows[count]["Lead_Alert_Required"] = alertRequired; dt.Rows[count]["CustName"] = DropDownList_Contacts.SelectedItem.Text; dt.Rows[count]["CustId"] = leadObj.getEntityId(); dt.Rows[count]["curr"] = allCurrList.ContainsKey(leadObj.getCurrency()) ? allCurrList[leadObj.getCurrency()].getCurrencyName() : ""; dt.Rows[count]["Submit Date"] = leadObj.getSubmitDate(); dt.Rows[count]["Submit Date Ticks"] = Convert.ToDateTime(leadObj.getSubmitDate()).Ticks; dt.Rows[count]["Due Date"] = dU.getConvertedDateWoTime(leadObj.getDueDate()); dt.Rows[count]["Due Date Ticks"] = !dt.Rows[count]["Due Date"].Equals("") ? Convert.ToDateTime(leadObj.getDueDate()).Ticks : 0; dt.Rows[count]["Next Date"] = dU.getConvertedDateWoTime(TextBox_Fwp_Date.Text.Trim()); dt.Rows[count]["Next Date Ticks"] = (!dt.Rows[count]["Next Date"].Equals("") ? Convert.ToDateTime(TextBox_Fwp_Date.Text).Ticks : 0); dt.Rows[count]["Assgn To"] = (!DropDownList_Users.SelectedValue.Equals("") ? DropDownList_Users.SelectedValue : ""); dt.Rows[count]["ActiveStat"] = leadObj.getActiveStat(); dt.Rows[count]["Mode"] = leadObj.getCreateMode(); dt.DefaultView.Sort = "Submit Date Ticks" + " " + "DESC"; Session[SessionFactory.ALL_SALE_ALL_LEAD_GRID_DATA] = dt.DefaultView.ToTable(); ScriptManager.RegisterStartupScript(this, typeof(string), "RefreshLeadGrid", "RefreshParent();", true); } catch (Exception ex) { Label_Status.Text = "Lead creation failed"; Label_Status.ForeColor = System.Drawing.Color.Red; Label_Status.Visible = true; } finally { Session.Remove(SessionFactory.CREATE_LEAD_SELECTED_RFQ_SPEC_MAP); Session.Remove(SessionFactory.CREATE_LEAD_RFQ_ID); Session.Remove(SessionFactory.CREATE_LEAD_PROD_SRV_QNTY_LIST); Session.Remove(SessionFactory.CREATE_LEAD_NDA_FILE); Session.Remove(SessionFactory.CREATE_LEAD_RESP_QUOTE_LIST); Session.Remove(SessionFactory.CREATE_LEAD_QUOTE_UNIT); } } }
protected void loadProductGrid() { String context = Request.QueryString.GetValues("context")[0]; String[] rfqId = Request.QueryString.GetValues("rfqId"); String respEntId = ""; ArrayList rfqSpecList = null; if (context.Equals("client")) { respEntId = Request.QueryString.GetValues("respCompId")[0]; rfqSpecList = (ArrayList)Session[SessionFactory.ALL_PURCHASE_ALL_RFQ_RFQ_SPEC]; } else { respEntId = Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString(); rfqSpecList = (ArrayList)Session[SessionFactory.ALL_SALE_ALL_POTENTIAL_POTN_SPEC]; } DataTable dt = new DataTable(); dt.Columns.Add("Hidden_Cat_Id"); dt.Columns.Add("Serial"); dt.Columns.Add("Qnty"); dt.Columns.Add("Prod_Name"); dt.Columns.Add("Cat_Name"); dt.Columns.Add("Unit_Price"); dt.Columns.Add("Cat_Total"); float totalAmnt = 0; ArrayList rfqQntyList = BackEndObjects.RFQProdServQnty.getRFQProductServiceQuantityforRFIdDB(rfqId[0]); Dictionary <String, RFQResponseQuotes> respQuoteDict = BackEndObjects.RFQResponseQuotes.getAllResponseQuotesforRFQandResponseEntityDB(rfqId[0], respEntId); int k = 0; for (int i = 0; i < rfqQntyList.Count; i++) { BackEndObjects.RFQProdServQnty rfqQntyObj = (RFQProdServQnty)rfqQntyList[i]; //Preference to toQuantity float qnty = rfqQntyObj.getToQnty() > 0 ? rfqQntyObj.getToQnty() : rfqQntyObj.getFromQnty(); String catId = rfqQntyObj.getProdCatId(); RFQResponseQuotes respQuoteObj = respQuoteDict != null && respQuoteDict.ContainsKey(catId)?respQuoteDict[catId]:null; if (respQuoteObj != null) { String quote = respQuoteObj.getQuote(); String prodName = respQuoteObj.getProductName(); dt.Rows.Add(); dt.Rows[k]["Hidden_Cat_Id"] = catId; dt.Rows[k]["Serial"] = k + 1; dt.Rows[k]["Qnty"] = qnty.ToString(); dt.Rows[k]["Prod_Name"] = prodName; dt.Rows[k]["Cat_Name"] = BackEndObjects.ProductCategory.getProductCategorybyIdwoFeaturesDB(catId).getProductCategoryName(); dt.Rows[k]["Unit_Price"] = quote; dt.Rows[k]["Cat_Total"] = float.Parse(quote) * qnty; totalAmnt += float.Parse(quote) * qnty; k++; } } if (dt != null && dt.Rows.Count > 0) { GridView1.Visible = true; GridView1.DataSource = dt; GridView1.DataBind(); GridView1.Columns[0].Visible = false; foreach (GridViewRow gVR in GridView1.Rows) { DataTable dtSpec = new DataTable(); dtSpec.Columns.Add("Hidden"); dtSpec.Columns.Add("FeatName"); dtSpec.Columns.Add("SpecText"); dtSpec.Columns.Add("FromSpec"); dtSpec.Columns.Add("ToSpec"); int rowCount = 0; for (int j = 0; j < rfqSpecList.Count; j++) { BackEndObjects.RFQProductServiceDetails rfqSpecObj = (BackEndObjects.RFQProductServiceDetails)rfqSpecList[j]; if (rfqSpecObj.getPrdCatId().Equals(((Label)gVR.Cells[1].FindControl("Label_Hidden")).Text)) { dtSpec.Rows.Add(); String featName = BackEndObjects.Features.getFeaturebyIdwoSpecDB(rfqSpecObj.getFeatId()).getFeatureName(); dtSpec.Rows[rowCount]["Hidden"] = rfqSpecObj.getFeatId(); dtSpec.Rows[rowCount]["FeatName"] = (featName != null ? featName.Trim() : ""); dtSpec.Rows[rowCount]["SpecText"] = rfqSpecObj.getSpecText(); if (!rfqSpecObj.getFromSpecId().Equals("")) { dtSpec.Rows[rowCount]["FromSpec"] = BackEndObjects.Specifications.getSpecificationDetailbyIdDB(rfqSpecObj.getFromSpecId()).getSpecName(); } if (!rfqSpecObj.getToSpecId().Equals("")) { dtSpec.Rows[rowCount]["ToSpec"] = BackEndObjects.Specifications.getSpecificationDetailbyIdDB(rfqSpecObj.getToSpecId()).getSpecName(); } rowCount++; } } ((GridView)gVR.Cells[2].FindControl("GridView1_Inner")).DataSource = dtSpec; ((GridView)gVR.Cells[2].FindControl("GridView1_Inner")).DataBind(); ((GridView)gVR.Cells[2].FindControl("GridView1_Inner")).Visible = true; ((GridView)gVR.Cells[2].FindControl("GridView1_Inner")).Columns[0].Visible = false; } Label_Sub_Total_Amount_Value.Visible = true; Label_Sub_Total_Amount_Value.Text = totalAmnt.ToString(); Label_Total_Amount_Value.Visible = true; Label_Total_Amount_Value.Text = updateTotalPOAmount(); } else { //Warning --- no prod specification found GridView1.Visible = false; Label_GridView_Status.Visible = true; if (context.Equals("client")) { Label_GridView_Status.Text = "* No product details added in the RFQ. Only product details added in RFQ will populate in Purchase Order"; } else { Label_GridView_Status.Text = "* No product details added in the Potential. Only product details added in Potential will populate in Sales Order"; } Label_GridView_Status.ForeColor = System.Drawing.Color.Red; } Session[SessionFactory.ALL_PURCHASE_FINALIZE_DEAL_PO_PROD_GRID] = dt; }