protected void RatesAmenitiesNextBtn_Click(object sender, EventArgs e) { updateAmmeneites(); //return; //progressTextHotelInfo.Text = "Hotel Information | Complete"; // progressTextHotelInfo.ForeColor = System.Drawing.Color.Black; //progressbarAmmen.Text = "2014 Rates & Amenities | Complete"; //progressbarAmmen.ForeColor = System.Drawing.Color.Black; //RadTab HotelInformationTab = OvationTabs.FindTabByValue("Hotel_Info"); RadTab RatesAmenities_Tab = OvationTabs.FindTabByValue("Rates_Amenities"); RadTab Marketing_pkgs_Tab = OvationTabs.FindTabByValue("Marketing_pkgs"); // HotelInformationTab.Enabled = false; //RatesAmenities_Tab.Enabled = false; // Marketing_pkgs_Tab.Enabled = true; Marketing_pkgs_Tab.Selected = true; marketingPCKsView.Selected = true; HotelInfoCodeBlock.Visible = false; AmenitiesCodeBlock.Visible = false; //MktgCodeBlock.Visible = true; ElectronicSigCodeBlock.Visible = false; }
protected void HotelInfoNextBtn_Click(object sender, EventArgs e) { RadTab RatesAmenities_Tab = OvationTabs.FindTabByValue("Rates_Amenities"); UpdateHotelInfo(); //progressTextHotelInfo.Text = "Hotel Information | Complete"; //progressTextHotelInfo.ForeColor = System.Drawing.Color.Black; //RadTab HotelInformationTab = OvationTabs.FindTabByValue("Hotel_Info"); //HotelInformationTab.Enabled = false; //RatesAmenities_Tab.Enabled = true; RatesAmenities_Tab.Selected = true; RatesAmenitiesView.Selected = true; HotelInfoCodeBlock.Visible = false; AmenitiesCodeBlock.Visible = true; //MktgCodeBlock.Visible = false; ElectronicSigCodeBlock.Visible = false; Ammenities_Num_roomshotel.Attributes.Add("onkeydown", "javascript:return jsNumbers(event);"); }
// marketing button click sub protected void MarketingPacksNextBtn_Click(object sender, EventArgs e) { // define our next tab to be selected on full validation of form ///////////// RadTab EelectronicTabMktButton = OvationTabs.FindTabByValue("Electronic_Sig"); updateMarkeing(); //selectMarketing(); UpdateHotelInfo(); updateAmmeneites(); string SalesContactName_Mgk = string.Empty; string SalesContactTitle_Mgk = string.Empty; string SalesContactTelephone_Mgk = string.Empty; string SalesContactFax_Mgk = string.Empty; string HotelName_Mgk = string.Empty; string SalesContactEmail_Mgk = string.Empty; string HotelAddrOne_Mgk = string.Empty; string Hotelgeneralmgr_Mgk = string.Empty; string HotelAddrTwo_Mgk = string.Empty; string DirectorofSales_Mgk = string.Empty; string Hotelcity_Mgk = string.Empty; string HotelWebSite_Mgk = string.Empty; string HotelInfoStateStr_Mgk = string.Empty; string HotelcountryStr_Mgk = string.Empty; string Hotelzippostcode_Mgk = string.Empty; string HotelMainphone_Mgk = string.Empty; string AAAatingStr_Mgk = string.Empty; string MobileStaRateStr_Mgk = string.Empty; string Hotelbriefdescipt_Mgk = string.Empty; string EnviromentProgram_Mgk = string.Empty; string avtiveRecycle_Mgk = string.Empty; string Property_Responsible_Cleaners_Mgk = string.Empty; string Property_WaterConserve_Mgk = string.Empty; /// ammeneties section ////////////////////// string percentage_Mgk = string.Empty; string LRAchoice_Mkt = string.Empty; string Floating_Bar_Dynamic_Mgk = string.Empty; string WoulextendRateYN_Mgk = string.Empty; string IsProperty_Virtuoso_Mgk = string.Empty; string internetGuestRoom_Mgk = string.Empty; string internetPublicSpace_Mgk = string.Empty; string propertyrenovation2014_Mgk = string.Empty; //string PropRenovationDetails_Mkt = string.Empty; string Nosmoking_Mgk = string.Empty; string Num_roomshotel_Mgk = string.Empty; string noToWalk_Mgk = string.Empty; /// marketing section string whatMarketPack_Mgk = string.Empty; using (SqlConnection RFPreviewMkgt_Conn = new SqlConnection(RFPDBconnStr)) { using (SqlCommand RFPreviewMkgt_cmd = new SqlCommand("SELECT Tbl_Hotel_PHC_HotelInfoPartialOne.szSabrePropertyNo, Tbl_Hotel_PHC_HotelInfoPartialOne.szApolloPropertyNo, Tbl_Hotel_PHC_HotelInfoPartialOne.szSabreChainCode, Tbl_Hotel_PHC_HotelInfoPartialOne.szApolloChainCode, Tbl_Hotel_PHC_HotelInfoPartialOne.szAddress, Tbl_Hotel_PHC_HotelInfoPartialOne.szAddressTwo, Tbl_Hotel_PHC_HotelInfoPartialOne.szCity, Tbl_Hotel_PHC_HotelInfoPartialOne.szState, Tbl_Hotel_PHC_HotelInfoPartialOne.szZipCode, Tbl_Hotel_PHC_HotelInfoPartialOne.szCountry, Tbl_Hotel_PHC_HotelInfoPartialOne.szElectronicSig, Tbl_Hotel_PHC_HotelInfoPartialOne.szElectronicSigCmt, tbl_Hotel_PHC_Contacts.szName, tbl_Hotel_PHC_Contacts.szTitle, tbl_Hotel_PHC_Contacts.szHotelPhone, tbl_Hotel_PHC_Contacts.szPhone, tbl_Hotel_PHC_Contacts.szFax, tbl_Hotel_PHC_Contacts.szEmail, tbl_Hotel_PHC_Contacts.szDirector, tbl_Hotel_PHC_Property.szPrefHotelName, tbl_Hotel_PHC_Property.szGeneralMgr, tbl_Hotel_PHC_Property.szWebSite, tbl_Hotel_PHC_Property.szDiamondRating, tbl_Hotel_PHC_Property.szStarRating, tbl_Hotel_PHC_Property.szDiscountOff, tbl_Hotel_PHC_Property.szLastRoomAvail, tbl_Hotel_PHC_Property.szVat, tbl_Hotel_PHC_Property.szExtendGroupNegRate, tbl_Hotel_PHC_Property.szConsortiaRate, tbl_Hotel_PHC_Property.szLowestConsortiaRate, tbl_Hotel_PHC_Property.szAverageConsortiaRate, tbl_Hotel_PHC_Property.szHighestConsortiaRate, tbl_Hotel_PHC_Property.szCorpRate, tbl_Hotel_PHC_Property.szRackRate, tbl_Hotel_PHC_Property.szAsscociationRate, tbl_Hotel_PHC_Property.szRecruitRatesSeptDec, tbl_Hotel_PHC_Property.szInternetIncRate, tbl_Hotel_PHC_Property.szRenovations, tbl_Hotel_PHC_Property.szRenovationsDesc, tbl_Hotel_PHC_Property.szRoomCnt, tbl_Hotel_PHC_Property.szSuiteCnt, tbl_Hotel_PHC_Property.szGuaranteeNotToWalkOurGuests, tbl_Hotel_PHC_Property.szHotelGrpAffiliation, tbl_Hotel_PHC_Property.szEnvCertPrg, tbl_Hotel_PHC_Property.szRecyclingPrg, tbl_Hotel_PHC_Property.szUtilEnvRespCleaners, tbl_Hotel_PHC_Property.szActiveWaterCnsvPrg, tbl_Hotel_PHC_Property.szIncentive, tbl_Hotel_PHC_Property.szAmenitiesIncluded, tbl_Hotel_PHC_Property.szIsPropVirtuosoMem, tbl_Hotel_PHC_Property.szIsVirtuosoAmmenInc, tbl_Hotel_PHC_Property.szVirtuosoAmmen, tbl_Hotel_PHC_Property.szEnsureAmenty, tbl_Hotel_PHC_Property.szITinPublicSpaceInc, tbl_Hotel_PHC_Property.szItinGuestRoomInc, tbl_Hotel_PHC_Property.szHotelDesc, tbl_Hotel_PHC_Property.szRestaurant, tbl_Hotel_PHC_Property.szBarLounge, tbl_Hotel_PHC_Property.szToiletries, tbl_Hotel_PHC_Property.szDirectorOfSales FROM Tbl_Hotel_PHC_OvationRFPS INNER JOIN Tbl_Hotel_PHC_HotelInfoPartialOne ON Tbl_Hotel_PHC_OvationRFPS.LRFPID = Tbl_Hotel_PHC_HotelInfoPartialOne.LRFPID INNER JOIN tbl_Hotel_PHC_Contacts ON Tbl_Hotel_PHC_HotelInfoPartialOne.LRFPID = tbl_Hotel_PHC_Contacts.LRFPID INNER JOIN tbl_Hotel_PHC_Property ON tbl_Hotel_PHC_Contacts.LRFPID = tbl_Hotel_PHC_Property.LRFPID WHERE (Tbl_Hotel_PHC_OvationRFPS.LRFPID = @LRFPID)", RFPreviewMkgt_Conn)) { //RFPreview_cmd.CommandText = "dbo.sp_RFP_GetRFPreviewbyID"; RFPreviewMkgt_cmd.CommandType = CommandType.Text; RFPreviewMkgt_cmd.CommandTimeout = 0; RFPreviewMkgt_cmd.Parameters.AddWithValue("@LRFPID", Decrypt(HttpContext.Current.Request.QueryString["ORFP"], "trappOvation")); RFPreviewMkgt_Conn.Open(); using (SqlDataReader RFPreviewMkgt_Reader = RFPreviewMkgt_cmd.ExecuteReader()) { if (RFPreviewMkgt_Reader.Read()) { HotelName_Mgk = RFPreviewMkgt_Reader["szPrefHotelName"].ToString(); HotelAddrOne_Mgk = RFPreviewMkgt_Reader["szAddress"].ToString(); Hotelcity_Mgk = RFPreviewMkgt_Reader["szCity"].ToString(); HotelInfoStateStr_Mgk = RFPreviewMkgt_Reader["szState"].ToString(); HotelcountryStr_Mgk = RFPreviewMkgt_Reader["szCountry"].ToString(); Hotelzippostcode_Mgk = RFPreviewMkgt_Reader["szZipCode"].ToString(); HotelMainphone_Mgk = RFPreviewMkgt_Reader["szHotelPhone"].ToString(); SalesContactName_Mgk = RFPreviewMkgt_Reader["szName"].ToString(); SalesContactTitle_Mgk = RFPreviewMkgt_Reader["szTitle"].ToString(); SalesContactTelephone_Mgk = RFPreviewMkgt_Reader["szPhone"].ToString(); SalesContactFax_Mgk = RFPreviewMkgt_Reader["szFax"].ToString(); SalesContactEmail_Mgk = RFPreviewMkgt_Reader["szEmail"].ToString(); Hotelgeneralmgr_Mgk = RFPreviewMkgt_Reader["szGeneralMgr"].ToString(); DirectorofSales_Mgk = RFPreviewMkgt_Reader["szDirectorOfSales"].ToString(); HotelWebSite_Mgk = RFPreviewMkgt_Reader["szWebSite"].ToString(); AAAatingStr_Mgk = RFPreviewMkgt_Reader["szDiamondRating"].ToString(); MobileStaRateStr_Mgk = RFPreviewMkgt_Reader["szStarRating"].ToString(); Hotelbriefdescipt_Mgk = RFPreviewMkgt_Reader["szHotelDesc"].ToString(); avtiveRecycle_Mgk = RFPreviewMkgt_Reader["szRecyclingPrg"].ToString(); EnviromentProgram_Mgk = RFPreviewMkgt_Reader["szUtilEnvRespCleaners"].ToString(); Property_WaterConserve_Mgk = RFPreviewMkgt_Reader["szActiveWaterCnsvPrg"].ToString(); /// ammeneties section ////////////////////////////////////////////////// LRAchoice_Mkt = RFPreviewMkgt_Reader["szLastRoomAvail"].ToString(); percentage_Mgk = RFPreviewMkgt_Reader["szDiscountOff"].ToString(); WoulextendRateYN_Mgk = RFPreviewMkgt_Reader["szExtendGroupNegRate"].ToString(); IsProperty_Virtuoso_Mgk = RFPreviewMkgt_Reader["szIsPropVirtuosoMem"].ToString(); internetGuestRoom_Mgk = RFPreviewMkgt_Reader["szItinGuestRoomInc"].ToString(); internetPublicSpace_Mgk = RFPreviewMkgt_Reader["szITinPublicSpaceInc"].ToString(); propertyrenovation2014_Mgk = RFPreviewMkgt_Reader["szRenovations"].ToString(); //PropRenovationDetails_Mkt = RFPreviewMkgt_Reader["szRenovationsDesc"].ToString(); Num_roomshotel_Mgk = RFPreviewMkgt_Reader["szRoomCnt"].ToString(); noToWalk_Mgk = RFPreviewMkgt_Reader["szGuaranteeNotToWalkOurGuests"].ToString(); /// marketing whatMarketPack_Mgk = RFPreviewMkgt_Reader["szIncentive"].ToString(); } } } } using (SqlConnection NoSmokeMkg_Conn = new SqlConnection(RFPDBconnStr)) { using (SqlCommand NoSmokeMkg_cmd = new SqlCommand("SELECT tbl_Hotel_PHC_Features.szFeature, tbl_Hotel_PHC_Features_Property.LRFPID FROM tbl_Hotel_PHC_Features_Property INNER JOIN tbl_Hotel_PHC_Features ON tbl_Hotel_PHC_Features_Property.lFeatureID = tbl_Hotel_PHC_Features.lFeatureID WHERE (tbl_Hotel_PHC_Features.szFeature = 'Non-smoking Hotel' OR tbl_Hotel_PHC_Features.szFeature = 'Smoking Hotel') AND (tbl_Hotel_PHC_Features_Property.LRFPID = @LRFPID)", NoSmokeMkg_Conn)) { NoSmokeMkg_cmd.CommandType = CommandType.Text; NoSmokeMkg_cmd.CommandTimeout = 0; NoSmokeMkg_cmd.Parameters.AddWithValue("@LRFPID", Decrypt(HttpContext.Current.Request.QueryString["ORFP"].ToString(), "trappOvation")); NoSmokeMkg_Conn.Open(); using (SqlDataReader NoSmokeMkg_Reader = NoSmokeMkg_cmd.ExecuteReader()) { if (NoSmokeMkg_Reader.Read()) { Nosmoking_Mgk = NoSmokeMkg_Reader["szFeature"].ToString(); } } } } /// regex for email ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// string expression_Mgk = @"^[a-z][a-z|0-9|]*([_][a-z|0-9]+)*([.][a-z|" + @"0-9]+([_][a-z|0-9]+)*)?@[a-z][a-z|0-9|]*\.([a-z]" + @"[a-z|0-9]*(\.[a-z][a-z|0-9]*)?)$"; Match match_Mgk = Regex.Match(Sales_Contact_Email.Text.ToString(), expression_Mgk, RegexOptions.IgnoreCase); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // hotel Info section error ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //string hotinfoTitle = @"<br /><img src=""Images/HotelInfoTitle.png"" style=""padding-left: 20px;"" />"; if (string.IsNullOrEmpty(HotelName_Mgk) || string.IsNullOrEmpty(HotelAddrOne_Mgk) || string.IsNullOrEmpty(Hotelcity_Mgk) || HotelInfoStateStr_Mgk.ToString() == "Please Choose a State" || HotelcountryStr_Mgk.ToString() == "Please Choose a Country" || string.IsNullOrEmpty(Hotelzippostcode_Mgk) || string.IsNullOrEmpty(HotelMainphone_Mgk) || string.IsNullOrEmpty(SalesContactName_Mgk) || string.IsNullOrEmpty(SalesContactTitle_Mgk) || string.IsNullOrEmpty(SalesContactTelephone_Mgk) || string.IsNullOrEmpty(SalesContactFax_Mgk) || string.IsNullOrEmpty(SalesContactEmail_Mgk) || match_Mgk.Success == false || string.IsNullOrEmpty(Hotelgeneralmgr_Mgk) || string.IsNullOrEmpty(DirectorofSales_Mgk) || string.IsNullOrEmpty(HotelWebSite_Mgk) || string.IsNullOrEmpty(AAAatingStr_Mgk) || string.IsNullOrEmpty(MobileStaRateStr_Mgk) || string.IsNullOrEmpty(Hotelbriefdescipt_Mgk) || string.IsNullOrEmpty(avtiveRecycle_Mgk) || string.IsNullOrEmpty(EnviromentProgram_Mgk) || string.IsNullOrEmpty(Property_WaterConserve_Mgk) || string.IsNullOrEmpty(LRAchoice_Mkt) || string.IsNullOrEmpty(percentage_Mgk) || string.IsNullOrEmpty(WoulextendRateYN_Mgk) || string.IsNullOrEmpty(IsProperty_Virtuoso_Mgk) || string.IsNullOrEmpty(internetGuestRoom_Mgk) || string.IsNullOrEmpty(internetPublicSpace_Mgk) || string.IsNullOrEmpty(Nosmoking_Mgk) || string.IsNullOrEmpty(propertyrenovation2014_Mgk) || string.IsNullOrEmpty(Num_roomshotel_Mgk) || string.IsNullOrEmpty(noToWalk_Mgk) || string.IsNullOrEmpty(whatMarketPack_Mgk)) { RFPSEctionsErrors.Selected = true; //HotelInfoError.Visible = true; //RFPSEctionsErrors.Visible = true; // errorNoerror.Text = "we have an error"; //rfpsubmiterror.Visible = true; //noerror.Visible = false; // ///////////////////////////////////////////////////////////////////// // hotel name ////////////////////////////////////////////////////////// if (string.IsNullOrEmpty(HotelName_Mgk)) { OhotelName.Visible = true; } else { OhotelName.Visible = false; } // Hotel address One ////////////////////////////////////////////////////////// if (string.IsNullOrEmpty(HotelAddrOne_Mgk)) { OaddressOne.Visible = true; } else { OaddressOne.Visible = false; } // Hotel city ////////////////////////////////////////////////////////// if (string.IsNullOrEmpty(Hotelcity_Mgk)) { OHCity.Visible = true; } else { OHCity.Visible = false; } // Hotel state ///////////////////////////////////////////////////////// if (HotelInfoStateStr_Mgk.ToString() == "Please Choose a State") { OHState.Visible = true; } else { OHState.Visible = false; } // Hotel Country /////////////////////////////////////////////////////// if (HotelcountryStr_Mgk.ToString() == "Please Choose a Country") { OHcountry.Visible = true; } else { OHcountry.Visible = false; } // hotel zip code ///////////////////////////////////////////////////// if (string.IsNullOrEmpty(Hotelzippostcode_Mgk)) { OHZipC.Visible = true; } else { OHZipC.Visible = false; } /// hotel main phone /////////////////////////////////////////////////// if (string.IsNullOrEmpty(HotelMainphone_Mgk)) { OHmainPhone.Visible = true; } else { OHmainPhone.Visible = false; } // Hotel sales contact name //////////////////////////////////////////// if (string.IsNullOrEmpty(SalesContactName_Mgk)) { OHSalesConName.Visible = true; } else { OHSalesConName.Visible = false; } // sales contact title //////////////////////////////////////////////// if (string.IsNullOrEmpty(SalesContactTitle_Mgk)) { OHSaleConTit.Visible = true; } else { OHSaleConTit.Visible = false; } // Hotel sales contact phone ////////////////////////////////////////// if (string.IsNullOrEmpty(SalesContactTelephone_Mgk)) { OHSalesContactPhone.Visible = true; } else { OHSalesContactPhone.Visible = false; } // Hotel sales contact fax if (string.IsNullOrEmpty(SalesContactFax_Mgk)) { OHSalesConfax.Visible = true; } else { OHSalesConfax.Visible = false; } // hotel sales contact email empty and bad email //////////////////////////////////////////// if (string.IsNullOrEmpty(SalesContactEmail_Mgk)) { OHSalesConEmlEmpty.Visible = true; OHSalesConEmlBad.Visible = false; } else if (match_Mgk.Success == false) { OHSalesConEmlBad.Text = "<li><strong>" + Sales_Contact_Email.Text.ToString() + "</strong> is not a valid email address</li>"; OHSalesConEmlBad.Visible = true; OHSalesConEmlEmpty.Visible = false; } else { OHSalesConEmlEmpty.Visible = false; OHSalesConEmlBad.Visible = false; } /// hotel gen manager if (string.IsNullOrEmpty(Hotelgeneralmgr_Mgk)) { OHGenMgr.Visible = true; } else { OHGenMgr.Visible = false; } // director of sales ////////////////////////////////////////////////////////////////////// if (string.IsNullOrEmpty(DirectorofSales_Mgk)) { OHDirectSales.Visible = true; } else { OHDirectSales.Visible = false; } // hotel web site //////////////////////////////////////////////////////////////////////// if (string.IsNullOrEmpty(HotelWebSite_Mgk)) { OHwebsite.Visible = true; } else { OHwebsite.Visible = false; } // AAA diamond rating /////////////////////////////////////////////////////////////////// if (string.IsNullOrEmpty(AAAatingStr_Mgk)) { OHAAARating.Visible = true; } else { OHAAARating.Visible = false; } // mobile star rating if (string.IsNullOrEmpty(MobileStaRateStr_Mgk)) { OHMobileStar.Visible = true; } else { OHMobileStar.Visible = false; } // hotel brief descrtiption /////////////////////////////////////////// if (string.IsNullOrEmpty(Hotelbriefdescipt_Mgk)) { OHhotelBreifdescript.Visible = true; } else { OHhotelBreifdescript.Visible = false; } // active recycle ////////////////////////////////////////////////////////////////////// if (string.IsNullOrEmpty(avtiveRecycle_Mgk)) { OHActiveRecyle.Visible = true; } else { OHActiveRecyle.Visible = false; } // responsible cleaners if (string.IsNullOrEmpty(EnviromentProgram_Mgk)) { OHResponsible.Visible = true; } else { OHResponsible.Visible = false; } // water conserve ///////////////////////////////////////////////////////////////////// if (string.IsNullOrEmpty(Property_WaterConserve_Mgk)) { OHwaterconserver.Visible = true; } else { OHwaterconserver.Visible = false; } // LRA choice if (string.IsNullOrEmpty(LRAchoice_Mkt)) { AmmenLRAYN.Visible = true; } else { AmmenLRAYN.Visible = false; } // ammen percetage if (string.IsNullOrEmpty(percentage_Mgk)) { AMpercentage.Visible = true; } else { AMpercentage.Visible = false; } // Ammen would extend rate ///////////////////////////////////////////////////////////// if (string.IsNullOrEmpty(WoulextendRateYN_Mgk)) { AMWouldExtend.Visible = true; } else { AMWouldExtend.Visible = false; } // is prop virtuoso if (string.IsNullOrEmpty(IsProperty_Virtuoso_Mgk)) { AMIsPropVirtuoso.Visible = true; } else { AMIsPropVirtuoso.Visible = false; } // internet included in guest room if (string.IsNullOrEmpty(internetGuestRoom_Mgk)) { AMinternetIncGuestRm.Visible = true; } else { AMinternetIncGuestRm.Visible = false; } // internet included in public space if (string.IsNullOrEmpty(internetPublicSpace_Mgk)) { AMinternetPublic.Visible = true; } else { AMinternetPublic.Visible = false; } // is porp non-smoking if (string.IsNullOrEmpty(Nosmoking_Mgk)) { AMIsNonSmoking.Visible = true; } else { AMIsNonSmoking.Visible = false; } // prop renovations radio buttonlist if (string.IsNullOrEmpty(propertyrenovation2014_Mgk)) { AMRenovations.Visible = true; } else { AMRenovations.Visible = false; } // prop renovations text box is yes // PropRenovationDetails_Mkt //if (propertyrenovation2014_Mgk.ToString() == "Y" && string.IsNullOrEmpty(PropRenovationDetails_Mkt)) //{ // AMrenovationTxt.Visible = true; //} //else //{ // AMrenovationTxt.Visible = false; //} // put here ///////////////////////////////////////// // how many hotel has if (string.IsNullOrEmpty(Num_roomshotel_Mgk)) { AMNumberRooms.Visible = true; } else { AMNumberRooms.Visible = false; } // no to walk if (string.IsNullOrEmpty(noToWalk_Mgk)) { AMnoToWalk.Visible = true; } else { AMnoToWalk.Visible = false; } // marketing packs if (string.IsNullOrEmpty(whatMarketPack_Mgk)) { MarketingPackError.Visible = true; } else { MarketingPackError.Visible = false; } } else { // now validate seasonal rates section //////////////////////////////////////////////// using (SqlConnection RoomsRatesMkt_Conn = new SqlConnection(RFPDBconnStr)) { using (SqlCommand RoomsRatesMkt_cmd = new SqlCommand("SELECT Tbl_Hotel_PHC_AmmenRmSeasons.dtSTdate, Tbl_Hotel_PHC_AmmenRmSeasons.dtEDDate, Tbl_Hotel_PHC_AmmenRmCatRates.szRmTypeCat,Tbl_Hotel_PHC_AmmenRmCatRates.nRmRate, Tbl_Hotel_PHC_AmmenRmCatRates.szCurCode, Tbl_Hotel_PHC_AmmenRmSeasons.szSeaonName FROM Tbl_Hotel_PHC_AmmenRmSeasons INNER JOIN Tbl_Hotel_PHC_AmmenRmCatRates ON Tbl_Hotel_PHC_AmmenRmSeasons.LID = Tbl_Hotel_PHC_AmmenRmCatRates.LSID WHERE(Tbl_Hotel_PHC_AmmenRmSeasons.LRFPID = @LRFPID) order by Tbl_Hotel_PHC_AmmenRmSeasons.LID ASC", RoomsRatesMkt_Conn)) { RoomsRatesMkt_cmd.CommandType = CommandType.Text; RoomsRatesMkt_cmd.CommandTimeout = 0; RoomsRatesMkt_cmd.Parameters.AddWithValue("@LRFPID", Decrypt(HttpContext.Current.Request.QueryString["ORFP"].ToString(), "trappOvation")); RoomsRatesMkt_Conn.Open(); using (SqlDataReader RoomsRatesMkt_Reader = RoomsRatesMkt_cmd.ExecuteReader()) { while (RoomsRatesMkt_Reader.Read()) { // HttpContext.Current.Response.Write(RoomsRatesMkt_Reader["szSeaonName"].ToString() + " "); if (RoomsRatesMkt_Reader["dtEDDate"] != DBNull.Value) { RFPSEctionsErrors.Selected = false; RatesSection.Visible = false; ElectornicSigView.Selected = true; ElectronicSigCodeBlock.Visible = true; finishedRFP.Visible = true; WincloseCodeBlock.Visible = false; } else { RFPSEctionsErrors.Selected = true; RatesSection.Visible = true; } if (RoomsRatesMkt_Reader["szRmTypeCat"] != DBNull.Value) { RFPSEctionsErrors.Selected = false; ElectornicSigView.Selected = true; ElectronicSigCodeBlock.Visible = true; finishedRFP.Visible = true; } else { RFPSEctionsErrors.Selected = true; RatesSection.Visible = true; } if (RoomsRatesMkt_Reader["nRmRate"] != DBNull.Value || RoomsRatesMkt_Reader["nRmRate"].ToString() != string.Empty) { RFPSEctionsErrors.Selected = false; ElectornicSigView.Selected = true; ElectronicSigCodeBlock.Visible = true; //finishedRFP.Visible = true; WincloseCodeBlock.Visible = false; } else { RFPSEctionsErrors.Selected = true; RatesSection.Visible = true; } } } } } } EelectronicTabMktButton.Selected = true; //progressTextHotelInfo.Text = "Hotel Information | Complete"; //progressTextHotelInfo.ForeColor = System.Drawing.Color.Black; //progressbarAmmen.Text = "2014 Rates & Amenities | Complete"; //progressbarAmmen.ForeColor = System.Drawing.Color.Black; //progressBarTxtMarketingPackages.Text = "Marketing Packages | Complete"; //progressBarTxtMarketingPackages.ForeColor = System.Drawing.Color.Bla }
protected void RatesAmenitiesNextBtn_Click(object sender, EventArgs e) { int mymhid = 0; //Page.Validate(); //Page.Validate("seasonRmCatVal"); //Page.Validate("seasonRmRateVal"); //if (Page.IsValid) //{ using (SqlConnection HotelInfo_PropertyUpdate_Conn = new SqlConnection(RFPDBconnStr)) { using (SqlCommand HotelInfo_PropertyUpdate_cmd = new SqlCommand("dbo.sp_RFP_UpDate_PropertyTbl_AfterinsertHotelinfo", HotelInfo_PropertyUpdate_Conn)) { HotelInfo_PropertyUpdate_cmd.CommandText = "dbo.sp_RFP_UpDate_PropertyTbl_AfterinsertHotelinfo"; HotelInfo_PropertyUpdate_cmd.CommandType = CommandType.StoredProcedure; HotelInfo_PropertyUpdate_cmd.CommandTimeout = 0; // st param SqlParameter HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@LRFPID"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Decrypt(HttpContext.Current.Request.QueryString["ORFP"], "trappOvation"); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); // nd parem HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szDiscountOff"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = percentageRecieveOffRate.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); // rd parem HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szLastRoomAvail"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Radiolist_Floating_Bar_Dynamic.SelectedValue.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szVat"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = RadioButtonList_VatType.SelectedValue.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szExtendGroupNegRate"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = RadioButtonList_WoulextendRateYN.SelectedValue.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szConsortiaRate"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = ConsortaRate.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szLowestConsortiaRate"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Consortia_floor_Low_Rate.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szAverageConsortiaRate"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Consortia_average_mediaum_Rate.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szHighestConsortiaRate"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Consortia_high_Rate.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szCorpRate"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Corp_Rate.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szRackRate"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Rack_Rate.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szAsscociationRate"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Assoc_Rate.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szRecruitRatesSeptDec"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Ovation_Recruitment_Rate.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szAmenitiesIncluded"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Amenities_Offered_to_Ovation.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szIsPropVirtuosoMem"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = RadioButtonList_IsProperty_Virtuoso.SelectedValue.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szIsVirtuosoAmmenInc"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = RadioButtonList_IsVirtuoso_included.SelectedValue.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szVirtuosoAmmen"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Ammenities_VirtuosoAmenity.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szEnsureAmenty"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Ammenities_ensureClient_VirtuosoAmenity.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szItinGuestRoomInc"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = internet_Access_inc_NegRate_GuestRoom.SelectedValue.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szITinPublicSpaceInc"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = internet_Access_inc_NegRate_publicspace.SelectedValue.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szToiletries"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Amenities_WhatBrandFor_GuestRoom_Bathroom.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szRestaurant"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Amenites_property_resturants_names.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szBarLounge"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Amenites_property_Bar_Lounge_names.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szRenovations"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Amenites_property_renovation_2014.SelectedValue.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szRenovationsDesc"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Amenites_property_renovationDates_details.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szRoomCnt"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Ammenities_Num_roomshotel.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szSuiteCnt"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Ammenities_Num_suiteshotel.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szGuaranteeNotToWalkOurGuests"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Amenities_noToWalk.SelectedValue.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); //th param HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szHotelGrpAffiliation"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Aemnites_Affilation_Details.Text.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); // the parem smoking or non HotelInfo_PropertyUpdate_Param = HotelInfo_PropertyUpdate_cmd.CreateParameter(); HotelInfo_PropertyUpdate_Param.ParameterName = "@szSmoking"; HotelInfo_PropertyUpdate_Param.Direction = ParameterDirection.Input; HotelInfo_PropertyUpdate_Param.SqlDbType = SqlDbType.VarChar; HotelInfo_PropertyUpdate_Param.Value = Amenites_property_non_smoking.SelectedValue.ToString(); HotelInfo_PropertyUpdate_cmd.Parameters.Add(HotelInfo_PropertyUpdate_Param); HotelInfo_PropertyUpdate_Conn.Open(); HotelInfo_PropertyUpdate_cmd.ExecuteNonQuery(); } // first get mhid using (SqlCommand HotelInfo_PropertyGetmhid_cmd = new SqlCommand("SELECT mhid from dbo.Tbl_Hotel_PHC_Property WHERE LRFPID = @LRFPID", HotelInfo_PropertyUpdate_Conn)) { HotelInfo_PropertyGetmhid_cmd.CommandType = CommandType.Text; HotelInfo_PropertyGetmhid_cmd.CommandTimeout = 0; HotelInfo_PropertyGetmhid_cmd.Parameters.AddWithValue("@LRFPID", Decrypt(HttpContext.Current.Request.QueryString["ORFP"], "trappOvation")); using (SqlDataReader GetMymhid_Reader = HotelInfo_PropertyGetmhid_cmd.ExecuteReader()) { if (GetMymhid_Reader.Read()) { mymhid = GetMymhid_Reader.GetInt32(GetMymhid_Reader.GetOrdinal("mhid")); } } } } using (SqlConnection FeaturesPropertyIjnsert_Conn = new SqlConnection(RFPDBconnStr)) { FeaturesPropertyIjnsert_Conn.Open(); // delete so we can start over like an update using (SqlCommand FeaturesPropertyIjnsert_cmd = new SqlCommand("DELETE FROM dbo.tbl_Hotel_PHC_Features_Property WHERE LRFPID = @LRFPID", FeaturesPropertyIjnsert_Conn)) { //FeaturesPropertyIjnsert_cmd.CommandText = "dbo.sp_RFP_UpDate_PropertyTbl_AfterinsertHotelinfo"; FeaturesPropertyIjnsert_cmd.CommandType = CommandType.Text; FeaturesPropertyIjnsert_cmd.CommandTimeout = 0; //FeaturesPropertyIjnsert_Conn.Open(); /// radio button no smoking FeaturesPropertyIjnsert_cmd.Parameters.Clear(); FeaturesPropertyIjnsert_cmd.Parameters.AddWithValue("@LRFPID", Decrypt(HttpContext.Current.Request.QueryString["ORFP"], "trappOvation")); FeaturesPropertyIjnsert_cmd.ExecuteNonQuery(); } // return; // insert in Features Property table /// using (SqlCommand FeaturesPropertyIjnsert_cmd = new SqlCommand("INSERT INTO dbo.tbl_Hotel_PHC_Features_Property(mhid,LRFPID,szYear,lFeatureID)VALUES(@mhid,@LRFPID,@szYear,@lFeatureID)", FeaturesPropertyIjnsert_Conn)) { //FeaturesPropertyIjnsert_cmd.CommandText = "dbo.sp_RFP_UpDate_PropertyTbl_AfterinsertHotelinfo"; FeaturesPropertyIjnsert_cmd.CommandType = CommandType.Text; FeaturesPropertyIjnsert_cmd.CommandTimeout = 0; foreach (ListItem feature in Amenities_Property_offering.Items) { if (feature.Selected) { // do inset // first check box list FeaturesPropertyIjnsert_cmd.Parameters.Clear(); FeaturesPropertyIjnsert_cmd.Parameters.AddWithValue("@mhid", mymhid); FeaturesPropertyIjnsert_cmd.Parameters.AddWithValue("@LRFPID", Decrypt(HttpContext.Current.Request.QueryString["ORFP"], "trappOvation")); FeaturesPropertyIjnsert_cmd.Parameters.AddWithValue("@szYear", TheYear.Value.ToString()); FeaturesPropertyIjnsert_cmd.Parameters.AddWithValue("@lFeatureID", feature.Value); FeaturesPropertyIjnsert_cmd.ExecuteNonQuery(); } } foreach (ListItem featureEquip in Amenities_Rooms_Equipped_With.Items) { if (featureEquip.Selected) { // second check box list FeaturesPropertyIjnsert_cmd.Parameters.Clear(); FeaturesPropertyIjnsert_cmd.Parameters.AddWithValue("@mhid", mymhid); FeaturesPropertyIjnsert_cmd.Parameters.AddWithValue("@LRFPID", Decrypt(HttpContext.Current.Request.QueryString["ORFP"], "trappOvation")); FeaturesPropertyIjnsert_cmd.Parameters.AddWithValue("@szYear", TheYear.Value.ToString()); FeaturesPropertyIjnsert_cmd.Parameters.AddWithValue("@lFeatureID", featureEquip.Value); FeaturesPropertyIjnsert_cmd.ExecuteNonQuery(); } } /// radio button no smoking FeaturesPropertyIjnsert_cmd.Parameters.Clear(); FeaturesPropertyIjnsert_cmd.Parameters.AddWithValue("@mhid", mymhid); FeaturesPropertyIjnsert_cmd.Parameters.AddWithValue("@LRFPID", Decrypt(HttpContext.Current.Request.QueryString["ORFP"], "trappOvation")); FeaturesPropertyIjnsert_cmd.Parameters.AddWithValue("@szYear", TheYear.Value.ToString()); FeaturesPropertyIjnsert_cmd.Parameters.AddWithValue("@lFeatureID", Amenites_property_non_smoking.SelectedValue); FeaturesPropertyIjnsert_cmd.ExecuteNonQuery(); } } //return; //progressTextHotelInfo.Text = "Hotel Information | Complete"; // progressTextHotelInfo.ForeColor = System.Drawing.Color.Black; //progressbarAmmen.Text = "2014 Rates & Amenities | Complete"; //progressbarAmmen.ForeColor = System.Drawing.Color.Black; //RadTab HotelInformationTab = OvationTabs.FindTabByValue("Hotel_Info"); RadTab RatesAmenities_Tab = OvationTabs.FindTabByValue("Rates_Amenities"); RadTab Marketing_pkgs_Tab = OvationTabs.FindTabByValue("Marketing_pkgs"); // HotelInformationTab.Enabled = false; //RatesAmenities_Tab.Enabled = false; // Marketing_pkgs_Tab.Enabled = true; Marketing_pkgs_Tab.Selected = true; marketingPCKsView.Selected = true; HotelInfoCodeBlock.Visible = false; AmenitiesCodeBlock.Visible = false; //MktgCodeBlock.Visible = true; ElectronicSigCodeBlock.Visible = false; }