public static TSWTour CancelTourPMS(TSWTour value) { TSWTour retval = new TSWTour(); SqlParameter[] param = new SqlParameter[] { new SqlParameter("@FromLive", value.FromLive), new SqlParameter("@ReservationNum", value.PreTourBooking.ReservationNumber), new SqlParameter("@ReservationSubNum", value.PreTourBooking.SubReservationNumber), new SqlParameter("@PCIID", value.PreTourBooking.PCIID), new SqlParameter("@HN", value.PreTourBooking.HN) }; SqlHelper.ExecuteNonQuery(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_CancelTourPMS", param); return retval; }
public static TSWTour CancelTour(TSWTour value) { TSWTour retval = new TSWTour(); SqlParameter[] param = new SqlParameter[] { new SqlParameter("@FromLive", value.FromLive), new SqlParameter("@TourID", value.TourID) }; using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_CancelTour", param)) { if (reader.Read()) { retval = Read(reader); } } 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 btnCancelTour_Click(object sender, EventArgs e) { //Obtain the TourID TSWTour itemCancelTour = new TSWTour(); TSWTour itemCancelTourPMS = new TSWTour(); itemCancelTour.TourID=TourId; itemCancelTour.FromLive=m_FromLive; //Cancel Tour in tSW itemCancelTour = TSWTourDB.CancelTour(itemCancelTour); itemCancelTourPMS.FromLive = m_FromLive; //cancel Tour in PMS Interface itemCancelTourPMS.PreTourBooking.ReservationNumber = paridRNO; itemCancelTourPMS.PreTourBooking.SubReservationNumber = paridRSNO; itemCancelTourPMS.PreTourBooking.PCIID = parPCIID; itemCancelTourPMS.PreTourBooking.HN = Helper.ToInt32(hdnHNDirectFromSIHOT.Value); itemCancelTourPMS = TSWTourDB.CancelTourPMS(itemCancelTourPMS); if (itemCancelTour.ReturnValue == 0) { SaveAutomaticNotesPMS("Tour has been cancelled by " + varSystemUser); lblCancelTour.Text = itemCancelTour.ReturnString + " succesfully."; btnContinueCancel.Visible = true; btnCancelTour.Visible = false; } else { lblCancelTour.Text = "Internal Error[" + itemCancelTour.ReturnValue+"-"+itemCancelTour.ReturnString +"]"; } //Write "Cancel" in the notes }
private void PopulateTourTime() { TSWTour parItemTour = new TSWTour(); parItemTour.SiteID=SiteId; parItemTour.TourLocationID = Helper.ToInt32(ddlTourLocation.SelectedValue); if (m_FromLive == 0) parItemTour.DBName = "tswpracticeSP1"; else parItemTour.DBName = "TSWDATA"; //if (Helper.ToDateTime(txtTourDate.Text).Value!=null) parItemTour.TourDate = Helper.ToDateTime(txtTourDate.Text).Value; //throw new Exception(Helper.ToDateTime(txtTourDate.Text).ToString("mm/dd/yyyy")); ddlTourTime.Items.Clear(); TSWTourList list = TSWTourDB.GetWaves(parItemTour); ddlTourTime.Items.Add(new ListItem("Select..", "")); //throw new Exception(list.Count.ToString()); foreach (TSWTour item in list) { ddlTourTime.Items.Add(new ListItem(item.wave + " ("+ item.NumberAvailable + ")" , item.waveID.ToString())); } }
private void LoadTour_TSW() { TSWTour retval; TSWTour item = new TSWTour(); item.TourID = Helper.ToInt32(lblTourID.Text); item.FromLive = m_FromLive; TSWTour itemBack=TSWTourDB.GetTourBackFromTSW(item); if (itemBack != null) { ddlCampaign.SelectedValue = itemBack.CampaignID.ToString(); ddlTourLocation.SelectedValue = itemBack.TourLocationID.ToString(); //if (hdnStatus.Value!="PreTour") txtTourDate.Text = itemBack.TourDate.ToString(); if (hdnStatus.Value != "PreTour") PopulateTourTime(); ddlTourTime.SelectedValue = itemBack.waveID.ToString(); //throw new Exception("Good"); ddlTourTime.Visible = true; } }
//Loads the concierge private void LoadPersonnel_TSW() { TSWTour items = new TSWTour(); items.TourID = Helper.ToInt32(lblTourID.Text); items.FromLive = m_FromLive; TSWTour itemsBack = TSWTourDB.GetBackPersonnelFromTSW(items); if (itemsBack != null) { ddlPromotorName.SelectedValue = itemsBack.Catalogs.PersonnelID; } }
protected void rptProspects_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { HyperLink hlGUID = (HyperLink)e.Item.FindControl("hlGUID"); CheckBox chkIN = (CheckBox)e.Item.FindControl("chkBoxIn"); HyperLink hlRoom = (HyperLink)e.Item.FindControl("hlRoom"); HyperLink hlLastName = (HyperLink)e.Item.FindControl("hlLastName"); CheckBox chkAvl = (CheckBox)e.Item.FindControl("chkBoxAva"); CheckBox chkInfo = (CheckBox)e.Item.FindControl("chkBoxInf"); CheckBox chkInvit = (CheckBox)e.Item.FindControl("chkBoxInv"); HyperLink hlCheckInDate = (HyperLink)e.Item.FindControl("hlCheckInDate"); HyperLink hlCheckOutDate = (HyperLink)e.Item.FindControl("hlCheckOutDate"); HyperLink Status = (HyperLink)e.Item.FindControl("Status"); HyperLink hlCountry = (HyperLink)e.Item.FindControl("hlCountry"); HyperLink hlAgency = (HyperLink)e.Item.FindControl("hlAgency"); HyperLink hlRooms = (HyperLink)e.Item.FindControl("hlRooms"); HyperLink hlPax = (HyperLink)e.Item.FindControl("hlPax"); HyperLink hlBookDate = (HyperLink)e.Item.FindControl("hlBookDate"); HyperLink hlVC = (HyperLink)e.Item.FindControl("hlVC"); HyperLink hlSegment = (HyperLink)e.Item.FindControl("hlSegment"); HyperLink hlVIP = (HyperLink)e.Item.FindControl("hlVIP"); HyperLink hlNQ = (HyperLink)e.Item.FindControl("hlNQ"); HyperLink hlComments = (HyperLink)e.Item.FindControl("hlComments"); LinkButton btnCancelTour = (LinkButton)e.Item.FindControl("btnCancelTour"); Label lblTourID = (Label)e.Item.FindControl("lblTourID"); ImageButton btnComments = (ImageButton)e.Item.FindControl("btnA"); HyperLink hlMemberNum = (HyperLink)e.Item.FindControl("hlMemberNum"); SIHOTPerson item = (SIHOTPerson)e.Item.DataItem; btnComments.ToolTip = "View Comments"; try { //Shows the cancel tour link if ((string)Session["AccessLevel"] == "Manager" && item.Status == "Booked" && DateTime.Compare(item.DEP.Value, DateTime.Now.Date) > 0) { btnCancelTour.Visible = true; //put the text for the label here //just helps to debug lblTourID.Text = item.TourId.ToString(); lblTourID.Visible = false; btnCancelTour.PostBackUrl = "Allocatetour.aspx?cmd=cancel&idRNO=" + item.RNO + "&idRSNO=" + item.RSNO + "&PCIID=" + item.PCIID + "&TourID=" + item.TourId; //btnCancelTour.PostBackUrl = "registration.aspx?cmd=delete&id=" + item.MemberId; ; //hlDelete.NavigateUrl = "member-edit.aspx?cmd=delete&id=" + item.MemberId; } if ((string)Session["AccessLevel"] == "Manager" && item.Status != "Booked" && item.Status != "PreBooked" && DateTime.Compare(item.DEP.Value, DateTime.Now.Date) >= 0 && item.OC.Trim() == "CI") { chkAvl.Enabled = true; chkAvl.BackColor = System.Drawing.Color.Yellow; } if ((string)Session["AccessLevel"] == "Manager") { btnSaveGrid.Visible = true; } btnComments.PostBackUrl = "Allocatetour.aspx?cmd=notes&idRNO=" + item.RNO + "&idRSNO=" + item.RSNO + "&PCIID=" + item.PCIID; //hlGUID.Text = item.PCIID.ToString();//+ (item.RNO.ToString()); //hlGUID.NavigateUrl = "AllocateTour.aspx?idRNO=" + item.RNO + "&PCIID=" + item.PCIID; //hlGUID.Visible = false; if (item.OC.Trim() == "CI") { chkIN.Checked = true; } if (item.Available == true) { chkAvl.Checked = true; } if (item.MATCHCODE != null) { if (item.MATCHCODE.Length > 3) { hlMemberNum.Text = item.MATCHCODE.Substring(0, 4); hlMemberNum.ToolTip = item.MATCHCODE.Trim(); } else { hlMemberNum.Text = item.MATCHCODE.Trim(); } } hlRoom.Text = item.RN; hlRoom.NavigateUrl = "AllocateTour.aspx?idRNO=" + item.RNO + "&idRSNO=" + item.RSNO + "&PCIID=" + item.PCIID; if (item.SN.Length > 10) { hlLastName.Text = item.SN.Substring(0, 10); } else { hlLastName.Text = item.SN.Trim(); } hlLastName.ToolTip = item.SN.Trim() + ", " + item.CN.Trim(); hlLastName.NavigateUrl = "AllocateTour.aspx?idRNO=" + item.RNO + "&idRSNO=" + item.RSNO + "&PCIID=" + item.PCIID; if (item.PreTourBooking.DateContacted != null) { hlBookDate.Text = Helper.ToString(item.PreTourBooking.DateContacted.Value.ToString("MM/dd/yyyy")); hlBookDate.NavigateUrl = "AllocateTour.aspx?idRNO=" + item.RNO + "&idRSNO=" + item.RSNO + "&PCIID=" + item.PCIID; } if (item.PreTourBooking.TourDate != null) { hlBookDate.Text = Helper.ToString(item.PreTourBooking.TourDate.Value.ToString("MM/dd/yyyy")); chkInvit.Checked = true; //itemsPreBooking.FollowUpDate.Value.ToString("MM/dd/yyyy"); } if (item.Status == "Booked" && item.TourId != 0) { TSWTour itemTSWTour = new TSWTour(); itemTSWTour = TSWTourDB.Select_t_Tour(item.TourId, m_FromLive); if (itemTSWTour.TourDate!=null) hlBookDate.Text = itemTSWTour.TourDate.Value.ToString("MM/dd/yyyy"); } if (item.Status == "PreBooked" || item.Status == "Booked") { chkInvit.Checked = true; } if (item.PreTourBooking.Invited && item.PreTourBooking.TourDate!=null) { hlBookDate.Text = Helper.ToString(item.PreTourBooking.TourDate.Value.ToString("MM/dd/yyyy")); hlBookDate.NavigateUrl = "AllocateTour.aspx?idRNO=" + item.RNO + "&idRSNO=" + item.RSNO + "&PCIID=" + item.PCIID; } //vw_TSW_ProspectTour.Wave, vw_TSW_ProspectTour.TourResult, vw_TSW_ProspectTour.VacConsult,DisplayMarket,DisplaySegment //switch (m_FilCriteria) //{case "pre": break;} if (item.TSWCatalogs.FirstName.Length > 5)//VC Full Name { hlVC.Text = item.TSWCatalogs.FirstName.Substring(0, 4); hlVC.ToolTip = item.TSWCatalogs.FirstName.Trim() + "/" + item.TSWTour.wave + "/" + item.TSWTour.TourResult; } else { hlVC.Text = item.TSWCatalogs.FirstName.Trim(); } if (item.DisplaySegment != null) { if (item.DisplaySegment.Length > 3)//Segment Description { hlSegment.Text = item.DisplayMarket.Substring(0, 3).ToUpper(); hlSegment.ToolTip = item.DisplayMarket.Trim() + "/" + item.DisplaySegment.Trim(); } else { hlSegment.Text = item.DisplayMarket.ToUpper().Trim(); } } if (item.PreTourBooking.DateContacted!=null) { chkInfo.Checked = true; } if ((item.ARR != null)) { //litPostedDate.Text = item.Posted_date.Value.ToString("MM/dd/yyyy"); hlCheckInDate.Text = item.ARR.Value.ToString("MM/dd/yyyy"); hlCheckInDate.NavigateUrl = "AllocateTour.aspx?idRNO=" + item.RNO + "&idRSNO=" + item.RSNO + "&PCIID=" + item.PCIID; if (DateTime.Compare(item.ARR.Value, DateTime.Now.Date) <= 0) { //hlCheckInDate.Text = "<font color='red'> " + hlCheckInDate.Text + "</color>"; hlCheckInDate.Text = hlCheckInDate.Text; hlCheckInDate.NavigateUrl = "AllocateTour.aspx?idRNO=" + item.RNO + "&idRSNO=" + item.RSNO + "&PCIID=" + item.PCIID; //hlCheckInDate.ToolTip = "This Reservation is Check Out"; } } if ((item.DEP != null)) { //litPostedDate.Text = item.Posted_date.Value.ToString("MM/dd/yyyy"); hlCheckOutDate.Text = item.DEP.Value.ToString("MM/dd/yyyy"); hlCheckOutDate.NavigateUrl = "AllocateTour.aspx?idRNO=" + item.RNO + "&idRSNO=" + item.RSNO + "&PCIID=" + item.PCIID; if (DateTime.Compare(item.DEP.Value, DateTime.Now.Date) <= 0) { //hlCheckOutDate.Text = "<font color='red'> " + hlCheckOutDate.Text + "</color>"; hlCheckOutDate.Text = hlCheckOutDate.Text; hlCheckOutDate.NavigateUrl = "AllocateTour.aspx?idRNO=" + item.RNO + "&idRSNO=" + item.RSNO + "&PCIID=" + item.PCIID; //hlCheckOutDate.ToolTip = "This Reservation is Check Out"; } } if (item.Status != null ) { if (item.Status.Length > 3 && item.Status=="PreBooked") { Status.Text = "PrB"; Status.ToolTip = item.Status.Trim(); } else if (item.Status.Length > 3 && item.Status == "PreTour") { Status.Text = "PrT"; Status.ToolTip = item.Status.Trim(); } else if (item.Status.Length > 3 ) { Status.Text = item.Status.Substring(0, 3); Status.ToolTip = item.Status.Trim(); } else { Status.Text = item.Status.Trim(); Status.ToolTip = item.Status.Trim(); } } else { Status.Text = "Ava"; Status.ToolTip = "Available"; } Status.NavigateUrl = "AllocateTour.aspx?idRNO=" + item.RNO + "&idRSNO=" + item.RSNO + "&PCIID=" + item.PCIID; hlCountry.Text = item.Address.Country; hlCountry.NavigateUrl = "AllocateTour.aspx?idRNO=" + item.RNO + "&idRSNO=" + item.RSNO + "&PCIID=" + item.PCIID; //hlRooms.Text = item.ro; //hlRooms.NavigateUrl = "AllocateTour.aspx?idRNO=" + item.RNO + "&PCIID=" + item.PCIID; if (item.PreTourBooking.NQTypesDesc != null && item.PreTourBooking.NQTypesDesc.Length>4) { hlNQ.Text = item.PreTourBooking.NQTypesDesc.Substring(0, 4); hlNQ.ToolTip = item.PreTourBooking.NQTypesDesc.Trim(); } else if (item.PreTourBooking.NQTypesDesc != null && item.PreTourBooking.NQTypesDesc.Length <= 4) { hlNQ.Text = item.PreTourBooking.NQTypesDesc.Trim(); } if (item.AgencyName.Length > 10) { hlAgency.Text = item.AgencyName.Substring(0, 10); hlAgency.ToolTip = item.AgencyName.Trim(); } else { hlAgency.Text = item.AgencyName.Trim(); } hlAgency.NavigateUrl = "AllocateTour.aspx?idRNO=" + item.RNO + "&idRSNO=" + item.RSNO + "&PCIID=" + item.PCIID; hlPax.Text = item.NOPAX.ToString(); hlPax.NavigateUrl = "AllocateTour.aspx?idRNO=" + item.RNO + "&idRSNO=" + item.RSNO + "&PCIID=" + item.PCIID; hlVIP.Text = item.VIP; hlVIP.NavigateUrl = "AllocateTour.aspx?idRNO=" + item.RNO + "&idRSNO=" + item.RSNO + "&PCIID=" + item.PCIID; if (item.Notes.NoteDesc.Length > 20) { hlComments.Text = item.Notes.NoteDesc.Substring(0, 20); hlComments.ToolTip = item.Notes.NoteDesc.Trim(); } else { hlComments.Text = item.Notes.NoteDesc.Trim(); } if (item.PrimaryFlag == false) { hlComments.Text = "<strong><font color='orange'>NOTPrimary</font></strong>"; } if (item.RT == "3") { //disable all the links hlComments.Text += " <font color='red'>Cancelled</font>"; } //((AjaxControlToolkit.ModalPopupExtender)e.Item.FindControl("pop")).Show(); } catch (Exception flaws) { throw new Exception(flaws.Message); } finally { } } }
public static TSWTour Select_t_Tour(int TourID, int FromLive) { TSWTour retval = new TSWTour(); SqlParameter[] param = new SqlParameter[] { new SqlParameter("@FromLive", FromLive), new SqlParameter("@TourID", TourID) }; using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "Select_t_Tour", param)) { if (reader.Read()) { retval = Read(reader); } } return retval; }
public static TSWTour Read(SqlDataReader reader) { TSWTour retval = new TSWTour(); for (int i = 0; i < reader.FieldCount; i++) { switch (reader.GetName(i)) { case "TourID": retval.TourID = Helper.ToInt32(reader[i]); break; case "TourTypeID": retval.TourTypeID = Helper.ToInt32(reader[i]); break; case "TourTypeDescription": retval.TourTypeDesc = Helper.ToString(reader[i]); break; case "Wave": retval.wave = Helper.ToString(reader[i]); break; case "NumberAvailable": retval.NumberAvailable = Helper.ToInt32(reader[i]); break; case "TourDate": retval.TourDate = Helper.ToDateTime(reader[i]); break; case "WaveID": retval.waveID = Helper.ToInt32(reader[i]); break; case "ReturnValue": retval.ReturnValue = Helper.ToInt32(reader[i]); break; case "ReturnString": retval.ReturnString = Helper.ToString(reader[i]); break; case "CampaignID": retval.CampaignID = Helper.ToInt32(reader[i]); break; case "PersonnelID": retval.Catalogs.PersonnelID = Helper.ToString(reader[i]); break; case "TourLocationID" : retval.TourLocationID = Helper.ToInt32(reader[i]); break; case "TourResult": retval.TourResult = Helper.ToString(reader[i]); break; } } return retval; }
public static TSWTourList InsertTSW_Tour(TSWTour value) { //string prospectId = ""; TSWTourList retval = new TSWTourList(); SqlParameter[] param = new SqlParameter[] { new SqlParameter("@FromLive", value.FromLive), new SqlParameter("@SiteID", value.SiteID), new SqlParameter("@ProspectID", value.ProspectId), new SqlParameter("@CampaignID", value.CampaignID), new SqlParameter("@TourTypeID", value.TourTypeID), new SqlParameter("@TourLocationID", value.TourLocationID), new SqlParameter("@TourDate", value.TourDate), new SqlParameter("@PreAssignedTo", ""), new SqlParameter("@WaveID", value.waveID) }; using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_CreateBookedTour", param)) { while (reader.Read()) { retval.Add(Read(reader)); } } //count = Helper.ToInt32(pOut.Value); return retval; }
public static TSWTourList GetWaves(TSWTour parItem) { TSWTourList retval = new TSWTourList(); SqlParameter[] param = new SqlParameter[]{ new SqlParameter("@inDBName", parItem.DBName), new SqlParameter("@inSiteId", parItem.SiteID), new SqlParameter("@inTourLocationID", parItem.TourLocationID), new SqlParameter("@inDate", parItem.TourDate), }; using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_GetWaves", param)) { while (reader.Read()) { retval.Add(Read(reader)); } } //count = Helper.ToInt32(pOut.Value); return retval; }