public List <BuildQuery.IQueryFilter> GetFilters()
{
var result = new List <IQueryFilter>();
var refObj = new LOAIPHONG();
if (!string.IsNullOrEmpty(this.MALOAIPHONG))
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refObj.MALOAIPHONG),
Value = this.MALOAIPHONG,
Method = FilterMethod.Like
});
}
if (!string.IsNullOrEmpty(this.TENLOAIPHONG))
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refObj.TENLOAIPHONG),
Value = this.TENLOAIPHONG,
Method = FilterMethod.Like
});
}
return(result);
}
public ActionResult LoaiPhongEdit([Bind(Include = "MA_LOAIPHONG,TEN_LOAIPHONG,KICHTHUOC,MAMAU,ANH")] LOAIPHONG lOAIPHONG)
{
if (ModelState.IsValid)
{
var img = Request.Files["ANH"];
if (img.ContentLength > 0)
{
string postedFileName = System.IO.Path.GetFileName(img.FileName);
var path = Server.MapPath("/Images/" + postedFileName);
img.SaveAs(path);
lOAIPHONG.ANH = postedFileName;
}
else
{
lOAIPHONG.ANH = Request["anhcu"];
}
db.Entry(lOAIPHONG).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("LoaiPhongIndex"));
}
ViewBag.tag = "loaiphong";
ViewBag.username = ((LoginSessionModel)Session["session"]).name;
return(View(lOAIPHONG));
}
public static Boolean SoSanh(LOAIPHONG A, LOAIPHONG B)
{
Boolean flag = A.Ten.CompareTo(B.Ten) == 0;
flag = flag && A.DonGia == B.DonGia;
return(flag);
}
public static String XuatChuoi(LOAIPHONG P)
{
String Chuoi = P.Ten + " : ";
Chuoi = Chuoi + P.DonGia + " dong/ngay";
return(Chuoi);
}
public async Task <IHttpActionResult> Delete(string id)
{
var result = new TransferObj <bool>();
LOAIPHONG instance = await _service.Repository.FindAsync(id);
if (instance == null)
{
return(NotFound());
}
try
{
_service.Delete(instance.ID);
int del = await _service.UnitOfWork.SaveAsync();
if (del > 0)
{
result.Data = true;
result.Status = true;
result.Message = "Xóa thành công bản ghi";
}
else
{
result.Data = false;
result.Status = false;
result.Message = "Thao tác không thành công";
}
}
catch (Exception e)
{
result.Data = false;
result.Status = false;
result.Message = e.Message;
}
return(Ok(result));
}
public ActionResult Create(LOAIPHONG loaiphong)
{
if (ModelState.IsValid)
{
if (loaiphong.ANH == null)
{
loaiphong.ANH = "";
}
if (loaiphong.MOTA == null)
{
loaiphong.MOTA = "";
}
if (loaiphong.SOGIUONG == null)
{
loaiphong.SOGIUONG = 1;
}
if (cc.Create(loaiphong))
{
return(RedirectToAction("Index", "LoaiPhong"));
}
else
{
ModelState.AddModelError("", "Lỗi do trường dữ liệu nhập không hợp lệ");
}
}
return(View());
}
public ActionResult Edit(LOAIPHONG LoaiPhong)
{
if (ModelState.IsValid)
{
if (LoaiPhong.ANH == null)
{
LoaiPhong.ANH = "";
}
if (LoaiPhong.MOTA == null)
{
LoaiPhong.MOTA = "";
}
if (LoaiPhong.SOGIUONG == null)
{
LoaiPhong.SOGIUONG = 1;
}
if (cc.SuaLOAIPHONG(LoaiPhong))
{
return(RedirectToAction("Index"));
}
else
{
ViewBag.ThongBao = "Đã có tên dịch vụ " + LoaiPhong.TEN;
}
}
return(View(LoaiPhong));
}
public ActionResult LoaiPhongCreate([Bind(Include = "MA_LOAIPHONG,TEN_LOAIPHONG,KICHTHUOC,MAMAU,ANH")] LOAIPHONG lOAIPHONG)
{
var img = Request.Files["ANH"];
string postedFileName = System.IO.Path.GetFileName(img.FileName);
var path = Server.MapPath("/Images/" + postedFileName);
img.SaveAs(path);
if (ModelState.IsValid)
{
int count = db.LOAIPHONGs.Where(phong => phong.MA_LOAIPHONG == lOAIPHONG.MA_LOAIPHONG).Count();
if (count == 0)
{
lOAIPHONG.ANH = postedFileName;
db.LOAIPHONGs.Add(lOAIPHONG);
db.SaveChanges();
return(RedirectToAction("LoaiPhongIndex"));
}
else
{
ModelState.AddModelError("", "Loại phòng đã tồn tại");
}
}
ViewBag.username = ((LoginSessionModel)Session["session"]).name;
ViewBag.tag = "loaiphong";
return(View(lOAIPHONG));
}
public ActionResult DeleteConfirmed(string id)
{
LOAIPHONG lOAIPHONG = db.LOAIPHONGs.Find(id);
db.LOAIPHONGs.Remove(lOAIPHONG);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static Double TinhTien(LOAIPHONG P, PHIEUTHUE Phieu)
{
Double kq = 0;
if (SoSanh(P, Phieu.LoaiPhong))
{
kq = (Double)(P.DonGia * Phieu.SoNgay);
}
return(kq);
}
public ActionResult Edit([Bind(Include = "MaLoai,TenLoai,ChiTiet")] LOAIPHONG lOAIPHONG)
{
if (ModelState.IsValid)
{
db.Entry(lOAIPHONG).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(lOAIPHONG));
}
private void btn_luu_Click(object sender, EventArgs e)
{
LOAIPHONG lp = new LOAIPHONG();
if (btn_them.Enabled == true)
{
lp.MALOAI = txt_maloai.Text;
lp.TENLOAI = txt_tenloai.Text;
lp.GIA = decimal.Parse(txt_gia.Text);
if (txt_maloai.Text == string.Empty && txt_tenloai.Text == string.Empty && txt_gia.Text == string.Empty)
{
MessageBox.Show("không được để trống");
return;
}
//kiểm tra khóa chính
if (blp.ktkc_LoaiPhong(lp.MALOAI) == true)
{
MessageBox.Show("Trùng khóa chính");
return;
}
if (blp.ThemLoaiPhong(lp) == true)
{
grv_loaiPhong.DataSource = blp.loadBangLoaiPhong();
MessageBox.Show("Thành công");
}
else
{
MessageBox.Show("Thất bại");
}
frm_loaiphong_Load(sender, e);
}
if (btn_sua.Enabled == true && btn_them.Enabled == false)
{
try
{
if (txt_tenloai.Text == string.Empty || txt_gia.Text == string.Empty)
{
MessageBox.Show(" không được để trống");
return;
}
lp.MALOAI = txt_maloai.Text;
lp.TENLOAI = txt_tenloai.Text;
lp.GIA = decimal.Parse(txt_gia.Text);
if (blp.sua_LoaiPhong(lp) == true)
{
MessageBox.Show("Thành công");
}
}
catch
{
MessageBox.Show("thất bại");
}
}
frm_loaiphong_Load(sender, e);
}
public bool themLoaiPhong(string maloai, string tenloai)
{
LOAIPHONG loaiph = new LOAIPHONG();
loaiph.MALOAIPH = maloai;
loaiph.TENLOAI = tenloai;
db.LOAIPHONGs.InsertOnSubmit(loaiph);
db.SubmitChanges();
return(true);
}
public ActionResult Slider(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//tblPhong p = db.tblPhongs.Include(a => a.tblLoaiPhong).Where(a=>a.ma_phong==id).First();
LOAIPHONG lp = db.LOAIPHONGs.Find(id);
return(View(lp));
}
public bool XoaLoaiPhong(string maloai)
{
LOAIPHONG loaiph = (from lp in db.LOAIPHONGs
where (lp.MALOAIPH == maloai)
select lp).First();
db.LOAIPHONGs.DeleteOnSubmit(loaiph);
db.SubmitChanges();
return(true);
}
public ActionResult Create([Bind(Include = "MaLoai,TenLoai,ChiTiet")] LOAIPHONG lOAIPHONG)
{
if (ModelState.IsValid)
{
db.LOAIPHONGs.Add(lOAIPHONG);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(lOAIPHONG));
}
public int ThemLoaiPhong(LOAIPHONG lp)
{
try
{
db.LOAIPHONGs.Add(lp);
return(db.SaveChanges());
}
catch (Exception ex)
{
return(0);
}
}
public ActionResult Edit([Bind(Include = "MALOAI,MOTA,GIA,TILEPHUTHU,ANH")] LOAIPHONG tblLoaiPhong)
{
if (ModelState.IsValid)
{
if (tblLoaiPhong.ANH == null)
tblLoaiPhong.ANH = "[\"/Content/Images/Phong/default.png\"]";
db.Entry(tblLoaiPhong).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(tblLoaiPhong);
}
public bool Inseart()
{
var loaiphong = new LOAIPHONG()
{
ID = 0,
Ten = view.Ten,
GiaNgay = view.GiaNgay,
GiaDem = view.GiaDem
};
return(model.Insert(loaiphong));
}
public bool SuaLoaiPhong(string maloai, string tenloai)
{
LOAIPHONG loaiph = (from lp in db.LOAIPHONGs
where (lp.MALOAIPH == maloai)
select lp).First();
loaiph.MALOAIPH = maloai;
loaiph.TENLOAI = tenloai;
db.SubmitChanges();
return(true);
}
public bool Update()
{
var ct = new LOAIPHONG()
{
ID = view.ID,
Ten = view.Ten,
GiaNgay = view.GiaNgay,
GiaDem = view.GiaDem
};
return(model.Update(ct));
}
public List <LOAIPHONG> LoadLoaiPhong()
{
DataTable data = DataProvider.Instance.ExcuteQuery("pLoadLOAIPHONG");
List <LOAIPHONG> res = new List <LOAIPHONG>();
foreach (DataRow item in data.Rows)
{
LOAIPHONG temp = new LOAIPHONG(item);
res.Add(temp);
}
return(res);
}
public bool Delete(int maPhong)
{
LOAIPHONG loaiPhongExist = context.LOAIPHONGs.Find(maPhong);
if (loaiPhongExist == null)
{
return(false);
}
loaiPhongExist.TrangThai = false;
context.SaveChanges();
return(true);
}
//Thêm
public bool them_LoaiPhong(LOAIPHONG lp)
{
try
{
data.LOAIPHONGs.InsertOnSubmit(lp);
data.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool Update(LOAIPHONG loaiPhong)
{
LOAIPHONG loaiPhongExist = context.LOAIPHONGs.Find(loaiPhong.Id_LoaiPhong);
if (loaiPhongExist == null)
{
return(false);
}
loaiPhongExist.HinhAnh = loaiPhong.HinhAnh;
loaiPhongExist.TenLoaiPhong = loaiPhong.TenLoaiPhong;
context.SaveChanges();
return(true);
}
public ActionResult Index(LOAIPHONG loaiphong, TestDK test)
{
if (ModelState.IsValid)
{
ViewBag.var1 = new SelectList(cc.LoadLoaiPhong(), "ID", "TEN");// load loai phong len
ViewBag.var2 = new SelectList(cc.LoadPhong(), "ID", "TENPHONG");
ViewBag.id = new SelectList(loaiPhong, "id", "tenPhong", loaiphong.ID);
idMaPhieu = cc.DangKi(test.CMND, test.TenDK, test.DiaChi, test.SDT, test.TenCongTy);
return(Redirect("Step2"));
}
return(View());
}
public ActionResult DeleteConfirmed(int id)
{
try
{
LOAIPHONG tblLoaiPhong = db.LOAIPHONGs.Find(id);
db.LOAIPHONGs.Remove(tblLoaiPhong);
db.SaveChanges();
}
catch
{
}
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "MOTA,GIA,TILEPHUTHU,ANH")] LOAIPHONG tblLoaiPhong)
{
if (ModelState.IsValid)
{
if (tblLoaiPhong.ANH == null)
tblLoaiPhong.ANH = "[\"/Content/Images/Phong/default.png\"]";
db.LOAIPHONGs.Add(tblLoaiPhong);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(tblLoaiPhong);
}
// GET: LoaiPhong/Edit/5
public ActionResult Edit(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
LOAIPHONG tblLoaiPhong = db.LOAIPHONGs.Find(id);
if (tblLoaiPhong == null)
{
return HttpNotFound();
}
return View(tblLoaiPhong);
}
//Xóa
public bool xoa_LoaiPhong(string pMaLoai)
{
try
{
LOAIPHONG lp = data.LOAIPHONGs.Where(t => t.MALOAI == pMaLoai).FirstOrDefault();
data.LOAIPHONGs.DeleteOnSubmit(lp);
data.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
