public ActionResult FillRatePlan(int RoomType) { int PropId = Convert.ToInt32(Session["PropId"].ToString()); var rateplan = BL_tblChangeHistory.GetRatePlanByRoomID(RoomType, PropId); return(Json(rateplan, JsonRequestBehavior.AllowGet)); }
public ActionResult GetHistoryChangeDataExcel(int?PropId, string chkradio, string dtfrom, string dtto, string dteffectivefrom, string dteffectiveto, int?id, int?roomType, int?ratePlan) { DataTable dt = new DataTable(); DateTime dtFrom = dtfrom == "" ? DateTime.Now : DateTime.ParseExact(dtfrom, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); DateTime dtTo = dtto == "" ? DateTime.Now : DateTime.ParseExact(dtto, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); if (chkradio == "R") { DateTime dtEffectiveFrom = dteffectivefrom == "" ? DateTime.Now : DateTime.ParseExact(dteffectivefrom, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); DateTime dtEffectiveTo = dteffectiveto == "" ? DateTime.Now : DateTime.ParseExact(dteffectiveto, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); if (PropId != 0) { dt = BL_tblChangeHistory.getRecordForSearchExcel(PropId.Value, dtFrom, dtTo, roomType.Value, ratePlan.Value, dtEffectiveFrom, dtEffectiveTo); } else { dt = BL_tblChangeHistory.getRecordForSearchExcel(PropId.Value, dtFrom, dtTo, 0, 0, dtEffectiveFrom, dtEffectiveTo); } } if (chkradio == "I" || chkradio == "B") { string Id = id.ToString(); dt = BL_tblChangeHistory.getRecordForSearchExcel(PropId.Value, dtFrom, dtTo, Id); } if (chkradio == "Promotion") { string Id = id.ToString(); dt = BL_tblChangeHistory.getRecordForSearchPromotionsExcel(dtFrom, dtTo, Id, PropId.Value); } if (chkradio == "RatePlan") { dt = BL_tblChangeHistory.getRecordForSearchRatePlanExcel(dtFrom, dtTo, PropId.Value); } DownloadExcel(dt); int iUserID = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId; etblChangeHistory obj = new etblChangeHistory { PropertyList = new List <SelectListItem> { new SelectListItem { Text = "All Hotels", Value = "0" } } }; obj.PropertyList.AddRange(BL_tblPropertyM.GetUserPropertyList(iUserID)); return(View("Index", obj)); }
public ActionResult GetPageName(int PropId) { var data = BL_tblChangeHistory.GetPageNameForDD(PropId); return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult FillRatePlan(int RoomType, int PropId) { var rateplan = BL_tblChangeHistory.GetRatePlanByRoomID(RoomType, PropId); return(Json(rateplan, JsonRequestBehavior.AllowGet)); }