public static PreTourBooking GetPreBooked(int parResNum, int parPCIID, int parHotelNumber, int FromLive, out int count) { PreTourBooking retval = new PreTourBooking(); SqlParameter pOut = new SqlParameter("@Count", SqlDbType.Int, 4); pOut.Direction = ParameterDirection.Output; SqlParameter[] param = new SqlParameter[]{ new SqlParameter("@FromLive", FromLive), new SqlParameter("@parReservationNum", parResNum), new SqlParameter("@parPCIID", parPCIID), new SqlParameter("@HotelNumber", parHotelNumber), pOut }; using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "Select_PreBooked", param)) { if (reader.Read()) { //retval.Add(Read(reader)); retval = Read(reader); } } count = Helper.ToInt32(pOut.Value); return retval; }
public static PreTourBooking Read(SqlDataReader reader) { PreTourBooking retval = new PreTourBooking(); for (int i = 0; i < reader.FieldCount; i++) { switch (reader.GetName(i)) { case "DateContacted": retval.DateContacted = Helper.ToDateTime(reader[i]); break; case "ContactedBy": retval.ContactedBy = Helper.ToString(reader[i]); break; case "HotelNumber": retval.HN = Helper.ToInt32(reader[i]); break; case "InterestedInTour": retval.InterestedInTour = Helper.ToString(reader[i]); break; case "Invited": retval.Invited = Helper.ToBoolean(reader[i]); break; case "FollowUpDate": retval.FollowUpDate = Helper.ToDateTime(reader[i]); break; case "Status": retval.Status = Helper.ToString(reader[i]); break; case "FollowUpTime": retval.FollowUpTime = Helper.ToString(reader[i]); break; case "NQTypesID": retval.NQTypesID = Helper.ToInt32(reader[i]); break; case "NQTypes": retval.NQTypesDesc = Helper.ToString(reader[i]); break; case "ProspectId": retval.ProspectID = Helper.ToInt32((reader[i])); break; case "TourID": retval.TourID = Helper.ToInt32((reader[i])); break; } } return retval; }
public static PreTourBooking Insert_PreBookedTour(PreTourBooking value) { //throw new Exception("Writing RSNO: " + value.SubReservationNumber); PreTourBooking retval = new PreTourBooking(); SqlParameter[] param = new SqlParameter[] { new SqlParameter("@FromLive", value.FromLive), new SqlParameter("@ReservationNum", value.ReservationNumber), new SqlParameter("@SubReservationNum", value.SubReservationNumber), new SqlParameter("@PCIID", value.PCIID), new SqlParameter("@HotelNumber", value.HN), new SqlParameter("@DateContacted", value.DateContacted), new SqlParameter("@ContactedBy", value.ContactedBy), new SqlParameter("@InterestedInTour", value.InterestedInTour), new SqlParameter("@FollowUpDate", value.FollowUpDate), new SqlParameter("@FollowUpTime", value.FollowUpTime), new SqlParameter("@Invited", value.Invited), new SqlParameter("@NQTypesID", value.NQTypesID), new SqlParameter("@Status", value.Status) }; SqlHelper.ExecuteNonQuery(Helper.ConnectionString, CommandType.StoredProcedure, "Insert_PreBookedTour", param); return retval; }
protected void btnBook_Click(object sender, EventArgs e) { //insert in TSW //For the hotel location check the times(time 1, time 2, time 3 it's being used military time) and also if the hotel location has enough presenters //Validate that the prospect doesn't exist by(email, name and telephone number) //DOB, Marital status, //emailid //phone numberid //Names(Guest1, Guest2) //MemberCompany item = new MemberCompany(); //New Code 10/27/10 Check that the fields are not blanc if (ddlTourTime.SelectedValue == string.Empty || ddlTourTime.SelectedValue == string.Empty || ddlTourTime.SelectedValue == string.Empty) { lblValidation.Text = "Values cannot be blank."; return; } lblValidation.Text = ""; TSWProspect itemProspect = new TSWProspect(); TSWProspect itemProspectSrc = new TSWProspect(); TSWProspect itemProspectType = new TSWProspect(); TSWProspect itemProspectStatus = new TSWProspect(); TSWTour itemTour = new TSWTour(); TSWTour itemTourID = new TSWTour(); Personnel itemPersonnel = new Personnel(); Premiums itemPremiums = new Premiums(); PreTourBooking itemPreTourBooking = new PreTourBooking(); itemProspect.FromLive = m_FromLive; itemProspectSrc.FromLive = m_FromLive; itemProspectType.FromLive = m_FromLive; itemProspectStatus.FromLive = m_FromLive; itemTour.FromLive = m_FromLive; itemTourID.FromLive = m_FromLive; //dcitemProspect.HN = SIHOTHotelCode; //Hotel Number from SIHOT itemProspect.HN = SiteId; //Hotel Number from SIHOT itemProspect.Salutation = hdnSalutation.Value; itemProspect.Title = hdnSalutation.Value; itemProspect.CN = lblFName.Text; itemProspect.SN = lblLastName.Text ; itemProspect.Address.Street1 = hdnStreet.Value; itemProspect.Address.City = hdnCity.Value; itemProspect.Address.State = hdnState.Value; itemProspect.Address.Country = hdnCountry.Value; itemProspect.Address.Zip = hdnZipCode.Value; itemProspect.Phone = hdnPhone1.Value; itemProspect.Phone2 = hdnPhone2.Value; itemProspect.Fax = hdnFax.Value; itemProspect.EMAIL = hdnEmail.Value; //throw new Exception(ddlMarital1.SelectedValue); itemProspect.MaritalID = Helper.ToInt32(ddlMarital1.SelectedValue); //throw new Exception(ddlMarital1.SelectedItem.Text); itemProspect.MaritalStatus = ddlMarital1.SelectedItem.Text; itemProspect.OccupationID=Helper.ToInt32(ddlOccupation.SelectedValue); itemProspect.Occupation=ddlOccupation.SelectedItem.Text; itemProspect.IncomeID = Helper.ToInt32(ddlIncome.SelectedValue); itemProspect.DOB=txtDOB.Text; //Get the SourceID thru stored procedure //ws_usp_GetProspectSourcePMSInterface itemProspectSrc= TSWProspectDB.GetProspectSource(itemProspect); itemProspect.ProspectSourceID = itemProspectSrc.ProspectSourceID; itemProspect.ProspectSourceDesc = itemProspectSrc.ProspectSourceDesc; //throw new Exception(itemProspect.SN + itemProspect.ProspectSourceID.ToString()); //Get the ProspectTypeId thru stored procedure //ws_usp_GetProspectType //itemProspect= TSWProspectDB.GetProspectType(itemProspect.FromLive); //itemProspect.ProspectTypeDesc = ""; itemProspectType= TSWProspectDB.GetProspectType(itemProspect); itemProspect.ProspectTypeID = itemProspectType.ProspectTypeID; itemProspect.ProspectTypeDesc = itemProspectType.ProspectTypeDesc; //Get the prospectStausID thru stored procedure //ws_usp_GetProspectStatus itemProspectStatus= TSWProspectDB.GetProspectStatus(itemProspect); itemProspect.ProspectStatusID = itemProspectStatus.ProspectStatusID; itemProspect.ProspectStatusDesc = itemProspectStatus.ProspectStatusDesc; //itemProspect.ProspectStatusID = 1; //itemProspect.ProspectStatusDesc = ""; //Step 1. Validate that the prospect doesn't exist //SearchEmail and SerachPhone APIsol //The fields to validate are Phonenumber, email address, lastname and first name //Fill the options the existing ones and give them the chance to select and option in order to make an update later. //Code for MiniVacs if (lblprospectID.Text != string.Empty && lblTourID.Text!=string.Empty) { //Process MiniVacs requirements on the side //Use ProspectID and TourID already in place for the MiniVacs return; } if (ProspectId == 0 && itemProspect.SN.Trim() != string.Empty && itemProspect.CN.Trim() != string.Empty && (itemProspect.Phone.Trim() != string.Empty || itemProspect.EMAIL.Trim() != string.Empty)) //does't exist the prospect id. I can assign the value of the porspectId from the check dups prospects { //throw new Exception(ProspectId.ToString() + itemProspect.SN + itemProspect.CN + (itemProspect.Phone.Trim() != string.Empty).ToString() + (itemProspect.EMAIL.Trim() != string.Empty).ToString()); int count = 0; TSWProspectList itemProspectList = TSWProspectDB.SearchUniqueProspect(itemProspect, out count); //check the four fields this needs to change NOW if (count > 0 && count != null) { //this needs to change NOW rptDuplicates.DataSource = TSWProspectDB.GetDupsProspects(itemProspect); rptDuplicates.DataBind(); //show the prospectId on top. The assignment of the prospectId happens in the the ItemDatabound of the repeater lblprospectID.Text = Helper.ToString(ProspectId); lblProspectDup.Text = "This prospect already exist in TSW and may have attended to the presentation in the past."; PnlDups.Visible = true; //return; lblConfRNumber.Text = " <font color=red><b>" + ProspectId + " Pre-Existing ProspectId</b></font>"; } else //if doesn't exist in the dups then Insert { ProspectId = TSWProspectDB.InsertTSW_Prospect(itemProspect); lblConfRNumber.Text = " <font color=red><b>" + ProspectId + "</b></font>"; if (ProspectId == 0) { lblConfRNumber.Text = "Error Creating Prospect"; return; } } } else if (lblprospectID.Text == string.Empty) { //***************************************** //***************************************** //***************************************** //I still need to check the Search FName & LastName. Insert happens, this means that the prospect doesn't exit //if (SearchEmail() != "true" && SearchPhone() != "true") //{ //throw new Exception(itemProspect.ProspectTypeID + " " + itemProspect.ProspectTypeDesc + " " + itemProspect.ProspectStatusID + " " + itemProspect.ProspectSourceID); ProspectId = TSWProspectDB.InsertTSW_Prospect(itemProspect); //call the TUNA here TRANSUNION //call the TUNA here TRANSUNION //if (m_FromLive == 1) //{ // ParseStringFWD_TOne_prod(); //SaveResults_TUNA_prod(); //} //else //{ //ParseStringFWD_TOne_test(); // SaveResults_TUNA_test(); //} //call the TUNA here TRANSUNION //call the TUNA here TRANSUNION lblConfRNumber.Text = " <font color=red><b>" + ProspectId + "</b></font>"; if (ProspectId == 0) { lblConfRNumber.Text = "Error Creating Prospect"; return; } } //the one that says about the prospect phNewProspect.Visible = true; //} //else //{ ////Step 2.or make an update WebAPI_UpdateTourProspect // lblConfRNumber.Text = " <font color=red><b>" + Helper.ToString(TSWProspectDB.UpdateTSW_Prospect(itemProspect)) + "</b></font>"; //} //***************************************** //***************************************** //***************************************** //Step 3 Create the Tour webapibooked tour itemTour.FromLive = m_FromLive; itemTour.SiteID=SiteId; itemTour.ProspectId = ProspectId; itemTour.CampaignID = Helper.ToInt32(ddlCampaign.SelectedValue); //Get the tourTypeId New Member addition //TourTypeID:7866 TourType: 'Members' //case statement //throw new Exception(hdnDisplaySegment.Value); if (hdnDisplaySegment.Value.ToLower().Contains("members") == true) { itemTour.TourTypeDesc = "Members"; } else { itemTour.TourTypeDesc = "In House"; } //itemTour.TourTypeDesc = "In House"; itemTourID = TSWTourDB.GetTourTypeID(itemTour); itemTour.TourTypeID = itemTourID.TourTypeID; //"In House=190" VALUE itemTour.TourLocationID = Helper.ToInt32(ddlTourLocation.SelectedValue); itemTour.TourDate=Helper.ToDateTime(txtTourDate.Text).Value; //itemTour.PreAssignedTo = ddlPromotorName.SelectedValue; itemTour.waveID=Helper.ToInt32(ddlTourTime.SelectedValue); //Response.Write(itemTour.SiteID + " " + itemTour.ProspectId + " " + itemTour.CampaignID + " " + itemTourID.TourTypeID + " " + itemTour.TourLocationID + " " + itemTour.TourDate + " " + itemTour.waveID); //Inserts the Tour in table t_tour. Return string "success or failure" and the tourid TSWTourList itemTourReturn = TSWTourDB.InsertTSW_Tour(itemTour); foreach (TSWTour item in itemTourReturn) { lblErrors.Text = ""; if (item.ReturnValue !=0) { lblErrorsTour.Visible = true; lblErrorsTour.Text += "Error creating Tour: " + item.ReturnValue + ", " + item.ReturnString; lblErrors.Text += "Error creating Tour: " + item.ReturnValue + ", " + item.ReturnString; PnlError.Visible = true; } else { TourId = item.TourID; lblErrors.Text += "Tour Created Succesfully:" + TourId; PnlError.Visible = true; } } //lblConfRNumber.Text += "TourId AfterCreate: "+ Helper.ToString(TSWTourDB.InsertTSW_Tour(itemTour)); //***************************************** //***************************************** //***************************************** //This number is generated from the previous line itemPersonnel.FromLive = m_FromLive; itemPersonnel.TourID = TourId; itemPersonnel.PersonnelID = Helper.ToInt32(ddlPromotorName.SelectedValue); itemPersonnel.TitleID = varTitleId;//46 Per Angel Torres it's ok to leave it like this //itemPersonnel.TitleID = Helper.ToInt32(TitleID); //step 4. Assign Personnel //Response.Write(itemPersonnel.TourID+ 1+ 1+1); Personnel itemRetunPersonnel= PersonnelDB.InsertTSW_Personnel(itemPersonnel); if (itemRetunPersonnel.ReturnValue <= 10) { //lblErrors.Text += "Error Creating Personnel" + itemRetunPersonnel.ReturnValue + itemRetunPersonnel.ReturnString; PnlError.Visible = true; } else { //lblErrors.Text += "Personnel Created Succesfully: " + itemRetunPersonnel.ReturnValue; //varPersonnelIdAssigned= itemRetunPersonnel.ReturnValue; PnlError.Visible = true; } //***************************************** //***************************************** //***************************************** //Step 5. Assign Premium Tours //loop for all the grid and premiums. I recommend to create an array and then save the array int varQty=0; foreach (RepeaterItem item in rptrPremiums.Items) { //varQty += Helper.ToInt32((TextBox)item.FindControl("txtPremQty")); varQty = Helper.ToInt32((string)((TextBox)item.FindControl("txtPremQty")).Text); //throw new Exception(varQty.ToString()); if (varQty>0) { itemPremiums.FromLive = m_FromLive; itemPremiums.SiteID = SiteId; itemPremiums.SIHOTPerson.HN = Helper.ToInt32(hdnHNDirectFromSIHOT.Value); itemPremiums.SIHOTPerson.PCIID = parPCIID; itemPremiums.SIHOTPerson.RNO = paridRNO; itemPremiums.Personnel.PersonnelID = Helper.ToInt32(ddlPromotorName.SelectedValue); ; itemPremiums.PremInvID =Helper.ToInt32((string)((Literal)item.FindControl("litPremID")).Text); itemPremiums.CampaignID = Helper.ToInt32(ddlCampaign.SelectedValue); itemPremiums.TourID = TourId; itemPremiums.Quantity = Helper.ToInt32((string) ((TextBox) item.FindControl("txtPremQty")).Text); //Save the amount of the voucher //if (itemPremiums.Catalogs.PremInvTypeID==6) //{ //if (Helper.ToDecimal((string)((TextBox)item.FindControl("txtPremAmt")).Text)!=0) itemPremiums.Amount = Helper.ToDecimal((string)((TextBox)item.FindControl("txtPremAmt")).Text); //} itemPremiums.PremDate = Helper.ToDateTime(txtTourDate.Text); //itemPremiums.Note = valuefromdatagridnotes; itemPremiums.AuditUser = varSystemUser; itemPremiums.auditDate = Helper.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")); itemPremiums.TourLocationID =Helper.ToInt32(ddlTourLocation.SelectedValue); Premiums itemRetunPremiums = PremiumsDB.InsertTSW_Premiums(itemPremiums); if (itemRetunPremiums.ReturnString != "Success") { //lblErrors.Text += "Error Creating the Premium:" + // itemRetunPremiums.ReturnString + itemRetunPremiums.ReturnValue; PnlError.Visible = true; } //else //{ //lblErrors.Text += "Premium Created Succesfully: " + itemRetunPremiums.ReturnValue; //PnlError.Visible = true; //Insert all the PremId generated from TSW in PMS Interface //Verify that the inherid values are being taken witht the current values from the screen //To be tested3/4/2010 //PremiumsDB.InsertPMS_Premiums(itemPremiums); //} } } //Step6. Save the Status, the prospectId, and tourid and disable the Premiums Grid if ((string)Session["AccessLevel"] != "Manager") { DisableRepeater(); } itemPreTourBooking.ReservationNumber = Helper.ToInt32(lblReservation.Text); itemPreTourBooking.Status = "Booked"; lblStatus.Text = "Booked"; hdnStatus.Value = "Booked"; itemPreTourBooking.FromLive = m_FromLive; if (TourId != 0) itemPreTourBooking.TourID = TourId; else itemPreTourBooking.TourID = 1111; itemPreTourBooking.ProspectID = ProspectId; itemPreTourBooking.PCIID = parPCIID; itemPreTourBooking.HN = Helper.ToInt32(hdnHNDirectFromSIHOT.Value); itemPreTourBooking.SubReservationNumber = Helper.ToInt32(hdnRSNO.Value); PreTourBookingDB.Update_PreBooked(itemPreTourBooking); btnBook.Visible = false; btnPremiums.Visible = false; phNewProspect.Visible = false; lblprospectID.Text=Helper.ToString(ProspectId); lblTourID.Text=Helper.ToString(TourId); DisableAll(); lblErrors.Text = "<font color='blue'>To make changes use TSW.</font>"; PnlError.Visible = true; //Save Notes in TSW Interface for the Booked Status if (TxtNotesBooked.Text != "") { SaveNotesTSW(ddlCommentType, TxtNotesBooked, false); } SaveAutomaticNotesPMS("Prospect has been Booked"); ShowComments(); //Shows THE PREMIUMS HISTORY LoadPremiums_TSW(); }
protected void btnSavePre_Click(object sender, EventArgs e) { //Validating NQ's; This validation doesn't work anymore //if (ddlNQTypes.SelectedValue != "" && RadInterestedTour.SelectedValue == "yes") //{ // lblNQTypes.Text = "<font color ='red'>De-Select the NQ to continue..</font>"; // lblNQTypes.Visible = true; // return; //} //Save the prebooking PMS Interface //enable the rest of the controls PreTourBooking item = new PreTourBooking(); item.ReservationNumber = Helper.ToInt32(lblReservation.Text); item.DateContacted = Helper.ToDateTime(txtDateContacted.Text); item.ContactedBy = txtContactedBy.Text;//removeDC item.ContactedBy = ddlVCinfo.SelectedValue; item.Invited = chkInvited.Checked; //OLDitem.HN = SIHOTHotelCode; item.HN = Helper.ToInt32(hdnHNDirectFromSIHOT.Value); item.SubReservationNumber = Helper.ToInt32(hdnRSNO.Value); item.FromLive = m_FromLive; //Check if the record already exist in the hidden field with the status if (hdnStatus.Value=="Available") //Make an update { if (RadInterestedTour.SelectedValue == "yes") { //save PMS Interface and enable the other section item.InterestedInTour = "yes"; if (txtFollowUpDate.Text != "") { item.FollowUpDate = Helper.ToDateTime(txtFollowUpDate.Text); item.FollowUpTime = ddlFollowUpTime.SelectedValue; } item.PCIID = parPCIID; // Already Invited if (chkDoNOTContact.Checked == true) item.Status = "DoNOTContact"; else item.Status = "PreBooked"; EnableBooking(); hdnStatus.Value = item.Status; SaveAutomaticNotesPMS("Prospect has been Pre-Booked."); } else if (RadInterestedTour.SelectedValue == "no") { //save PMS Interface and enable the other section item.InterestedInTour = RadInterestedTour.SelectedValue; item.PCIID = parPCIID; //item.FollowUpDate = Helper.ToDateTime(txtFollowUpDate.Text); if (chkDoNOTContact.Checked == true) item.Status = "DoNOTContact"; else item.Status = "Available"; //Invited hdnStatus.Value = item.Status; } else if (RadInterestedTour.SelectedValue == "maybe") { //Save the detail information and becomes not available with notes. item.InterestedInTour = RadInterestedTour.SelectedValue; if (txtFollowUpDate.Text != "") { item.FollowUpDate = Helper.ToDateTime(txtFollowUpDate.Text); item.FollowUpTime = ddlFollowUpTime.SelectedValue; } if (chkInvited.Checked == true) item.Invited = true; if (chkDoNOTContact.Checked == true) item.Status = "DoNOTContact"; else item.Status = "Available"; item.PCIID = parPCIID; hdnStatus.Value = item.Status; } item.NQTypesID = Helper.ToInt32(ddlNQTypes.SelectedValue); PreTourBookingDB.Update_PreBookedTour(item); } //The status doesn't exist. It's a brand new insert else if (hdnStatus.Value=="") { if (RadInterestedTour.SelectedValue == "yes") { //save PMS Interface and enable the other section item.InterestedInTour = "yes"; item.PCIID = parPCIID; if (txtFollowUpDate.Text != "") { item.FollowUpDate = Helper.ToDateTime(txtFollowUpDate.Text); item.FollowUpTime = ddlFollowUpTime.SelectedValue; } item.Status = "PreBooked"; //Invited hdnStatus.Value = item.Status; //Save the Status in tblSIHOTPerson EnableBooking(); SaveAutomaticNotesPMS("Prospect has been Pre-Booked."); } else if (RadInterestedTour.SelectedValue == "no") { //Save the detail information and becomes not available with notes. if (chkDoNOTContact.Checked == true) { //save the status for that reservation "DoNOTContact" item.Status = "DoNOTContact"; } item.PCIID = parPCIID; item.Status = "Available"; item.InterestedInTour = "no"; hdnStatus.Value = item.Status; } //throw new Exception(RadInterestedTour.SelectedValue); else { if (txtFollowUpDate.Text != "") { item.FollowUpDate = Helper.ToDateTime(txtFollowUpDate.Text); item.FollowUpTime = ddlFollowUpTime.SelectedValue; } //Save the detail information and becomes not available with notes. if (chkInvited.Checked == true) item.Invited = true; if (chkDoNOTContact.Checked == true) item.Status = "DoNOTContact"; else item.Status = "Available"; item.PCIID = parPCIID; hdnStatus.Value = item.Status; item.InterestedInTour = "maybe"; } item.NQTypesID = Helper.ToInt32(ddlNQTypes.SelectedValue); if (txtDateContacted.Text != string.Empty) { PreTourBookingDB.Insert_PreBookedTour(item); } } lblStatus.Text = item.Status; //if the info tab has notes. Save them. if (txtNotesPreBooked.Text != "") { SaveNotesPMS(txtNotesPreBooked, false); } ShowComments(); PnlConfirmation.Visible = true; PnlDups.Visible = false; PnlMain.Visible = false; phNewProspect.Visible = false; lblConfirmation.Text = "Info saved succesfully."; TSWProspect itemProspect = new TSWProspect(); itemProspect.FromLive = m_FromLive; itemProspect.CN = lblFName.Text.Trim(); itemProspect.SN = lblLastName.Text.Trim(); itemProspect.Phone = hdnPhone1.Value.Trim(); itemProspect.EMAIL = hdnEmail.Value.Trim(); CheckIfProspectExistTSW(itemProspect); }
void SavePreBookingAutomatic() { //Save the prebooking PMS Interface //enable the rest of the controls PreTourBooking item = new PreTourBooking(); item.FromLive = m_FromLive; item.ReservationNumber = Helper.ToInt32(lblReservation.Text); item.SubReservationNumber =Helper.ToInt32(hdnRSNO.Value); item.DateContacted = Helper.ToDateTime(txtDateContacted.Text); item.ContactedBy = ddlVCinfo.SelectedValue; //item.ContactedBy = txtContactedBy.Text; //removedc item.Invited = chkInvited.Checked; item.HN = Helper.ToInt32(hdnHNDirectFromSIHOT.Value); item.NQTypesID = Helper.ToInt32(ddlNQTypes.SelectedValue); //Check if the record already exist in the hidden field with the status if (hdnStatus.Value == "Available" || hdnStatus.Value == "PreBooked") //Make an update { if (RadInterestedTour.SelectedValue == "yes") { //save PMS Interface and enable the other section item.InterestedInTour = "yes"; if (txtFollowUpDate.Text != "") item.FollowUpDate = Helper.ToDateTime(txtFollowUpDate.Text); item.FollowUpTime = ddlFollowUpTime.SelectedValue; item.PCIID = parPCIID; // Already Invited if (chkDoNOTContact.Checked == true) item.Status = "DoNOTContact"; else item.Status = "PreBooked"; EnableBooking(); hdnStatus.Value = item.Status; SaveAutomaticNotesPMS("Prospect has been Pre-Booked."); } else if (RadInterestedTour.SelectedValue == "no") { //save PMS Interface and enable the other section item.InterestedInTour = "no"; item.PCIID = parPCIID; //item.FollowUpDate = Helper.ToDateTime(txtFollowUpDate.Text); if (chkDoNOTContact.Checked == true) item.Status = "DoNOTContact"; else item.Status = "Available"; //Invited hdnStatus.Value = item.Status; } else if (RadInterestedTour.SelectedValue == "maybe") { //Save the detail information and becomes not available with notes. item.InterestedInTour = "maybe"; if (chkInvited.Checked == true) item.Invited = true; if (chkDoNOTContact.Checked == true) item.Status = "DoNOTContact"; else item.Status = "Available"; item.PCIID = parPCIID; hdnStatus.Value = item.Status; } PreTourBookingDB.Update_PreBookedTour(item); } //The status doesn't exist. It's a brand new insert else if (hdnStatus.Value == "") { if (RadInterestedTour.SelectedValue == "yes") { //save PMS Interface and enable the other section item.InterestedInTour = "yes"; item.PCIID = parPCIID; if (txtFollowUpDate.Text != "") { item.FollowUpDate = Helper.ToDateTime(txtFollowUpDate.Text); item.FollowUpTime = ddlFollowUpTime.SelectedValue; } item.Status = "PreBooked"; //Invited //Save the Status in tblSIHOTPerson EnableBooking(); SaveAutomaticNotesPMS("Prospect has been Pre-Booked."); hdnStatus.Value = item.Status; } else if (RadInterestedTour.SelectedValue == "no") { //Save the detail information and becomes not available with notes. if (chkDoNOTContact.Checked == true) { //save the status for that reservation "DoNOTContact" item.Status = "DoNOTContact"; } item.PCIID = parPCIID; item.Status = "Available"; item.InterestedInTour = "no"; hdnStatus.Value = item.Status; } //throw new Exception(RadInterestedTour.SelectedValue); else if (RadInterestedTour.SelectedValue == "maybe") { //Save the detail information and becomes not available with notes. if (chkInvited.Checked == true) item.Invited = true; if (chkDoNOTContact.Checked == true) item.Status = "DoNOTContact"; else item.Status = "Available"; item.PCIID = parPCIID; hdnStatus.Value = item.Status; item.InterestedInTour = "maybe"; } item.NQTypesID = Helper.ToInt32(ddlNQTypes.SelectedValue); if (txtDateContacted.Text != string.Empty) { PreTourBookingDB.Insert_PreBookedTour(item); } } lblStatus.Text = item.Status; //if the info tab has notes. Save them. if (txtNotesPreBooked.Text != "") { SaveNotesPMS(txtNotesPreBooked, false); } ShowComments(); }
void PopulatePreBooking(PreTourBooking itemsPreBooking) { if (itemsPreBooking.DateContacted!=null) txtDateContacted.Text = Helper.ToString(itemsPreBooking.DateContacted); if (itemsPreBooking.ContactedBy!=null) ddlVCinfo.Text = itemsPreBooking.ContactedBy; if (ddlVCinfo.SelectedValue == "") { txtContactedBy.Visible = true; txtContactedBy.Text = itemsPreBooking.ContactedBy;//removeDC' } else { txtContactedBy.Visible = false; } //throw new Exception(itemsPreBooking.Invited.ToString()); if (itemsPreBooking.Invited == true) chkInvited.Checked = true; if (itemsPreBooking.Status == "DoNOTContact") chkDoNOTContact.Checked = true; RadInterestedTour.SelectedValue = itemsPreBooking.InterestedInTour; if (itemsPreBooking.FollowUpDate!=null) txtFollowUpDate.Text = itemsPreBooking.FollowUpDate.Value.ToString("MM/dd/yyyy"); //throw new Exception(itemsPreBooking.FollowUpTime); if (itemsPreBooking.FollowUpTime!=null) ddlFollowUpTime.Text = itemsPreBooking.FollowUpTime; }
public static void Update_PreBooked(PreTourBooking value) { //throw new Exception("Updating PreBooked: " + value.SubReservationNumber); SqlParameter[] param = new SqlParameter[] { new SqlParameter("@FromLive", value.FromLive), new SqlParameter("@ReservationNum", value.ReservationNumber), new SqlParameter("@SubReservationNum", value.SubReservationNumber), new SqlParameter("@PCIID", value.PCIID), new SqlParameter("@HotelNumber", value.HN), new SqlParameter("@Status", value.Status), new SqlParameter("@TourDate", value.TourDate), new SqlParameter("@TourID", value.TourID), new SqlParameter("@ProspectID", value.ProspectID) }; SqlHelper.ExecuteNonQuery(Helper.ConnectionString, CommandType.StoredProcedure, "Update_PreBooked_Status", param); }