protected void btnSaveGrid_Click(object sender, EventArgs e)
{
SIHOTPerson itemAvailable = new SIHOTPerson();
bool ChkValue = false;
foreach (RepeaterItem item in rptProspects.Items)
{
//varQty += Helper.ToInt32((TextBox)item.FindControl("txtPremQty"));
//ChkValue = Helper.ToBoolean(((CheckBox)item.FindControl("chkBoxAva")).Checked);
ChkValue = ((CheckBox)item.FindControl("chkBoxAva")).Checked;
//Response.Write(((CheckBox)item.FindControl("chkBoxAva")).Checked + "HC" + SIHOTHotelCode.ToString() + "PCIID" + Helper.ToInt32((string)((HyperLink)item.FindControl("hlGUID")).Text) + "RoomNumber" + Helper.ToString((string)((HyperLink)item.FindControl("hlRoom")).Text));
//throw new Exception("Here2" + ((CheckBox)item.FindControl("chkBoxAva")).Checked);
itemAvailable.HN = SIHOTHotelCode;
itemAvailable.VacationClubCode= SIHOTVCCode;
itemAvailable.PCIID = Helper.ToInt32((string)((HyperLink)item.FindControl("hlGUID")).Text);
itemAvailable.RN = Helper.ToString((string)((HyperLink)item.FindControl("hlRoom")).Text); //Room number
itemAvailable.DEP = Helper.ToDateTime((string)((HyperLink)item.FindControl("hlCheckOutDate")).Text);
itemAvailable.Available= ((CheckBox)item.FindControl("chkBoxAva")).Checked;
//Update tblSIHOTPerson
SIHOTPersonDB.UpdateSIHOT_Person_Available(itemAvailable);
}
}
//Change of Reservation uploadxml
void ProcessCR(string strFileName)
{
//Clears the dataset
dsAux.Reset();
dsAux.ReadXml(strFileName);
SqlDataAdapter myDataAdapter = new SqlDataAdapter();
m_SH_Hotel_Num = 0;
//Saving the document
DataRow myRow;
DataTable tbl = dsAux.Tables[0];
//Checking how many table contains the dataset
if (dsAux.Tables.Count ==2)
{
ProcessCR_2_tbls(strFileName);
return;
}
else if (dsAux.Tables.Count ==5)
{
//cards inside CR do the same but remove CR
}
else if (dsAux.Tables.Count != 4)
{
return;
}
//dsAux.Tables[0].ReadXml(
SIHOT_Reservation item = new SIHOT_Reservation();
//Being used to get back the reservation from the Database
SIHOT_Reservation itemReturn = new SIHOT_Reservation();
for (int i = 0; i < tbl.Rows.Count; i++)
{
myRow = tbl.Rows[i];
m_TRansactionNumber = Helper.ToInt32(myRow["TN"].ToString());
item.TN = m_TRansactionNumber;
item.OC = myRow["OC"].ToString();
item.HN = Helper.ToInt32(myRow["HN"].ToString());
m_SH_Hotel_Num = Helper.ToInt32(myRow["HN"].ToString());
if (myRow.Table.Columns.Contains("WS"))
item.WS = myRow["WS"].ToString();
if (myRow.Table.Columns.Contains("USERID"))
item.UserId = myRow["USERID"].ToString();
item.OBJID = myRow["OBJID"].ToString();
item.ORG = myRow["ORG"].ToString();
item.SIHOT_Document_Id = myRow["SIHOT-Document_Id"].ToString();
}
//Second Part Saving the reservation
myRow = null;
tbl = dsAux.Tables[1];
for (int i = 0; i < tbl.Rows.Count; i++)
{
myRow = tbl.Rows[i];
//Check if this reservation already exist
item.RNO = Helper.ToInt32(myRow["RNO"].ToString());
item.RSNO = Helper.ToInt32(myRow["RSNO"].ToString());
m_ReservationNum = Helper.ToInt32(myRow["RNO"].ToString());
m_ReservationSubNum = Helper.ToInt32(myRow["RSNO"].ToString());
//throw new Exception("The Value is here: " + Helper.ToDT_mm_DD_yyyy(myRow["ARR"].ToString()) + Helper.ToDateTime(myRow["DEP"].ToString()));
//throw new Exception("The Value is here: " + myRow["ARR"].ToString() + " to "+ myRow["DEP"].ToString());
//For Hotels with format dd/mm/yyyy
if (item.HN == 5907 || item.HN == 7172)
{
if (myRow.Table.Columns.Contains("ARR"))
//item.ARR = DateTime.Parse(myRow["ARR"].ToString());
item.ARR = Helper.ToDateTime(myRow["ARR"].ToString());
if (myRow.Table.Columns.Contains("DEP"))
item.DEP = Helper.ToDateTime(myRow["DEP"].ToString());
}
else if (item.WS == "A_LLAVES" || item.WS == "GTE_FRONT" || item.WS == "MPVRTELEFONOS2")
{
if (myRow.Table.Columns.Contains("ARR"))
item.ARR = Helper.ToDateTime(myRow["ARR"].ToString());
if (myRow.Table.Columns.Contains("DEP"))
item.DEP = Helper.ToDateTime(myRow["DEP"].ToString());
}
else
{
//For Hotels with format dd/mm/yyyy
if (myRow.Table.Columns.Contains("ARR"))
item.ARR = Helper.ToDT_mm_DD_yyyy(myRow["ARR"].ToString());
if (myRow.Table.Columns.Contains("DEP"))
item.DEP = Helper.ToDT_mm_DD_yyyy(myRow["DEP"].ToString());
}
item.NOPAX = Helper.ToInt32(myRow["NOPAX"].ToString());
item.RT = myRow["RT"].ToString();
item.OBJID = myRow["OBJID"].ToString();
item.SIHOT_Reservation_Id = myRow["SIHOT-Reservation_Id"].ToString(); ;
//Check if that reservation exist or not is PMS Interface
//if (item.RNO==219157)
//{
// throw new Exception(item.RNO.ToString() +"/"+ item.RSNO);
//}
itemReturn = SIHOT_ReservationDB.SelectReservationFC(item);
//if (itemReturn.RNO == 0 && itemReturn.RSNO==0)
if (itemReturn.RNO == 0 && itemReturn.RSNO == 0)
{
//insert that row in the table
SIHOT_ReservationDB.InsertSIHOT_Reservation(item);
}
else if (itemReturn.RNO > 0)
{
SIHOT_ReservationDB.Update_tblSIHOT_ReservationByResNum(item);
}
}
//Saving the Person
myRow = null;
tbl = dsAux.Tables[2];
if (dsAux.Tables.IndexOf(tbl) > -1)
{
SIHOTPerson itemPerson = new SIHOTPerson();
//Being used to get back the reservation from the Database
SIHOTPerson itemPersonReturn = new SIHOTPerson();
for (int i = 0; i < tbl.Rows.Count; i++)
{
myRow = tbl.Rows[i];
itemPerson.TN = m_TRansactionNumber;
itemPerson.HN = m_SH_Hotel_Num;
itemPerson.RNO = m_ReservationNum;
itemPerson.RSNO = m_ReservationSubNum;
//For Hotels with format dd/mm/yyyy
if (item.HN == 5907 || item.HN == 7172)
{
if (myRow.Table.Columns.Contains("ARR"))
//item.ARR = DateTime.Parse(myRow["ARR"].ToString());
itemPerson.ARR = Helper.ToDateTime(myRow["ARR"].ToString());
if (myRow.Table.Columns.Contains("DEP"))
itemPerson.DEP = Helper.ToDateTime(myRow["DEP"].ToString());
}
else if (item.WS == "A_LLAVES" || item.WS == "GTE_FRONT" || item.WS == "MPVRTELEFONOS2")
{
if (myRow.Table.Columns.Contains("ARR"))
itemPerson.ARR = Helper.ToDateTime(myRow["ARR"].ToString());
if (myRow.Table.Columns.Contains("DEP"))
itemPerson.DEP = Helper.ToDateTime(myRow["DEP"].ToString());
}
else
{
//For Hotels with format dd/mm/yyyy
if (myRow.Table.Columns.Contains("ARR"))
itemPerson.ARR = Helper.ToDT_mm_DD_yyyy(myRow["ARR"].ToString());
if (myRow.Table.Columns.Contains("DEP"))
itemPerson.DEP = Helper.ToDT_mm_DD_yyyy(myRow["DEP"].ToString());
}
//Check if this PCIID already exist
//itemPerson.RNO = item.RNO;
if (myRow.Table.Columns.Contains("PCIID"))
itemPerson.PCIID = Helper.ToInt32(myRow["PCIID"].ToString());
itemPerson.NOPAX = Helper.ToInt32(myRow["NOPAX"].ToString());
itemPerson.TG = myRow["TG"].ToString();
itemPerson.HASPREV = Helper.ToBoolean(myRow["HASPREV"].ToString());
itemPerson.HASSUCC = Helper.ToBoolean(myRow["HASSUCC"].ToString());
if (myRow.Table.Columns.Contains("GID"))
itemPerson.GID = myRow["GID"].ToString().Trim();
//If DataRow.Table.Columns.Contains("column") Then
if (myRow.Table.Columns.Contains("VIP"))
itemPerson.VIP = myRow["VIP"].ToString();
if (myRow.Table.Columns.Contains("TITLE"))
itemPerson.Title = myRow["TITLE"].ToString();
if (myRow.Table.Columns.Contains("Street"))
itemPerson.Address.Street1 = myRow["STREET"].ToString();
if (myRow.Table.Columns.Contains("CITY"))
itemPerson.Address.City = myRow["CITY"].ToString();
if (myRow.Table.Columns.Contains("ZIP"))
itemPerson.Address.Zip = myRow["ZIP"].ToString();
if (myRow.Table.Columns.Contains("COUNTRY"))
itemPerson.Address.Country = myRow["COUNTRY"].ToString();
//itemPerson.Address.State = myRow["STATE"].ToString();
//itemPerson.Area = myRow["AREA"].ToString();
if (myRow.Table.Columns.Contains("PHONE"))
itemPerson.Phone = myRow["PHONE"].ToString();
if (myRow.Table.Columns.Contains("FAX"))
itemPerson.Fax = myRow["FAX"].ToString();
if (myRow.Table.Columns.Contains("EMAIL"))
itemPerson.EMAIL = myRow["EMAIL"].ToString();
//throw new Exception(myRow["DOB"].ToString());
//if (myRow.Table.Columns.Contains("DOB"))
//{
// if (myRow["DOB"].ToString() != "")
// itemPerson.DOB = Helper.ToDateTime(myRow["DOB"].ToString());
//}
if (myRow.Table.Columns.Contains("Salutation"))
{
itemPerson.Salutation = myRow["Salutation"].ToString();
}
if (myRow.Table.Columns.Contains("TAXID"))
{
itemPerson.TAXID = myRow["TAXID"].ToString();
}
if (myRow.Table.Columns.Contains("SEX"))
itemPerson.Sex = myRow["SEX"].ToString();
//We assign the agency name in the last name; when is an insert we use the agency name and the last name. When is an update we only update the last name
itemPerson.AgencyName = myRow["SN"].ToString();
itemPerson.SN = myRow["SN"].ToString();
itemPerson.CN = myRow["CN"].ToString();
itemPerson.MC = myRow["MC"].ToString();
itemPerson.RN = myRow["RN"].ToString();
itemPerson.CAT = myRow["CAT"].ToString();
itemPerson.SF = myRow["SF"].ToString();
if (myRow.Table.Columns.Contains("MATCHCODE"))
if (myRow.Table.Columns.Contains("MATCHCODE").ToString() != "")
itemPerson.MATCHCODE = myRow["MATCHCODE"].ToString();
itemPerson.SIHOT_Reservation_Id = myRow["SIHOT-Reservation_Id"].ToString();
itemPerson.SIHOT_Person_Id = myRow["SIHOT-Person_Id"].ToString();
//Chck if the PCIID already exist in the table
int count=0;
itemPersonReturn = SIHOTPersonDB.SelectPersonByPCIID_CR(itemPerson, out count);
if (itemPersonReturn.PCIID == 0)
//if (count == 0)
//if (count != 0)
{
//insert that row in the table; PCIID doesn't exist
SIHOTPersonDB.InsertSIHOT_Person(itemPerson);
//update that row in the table; PCIID already exist
}
else if (itemPersonReturn.PCIID > 0)
{
Response.Write("update" + itemPerson.PCIID + itemPerson.HN);
SIHOTPersonDB.UpdateSIHOT_Person_CR(itemPerson);
}
}
}
//Saving the Package
myRow = null;
tbl = dsAux.Tables[3];
SIHOT_Package itemPackage = new SIHOT_Package();
SIHOT_Package itemPackageReturn = new SIHOT_Package();
for (int i = 0; i < tbl.Rows.Count; i++)
{
//global variable
myRow = tbl.Rows[i];
itemPackage.TN = m_TRansactionNumber;
if (myRow["From"].ToString() != null)
itemPackage.SIHOT_PACKAGE_FROM = Helper.ToDateTime(myRow["From"].ToString());
if (myRow["To"].ToString() != null)
itemPackage.SIHOT_PACKAGE_TO = Helper.ToDateTime(myRow["To"].ToString());
if (myRow["SID"].ToString() != null)
itemPackage.SIHOT_PACKAGE_SID = myRow["SID"].ToString();
if (myRow["RS"].ToString() != null)
itemPackage.SIHOT_PACKAGE_RS = myRow["RS"].ToString();
if (myRow["SIDT"].ToString() != null)
itemPackage.SIHOT_PACKAGE_SIDT = myRow["SIDT"].ToString();
if (myRow["SIHOT-Person_Id"].ToString() != null)
itemPackage.SIHOT_Person_Id = myRow["SIHOT-Person_Id"].ToString();
//Right now I don't need the package
//itemPackageReturn = SIHOTPackageDB.s;
//if (itemPackageReturn.PCIID == 0)
//{
// //inserting the row in the table
// SIHOTPackageDB.InsertSIHOT_Package(itemPackage);
//}
//else if (itemPackageReturn.PCIID == 0)
//{
// SIHOTPackageDB.UPDATESIHOT_Package(itemPackage);
//}
}
//myDataAdapter.Fill(datos2, "TABLA3");
//myDataAdapter.Update(datos2, nombretabla);
//myDataAdapter.Update(
//string filePath = "C:\\temp\\SIHOTForeCast2.xml";
//dsAux.ReadXml(filePath);
//GridView1.DataSource = dsAux;
//GridView1.DataBind();
//DataSet ds = new DataSet();
//ds.ReadXml(Request.PhysicalApplicationPath + @"\App_Data\" + "MilitaryTime.xml");
//load an xml file into a dataset and bind it to a GridView
//System.Data.DataSet myDS = new System.Data.DataSet();
////myDS.ReadXml(Server.MapPath(@"C:\temp\SIHOTForeCast2.xml"));
//myDS.ReadXml(Request.PhysicalApplicationPath + @"\App_Data\" + "SIHOTForeCast2.xml");
////bind with a GridView for display
//GridView1.DataSource = myDS;
//GridView1.DataBind();
}
void ProcessCOS()
{
//Saving the document
DataRow myRow;
dsAux.Reset();
DataTable tbl = dsAux.Tables[0];
//dsAux.Tables[0].ReadXml(
SIHOTPerson itemPerson = new SIHOTPerson();
//Being used to get back the reservation from the Database
SIHOTPerson itemPersonReturn = new SIHOTPerson();
for (int i = 0; i < tbl.Rows.Count; i++)
{
myRow = tbl.Rows[i];
m_TRansactionNumber = Helper.ToInt32(myRow["TN"].ToString());
itemPerson.TN = m_TRansactionNumber;
itemPerson.OC = myRow["CIO"].ToString();
//Check if that reservation exist or not is PMS Interface
int count = 0;
itemPersonReturn = SIHOTPersonDB.SelectPersonByPCIID(itemPerson, out count);
//Search if the record exist by the PCIID
if (itemPersonReturn.PCIID == 0)
{
//insert that row in the table
//SIHOTPersonDB.InsertSIHOT_CheckIn(itemPerson);
}
else if (itemPersonReturn.PCIID > 0)
{
SIHOTPersonDB.UpdateSIHOT_CheckIn(itemPerson);
}
}
}
void ProcessCheckOUT(string strFileName)
{
//Saving the document
dsAux.Reset();
dsAux.ReadXml(strFileName);
DataRow myRow;
DataTable tbl = dsAux.Tables[0];
//dsAux.Tables[0].ReadXml(
SIHOTPerson itemPerson = new SIHOTPerson();
//Being used to get back the reservation from the Database
SIHOTPerson itemPersonReturn = new SIHOTPerson();
for (int i = 0; i < tbl.Rows.Count; i++)
{
myRow = tbl.Rows[i];
m_TRansactionNumber = Helper.ToInt32(myRow["TN"].ToString());
itemPerson.TN = m_TRansactionNumber;
itemPerson.OC = myRow["OC"].ToString();
itemPerson.HN = Helper.ToInt32(myRow["HN"].ToString());
//This dates come with a format yyyy/mm/dd
//itemPerson.ARR = Helper.ToDateTime(myRow["ARR"].ToString());
//itemPerson.DEP = Helper.ToDateTime(myRow["DEP"].ToString());
if (myRow.Table.Columns.Contains("USERID"))
itemPerson.UserId = myRow["USERID"].ToString();
if (myRow.Table.Columns.Contains("WS"))
itemPerson.WS = myRow["WS"].ToString();
//if (myRow.Table.Columns.Contains("ARR"))
// itemPerson.ARR = Helper.ToDT_mm_DD_yyyy(myRow["ARR"].ToString());
//if (myRow.Table.Columns.Contains("DEP"))
// itemPerson.DEP = Helper.ToDT_mm_DD_yyyy(myRow["DEP"].ToString());
if (myRow.Table.Columns.Contains("ARR"))
itemPerson.ARR = Helper.ToDateTime(myRow["ARR"].ToString());
if (myRow.Table.Columns.Contains("DEP"))
itemPerson.DEP = Helper.ToDateTime(myRow["DEP"].ToString());
if (myRow.Table.Columns.Contains("PCIID"))
itemPerson.PCIID = Helper.ToInt32(myRow["PCIID"].ToString());
//itemPerson.NOPAX = Helper.ToInt32(myRow["NOPAX"].ToString());
//Type of Guest
if (myRow.Table.Columns.Contains("TG"))
itemPerson.TG = myRow["TG"].ToString();
if (myRow.Table.Columns.Contains("HASPREV"))
itemPerson.HASPREV = Helper.ToBoolean(myRow["HASPREV"].ToString());
if (myRow.Table.Columns.Contains("HASSUCC"))
itemPerson.HASSUCC = Helper.ToBoolean(myRow["HASSUCC"].ToString());
if (myRow.Table.Columns.Contains("GID"))
itemPerson.GID = myRow["GID"].ToString();
if (myRow.Table.Columns.Contains("LN"))
itemPerson.LN = myRow["LN"].ToString();
if (myRow.Table.Columns.Contains("VIP"))
itemPerson.VIP = myRow["VIP"].ToString();
if (myRow.Table.Columns.Contains("TITLE"))
itemPerson.Title = myRow["TITLE"].ToString();
if (myRow.Table.Columns.Contains("STREET"))
itemPerson.Address.Street1 = myRow["STREET"].ToString();
if (myRow.Table.Columns.Contains("CITY"))
itemPerson.Address.City = myRow["CITY"].ToString();
if (myRow.Table.Columns.Contains("ZIP"))
itemPerson.Address.Zip = myRow["ZIP"].ToString();
if (myRow.Table.Columns.Contains("COUNTRY"))
itemPerson.Address.Country = myRow["COUNTRY"].ToString();
//itemPerson.Address.State = myRow["STATE"].ToString();
//itemPerson.Area = myRow["AREA"].ToString();
if (myRow.Table.Columns.Contains("PHONE"))
itemPerson.Phone = myRow["PHONE"].ToString();
if (myRow.Table.Columns.Contains("FAX"))
itemPerson.Fax = myRow["FAX"].ToString();
if (myRow.Table.Columns.Contains("EMAIL"))
itemPerson.EMAIL = myRow["EMAIL"].ToString();
if (myRow.Table.Columns.Contains("SF"))
itemPerson.SF = myRow["SF"].ToString();
//throw new Exception(Helper.ToDT_mm_DD_yyyy(myRow["DOB"].ToString()).ToString());
if (myRow.Table.Columns.Contains("DOB"))
{
if (myRow["DOB"].ToString() != "")
itemPerson.DOB = Helper.ToDT_mm_DD_yyyy(myRow["DOB"].ToString());
}
if (myRow.Table.Columns.Contains("SEX"))
itemPerson.Sex = myRow["SEX"].ToString();
if (myRow.Table.Columns.Contains("Salutation"))
{
itemPerson.Salutation = myRow["Salutation"].ToString();
}
if (myRow.Table.Columns.Contains("TAXID"))
{
itemPerson.TAXID = myRow["TAXID"].ToString();
}
if (myRow.Table.Columns.Contains("SN"))
itemPerson.SN = myRow["SN"].ToString();
if (myRow.Table.Columns.Contains("CN"))
itemPerson.CN = myRow["CN"].ToString();
if (myRow.Table.Columns.Contains("MC"))
itemPerson.MC = myRow["MC"].ToString();
if (myRow.Table.Columns.Contains("RN"))
itemPerson.RN = myRow["RN"].ToString();
if (myRow.Table.Columns.Contains("CAT"))
itemPerson.CAT = myRow["CAT"].ToString();
if (myRow.Table.Columns.Contains("TN"))
itemPerson.TN_CHK_IN = myRow["TN"].ToString();
if (myRow.Table.Columns.Contains("NC"))
itemPerson.NC_CHK_IN = myRow["NC"].ToString();
if (myRow.Table.Columns.Contains("CA"))
itemPerson.CA_CHK_IN = myRow["CA"].ToString();
if (myRow.Table.Columns.Contains("AP"))
itemPerson.AP_CHK_IN = myRow["AP"].ToString();
if (myRow.Table.Columns.Contains("CS"))
itemPerson.CS_CHK_IN = myRow["CS"].ToString();
if (myRow.Table.Columns.Contains("PH0"))
itemPerson.PH0_CHK_IN = myRow["PH0"].ToString();
if (myRow.Table.Columns.Contains("PH1"))
itemPerson.PH1_CHK_IN = myRow["PH1"].ToString();
if (myRow.Table.Columns.Contains("SRC"))
itemPerson.SRC_CHK_IN = myRow["SRC"].ToString();
if (myRow.Table.Columns.Contains("PAYTV"))
itemPerson.PAYTV_CHK_IN = myRow["PAYTV"].ToString();
if (myRow.Table.Columns.Contains("AN"))
itemPerson.AN_CHK_IN = myRow["AN"].ToString();
if (myRow.Table.Columns.Contains("ORG"))
itemPerson.ORG_CHK_IN = myRow["ORG"].ToString();
if (myRow.Table.Columns.Contains("GT"))
itemPerson.GT = myRow["GT"].ToString();
if (myRow.Table.Columns.Contains("GTD"))
itemPerson.GTD = myRow["GTD"].ToString();
if (myRow.Table.Columns.Contains("GNR"))
itemPerson.GNR = myRow["GNR"].ToString();
if (myRow.Table.Columns.Contains("GMD"))
itemPerson.GMD = myRow["GMD"].ToString();
if (myRow.Table.Columns.Contains("TT"))
itemPerson.TT = myRow["TT"].ToString();
if (myRow.Table.Columns.Contains("PAYTV"))
itemPerson.PAYTV_CHK_IN = myRow["PAYTV"].ToString();
if (myRow.Table.Columns.Contains("CREQ"))
itemPerson.CREQ = myRow["CREQ"].ToString();
if (myRow.Table.Columns.Contains("GDB"))
itemPerson.GDB = myRow["GDB"].ToString();
if (myRow.Table.Columns.Contains("HQGID"))
itemPerson.HQGID = myRow["HQGID"].ToString();
//Check if that reservation exist or not is PMS Interface
int count = 0;
itemPersonReturn = SIHOTPersonDB.SelectPersonByPCIID(itemPerson, out count);
//Search if the record exist by the PCIID
if (itemPersonReturn.PCIID == 0)
{
//insert that row in the table
Response.Write("insert[" + itemPerson.PCIID + itemPerson.HN+"]");
//SIHOTPersonDB.InsertSIHOT_CheckOut(itemPerson);
}
else if (itemPersonReturn.PCIID > 0)
{
Response.Write("update[" + itemPerson.PCIID + itemPerson.HN+"]");
SIHOTPersonDB.UpdateSIHOT_CheckOut(itemPerson);
}
}
}
void ProcessCheckIN(string strFileName)
{
//Saving the document
dsAux.Reset();
dsAux.ReadXml(strFileName);
DataRow myRow;
myRow = null;
DataTable tblIN = dsAux.Tables[0];
//dsAux.Tables[0].ReadXml(
SIHOTPerson itemPerson = new SIHOTPerson();
//Being used to get back the reservation from the Database
SIHOTPerson itemPersonReturn = new SIHOTPerson();
for (int i = 0; i < tblIN.Rows.Count; i++)
{
myRow = tblIN.Rows[i];
m_TRansactionNumber = Helper.ToInt32(myRow["TN"].ToString());
itemPerson.TN = m_TRansactionNumber;
itemPerson.OC = myRow["OC"].ToString();
itemPerson.HN = Helper.ToInt32(myRow["HN"].ToString());
if (myRow.Table.Columns.Contains("WS"))
itemPerson.WS = myRow["WS"].ToString();
//For Hotels with format mm/dd/yyyy-->Puerto Rico
if (itemPerson.HN == 5907 || itemPerson.HN == 7172)
{
if (myRow.Table.Columns.Contains("ARR"))
itemPerson.ARR = Helper.ToDateTime(myRow["ARR"].ToString());
if (myRow.Table.Columns.Contains("DEP"))
itemPerson.DEP = Helper.ToDateTime(myRow["DEP"].ToString());
}
else if (itemPerson.WS == "A_LLAVES" || itemPerson.WS == "GTE_FRONT" || itemPerson.WS == "CALL_CENTER" || itemPerson.WS == "MPVRTELEFONOS2")
{
if (myRow.Table.Columns.Contains("ARR"))
itemPerson.ARR = Helper.ToDateTime(myRow["ARR"].ToString());
if (myRow.Table.Columns.Contains("DEP"))
itemPerson.DEP = Helper.ToDateTime(myRow["DEP"].ToString());
}
else
{
//For Hotels with format dd/mm/yyyy
if (myRow.Table.Columns.Contains("ARR"))
itemPerson.ARR = Helper.ToDT_mm_DD_yyyy(myRow["ARR"].ToString());
if (myRow.Table.Columns.Contains("DEP"))
itemPerson.DEP = Helper.ToDT_mm_DD_yyyy(myRow["DEP"].ToString());
}
if (myRow.Table.Columns.Contains("PCIID"))
itemPerson.PCIID = Helper.ToInt32(myRow["PCIID"].ToString());
//itemPerson.NOPAX = Helper.ToInt32(myRow["NOPAX"].ToString());
//Type of Guest
if (myRow.Table.Columns.Contains("TG"))
itemPerson.TG = myRow["TG"].ToString();
if (myRow.Table.Columns.Contains("HASPREV"))
itemPerson.HASPREV = Helper.ToBoolean(myRow["HASPREV"].ToString());
if (myRow.Table.Columns.Contains("HASSUCC"))
itemPerson.HASSUCC = Helper.ToBoolean(myRow["HASSUCC"].ToString());
if (myRow.Table.Columns.Contains("GID"))
itemPerson.GID = myRow["GID"].ToString();
if (myRow.Table.Columns.Contains("LN"))
itemPerson.LN = myRow["LN"].ToString();
if (myRow.Table.Columns.Contains("VIP"))
itemPerson.VIP = myRow["VIP"].ToString();
if (myRow.Table.Columns.Contains("TITLE"))
itemPerson.Title = myRow["TITLE"].ToString();
if (myRow.Table.Columns.Contains("STREET"))
itemPerson.Address.Street1 = myRow["STREET"].ToString();
if (myRow.Table.Columns.Contains("CITY"))
itemPerson.Address.City = myRow["CITY"].ToString();
if (myRow.Table.Columns.Contains("ZIP"))
itemPerson.Address.Zip = myRow["ZIP"].ToString();
if (myRow.Table.Columns.Contains("COUNTRY"))
itemPerson.Address.Country = myRow["COUNTRY"].ToString();
//itemPerson.Address.State = myRow["STATE"].ToString();
//itemPerson.Area = myRow["AREA"].ToString();
if (myRow.Table.Columns.Contains("PHONE"))
itemPerson.Phone = myRow["PHONE"].ToString();
if (myRow.Table.Columns.Contains("FAX"))
itemPerson.Fax = myRow["FAX"].ToString();
if (myRow.Table.Columns.Contains("EMAIL"))
itemPerson.EMAIL = myRow["EMAIL"].ToString();
if (myRow.Table.Columns.Contains("SF"))
itemPerson.SF = myRow["SF"].ToString();
//throw new Exception(Helper.ToDT_mm_DD_yyyy(myRow["DOB"].ToString()).ToString());
if (myRow.Table.Columns.Contains("DOB"))
{
if (myRow["DOB"].ToString() != "")
itemPerson.DOB = Helper.ToDT_mm_DD_yyyy(myRow["DOB"].ToString());
}
if (myRow.Table.Columns.Contains("SEX"))
itemPerson.Sex = myRow["SEX"].ToString();
if (myRow.Table.Columns.Contains("Salutation"))
{
itemPerson.Salutation = myRow["Salutation"].ToString();
}
if (myRow.Table.Columns.Contains("TAXID"))
{
itemPerson.TAXID = myRow["TAXID"].ToString();
}
if (myRow.Table.Columns.Contains("SN"))
itemPerson.SN = myRow["SN"].ToString();
if (myRow.Table.Columns.Contains("CN"))
itemPerson.CN = myRow["CN"].ToString();
if (myRow.Table.Columns.Contains("MC"))
itemPerson.MC = myRow["MC"].ToString();
if (myRow.Table.Columns.Contains("RN"))
itemPerson.RN = myRow["RN"].ToString();
if (myRow.Table.Columns.Contains("CAT"))
itemPerson.CAT = myRow["CAT"].ToString();
if (myRow.Table.Columns.Contains("MATCHCODE"))
if (myRow.Table.Columns.Contains("MATCHCODE").ToString() != "")
itemPerson.MATCHCODE = myRow["MATCHCODE"].ToString();
if (myRow.Table.Columns.Contains("TN"))
itemPerson.TN_CHK_IN = myRow["TN"].ToString();
if (myRow.Table.Columns.Contains("NC"))
itemPerson.NC_CHK_IN = myRow["NC"].ToString();
if (myRow.Table.Columns.Contains("CA"))
itemPerson.CA_CHK_IN = myRow["CA"].ToString();
if (myRow.Table.Columns.Contains("AP"))
itemPerson.AP_CHK_IN = myRow["AP"].ToString();
if (myRow.Table.Columns.Contains("CS"))
itemPerson.CS_CHK_IN = myRow["CS"].ToString();
if (myRow.Table.Columns.Contains("PH0"))
itemPerson.PH0_CHK_IN = myRow["PH0"].ToString();
if (myRow.Table.Columns.Contains("PH1"))
itemPerson.PH1_CHK_IN = myRow["PH1"].ToString();
if (myRow.Table.Columns.Contains("SRC"))
itemPerson.SRC_CHK_IN = myRow["SRC"].ToString();
if (myRow.Table.Columns.Contains("PAYTV"))
itemPerson.PAYTV_CHK_IN = myRow["PAYTV"].ToString();
if (myRow.Table.Columns.Contains("AN"))
itemPerson.AN_CHK_IN = myRow["AN"].ToString();
if (myRow.Table.Columns.Contains("ORG"))
itemPerson.ORG_CHK_IN = myRow["ORG"].ToString();
if (myRow.Table.Columns.Contains("GT"))
itemPerson.GT = myRow["GT"].ToString();
if (myRow.Table.Columns.Contains("GTD"))
itemPerson.GTD = myRow["GTD"].ToString();
if (myRow.Table.Columns.Contains("GNR"))
itemPerson.GNR = myRow["GNR"].ToString();
if (myRow.Table.Columns.Contains("GMD"))
itemPerson.GMD = myRow["GMD"].ToString();
if (myRow.Table.Columns.Contains("TT"))
itemPerson.TT = myRow["TT"].ToString();
if (myRow.Table.Columns.Contains("PAYTV"))
itemPerson.PAYTV_CHK_IN = myRow["PAYTV"].ToString();
if (myRow.Table.Columns.Contains("CREQ"))
itemPerson.CREQ = myRow["CREQ"].ToString();
//Check if that reservation exist or not is PMS Interface
int count=0;
itemPersonReturn = SIHOTPersonDB.SelectPersonByPCIID(itemPerson, out count);
//Search if the record exist by the PCIID
//WriteLogFile("dsadsa [" + itemPersonReturn.PCIID + "]");
if (itemPersonReturn.PCIID == 0)
{
//insert that row in the table
WriteLogFile("insert" + itemPersonReturn.PCIID + itemPerson.HN);
//SIHOTPersonDB.InsertSIHOT_CheckIn(itemPerson);
}
else if (itemPersonReturn.PCIID > 0)
{
//WriteLogFile("update" + itemPerson.PCIID + itemPerson.HN);
SIHOTPersonDB.UpdateSIHOT_CheckIn(itemPerson);
}
}
}
void ProcessRoomMove(string strFileName)
{
//Saving the document
dsAux.Reset();
dsAux.ReadXml(strFileName);
DataRow myRow;
DataTable tbl = dsAux.Tables[0];
//dsAux.Tables[0].ReadXml(
SIHOTPerson itemPerson = new SIHOTPerson();
//Being used to get back the reservation from the Database
SIHOTPerson itemPersonReturn = new SIHOTPerson();
for (int i = 0; i < tbl.Rows.Count; i++)
{
myRow = tbl.Rows[i];
m_TRansactionNumber = Helper.ToInt32(myRow["TN"].ToString());
itemPerson.TN = m_TRansactionNumber;
//this line is overwritting my checkins
itemPerson.OC = myRow["OC"].ToString();
itemPerson.HN = Helper.ToInt32(myRow["HN"].ToString());
itemPerson.PCIID = Helper.ToInt32(myRow["PCIID"].ToString());
if (myRow.Table.Columns.Contains("RN"))
itemPerson.RN = myRow["RN"].ToString();
if (myRow.Table.Columns.Contains("ORN"))
itemPerson.ORN = myRow["ORN"].ToString();
if (myRow.Table.Columns.Contains("PH0"))
itemPerson.PH0_CHK_IN = myRow["PH0"].ToString();
if (myRow.Table.Columns.Contains("OPH0"))
itemPerson.OPH0 = myRow["OPH0"].ToString();
if (myRow.Table.Columns.Contains("PH1"))
itemPerson.PH1_CHK_IN = myRow["PH1"].ToString();
if (myRow.Table.Columns.Contains("OPH1"))
itemPerson.OPH1 = myRow["OPH1"].ToString();
if (myRow.Table.Columns.Contains("SF"))
itemPerson.SF = myRow["SF"].ToString();
//Check if that reservation exist or not is PMS Interface
int count = 0;
itemPersonReturn = SIHOTPersonDB.SelectPersonByPCIID(itemPerson, out count);
//Search if the record exist by the PCIID
if (itemPersonReturn.PCIID == 0)
{
//insert that row in the table
Response.Write("insert RoomMove[" + itemPerson.PCIID + itemPerson.HN + "]");
//SIHOTPersonDB.InsertSIHOT_CheckOut(itemPerson);
}
else if (itemPersonReturn.PCIID > 0)
{
//WriteLogFile("update[" + itemPerson.PCIID + itemPerson.HN + "]");
SIHOTPersonDB.UpdateSIHOT_RoomMove(itemPerson);
}
}
}
void ProcessMultipleFiles()
{
DataTable tbl;
foreach (DataTable dtTemp in dsAux.Tables)
{
//cmbDataSetTables.Items.Add(dtTemp.TableName);
//Saving the document
DataRow myRow;
SIHOT_Reservation item = new SIHOT_Reservation();
if (dtTemp.TableName == "SIHOT-Document")
{
myRow = null;
tbl = dsAux.Tables[dtTemp.TableName];
for (int i = 0; i < tbl.Rows.Count; i++)
{
myRow = tbl.Rows[i];
m_TRansactionNumber = Helper.ToInt32(myRow["TN"].ToString());
item.TN = m_TRansactionNumber;
item.OC = myRow["OC"].ToString();
item.HN = Helper.ToInt32(myRow["HN"].ToString());
m_SH_Hotel_Num = Helper.ToInt32(myRow["HN"].ToString());
item.SIHOT_Document_Id = myRow["SIHOT-Document_Id"].ToString();
//insert that row in the table
this.GridView1.DataSource = dsAux.Tables[dtTemp.TableName];
GridView1.DataBind();
}
}
if (dtTemp.TableName == "SIHOT-Reservation")
{
myRow = null ;
tbl = dsAux.Tables[dtTemp.TableName];
for (int i = 0; i < tbl.Rows.Count; i++)
{
myRow = tbl.Rows[i];
item.RNO = Helper.ToInt32(myRow["RNO"].ToString());
item.RSNO = Helper.ToInt32(myRow["RSNO"].ToString());
item.ARR = Helper.ToDateTime(myRow["ARR"].ToString());
//items.ARR.Value.ToString("MM/dd/yyyy");
item.DEP = Helper.ToDateTime(Helper.ToDT_mm_DD_yyyy(myRow["DEP"].ToString()));
item.NOPAX = Helper.ToInt32(myRow["NOPAX"].ToString());
item.RT = myRow["RT"].ToString();
item.SIHOT_Reservation_Id = myRow["SIHOT-Reservation_Id"].ToString();
}
//insert that row in the table
SIHOT_ReservationDB.InsertSIHOT_Reservation(item);
//Response.Write("Registro agregado exitosamente");
this.GridView2.DataSource = dsAux.Tables[dtTemp.TableName];
GridView2.DataBind();
}
if (dtTemp.TableName == "SIHOT-Person")
{
//Second Part Saving the reservation
//Check if this reservation already exist
//Saving the Person
myRow = null;
tbl = dsAux.Tables[dtTemp.TableName];
SIHOTPerson itemPerson = new SIHOTPerson();
for (int i = 0; i < tbl.Rows.Count; i++)
{
myRow = tbl.Rows[i];
itemPerson.TN = m_TRansactionNumber;
itemPerson.ARR = Helper.ToDateTime(myRow["ARR"].ToString());
itemPerson.DEP = Helper.ToDateTime(myRow["DEP"].ToString());
//Check if this PCIID already exist
itemPerson.PCIID = Helper.ToInt32(myRow["PCIID"].ToString());
itemPerson.NOPAX = Helper.ToInt32(myRow["NOPAX"].ToString());
itemPerson.TG = myRow["PCIID"].ToString();
itemPerson.HASPREV = Helper.ToBoolean(myRow["HASPREV"].ToString());
itemPerson.HASSUCC = Helper.ToBoolean(myRow["HASSUCC"].ToString());
itemPerson.GID = myRow["GID"].ToString();
itemPerson.LN = myRow["LN"].ToString();
itemPerson.VIP = myRow["VIP"].ToString();
itemPerson.Title = myRow["TITLE"].ToString();
itemPerson.Address.Street1 = myRow["STREET"].ToString();
itemPerson.Address.City = myRow["CITY"].ToString();
itemPerson.Address.Zip = myRow["ZIP"].ToString();
itemPerson.Address.Country = myRow["COUNTRY"].ToString();
//itemPerson.Address.State = myRow["STATE"].ToString();
//itemPerson.Area = myRow["AREA"].ToString();
itemPerson.Phone = myRow["PHONE"].ToString();
itemPerson.Fax = myRow["FAX"].ToString();
itemPerson.EMAIL = myRow["EMAIL"].ToString();
//if (myRow["DOB"].ToString()!=null)
// itemPerson.DOB = Helper.ToDateTime(myRow["DOB"].ToString());
itemPerson.Sex = myRow["SEX"].ToString();
itemPerson.SN = myRow["SN"].ToString();
itemPerson.CN = myRow["CN"].ToString();
itemPerson.MC = myRow["MC"].ToString();
itemPerson.RN = myRow["RN"].ToString();
itemPerson.CAT = myRow["CAT"].ToString();
itemPerson.SIHOT_Reservation_Id = myRow["SIHOT-Reservation_Id"].ToString();
itemPerson.SIHOT_Person_Id = myRow["SIHOT-Person_Id"].ToString();
//insert that row in the table
SIHOTPersonDB.InsertSIHOT_Person(itemPerson);
if (dtTemp.TableName == "SIHOT-Person")
{
this.GridView3.DataSource = dsAux.Tables[dtTemp.TableName];
GridView3.DataBind();
}
}
}
if (dtTemp.TableName == "SIHOT-Package")
{
//Saving the Package
myRow = null;
tbl = dsAux.Tables[dtTemp.TableName];
SIHOT_Package itemPackage = new SIHOT_Package();
for (int i = 0; i < tbl.Rows.Count; i++)
{
//global variable
myRow = tbl.Rows[i];
itemPackage.TN = m_TRansactionNumber;
if (myRow["From"].ToString() != null)
itemPackage.SIHOT_PACKAGE_FROM = Helper.ToDateTime(myRow["From"].ToString());
if (myRow["To"].ToString() != null)
itemPackage.SIHOT_PACKAGE_TO = Helper.ToDateTime(myRow["To"].ToString());
if (myRow["SID"].ToString() != null)
itemPackage.SIHOT_PACKAGE_SID = myRow["SID"].ToString();
if (myRow["RS"].ToString() != null)
itemPackage.SIHOT_PACKAGE_RS = myRow["RS"].ToString();
if (myRow["SIDT"].ToString() != null)
itemPackage.SIHOT_PACKAGE_SIDT = myRow["SIDT"].ToString();
if (myRow["SIHOT-Person_Id"].ToString() != null)
itemPackage.SIHOT_Person_Id = myRow["SIHOT-Person_Id"].ToString();
//inserting the row in the table
SIHOTPackageDB.InsertSIHOT_Package(itemPackage);
if (dtTemp.TableName == "SIHOT-Package")
{
this.GridView4.DataSource = dsAux.Tables[dtTemp.TableName];
GridView4.DataBind();
}
}
}
}
}
public static void UpdateSIHOT_Person_CR(SIHOTPerson value)
{
//throw new Exception(value.GID);
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@TN_48", value.TN),
new SqlParameter("@HN_50", value.HN),
new SqlParameter("@RNO_51", value.RNO),
new SqlParameter("@RSNO_52", value.RSNO),
new SqlParameter("@PCIID_1", value.PCIID),
new SqlParameter("@ARR_Date_2", value.ARR),
new SqlParameter("@DEP_Date_3", value.DEP),
//new SqlParameter("@HASPREV_4", value.HASPREV),
//new SqlParameter("@HASSUCC_5", value.HASSUCC),
new SqlParameter("@NOPAX_6", value.NOPAX),
new SqlParameter("@SF_7", value.SF),
new SqlParameter("@GID_8", value.GID),
new SqlParameter("@SN_9", value.SN),
new SqlParameter("@CN_10", value.CN),
new SqlParameter("@LN_11", value.LN),
new SqlParameter("@VIP_12", value.VIP),
new SqlParameter("@STREET_13", value.Address.Street1),
new SqlParameter("@CITY_14", value.Address.City),
new SqlParameter("@ZIP_15", value.Address.Zip),
new SqlParameter("@COUNTRY_16", value.Address.Country),
new SqlParameter("@STATE_17", value.Address.State),
new SqlParameter("@AREA_18", value.Area),
new SqlParameter("@PHONE_19", value.Phone),
new SqlParameter("@PHONE2_20", value.Phone2),
new SqlParameter("@FAX_21", value.Fax),
new SqlParameter("@FAX2_22", value.Fax2),
new SqlParameter("@EMAIL_23", value.EMAIL),
new SqlParameter("@EMAIL2_24", value.EMAIL2),
new SqlParameter("@TAXID_25", value.TAXID),
new SqlParameter("@DOB_26", value.DOB),
new SqlParameter("@SEX_27", value.Sex),
new SqlParameter("@PASSWD_28", value.Passwd),
new SqlParameter("@MATCHCODE_29", value.MATCHCODE),
new SqlParameter("@ADMCODEHQ_30", value.ADMCODEHQ),
new SqlParameter("@GT_31", value.GT),
new SqlParameter("@GTD_32", value.GTD),
new SqlParameter("@GNR_33", value.GNR),
new SqlParameter("@GMD_34", value.GMD),
new SqlParameter("@GDB_35", value.GDB),
new SqlParameter("@TT_36", value.TT),
new SqlParameter("@HQGID_37", value.HQGID),
new SqlParameter("@CREQ_38", value.CREQ),
new SqlParameter("@CREQSTATE_39", value.CREQState),
new SqlParameter("@SALUTATION_40", value.Salutation),
new SqlParameter("@TITLE_41", value.Title),
new SqlParameter("@T_TITLE_42", value.Title),
new SqlParameter("@CARDS_43", value.Cards),
new SqlParameter("@RN_44", value.RN),
//new SqlParameter("@ROOMSIMPLIED_48", value.RN),
new SqlParameter("@CAT_45", value.CAT),
new SqlParameter("@TG_46", value.TG),
new SqlParameter("@MC_47", value.MC)
};
SqlHelper.ExecuteNonQuery(Helper.ConnectionString, CommandType.StoredProcedure, "Update_tblSIHOT_Person_CR", param);
}
public static void UpdateSIHOT_Person_Available(SIHOTPerson value)
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@HN_1", value.HN),
new SqlParameter("@VacationClubCode", value.VacationClubCode),
new SqlParameter("@PCIID_2", value.PCIID),
new SqlParameter("@RoomNum_3", value.RN),
//new SqlParameter("@DEP_Date_4", value.DEP),
new SqlParameter("@Avl_5", value.Available)
};
SqlHelper.ExecuteNonQuery(Helper.ConnectionString, CommandType.StoredProcedure, "Update_tblSIHOT_Person_Avl", param);
}
public static SIHOTPerson SelectPersonByPCIID_CR(SIHOTPerson value, out int count)
{
SIHOTPerson retval = new SIHOTPerson();
// throw new Exception(value.DEP.ToString());
SqlParameter pOut = new SqlParameter("@Count", SqlDbType.Int, 4);
pOut.Direction = ParameterDirection.Output;
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@parHN", value.HN), //new addition
//new SqlParameter("@parDepDate", value.DEP), //new addition
new SqlParameter("@parPCIID", value.PCIID),
new SqlParameter("@parReservationNumber", value.RNO),//new addition
new SqlParameter("@parReservationSubNumber", value.RSNO), //new addition
pOut
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "Select_tblSIHOT_Person_CR", param))
{
if (reader.Read())
{
retval = Read(reader);
}
}
count = Helper.ToInt32(pOut.Value);
return retval;
}
public static SIHOTPerson Read(SqlDataReader reader)
{
SIHOTPerson retval = new SIHOTPerson();
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.ToDateTime(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 "Available":
retval.Available= Helper.ToBoolean(reader[i]);
break;
case "Info":
retval.PreTourBooking.Invited = Helper.ToBoolean(reader[i]);
break;
case "ProspectId":
retval.ProspectId = Helper.ToInt32(reader[i]);
break;
case "TourID":
retval.TourId = Helper.ToInt32(reader[i]);
break;
case "Status":
retval.Status = Helper.ToString(reader[i]);
break;
case "DateContacted":
retval.PreTourBooking.DateContacted = Helper.ToDateTime(reader[i]);
break;
case "ContactedBy":
retval.PreTourBooking.ContactedBy = Helper.ToString(reader[i]);
break;
case "InterestedInTour":
retval.PreTourBooking.InterestedInTour = Helper.ToString(reader[i]);
break;
case "Invited":
retval.PreTourBooking.Invited = Helper.ToBoolean(reader[i]);
break;
case "FollowUpDate":
retval.PreTourBooking.FollowUpDate = Helper.ToDateTime(reader[i]);
break;
case "AgencyName":
retval.AgencyName = Helper.ToString(reader[i]);
break;
case "NoteDesc":
retval.Notes.NoteDesc = Helper.ToString(reader[i]);
break;
case "NQTypesID":
retval.PreTourBooking.NQTypesID = Helper.ToInt32(reader[i]);
break;
case "PrimaryFlag":
retval.PrimaryFlag = Helper.ToBoolean(reader[i]);
break;
//vw_TSW_ProspectTour.Wave, vw_TSW_ProspectTour.TourResult, vw_TSW_ProspectTour.VacConsult,DisplayMarket,DisplaySegment
case "VacConsult"://VC FName and LName
retval.TSWCatalogs.FirstName = Helper.ToString(reader[i]);
break;
case "Wave"://Tour Wave
retval.TSWTour.wave = Helper.ToString(reader[i]);
break;
case "TourResult":
retval.TSWTour.TourResult = Helper.ToString(reader[i]);
break;
case "DisplayMarket":
retval.DisplayMarket = Helper.ToString(reader[i]);
break;
case "DisplaySegment":
retval.DisplaySegment = Helper.ToString(reader[i]);
break;
case "NQTypes":
retval.PreTourBooking.NQTypesDesc = Helper.ToString(reader[i]);
break;
}
}
return retval;
}
public static SIHOTPerson GetProspectTSW(int prospectID)
{
SIHOTPerson retval = new SIHOTPerson();
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@prospectID", prospectID),
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "TUNA_selProspect_ByProsID_TSW", param))
{
if (reader.Read())
{
retval = Read(reader);
}
}
return retval;
}
public static SIHOTPerson GetPersons_ByReservationNum(int parReservationNum, int parReservationSubNum, int parPCIID, Int32 parSiteId, int FromLive)
{
SIHOTPerson retval = new SIHOTPerson();
SqlParameter pOut = new SqlParameter("@Count", SqlDbType.Int, 4);
pOut.Direction = ParameterDirection.Output;
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@FromLive", FromLive),
new SqlParameter("@parReservationNum", parReservationNum),
new SqlParameter("@parSubReservationNum", parReservationSubNum),
new SqlParameter("@parPCIID", parPCIID),
new SqlParameter("@parHotelNumber", parSiteId),
pOut
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, "Select_TSW_Person_By_ReservNum", param))
{
if (reader.Read())
{
retval = Read(reader);
}
}
return retval;
}
public static void UpdateSIHOT_RoomMove(SIHOTPerson value)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@PCIID_1", value.PCIID),
new SqlParameter("@TN_2", value.TN),
new SqlParameter("@OC_4", value.OC),
new SqlParameter("@HN_5", value.HN),
new SqlParameter("@RN_6", value.RN),
new SqlParameter("@ORN_7", value.ORN),
new SqlParameter("@PH0_8", value.PH0_CHK_IN),
new SqlParameter("@PH1_9", value.PH1_CHK_IN),
new SqlParameter("@OPH0_10", value.OPH0),
new SqlParameter("@OPH1_11", value.OPH1),
new SqlParameter("@SF_12", value.SF)
};
SqlHelper.ExecuteNonQuery(Helper.ConnectionString, CommandType.StoredProcedure, "Update_tblSIHOT_RoomMove", param);
}
