/// <summary>
/// Method to get the Hotel Info based on Stars/Event
/// </summary>
/// <param name="StarsId"></param>
/// <returns></returns>
public HotelCarModel GetHotelInfoByStarsEvent(string StarsId, decimal EventId)
{
HotelCarModel model = new HotelCarModel();
using (LBCData context = new LBCData(ConnectionHelper.getConnectionString()))
{
var _registration = from pr in context.LBC_PROFILE
join reg in context.LBC_REGISTRATION on pr.STARS_ID equals reg.STARS_ID
from ht in context.LBC_HOTEL_CAR_INFO.Where(ht => ht.STARS_ID == pr.STARS_ID && ht.EVENT_ID == reg.EVENT_ID).DefaultIfEmpty()
where pr.STARS_ID == StarsId && reg.EVENT_ID == EventId && reg.REGD_STATUS == "A"
select new HotelCarModel
{
STARS_ID = pr.STARS_ID,
PA_CODE = pr.PA_CODE,
FIRST_NAME = pr.FIRST_NAME,
LAST_NAME = pr.LAST_NAME,
DEALERSHIP_NAME = pr.DLR_NAME,
HOTEL_NAME = ht.HOTEL_NAME,
HOTEL_CONF = ht.HOTEL_CONF,
HOTEL_CHECK_IN = ht.HOTEL_CHECK_IN,
HOTEL_CHECK_OUT = ht.HOTEL_CHECK_OUT,
CAR_CONFIRM = ht.CAR_CONFIRM,
CAR_NOTES = ht.CAR_NOTES,
EVENT_ID = reg.EVENT_ID,
ADMIN_NOTES = ht.ADMIN_NOTES
};
model = _registration.SingleOrDefault();
}
return(model);
}
public bool UpdateHotelInfo(HotelCarModel model)
{
bool save = true;
try
{
using (LBCData context = new LBCData(ConnectionHelper.getConnectionString()))
{
var _hotel = (from p in context.LBC_HOTEL_CAR_INFO
where p.STARS_ID == model.STARS_ID && p.EVENT_ID == model.EVENT_ID
select p).FirstOrDefault();
_hotel.HOTEL_NAME = model.HOTEL_NAME;
_hotel.HOTEL_CONF = model.HOTEL_CONF;
_hotel.HOTEL_CHECK_IN = model.HOTEL_CHECK_IN;
_hotel.HOTEL_CHECK_OUT = model.HOTEL_CHECK_OUT;
_hotel.CAR_CONFIRM = model.CAR_CONFIRM;
_hotel.CAR_NOTES = model.CAR_NOTES;
_hotel.ADMIN_NOTES = model.ADMIN_NOTES;
_hotel.UPDATE_DATE = model.UPDATE_DATE;
_hotel.UPDATED_BY = model.UPDATED_BY;
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
// save = false;
}
return(save);
}
/// <summary>
/// Method to Create entry
/// </summary>
/// <param name="model"></param>
public void SaveHotelInfo(HotelCarModel model)
{
using (LBCData context = new LBCData(ConnectionHelper.getConnectionString()))
{
LBC_HOTEL_CAR_INFO _hotel = new LBC_HOTEL_CAR_INFO()
{
STARS_ID = model.STARS_ID,
EVENT_ID = model.EVENT_ID,
HOTEL_NAME = model.HOTEL_NAME,
HOTEL_CONF = model.HOTEL_CONF,
HOTEL_CHECK_IN = model.HOTEL_CHECK_IN,
HOTEL_CHECK_OUT = model.HOTEL_CHECK_OUT,
CAR_CONFIRM = model.CAR_CONFIRM,
ADMIN_NOTES = model.ADMIN_NOTES,
CAR_NOTES = model.CAR_NOTES,
CREATED_DATE = model.CREATED_DATE,
CREATED_BY = model.CREATED_BY
};
context.LBC_HOTEL_CAR_INFO.Add(_hotel);
context.SaveChanges();
}
}
public bool UpdateHotelInfo(HotelCarModel model)
{
HotelInfoRepository _hotel = new HotelInfoRepository();
return(_hotel.UpdateHotelInfo(model));
}
public void SaveHotelInfo(HotelCarModel model)
{
HotelInfoRepository _hotel = new HotelInfoRepository();
_hotel.SaveHotelInfo(model);
}
