/// <summary>
/// Connect TBDAT to retreive guest's data
/// </summary>
/// <param name="propertyCode"></param>
/// <param name="checkOutDate"></param>
public static List <Medallia> GetGuestByPropCode(string propertyCode, string checkOutDate)
{
var mdc = new MedalliaDataContext();
List <Medallia> guest;
if (checkOutDate.ToLower().Equals("any"))
{
guest = (from tbdat in mdc.TBDATs
where tbdat.PROPERTYCODE == propertyCode && tbdat.EMAIL != " " && tbdat.EMAIL != ""
orderby tbdat.PROPERTYCODE, tbdat.GUESTFIRSTNAME, tbdat.GUESTLASTNAME
select new Medallia()
{
Email = tbdat.EMAIL,
GuestFirstName = tbdat.GUESTFIRSTNAME,
GuestLastName = tbdat.GUESTLASTNAME,
PropertyCode = tbdat.PROPERTYCODE,
Country = tbdat.COUNTRY,
RateCode = tbdat.RATECODE
}).ToList();
}
else
{
var datetime = checkOutDate + " 00:00:00.000";
var dt = Convert.ToDateTime(datetime);
guest = (from tbdat in mdc.TBDATs
where tbdat.CHECKOUTDATE == dt && tbdat.PROPERTYCODE == propertyCode && tbdat.EMAIL != " " && tbdat.EMAIL != ""
orderby tbdat.PROPERTYCODE, tbdat.GUESTFIRSTNAME, tbdat.GUESTLASTNAME
select new Medallia()
{
Email = tbdat.EMAIL,
GuestFirstName = tbdat.GUESTFIRSTNAME,
GuestLastName = tbdat.GUESTLASTNAME,
PropertyCode = tbdat.PROPERTYCODE,
Country = tbdat.COUNTRY,
RateCode = tbdat.RATECODE
}).ToList();
}
return(guest);
}
/// <summary>
/// Connect TBDAT to retreive guest's data
/// </summary>
/// <param name="propertyCode"></param>
/// <param name="checkOutDate"></param>
public static List<Medallia> GetGuestByPropCode(string propertyCode, string checkOutDate)
{
var mdc = new MedalliaDataContext();
List<Medallia> guest;
if(checkOutDate.ToLower().Equals("any"))
{
guest = (from tbdat in mdc.TBDATs
where tbdat.PROPERTYCODE == propertyCode && tbdat.EMAIL != " " && tbdat.EMAIL != ""
orderby tbdat.PROPERTYCODE , tbdat.GUESTFIRSTNAME , tbdat.GUESTLASTNAME
select new Medallia()
{
Email = tbdat.EMAIL,
GuestFirstName = tbdat.GUESTFIRSTNAME,
GuestLastName = tbdat.GUESTLASTNAME,
PropertyCode = tbdat.PROPERTYCODE,
Country = tbdat.COUNTRY,
RateCode = tbdat.RATECODE
}).ToList();
}
else
{
var datetime = checkOutDate + " 00:00:00.000";
var dt = Convert.ToDateTime(datetime);
guest = (from tbdat in mdc.TBDATs
where tbdat.CHECKOUTDATE == dt && tbdat.PROPERTYCODE == propertyCode && tbdat.EMAIL != " " && tbdat.EMAIL != ""
orderby tbdat.PROPERTYCODE , tbdat.GUESTFIRSTNAME , tbdat.GUESTLASTNAME
select new Medallia()
{
Email = tbdat.EMAIL,
GuestFirstName = tbdat.GUESTFIRSTNAME,
GuestLastName = tbdat.GUESTLASTNAME,
PropertyCode = tbdat.PROPERTYCODE,
Country = tbdat.COUNTRY,
RateCode = tbdat.RATECODE
}).ToList();
}
return guest;
}