public JsonResult SaveRoomRate(string Mode, string StartDate, string Enddate, string RoomType, string PricePolicy, string AccommodationType, string HotelRoomID, string SinglePrice, string DoublePrice, string RoomPrice)
        {
            int j = 0;
            RoomRateRepository Obj = new RoomRateRepository();
            try {
            AssignBizContext();
            int HotelID = BizContext.HotelID;
            long UserSessionID = Convert.ToInt64(BizContext.UserSessionID);
            HotelRooms = modelHotelRateAndAvailability.GetHotelRooms("RoomTypeName", HotelID);
            foreach (DataRow hotelRoom in HotelRooms.Rows)
            {
                modelRepo.CreateHotelRoomRate(hotelRoom["ID"].ToString(), StartDate, Enddate, PricePolicy, AccommodationType);
            }

            double singlePrice = 0;
            double doublePrice = 0;
            double roomPrice = 0;

            if (SinglePrice != string.Empty)
            {
                singlePrice = Convert.ToDouble(FormatToNumber(SinglePrice, "en", "en-Gb", 2));
            }
            if (DoublePrice != string.Empty)
            {
                doublePrice = Convert.ToDouble(FormatToNumber(DoublePrice, "en", "en-Gb", 2));
            }
            if (RoomPrice != string.Empty)
            {
                roomPrice = Convert.ToDouble(FormatToNumber(RoomPrice, "en", "en-Gb", 2));
            }

            Obj.SaveHotelRoomRate(HotelID, HotelRoomID, StartDate, Enddate, PricePolicy, AccommodationType, singlePrice, doublePrice, roomPrice, UserSessionID, DateTime.Now, this);
            }
            catch (Exception ex)
            {
                string hostName1 = Dns.GetHostName();
                string GetUserIPAddress = Dns.GetHostByName(hostName1).AddressList[0].ToString();
                string PageName = Convert.ToString(Session["PageName"]);
                //string GetUserIPAddress = GetUserIPAddress1();
                using (BaseRepository baseRepo = new BaseRepository())
                {
                    //BizContext BizContext1 = new BizContext();
                    BizApplication.AddError(baseRepo.BizDB, PageName, ex.Message, ex.StackTrace, DateTime.Now, GetUserIPAddress);
                }
                Session["PageName"] = "";
                string error = ErrorHandling.HandleException(ex);
                return this.Json(new DataSourceResult { Errors = error });
            }
            return Json(j, JsonRequestBehavior.AllowGet);
        }
        public JsonResult SaveDailyRoomRate(string Mode, string StartDate, string Enddate, string RoomType, string PricePolicy, string AccommodationType, string DateIDArray, string HotelRoomID, string SinglePriceArray, string DoublePriceArray, string RoomPriceArray, int MaxPeopleCount)
        {
            int j = 1;
            RoomRateRepository Obj = new RoomRateRepository();
            try {
            AssignBizContext();
            int HotelID = BizContext.HotelID;
            long UserSessionID = Convert.ToInt64(BizContext.UserSessionID);

            modelRepo.CreateHotelRoomRate(HotelRoomID, StartDate, Enddate, PricePolicy, AccommodationType);

            Obj.SaveHotelRate(HotelID, HotelRoomID, DateIDArray, PricePolicy, AccommodationType, SinglePriceArray, DoublePriceArray, RoomPriceArray, MaxPeopleCount, UserSessionID, DateTime.Now, this);
            }
            catch (Exception ex)
            {
                string hostName1 = Dns.GetHostName();
                string GetUserIPAddress = Dns.GetHostByName(hostName1).AddressList[0].ToString();
                string PageName = Convert.ToString(Session["PageName"]);
                //string GetUserIPAddress = GetUserIPAddress1();
                using (BaseRepository baseRepo = new BaseRepository())
                {
                    //BizContext BizContext1 = new BizContext();
                    BizApplication.AddError(baseRepo.BizDB, PageName, ex.Message, ex.StackTrace, DateTime.Now, GetUserIPAddress);
                }
                Session["PageName"] = "";
                string error = ErrorHandling.HandleException(ex);
                return this.Json(new DataSourceResult { Errors = error });
            }
            return Json(j, JsonRequestBehavior.AllowGet);
        }