public List<HomeExt> GetCulturecode()
{
DataTable dt = new DataTable();
SQLCon.Open();
SqlCommand cmd = new SqlCommand("B_Getculture_BizTbl_Culture", SQLCon);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
SQLCon.Close();
List<HomeExt> CultureList = new List<HomeExt>();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
HomeExt obj = new HomeExt();
obj.Code = dr["Code"].ToString();
obj.SystemCode = dr["SystemCode"].ToString();
obj.Description = dr["Description"].ToString();
CultureList.Add(obj);
}
}
}
return CultureList;
}
public List<HomeExt> recentHotelReservations(int HotelID, DateTime ReservationStartDate, DateTime ReservationEndDate)
{
List<HomeExt> list = new List<HomeExt>();
DataTable dt = new DataTable();
DataSet ds = new DataSet();
SQLCon.Open();
SqlCommand cmd = new SqlCommand("TB_SP_GetHotelReservations", SQLCon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OrderBy", "ReservationDate");
cmd.Parameters.AddWithValue("@Culture", CultureCode);
cmd.Parameters.AddWithValue("@PagingSize", int.MaxValue);
cmd.Parameters.AddWithValue("@PageIndex", 1);
cmd.Parameters.AddWithValue("@HotelID", HotelID);
cmd.Parameters.AddWithValue("@ReservationStartDate", ReservationStartDate.Date);
cmd.Parameters.AddWithValue("@ReservationEndDate", ReservationEndDate.Date);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
SQLCon.Close();
dt = ds.Tables[1].DefaultView.ToTable(true, "ReservationID", "PinCode", "ReservationDate", "FullName", "CheckInDate", "CheckOutDate", "StatusID", "StatusName");
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
HomeExt model = new HomeExt();
model.ReservationID = dr["ReservationID"].ToString();
model.ReservationOwener = dr["FullName"].ToString();
string EncryptReservationID = dr["ReservationID"].ToString();
EncryptReservationID = System.Web.HttpContext.Current.Server.UrlEncode(ConvertStringToHex(objEncryptreservation.Encrypt(EncryptReservationID, "58421043")));
model.EncryptReservationID = EncryptReservationID;
DateTime Resrvationdate = Convert.ToDateTime(dr["ReservationDate"]).Date;
DateTime Nowdate = DateTime.Now.Date;
if (Resrvationdate == Nowdate)
{
model.Resrvationdate = Resources.Resources.Today;
}
else if (Resrvationdate == Nowdate.AddDays(-1))
{
model.Resrvationdate = Resources.Resources.Yesterday;
}
else
{
model.Resrvationdate = Resrvationdate.ToString("dd MMMM yyyy, dddd");
}
list.Add(model);
}
}
return list;
}
