public static TSWProspect GetBackProspectFromTSW(TSWProspect value)
{
TSWProspect retval = null;
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@FromLive", value.FromLive),
new SqlParameter("@ProspectID", value.ProspectId)
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_GetProspect", param))
{
if (reader.Read())
{
retval = Read(reader);
}
}
return retval;
}
public static TSWProspect AgencyInTSWStep1(string value, int parFromLive)
{
TSWProspect retval = new TSWProspect();
//SqlParameter pOut = new SqlParameter("@Count", SqlDbType.Int, 4);
//pOut.Direction = ParameterDirection.Output;
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@FromLive", parFromLive),
new SqlParameter("@ProspectSource", value)
//,pOut
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_GetProspectSources", param))
{
if (reader.Read())
{
retval = Read(reader);
}
}
return retval;
}
private void LoadProspect_TSW()
{
TSWProspect items=new TSWProspect() ;
items.ProspectId = Helper.ToInt32(lblprospectID.Text);
items.FromLive = m_FromLive;
TSWProspect itemsBack = TSWProspectDB.GetBackProspectFromTSW(items);
if (itemsBack != null)
{
//if (itemsBack.DOB != null)
if (itemsBack.DOB != null)
txtDOB.Text = itemsBack.DOB;
if (itemsBack.MaritalID != 0)
ddlMarital1.SelectedValue = itemsBack.MaritalID.ToString();
if (itemsBack.OccupationID != 0)
ddlOccupation.SelectedValue = itemsBack.OccupationID.ToString();
if (itemsBack.IncomeID != 0)
ddlIncome.SelectedValue = itemsBack.IncomeID.ToString();
}
}
//I get the SIHOT reservation from PMSInterface
private SIHOTPerson LoadData(int paridRNO, int paridRSNO, int parPCIID)
{
SIHOTPerson retval;
SIHOTPerson items = SIHOTPersonDB.GetPersons_ByReservationNum(paridRNO, paridRSNO, parPCIID, Helper.ToInt32(hdnHNDirectFromSIHOT.Value), m_FromLive);
if (items != null)
{
if (items.HN != 0)
hdnHNDirectFromSIHOT.Value= Helper.ToString(items.HN);
if (items.RN != null)
lblRoomNum.Text = Helper.ToString(items.RN);
if (items.PCIID!= 0)
lblPCIID.Text = Helper.ToString(items.PCIID);
if (items.RNO != 0)
this.lblReservation.Text = Helper.ToString(items.RNO);
if (items.RSNO != 0)
hdnRSNO.Value = Helper.ToString(items.RSNO);
if (items.CN != null)
this.lblFName.Text = items.CN;
if (items.SN != null)
this.lblLastName.Text = items.SN;
if (items.NOPAX != 0)
this.lblNoPax.Text = Helper.ToString(items.NOPAX);
if (items.ARR != null)
this.lblCheckInDate.Text = items.ARR.Value.ToString("MM/dd/yyyy");
if (items.DEP != null)
this.lblCheckOutDate.Text = items.DEP.Value.ToString("MM/dd/yyyy");
//if(items.EMAIL!=null && items.EMAIL2!=null)
if (items.EMAIL != null)
{
if (items.EMAIL.Length > 12)
{
this.lblEmail.Text = items.EMAIL.Substring(0, 12) + "...";
this.lblEmail.ToolTip = items.EMAIL.Trim();
}
else
{
this.lblEmail.Text = items.EMAIL.Trim();
}
}
if (items.Phone != null && items.Phone2 != null)
lblTelephone.Text = items.Phone + "; " + items.Phone2;
if (items.PH0_CHK_IN != null && items.PH1_CHK_IN != null)
this.lblRoomExtension.Text = items.PH0_CHK_IN + "; " + items.PH1_CHK_IN;
if (items.DOB != null)
{
txtDOB.Text = items.DOB.Value.ToString("MM/dd/yyyy");
this.hdnDOB.Value = String.Format("{0:yyyyMMdd}", items.DOB);
}
if (items.Address != null)
lblCountry.Text = items.Address.Country;
if (items.Salutation != null)
lblSalutation.Text = items.Salutation;
if (items.AgencyName != null)
lblAgency.Text = items.AgencyName;
if (items.ProspectId != 0)
this.lblprospectID.Text = items.ProspectId.ToString();
if (items.TourId != 0)
this.lblTourID.Text = items.TourId.ToString();
if (items.PreTourBooking.NQTypesID != 0)
ddlNQTypes.SelectedValue = items.PreTourBooking.NQTypesID.ToString();
//Allocating the hidden values
hdnSiteId.Value = SiteId.ToString();
hdnSalutation.Value = items.Salutation;
hdnTitle.Value = items.Title;
hdnStreet.Value = items.Address.Street1;
hdnCity.Value = items.Address.City;
hdnState.Value = items.Address.State;
hdnCountry.Value = items.Address.Country;
hdnZipCode.Value = items.Address.Zip;
hdnPhone1.Value = items.Phone;
hdnPhone2.Value = items.Phone2;
hdnFax.Value = items.Fax;
hdnEmail.Value = items.EMAIL;
hdnDisplayMarket.Value = items.DisplayMarket;
hdnDisplaySegment.Value = items.DisplaySegment;
lblDMarket.Text = items.DisplayMarket;
lblDSegment.Text = items.DisplaySegment;
hdnTaxID.Value = items.TAXID;
}
int count = 0;
PreTourBooking itemsPreBooking = PreTourBookingDB.GetPreBooked(paridRNO, parPCIID, Helper.ToInt32(hdnHNDirectFromSIHOT.Value), m_FromLive, out count);
if (count > 0)
{
lblStatus.Text = itemsPreBooking.Status;
if (lblStatus.Text == "PreTour")
{
RequiredFieldValidator7.Enabled = false;
RequiredFieldValidator7.EnableClientScript = false;
}
if (itemsPreBooking.Status == "Booked")
{
lblErrors.Text = "<font color='blue'>To make changes use TSW.</font>";
PnlError.Visible = true;
if ((string)Session["AccessLevel"] == "Manager")
{
btnSaveMgrPremiums.Visible = true;
}
LoadProspect_TSW();
LoadPersonnel_TSW();
LoadTour_TSW();
LoadPremiums_TSW();
}
hdnStatus.Value = itemsPreBooking.Status;
if (itemsPreBooking.Status == "DoNOTContact")
{
hdnchkDoNOTContact.Value = "true";
}
hdnchkInvited.Value = Helper.ToString(itemsPreBooking.Invited);
hdnRadInterestedTour.Value = Helper.ToString(itemsPreBooking.InterestedInTour);
RadInterestedTour.SelectedValue = itemsPreBooking.InterestedInTour;
hdnFollowUpDate.Value = Helper.ToString(itemsPreBooking.FollowUpDate);
if (hdnStatus.Value == "Available")
{
//and Populate the up section
PopulatePreBooking(itemsPreBooking);
EnablPreBooking();
}
if (hdnStatus.Value == "PreBooked")
{
//and Populate the up section
PopulatePreBooking(itemsPreBooking);
EnableBooking();
}
if (hdnStatus.Value == "Booked" || hdnStatus.Value == "DoNOTContact" || hdnStatus.Value == "PreTour")
{
PopulatePreBooking(itemsPreBooking);
DisableAll();
}
}
else
{
//The status it's still "available"
//PopulatePreBooking(itemsPreBooking);
EnablPreBooking();
}
//From the Sihot Person object declared on TOP
if (hdnStatus.Value == "PreTour") //Create a structure for the statuses
{
PreTour();
}
else if (hdnStatus.Value != "Booked")
{
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();
//throw new Exception(itemProspect.FromLive + itemProspect.CN + itemProspect.SN + itemProspect.Phone + itemProspect.EMAIL);
CheckIfProspectExistTSW(itemProspect);
}
retval = items;
return retval;
}
void CheckIfProspectExistTSW(TSWProspect itemProspect)
{
int count = 0;
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
{
TSWProspectList itemProspectList = TSWProspectDB.SearchUniqueProspect(itemProspect, out count); //check the four fields
//I need to iterate thru the list
if (itemProspectList.Count > 0 && count > 0 && count != null) //System.DBNull
{
//DataSet ds = TSWProspectDB.GetDupsProspects(itemProspect);
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);
//foreach (DataRow irow in ds.Tables(0).Rows)
//{
// irow(
//}
lblCountProsp.Text = rptDuplicates.Items.Count.ToString() + " Record(s).";
lblCountProsp.Visible = true;
lblProspectDup.Text = "This prospect already exist in TSW and may have attended to the presentation in the past.";
PnlDups.Visible = true;
return;
}
}
}
protected void RadInterestedTour_SelectedIndexChanged(object sender, EventArgs e)
{
//this code doesn't apply anymore
// if (ddlNQTypes.SelectedValue!="" && RadInterestedTour.SelectedValue == "yes")
// {
// lblNQTypes.Text = "<font color ='red'>De-Select the NQ to continue..</font>";
// lblNQTypes.Visible = true;
// return;
//}
if (RadInterestedTour.SelectedValue == "yes")
{
//go to the next tab and check the prospect info
TSWProspect itemProspect = new TSWProspect();
itemProspect.CN = lblFName.Text.Trim();
itemProspect.SN = lblLastName.Text.Trim();
itemProspect.Phone = hdnPhone1.Value.Trim();
itemProspect.EMAIL = hdnEmail.Value.Trim();
//Saves the info section automatic
SavePreBookingAutomatic();
CheckIfProspectExistTSW(itemProspect);
EnableBooking();
TabContainer1.ActiveTab = TabContainer1.Tabs[1];
}
else if (RadInterestedTour.SelectedValue == "maybe" && chkInvited.Checked == true)
{
txtFollowUpDate.Enabled = true;
ddlFollowUpTime.Enabled = true;
}
else if (RadInterestedTour.SelectedValue == "no")
{
txtFollowUpDate.Text = "";
txtFollowUpDate.Enabled = false;
ddlFollowUpTime.SelectedValue = "";
ddlFollowUpTime.Enabled = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//AdminUser admin = AdminUserDB.GetAdminUser(Helper.ToString(Session["UserId"]));
parPCIID = Helper.ToInt32(Request["PCIID"]);
paridRNO = Helper.ToInt32(Request["idRNO"]);
paridRSNO = Helper.ToInt32(Request["idRSNO"]);
TourId = Helper.ToInt32(Request["TourID"]);
if (!Page.IsPostBack)
{
//parPCIID= Helper.ToInt32(Request["PCIID"]);
if (paridRNO > 0 && parPCIID > 0)
{
LoadData(paridRNO, paridRSNO, parPCIID);
TSWProspect itemsDups = new TSWProspect();
itemsDups.FromLive = m_FromLive;
itemsDups.CN = lblFName.Text.Trim();
itemsDups.SN = lblLastName.Text.Trim();
itemsDups.Phone = hdnPhone1.Value.Trim();
itemsDups.EMAIL = hdnEmail.Value.Trim();
CheckIfProspectExistTSW(itemsDups);
}
if (m_cmd == "notes")
{
PopulateCommentTypes(ddlPopUpNoteType);
ShowCommentsPopUp();
lblErrors.Visible = false;
PnlUpdatNotes.Visible = true;
PnlMain.Visible = false;
litPopUpComments.Text = "<table class='form1'><tr><td class='form1'>Reservation Number:</td><td class='form1'> <font color='blue'>" + lblReservation.Text + "</font></td><td class='form1'>PCIID:</td><td> <font color='blue'>" + this.lblPCIID.Text + "</font></td>"
+ "<td>Room Number:</td><td> <font color='blue'>" + lblRoomNum.Text + "</font></td><td>Room Extension:</td><td><font color='blue'>" + lblRoomExtension.Text + "</font></td></tr><tr><td>First Name, Last Name:</td><td><font color='blue'>" + lblFName.Text + ", " + lblLastName.Text + "</font></td></tr></table>";
}
if (m_cmd == "cancel")
{
lblErrors.Visible = false;
PnlMain.Visible = false;
pnlCancelTour.Visible = true;
//lblCancelTour.Text = parPCIID.ToString() + " " + paridRNO.ToString() + " " + TourId;
lblCancelTour.Text = "<div align='center'>The following Tour-Reservation is going to be cancelled:</div><table align='center' class='form1'><tr><td> Reservation Number:</td><td> <font color='blue'>" + lblReservation.Text + "</font></td></tr><br>"
+ "<tr><td> PCIID: </td><td><font color='blue'>" + this.lblPCIID.Text + "</font></td></tr><br>"
+ "<tr><td> Room Number: </td><td><font color='blue'>" + lblRoomNum.Text + "</font></td></tr><br>"
+ "<tr><td> Room Extension: </td><td><font color='blue'>" + lblRoomExtension.Text + "</font></td></tr><br>"
+ "<tr><td> First Name: </td><td><font color='blue'>" + lblFName.Text + "</font></td></tr><br>"
+ "<tr><td> Last Name: </td><td><font color='blue'>" + lblLastName.Text + "</font></td></tr><br>"
+ "<tr><td> Check In Date: </td><td><font color='blue'>" + lblCheckInDate.Text + "</font></td></tr><br>"
+ "<tr><td> Tour ID: </td><td><font color='blue'>" + TourId + "</font></td></tr></table>";
}
ProspectId = Helper.ToInt32(Request["pID"]);
//Use the prospect from TSW to create a brand new tour.
if (ProspectId != 0)
{
EnablPreBooking();
}
//Block the fields if the Check Out Date has passed
if (lblCheckOutDate.Text != string.Empty)
{
if (DateTime.Compare(Convert.ToDateTime(lblCheckOutDate.Text), DateTime.Now.Date) < 0)
{
lblCheckOutDate.Text = "<font color='red'> " + lblCheckOutDate.Text + "</color>";
DisableAll();
}
}
//Use the prospect from TSW to create a brand new tour.
if (lblReservation.Text != "" && parPCIID!=0 && SIHOTHotelCode!=0)
ShowComments();
//To show the prizes in blank
PopulatePrizes();
}
}
//dc
public static DataSet GetDupsProspects(TSWProspect value)
{
DataSet retval = new DataSet();
SqlParameter pOut = new SqlParameter("@Count", SqlDbType.Int, 4);
pOut.Direction = ParameterDirection.Output;
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@FromLive", value.FromLive),
new SqlParameter("@inFirst", value.CN),
new SqlParameter("@inLast", value.SN),
new SqlParameter("@inEmail", value.EMAIL),
new SqlParameter("@inPhone", value.Phone)
,pOut
};
retval = SqlHelper.ExecuteDataset(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_SearchForProspect", param);
return retval;
}
void UpdateProspect()
{
TSWProspect itemProspect = new TSWProspect();
itemProspect.FromLive = m_FromLive;
//dcitemProspect.HN = SIHOTHotelCode; //Hotel Number from SIHOT
itemProspect.SiteID = Helper.ToInt32(hdnSiteID.Value);
//itemProspect.Salutation = hdnSalutation.Value;
//itemProspect.Title = hdnSalutation.Value;
itemProspect.ProspectId = Helper.ToInt32(lblProspectID.Text.Trim());
itemProspect.ProspectTypeID = Helper.ToInt32(hdnProspectTypeID.Value);
itemProspect.ProspectStatusID = Helper.ToInt32(hdnProspectStatusID.Value);
itemProspect.ProspectSourceID = Helper.ToInt32(hdnProspectSrcID.Value);
itemProspect.CN = txtFName.Text.Trim();
itemProspect.SN = txtLName.Text.Trim();
itemProspect.Address.Street1 = txtAddress.Text.Trim();
itemProspect.Address.City = txtCity.Text.Trim();
itemProspect.Address.State = ddlState.SelectedItem.Text;
itemProspect.TSWCatalogs.StateID = ddlState.SelectedValue;
//Save the stateID as well
itemProspect.Address.Country = ddlCountry.SelectedItem.Text;
itemProspect.TSWCatalogs.CountryID = ddlCountry.SelectedValue;
//Save teh CountryID as well
itemProspect.Address.Zip = txtZipCode.Text.Trim();
itemProspect.Phone = txtPhone.Text.Trim();
//PENDINGitemProspect.TSWCatalogs.PhoneType = ddlPhType.SelectedValue;
//Phone Type
//itemProspect.Phone2 = hdnPhone2.Value;
//itemProspect.Fax = hdnFax.Value;
itemProspect.EMAIL = txtEmail.Text.Trim();
itemProspect.DOB = txtDOB.Text.Trim();
//EmailType
//Internally the stored procedure determines if it's an insert or an update
ProspectId = TSWProspectDB.InsertTSW_Prospect_TUNA(itemProspect);
lblProspectID.Text = ProspectId.ToString();
if (ProspectId == 0)
{
lblErrorValidationMessages.Text = "Error Creating Prospect";
return;
}
}
public static TSWProspectList SearchUniqueProspect(TSWProspect value, out int count)
{
TSWProspectList retval = new TSWProspectList();
//throw new Exception(value.FromLive + " " + value.CN + " " + value.SN + " " + value.EMAIL + " " + value.Phone);
SqlParameter pOut = new SqlParameter("@Count", SqlDbType.Int, 4);
pOut.Direction = ParameterDirection.Output;
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@FromLive", value.FromLive),
new SqlParameter("@inFirst", value.CN),
new SqlParameter("@inLast", value.SN),
new SqlParameter("@inEmail", value.EMAIL),
new SqlParameter("@inPhone", value.Phone)
,pOut
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_SearchForProspect", param))
{
while (reader.Read())
{
retval.Add(Read(reader));
}
}
count= Helper.ToInt32(pOut.Value);
return retval;
}
//dc
public static TSWProspect SearchTUhistory(TSWProspect value)
{
TSWProspect retval = null ;
SqlParameter pOut = new SqlParameter("@Count", SqlDbType.Int, 4);
pOut.Direction = ParameterDirection.Output;
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@FromLive", value.FromLive),
new SqlParameter("@ProspectID", value.ProspectId)
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "sel_TU_History", param))
{
if (reader.Read())
{
retval = Read(reader);
}
}
return retval;
}
public static TSWProspect Read(SqlDataReader reader)
{
TSWProspect retval = new TSWProspect();
for (int i = 0; i < reader.FieldCount; i++)
{
switch (reader.GetName(i))
{
case "TN":
retval.TN = Helper.ToInt32(reader[i]);
break;
case "OC":
retval.OC = Helper.ToString(reader[i]);
break;
case "HN":
retval.HN = Helper.ToInt32(reader[i]);
break;
case "USERID":
retval.UserId = Helper.ToString(reader[i]);
break;
case "WS":
retval.WS = Helper.ToString(reader[i]);
break;
case "ObjectId":
retval.OBJID = Helper.ToString(reader[i]);
break;
case "RNO":
retval.RNO = Helper.ToInt32(reader[i]);
break;
case "RSNO":
retval.RSNO = Helper.ToInt32(reader[i]);
break;
case "ARR_Date":
retval.ARR = Helper.ToDateTime(reader[i]);
break;
case "DEP_Date":
retval.DEP = Helper.ToDateTime(reader[i]);
break;
case "NOPAX":
retval.NOPAX = Helper.ToInt32(reader[i]);
break;
case "RT":
retval.RT = Helper.ToString(reader[i]);
break;
case "ORG":
retval.ORG = Helper.ToString(reader[i]);
break;
case "ARR":
retval.ARR = Helper.ToDateTime(reader[i]);
break;
case "DEP":
retval.DEP = Helper.ToDateTime(reader[i]);
break;
case "PCIID":
retval.PCIID = Helper.ToInt32(reader[i]);
break;
case "HASPREV":
retval.HASPREV = Helper.ToBoolean(reader[i]);
break;
case "HASSUCC":
retval.HASSUCC = Helper.ToBoolean(reader[i]);
break;
case "SF":
retval.SF = Helper.ToString(reader[i]);
break;
case "GID":
retval.GID = Helper.ToString(reader[i]);
break;
case "SN":
retval.SN = Helper.ToString(reader[i]);
break;
case "CN":
retval.CN= Helper.ToString(reader[i]);
break;
case "LN":
retval.LN = Helper.ToString(reader[i]);
break;
case "VIP":
retval.VIP = Helper.ToString(reader[i]);
break;
case "STREET":
retval.Address.Street1 = Helper.ToString(reader[i]);
break;
case "CITY":
retval.Address.City = Helper.ToString(reader[i]);
break;
case "ZIP":
retval.Address.Zip = Helper.ToString(reader[i]);
break;
case "COUNTRY":
retval.Address.Country = Helper.ToString(reader[i]);
break;
case "STATE":
retval.Address.State = Helper.ToString(reader[i]);
break;
case "AREA":
retval.Area = Helper.ToString(reader[i]);
break;
case "PHONE":
retval.Phone = Helper.ToString(reader[i]);
break;
case "PHONE2":
retval.Phone2 = Helper.ToString(reader[i]);
break;
case "FAX":
retval.Fax = Helper.ToString(reader[i]);
break;
case "FAX2":
retval.Fax2 = Helper.ToString(reader[i]);
break;
case "EMAIL":
retval.EMAIL = Helper.ToString(reader[i]);
break;
case "EMAIL2":
retval.EMAIL2 = Helper.ToString(reader[i]);
break;
case "TAXID":
retval.TAXID = Helper.ToString(reader[i]);
break;
case "DOB":
retval.DOB = Helper.ToString(reader[i]);
break;
case "SEX":
retval.Sex = Helper.ToString(reader[i]);
break;
case "PASSWD":
retval.Passwd = Helper.ToString(reader[i]);
break;
case "MATCHCODE":
retval.MATCHCODE = Helper.ToString(reader[i]);
break;
case "ADMCODEHQ":
retval.ADMCODEHQ = Helper.ToString(reader[i]);
break;
case "GT":
retval.GT = Helper.ToString(reader[i]);
break;
case "GTD":
retval.GTD = Helper.ToString(reader[i]);
break;
case "GNR":
retval.GNR = Helper.ToString(reader[i]);
break;
case "GMD":
retval.GMD = Helper.ToString(reader[i]);
break;
case "GDB":
retval.GDB = Helper.ToString(reader[i]);
break;
case "TT":
retval.TT = Helper.ToString(reader[i]);
break;
case "HQGID":
retval.HQGID = Helper.ToString(reader[i]);
break;
case "CREQ":
retval.CREQ = Helper.ToString(reader[i]);
break;
case "CREQSTATE":
retval.CREQState = Helper.ToString(reader[i]);
break;
case "SALUTATION":
retval.Salutation = Helper.ToString(reader[i]);
break;
case "TITLE":
retval.Title = Helper.ToString(reader[i]);
break;
case "T_TITLE":
retval.T_Title = Helper.ToString(reader[i]);
break;
case "CARDS":
retval.Cards = Helper.ToString(reader[i]);
break;
case "RN":
retval.RN = Helper.ToString(reader[i]);
break;
case "ROOMSIMPLIED":
retval.ROOMSIMPLIED = Helper.ToBoolean(reader[i]);
break;
case "CAT":
retval.CAT = Helper.ToString(reader[i]);
break;
case "TG":
retval.TG = Helper.ToString(reader[i]);
break;
case "MC":
retval.MC = Helper.ToString(reader[i]);
break;
//****
case "TN_CHK_IN":
retval.TN_CHK_IN = Helper.ToString(reader[i]);
break;
case "NC_CHK_IN":
retval.NC_CHK_IN = Helper.ToString(reader[i]);
break;
case "CA_CHK_IN":
retval.CA_CHK_IN = Helper.ToString(reader[i]);
break;
case "AP_CHK_IN":
retval.AP_CHK_IN= Helper.ToString(reader[i]);
break;
case "CS_CHK_IN":
retval.CS_CHK_IN = Helper.ToString(reader[i]);
break;
case "PH0_CHK_IN":
retval.PH0_CHK_IN = Helper.ToString(reader[i]);
break;
case "PH1_CHK_IN":
retval.PH1_CHK_IN = Helper.ToString(reader[i]);
break;
case "SRC_CHK_IN":
retval.SRC_CHK_IN = Helper.ToString(reader[i]);
break;
case "PAYTV_CHK_IN":
retval.PAYTV_CHK_IN = Helper.ToString(reader[i]);
break;
case "AN_CHK_IN":
retval.AN_CHK_IN = Helper.ToString(reader[i]);
break;
case "ORG_CHK_IN":
retval.ORG_CHK_IN = Helper.ToString(reader[i]);
break;
case "ProspectSourceID":
retval.AgencyID = Helper.ToInt32(reader[i]);
break;
case "SourceDescription":
retval.AgencyName = Helper.ToString(reader[i]);
break;
case "SiteID":
retval.SiteID = Helper.ToInt32(reader[i]);
break;
case "ReturnValue":
retval.ReturnValue = Helper.ToInt32(reader[i]);
break;
case "ReturnString":
retval.ReturnString = Helper.ToString(reader[i]);
break;
case "ProspectSourceIDCatalog":
retval.ProspectSourceID = Helper.ToInt32(reader[i]);
break;
case "ProspectSourceDesc":
retval.ProspectStatusDesc = Helper.ToString(reader[i]);
break;
case "ProspectTypeID":
retval.ProspectTypeID = Helper.ToInt32(reader[i]);
break;
case "ProspectTypeDesc":
retval.ProspectTypeDesc = Helper.ToString(reader[i]);
break;
case "ProspectStatusID":
retval.ProspectStatusID = Helper.ToInt32(reader[i]);
break;
case "ProspectStatusDesc":
retval.ProspectStatusDesc = Helper.ToString(reader[i]);
break;
case "MaritalStatusID":
retval.MaritalID = Helper.ToInt32(reader[i]);
break;
case "OccupationID":
retval.OccupationID = Helper.ToInt32(reader[i]);
break;
case "IncomeID":
retval.IncomeID = Helper.ToInt32(reader[i]);
break;
case "TransDate":
retval.TUNA.TransDate = Helper.ToDateTime(reader[i]);
break;
case "TransResult":
retval.TUNA.TransResult = Helper.ToString(reader[i]);
break;
case "TransScore":
retval.TUNA.TransScore = Helper.ToString(reader[i]);
break;
//DisplayMarket,DisplaySegment
//TourLocation, TourDate, TourResult
}
}
return retval;
}
public static int InsertTSW_Prospect_TUNA(TSWProspect value)
{
int prospectId = 0;
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@ProspectID", value.ProspectId),
new SqlParameter("@FromLive", value.FromLive),
new SqlParameter("@SiteID", value.SiteID),
//new SqlParameter("@Salutation", value.Salutation),
//new SqlParameter("@Title", value.Title),
new SqlParameter("@ProspectTypeID", value.ProspectTypeID), //Hotel Guest 179
//new SqlParameter("@ProspectType", value.ProspectTypeDesc), //Hotel Guest
new SqlParameter("@ProspectStatusID",value.ProspectStatusID), //Active 124
new SqlParameter("@SourceID", value.ProspectSourceID), //PMS Interface 15925
//new SqlParameter("@ProspectStatus","Active"),
new SqlParameter("@LastName", value.SN),
new SqlParameter("@FirstName", value.CN ),
new SqlParameter("@StreetAddress", value.Address.Street1),
new SqlParameter("@City", value.Address.City),
new SqlParameter("@State", value.Address.State),
new SqlParameter("@StateId", value.TSWCatalogs.StateID) ,
new SqlParameter("@PostalCode", value.Address.Zip),
new SqlParameter("@Country", value.Address.Country),
new SqlParameter("@CountryID", value.TSWCatalogs.CountryID),
new SqlParameter("@Phone1", value.Phone), //another table
new SqlParameter("@Phone2", value.Phone2), //another table
//new SqlParameter("@Fax", value.Fax), //another table Fax=5
new SqlParameter("@Email", value.EMAIL), //another table
//new SqlParameter("@MaritalStatusID", value.MaritalID),
//new SqlParameter("@MaritalStatus",value.MaritalStatus),
//new SqlParameter("@OccupationID", value.OccupationID),
//new SqlParameter("@Occupation", value.Occupation),
//new SqlParameter("@IncomeID", value.IncomeID),
new SqlParameter("@Birthdate", value.DOB) //another table
};
//I am pointing to the practice database
prospectId = (int)SqlHelper.ExecuteScalar(Helper.ConnectionString, CommandType.StoredProcedure, "usp_ProspectSave", param);
return prospectId;
}
//
public static TSWProspect GetProspectType(TSWProspect value)
{
TSWProspect retval = new TSWProspect();
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@FromLive", value.FromLive),
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "ws_usp_GetProspectType", param))
{
if (reader.Read())
{
retval = (Read(reader));
}
}
//count = Helper.ToInt32(pOut.Value);
return retval;
}
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);
}
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();
}
void SearchDuplicateProspect()
{
TSWProspect itemProspect = new TSWProspect();
itemProspect.FromLive = m_FromLive;
itemProspect.CN = txtFName.Text.Trim();
itemProspect.SN = txtLName.Text.Trim();
itemProspect.Phone = txtPhone.Text.Trim();
itemProspect.EMAIL = txtEmail.Text.Trim();
if (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
grdProspects.DataSource = TSWProspectDB.GetDupsProspects(itemProspect);
grdProspects.DataBind();
//show the prospectId on top. The assignment of the prospectId happens in the the ItemDatabound of the repeater
PnlDups.Visible = true;
}
else //if the prospect was NOT found
//show panel NOT found and ask if you want to request Tuna (Yes/No)
//Disclaimer. Please note if the prospect qualifies(A, B). This prospect personal info and qualifications are going to be saved.
//otherwise all the information is going to be discarded.
//If clicked=Yes Proced with qualification
//if clicked=No Take him back (shall we keep the data on screen)
{
pnlNOTFound.Visible = true;
lblProspectNotFound.Text = "The prospect was not found. Proceed with Pre-Qualification? ";
DisableAllControls();
btnTUNA_Yes.Visible = true;
btnTUNA_No.Visible = true;
HideAllButtons();
}
}
}
