public string UpdateTrangThaiPhong(QLPHONGKHAMEntities db, TrangThaiPhongDTO TrangThaiPhong) { TRANGTHAIPHONG trangthaiphongDAO = new TRANGTHAIPHONG(); BUS.Com.Utils.CopyPropertiesFrom(TrangThaiPhong, trangthaiphongDAO); return(trangThaiPhongServices.Save(db, trangthaiphongDAO)); }
public void Insert_TestCase2() { TRANGTHAIPHONG trangThaiPhong = new TRANGTHAIPHONG { SttCaoNhat = 1, }; TrangThaiPhongDAO dao = new TrangThaiPhongDAO(); string actual = dao.Save(db, trangThaiPhong); string expected = "1111"; Assert.Equals(expected, actual); }
public void Delete_TestCase9() { TRANGTHAIPHONG trangThaiPhong = new TRANGTHAIPHONG { MaPhong = TestCommon.LEN_10, NgayKham = TestCommon.LEN_8, SttCaoNhat = 1, }; TrangThaiPhongDAO dao = new TrangThaiPhongDAO(); string actual = dao.Save(db, trangThaiPhong); Assert.Equals(null, actual); }
public void Insert_TestCase4() { TRANGTHAIPHONG trangThaiPhong = new TRANGTHAIPHONG { MaPhong = "123", NgayKham = TestCommon.LEN_8, SttCaoNhat = 1, }; TrangThaiPhongDAO dao = new TrangThaiPhongDAO(); string actual = dao.Save(db, trangThaiPhong); string expected = "1111"; Assert.Equals(expected, actual); }
public void Update_TestCase6() { TrangThaiPhongDAO dao = new TrangThaiPhongDAO(); TRANGTHAIPHONG trangThaiPhong = new TRANGTHAIPHONG { MaPhong = TestCommon.LEN_10, NgayKham = TestCommon.LEN_8, SttCaoNhat = 1, }; dao.Save(db, trangThaiPhong); TRANGTHAIPHONG trangThaiPhongUpdate = new TRANGTHAIPHONG { SttCaoNhat = 2, }; string actual = dao.Save(db, trangThaiPhongUpdate); // Biến kết quả string expected = "1111"; // Test Assert.Equals(expected, actual); }
public string GetTrangThaiPhong(QLPHONGKHAMEntities db, string MaPhongKham, string NgayThang, out TrangThaiPhongDTO TrangThaiPhong) { TrangThaiPhong = new TrangThaiPhongDTO(); TRANGTHAIPHONG entity = null; object[] id = { MaPhongKham, NgayThang }; if (trangThaiPhongServices.FindById(db, id, out entity) == Constant.RES_FAI) { return(Constant.RES_FAI); } if (entity == null) { entity = new TRANGTHAIPHONG(); entity.MaPhong = MaPhongKham; entity.NgayKham = NgayThang; entity.SttCaoNhat = 0; trangThaiPhongServices.Save(db, entity); } BUS.Com.Utils.CopyPropertiesFrom(entity, TrangThaiPhong); return(Constant.RES_SUC); }
public ActionResult DetailRoom(int?maKS, int?maLoaiPhong, DatPhong dp, string ngayBatDau, string ngayKetThuc) { //Check Login var user = Session["loginSuccess"] as UserName; ViewBag.User = null; if (user != null) { ViewBag.User = user.maKH; } //Tìm Hotel var dbhotel = db.KHACHSANs.SingleOrDefault(m => m.MaKS == maKS); //List rooms of this Hotel var dblistloaiPhong = db.LOAIPHONGs.Where(m => m.MaKS == maKS).ToList(); Hotel hotel = new Hotel(dbhotel.MaKS, dbhotel.TenKS, dbhotel.SoSao, dbhotel.SoNha, dbhotel.Quan, dbhotel.ThanhPho, dbhotel.GiaTB, dbhotel.MoTa); ViewBag.Hotel = hotel; ViewBag.maLoaiPhong = maLoaiPhong.ToString(); List <LoaiPhong> listLoaiPhong = new List <LoaiPhong>(); foreach (var item in dblistloaiPhong) { listLoaiPhong.Add(new LoaiPhong(item.MaLoaiPhong, item.TenLoaiPhong, item.MaKS)); } ViewBag.listLoaiPhong = listLoaiPhong; //Get this day DateTime thisDay = DateTime.Today; DateTime ngayDat = DateTime.Today; if (ngayBatDau != null && ngayBatDau != "") { String[] sub = ngayBatDau.Split('-'); ngayDat = new DateTime(int.Parse(sub[0]), int.Parse(sub[1]), int.Parse(sub[2])); } string this_day = thisDay.ToString("yyyy-MM-dd"); ViewBag.thisday = this_day; ViewBag.ngayDatPhong = ngayBatDau; ViewBag.ngayDatPhong = ngayKetThuc; if (maLoaiPhong != null) { //GEt listPhong var dblstPhong = db.DanhSachPhong(maLoaiPhong).ToList().OrderBy(m => m.SoPhong); var dbStage = db.TrangThaiPhongDaDatTheoNgay(maLoaiPhong, ngayDat).OrderBy(m => m).ToList(); var phongtrongs = dblstPhong.Select(x => new Phong { maPhong = x.MaPhong, soPhong = x.SoPhong, stage = dbStage.Any(p => p == x.MaPhong) ? "hết phòng" : "còn phòng" }).ToList(); List <Phong> listPhong = new List <Phong>(); //Lay tình trạng phòng ViewBag.listPhong = phongtrongs; //Book Room ViewBag.ThongBao = ""; int i = 0; if (dp.maPhong != null) { //dp.ngayBatDau = DateTime.ParseExact(ngayBatDau,"MM/dd/yyyy", CultureInfo.InvariantCulture); //dp.ngayTraPhong = DateTime.ParseExact(ngayKetThuc, "MM/dd/yyyy", CultureInfo.InvariantCulture); dp.ngayBatDau = DateTime.Parse(ngayBatDau); dp.ngayTraPhong = DateTime.Parse(ngayKetThuc); if (DateTime.Compare(dp.ngayBatDau, dp.ngayTraPhong) <= 0) { dp.maKH = user.maKH; dp.ngayDat = thisDay; int numDaysDiff = Math.Abs(dp.ngayBatDau.Subtract(dp.ngayTraPhong).Days) + 1; dp.donGia = numDaysDiff * dp.donGia; dp.tinhTrang = "chưa xác nhận"; var test = false; DateTime start = dp.ngayBatDau; for (i = 0; i < numDaysDiff; i++) { test = TrangThaiPhongTheoNgay(dp.maPhong, start.AddDays(i)); if (test) { ViewBag.ThongBao = "Dat Phong That Bai"; break; } } if (!test) { ViewBag.ThongBao = "Dat Phong Thanh Cong"; DATPHONG datphong = new DATPHONG(); datphong.MaPhong = dp.maPhong; datphong.MaKH = dp.maKH; datphong.NgayBatDau = dp.ngayBatDau; datphong.NgayTraPhong = dp.ngayTraPhong; datphong.NgayDat = thisDay; datphong.DonGia = dp.donGia; datphong.MoTa = "ABC"; datphong.TinhTrang = "chưa xác nhận"; //Cap nhat bang dat Phong db.DATPHONGs.Add(datphong); //Cap nhat bang Trang Thai Phong TRANGTHAIPHONG ttp1 = null; for (i = 0; i < numDaysDiff; i++) { //TrangThaiPhongTheoNgay(dp.maPhong, dp.ngayBatDau.AddDays(i)); ttp1 = new TRANGTHAIPHONG(); ttp1.MaPhong = (int)dp.maPhong; ttp1.Ngay = dp.ngayBatDau.AddDays(i); ttp1.TinhTrang = "đang sử dụng"; db.TRANGTHAIPHONGs.Add(ttp1); } db.SaveChanges(); var dathuephong = phongtrongs.FirstOrDefault(x => x.maPhong == datphong.MaPhong); var dathuephongThuTu = Array.IndexOf(phongtrongs.ToArray(), dathuephong); phongtrongs.ElementAt(dathuephongThuTu).stage = "hết phòng"; ViewBag.listPhong = phongtrongs; } } } } return(View()); }