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