// GET: ChangeHistory public ActionResult Index() { 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(obj)); }
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 Index() { etblChangeHistory obj = new etblChangeHistory(); return(View(obj)); }