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); }