public void AddLogApplication(LogsApplication item, string connectionName)
{
Database db = DatabaseFactory.CreateDatabase(connectionName);
DbCommand dbCommand = db.GetStoredProcCommand("AddLogApplication");
db.AddInParameter(dbCommand, "UserName", DbType.String, item.UserName);
db.AddInParameter(dbCommand, "Firm", DbType.String, MyCTSConvert.ToDBValue(item.Firm));
db.AddInParameter(dbCommand, "UserControlName", DbType.String, MyCTSConvert.ToDBValue(item.UserControlName));
db.AddInParameter(dbCommand, "ErrorDescription", DbType.String, MyCTSConvert.ToDBValue(item.ErrorDescription));
db.AddInParameter(dbCommand, "StackTrace", DbType.String, MyCTSConvert.ToDBValue(item.StackTrace));
db.ExecuteNonQuery(dbCommand);
}
public List <SetNewFeeRule> AddNewFeeRule(string attribute1, int priority, string description,
string extendedDescription, decimal defaultFee, decimal defaultMount, bool mandatory,
bool activationState, DateTime startDate, DateTime expirationDate, string agente, string connectionName)
{
Database db = DatabaseFactory.CreateDatabase(connectionName);
DbCommand dbcomand = db.GetStoredProcCommand(Resources.SetNewFeeRuleResources.SP_SETNEWFEERULE);
db.AddInParameter(dbcomand, Resources.SetNewFeeRuleResources.PARAM_QUERY1, DbType.String, attribute1);
db.AddInParameter(dbcomand, Resources.SetNewFeeRuleResources.PARAM_QUERY2, DbType.Int32, priority);
db.AddInParameter(dbcomand, Resources.SetNewFeeRuleResources.PARAM_QUERY3, DbType.String, description);
db.AddInParameter(dbcomand, Resources.SetNewFeeRuleResources.PARAM_QUERY4, DbType.String, extendedDescription);
db.AddInParameter(dbcomand, Resources.SetNewFeeRuleResources.PARAM_QUERY5, DbType.Decimal, defaultFee);
db.AddInParameter(dbcomand, Resources.SetNewFeeRuleResources.PARAM_QUERY6, DbType.Decimal, defaultMount);
db.AddInParameter(dbcomand, Resources.SetNewFeeRuleResources.PARAM_QUERY7, DbType.Boolean, mandatory);
db.AddInParameter(dbcomand, Resources.SetNewFeeRuleResources.PARAM_QUERY8, DbType.Boolean, activationState);
db.AddInParameter(dbcomand, Resources.SetNewFeeRuleResources.PARAM_QUERY9, DbType.DateTime, MyCTSConvert.ToDBValue(startDate));
db.AddInParameter(dbcomand, Resources.SetNewFeeRuleResources.PARAM_QUERY10, DbType.DateTime, MyCTSConvert.ToDBValue(expirationDate));
db.AddInParameter(dbcomand, Resources.SetNewFeeRuleResources.PARAM_QUERY11, DbType.String, agente);
List <SetNewFeeRule> listNewFeeRule = new List <SetNewFeeRule>();
using (IDataReader dr = db.ExecuteReader(dbcomand))
{
int _idRuleNumber = dr.GetOrdinal(Resources.SetNewFeeRuleResources.PARAM_IDRULENUMBER);
while (dr.Read())
{
SetNewFeeRule item = new SetNewFeeRule();
item.IDRuleNumber = dr.GetInt32(_idRuleNumber);
listNewFeeRule.Add(item);
}
return(listNewFeeRule);
}
}
public void AddDetailsPNR(string recLoc, string origin, string destination, string departureTime,
string arrivalTime, string airlineCode, string flightNumber, Nullable <DateTime> departureDate,
string airlineRef, DateTime traveldate,
string location_dk, Nullable <Decimal> paxNumber, string paxType, string paxName, string paxLastName, string segmentType,
string fareBasis, string pcc, string idGroup, string masterPNR, string connectionName)
{
Database db = DatabaseFactory.CreateDatabase(connectionName);
DbCommand dbcomand = db.GetStoredProcCommand(Resources.SetDetailsPNRResources.SP_SetDetailsPNR);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY, DbType.String, recLoc);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY2, DbType.String, origin);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY3, DbType.String, destination);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY4, DbType.String, departureTime);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY5, DbType.String, arrivalTime);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY6, DbType.String, airlineCode);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY7, DbType.String, flightNumber);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY8, DbType.DateTime, departureDate);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY9, DbType.String, airlineRef);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY10, DbType.DateTime, MyCTSConvert.ToDBValue(traveldate));
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY11, DbType.String, location_dk);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY12, DbType.String, paxNumber);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY13, DbType.String, paxType);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY14, DbType.String, paxName);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY15, DbType.String, paxLastName);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY16, DbType.String, segmentType);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY17, DbType.String, fareBasis);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY18, DbType.String, pcc);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY19, DbType.String, idGroup);
db.AddInParameter(dbcomand, Resources.SetDetailsPNRResources.PARAM_QUERY20, DbType.String, masterPNR);
db.ExecuteNonQuery(dbcomand);
}
public Star2Details ObjGetStar2Details(string level1, string level2, string connectionName)
{
Database db = DatabaseFactory.CreateDatabase(connectionName);
DbCommand dbCommand = db.GetStoredProcCommand(Resources.GetStar2DetailsResources.SP_GetStar2Details);
db.AddInParameter(dbCommand, Resources.GetStar2DetailsResources.PARAM_Level1, DbType.String, level1);
db.AddInParameter(dbCommand, Resources.GetStar2DetailsResources.PARAM_Level2, DbType.String, level2);
var item = new Star2Details();
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
int _id = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Id);
int _level1 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Level1);
int _level2 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Level2);
int _name = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Name);
int _lastName = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_LastName);
int _officePhone = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_OfficePhone);
int _ext = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Ext);
int _officePhoneCode = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_OfficePhoneCode);
int _directPhone = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_DirectPhone);
int _directPhoneCode = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_DirectPhoneCode);
int _email = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Email);
int _frequentFlyer1 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_FrequentFlyer1);
int _frequentFlyer2 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_FrequentFlyer2);
int _frequentFlyer3 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_FrequentFlyer3);
int _frequentFlyer4 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_FrequentFlyer4);
int _frequentFlyer5 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_FrequentFlyer5);
int _passport = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Passport);
int _birthday = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Birthday);
int _visa = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Visa);
int _immigrationForm = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_ImmigrationForm);
int _rfc = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_RFC);
int _creditCar = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_CreditCar);
int _personalCar = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_PersonalCar);
int _streetAndNumber = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_StreetAndNumber);
int _colony = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Colony);
int _postalCode = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_PostalCode);
int _estate = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Estate);
int _city = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_City);
int _name2 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Name2);
int _lastName2 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_LastName2);
int _paternal = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Paternal);
int _maternal = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Maternal);
int _occupation = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Occupation);
int _seat = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Seat);
int _family1 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Family1);
int _family2 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Family2);
int _family3 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Family3);
int _family4 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Family4);
int _family5 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Family5);
int _family6 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Family6);
int _comments = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Comments);
int _hotelCreditCar = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_HotelCreditCar);
int _cadHotel1 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_CadHotel1);
int _cadHotel2 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_CadHotel2);
while (dr.Read())
{
item.Id = (dr[_id] == DBNull.Value) ? Types.StringNullValue : dr.GetInt32(_id).ToString();
item.Level1 = MyCTSConvert.ToString(dr.GetString(_level1));
item.Level2 = MyCTSConvert.ToString(dr.GetString(_level2));
item.Name = MyCTSConvert.ToString(dr.GetString(_name));
item.LastName = MyCTSConvert.ToString(dr.GetString(_lastName));
item.OfficePhone = MyCTSConvert.ToString(dr.GetString(_officePhone));
item.Ext = MyCTSConvert.ToString(dr.GetString(_ext));
item.OfficePhoneCode = MyCTSConvert.ToString(dr.GetString(_officePhoneCode));
item.DirectPhone = MyCTSConvert.ToString(dr.GetString(_directPhone));
item.DirectPhoneCode = MyCTSConvert.ToString(dr.GetString(_directPhoneCode));
item.Email = MyCTSConvert.ToString(dr.GetString(_email));
item.FrequentFlyer1 = MyCTSConvert.ToString(dr.GetString(_frequentFlyer1));
item.FrequentFlyer2 = MyCTSConvert.ToString(dr.GetString(_frequentFlyer2));
item.FrequentFlyer3 = MyCTSConvert.ToString(dr.GetString(_frequentFlyer3));
item.FrequentFlyer4 = MyCTSConvert.ToString(dr.GetString(_frequentFlyer4));
item.FrequentFlyer5 = MyCTSConvert.ToString(dr.GetString(_frequentFlyer5));
item.Passport = MyCTSConvert.ToString(dr.GetString(_passport));
item.Birthday = MyCTSConvert.ToString(dr.GetString(_birthday));
item.Visa = MyCTSConvert.ToString(dr.GetString(_visa));
item.ImmigrationForm = MyCTSConvert.ToString(dr.GetString(_immigrationForm));
item.Rfc = MyCTSConvert.ToString(dr.GetString(_rfc));
item.CreditCar = MyCTSConvert.ToString(dr.GetString(_creditCar));
item.PersonalCar = MyCTSConvert.ToString(dr.GetString(_personalCar));
item.StreetAndNumber = MyCTSConvert.ToString(dr.GetString(_streetAndNumber));
item.Colony = MyCTSConvert.ToString(dr.GetString(_colony));
item.PostalCode = MyCTSConvert.ToString(dr.GetString(_postalCode));
item.Estate = MyCTSConvert.ToString(dr.GetString(_estate));
item.City = MyCTSConvert.ToString(dr.GetString(_city));
item.Name2 = MyCTSConvert.ToString(dr.GetString(_name2));
item.LastName2 = MyCTSConvert.ToString(dr.GetString(_lastName2));
item.Paternal = MyCTSConvert.ToString(dr.GetString(_paternal));
item.Maternal = MyCTSConvert.ToString(dr.GetString(_maternal));
item.Occupation = MyCTSConvert.ToString(dr.GetString(_occupation));
item.Seat = MyCTSConvert.ToString(dr.GetString(_seat));
item.Family1 = MyCTSConvert.ToString(dr.GetString(_family1));
item.Family2 = MyCTSConvert.ToString(dr.GetString(_family2));
item.Family3 = MyCTSConvert.ToString(dr.GetString(_family3));
item.Family4 = MyCTSConvert.ToString(dr.GetString(_family4));
item.Family5 = MyCTSConvert.ToString(dr.GetString(_family5));
item.Family6 = MyCTSConvert.ToString(dr.GetString(_family6));
item.Comments = MyCTSConvert.ToString(dr.GetString(_comments));
item.HotelCreditCar = MyCTSConvert.ToString(dr.GetString(_hotelCreditCar));
item.CadHotel1 = MyCTSConvert.ToString(dr.GetString(_cadHotel1));
item.CadHotel2 = MyCTSConvert.ToString(dr.GetString(_cadHotel2));
}
}
return(item);
}
