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