public JsonResult GetDataRows(int year, int month, int file) { //string firstname = Request.QueryString["month"]; //string lastname = Request.QueryString["year"]; //string lastname1 = Request.QueryString["file"]; //var products = Product.GetSampleProducts(); //int pageIndex = Convert.ToInt32(page) - 1; //int pageSize = rows; //int totalRecords = products.Count(); //int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize); //int uploadYear = year; //int uploadMonth = month; //int uploadFile = file; //var data = products.OrderBy(x => x.Id) // .Skip(pageSize * (page - 1)) // .Take(pageSize).ToList(); this.SetConnectionDB(); EVNImporterServices services = new EVNImporterServices(oracleConnection, DBConnection); DVKH dataTable = new DVKH(); var obj = (dynamic)null; switch (file) { case 1: dataTable.DNT_QMKLTN_HA1820 = services.GetList_DNT_QMKLTN_HA1820(month, year); obj = dataTable.DNT_QMKLTN_HA1820.Count > 0 ? dataTable.DNT_QMKLTN_HA1820 : null; break; case 2: dataTable.DNT_QMKLTN_NVK = services.GetList_DNT_QMKLTN_NVK(month, year); obj = dataTable.DNT_QMKLTN_NVK.Count > 0 ? dataTable.DNT_QMKLTN_NVK : null; break; case 3: dataTable.DNT_QMKL_QD41 = services.GetList_DNT_QMKL_QD41(month, year); obj = dataTable.DNT_QMKL_QD41.Count > 0 ? dataTable.DNT_QMKL_QD41 : null; break; case 4: dataTable.DNT_QMKLTN_QD2081 = services.GetList_DNT_QMKLTN_QD2081(month, year); obj = dataTable.DNT_QMKLTN_QD2081.Count > 0 ? dataTable.DNT_QMKLTN_QD2081 : null; break; case 5: dataTable.DNT_THCDIEN_PL71 = services.GetList_DNT_THCDIEN_PL71(month, year); obj = dataTable.DNT_THCDIEN_PL71.Count > 0 ? dataTable.DNT_THCDIEN_PL71 : null; break; case 6: dataTable.DNT_THCDIEN_PL72 = services.GetList_DNT_THCDIEN_PL72(month, year); obj = dataTable.DNT_THCDIEN_PL72.Count > 0 ? dataTable.DNT_THCDIEN_PL72 : null; break; default: break; } // var data2 = services.GetList_DNT_QMKLTN_HA1820(); //var json = new JavaScriptSerializer().Serialize(obj); var jsonData = new { total = 20, page = 1, records = 12, rows = obj }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public ActionResult Booking(string dtp_from, string dtp_to, string people, string quantity, string pool, string bar, string gym, string rooms, string fullname, string phonenum) { var db = new QuanLyKhachSanEntities(); var PhongThue = new PHONGTHUE(); string idPhongThue = new GenerateIDPhongThue().generateID(); // check phòng var phongTrong = db.PHONGs.Where(x => x.LOAIPHONG == rooms && x.TRANGTHAI == "false").FirstOrDefault(); if (phongTrong == null) { return(Content("nullRooms")); } // tạo thông tin khách hàng var khachHang = new KHACHHANG(); khachHang.MAKH = new GenerateIDPhongThue().generateIDKH(); khachHang.TENKH = fullname; khachHang.SDT = Convert.ToInt32(phonenum); db.KHACHHANGs.Add(khachHang); // lưu database db.SaveChanges(); // tạo thống tin cho phòng thuê phongTrong.TRANGTHAI = "true"; PhongThue.MADK = idPhongThue; PhongThue.NGAYDI = Convert.ToDateTime(dtp_to); PhongThue.NGAYDEN = Convert.ToDateTime(dtp_from); PhongThue.SOPHONG = phongTrong.SOPHONG; PhongThue.MAKH = khachHang.MAKH; db.PHONGTHUEs.Add(PhongThue); db.SaveChanges(); // tạo thông tin lưu dịch vụ if (pool == "true") { string idBooking = new GenerateIDPhongThue().generateIDServiceBooking(); var DVKH = new DVKH(); DVKH.ID = idBooking; DVKH.MADV = "1"; DVKH.MADK = idPhongThue; db.DVKHs.Add(DVKH); db.SaveChanges(); } if (bar == "true") { string idBooking = new GenerateIDPhongThue().generateIDServiceBooking(); var DVKH = new DVKH(); DVKH.ID = idBooking; DVKH.MADV = "2"; DVKH.MADK = idPhongThue; db.DVKHs.Add(DVKH); db.SaveChanges(); } if (gym == "true") { string idBooking = new GenerateIDPhongThue().generateIDServiceBooking(); var DVKH = new DVKH(); DVKH.ID = idBooking; DVKH.MADV = "3"; DVKH.MADK = idPhongThue; db.DVKHs.Add(DVKH); db.SaveChanges(); } return(Content("true")); }