/// <summary>
/// GetBookingByEmail
/// </summary>
/// <param name="Surname"></param>
/// <param name="RLOC"></param>
/// <returns></returns>
public IList <BookingModel> GetBookingByEmail(string strEmailAddress)
{
MySqlParameter[] queryParams = new MySqlParameter[] {
new MySqlParameter("email", strEmailAddress),
};
StringBuilder sb = new StringBuilder();
sb.Append("CALL GetBookingByEmail(@email)");
string commandText = sb.ToString();
var results = qilivedata.ExecuteStoreQuery <BookingModel>(commandText, queryParams);
return(results.ToList());
}
/// <summary>
/// SearchItineraryDataBySurnameAndRLOC
/// </summary>
/// <param name="Surname"></param>
/// <param name="RLOC"></param>
/// <returns></returns>
public IList <XmlBookingModel> SearchItineraryDataBySurnameAndRLOC(string Surname, string RLOC)
{
try
{
MySqlParameter[] queryParams = new MySqlParameter[] {
new MySqlParameter("p_RLOC", RLOC),
new MySqlParameter("p_lastname", Surname),
};
StringBuilder sb = new StringBuilder();
sb.Append("CALL GetItineraryDataBySurnameAndRLOC(@p_RLOC, @p_lastname)");
string commandText = sb.ToString();
var results = qilivedata.ExecuteStoreQuery <XmlBookingModel>(commandText, queryParams);
return(results.ToList());
}
catch
{
IList <XmlBookingModel> lst = new List <XmlBookingModel>();
return(lst);
}
}
