private AjaxReponseModel <dynamic> GetProductByID()
{
var response = new AjaxReponseModel <dynamic>(AjaxReponseStatusEnum.Success);
try
{
var data = new StreamReader(Request.InputStream).ReadToEnd();
var dym = JsonConvert.DeserializeObject <Product>(data);
int maSP = dym.MaSP;
using (var ctx = new qlksEntities())
{
var emp = ctx.tblSanPhams.AsEnumerable().Select(st => new
{
st.MaSP,
st.TenSP,
st.DonGia
}).Where(st => st.MaSP == maSP).ToList();
response.Data = emp;
}
return(response);
}
catch (Exception e)
{
return(response);
}
finally
{
}
}
private AjaxReponseModel <dynamic> Login()
{
var response = new AjaxReponseModel <dynamic>(AjaxReponseStatusEnum.Success);
var data = new StreamReader(Request.InputStream).ReadToEnd();
var dym = JsonConvert.DeserializeObject <dynamic>(data);
string userName = dym.userName;
string passWord = dym.passWord;
using (var db = new qlksEntities())
{
var user = db.tblNhanViens.SingleOrDefault(w => w.MatKhau == passWord && w.TenDangNhap == userName);
if (user != null)
{
response.Message = "Đăng nhập thành công.";
Session["UserLogin"] = user;
}
else
{
response.Status = AjaxReponseStatusEnum.Fail;
response.Message = "Đăng nhập thất bại. Vui lòng kiểm tra lại tên đăng nhập hoặc mật khẩu.";
}
};
return(response);
}
private AjaxReponseModel <dynamic> UpdateProduct()
{
var response = new AjaxReponseModel <dynamic>(AjaxReponseStatusEnum.Success);
try
{
var data = new StreamReader(Request.InputStream).ReadToEnd();
var dym = JsonConvert.DeserializeObject <Product>(data);
int maSP = dym.MaSP;
using (var db = new qlksEntities())
{
tblSanPham sp = db.tblSanPhams.SingleOrDefault(w => w.MaSP == maSP);
sp.TenSP = String.IsNullOrEmpty(dym.TenSP.ToString()) ? String.Empty : dym.TenSP.ToString().Trim();
sp.DonGia = dym.DonGia;
db.SaveChanges();
response.Message = "SUCCESS";
};
return(response);
}
catch (Exception e)
{
response.Message = "ERROR";
return(response);
}
finally
{
}
}
private AjaxReponseModel <dynamic> GetRoomByID()
{
var response = new AjaxReponseModel <dynamic>(AjaxReponseStatusEnum.Success);
try
{
var data = new StreamReader(Request.InputStream).ReadToEnd();
var dym = JsonConvert.DeserializeObject <Room>(data);
int maPhong = dym.MaPhong;
using (var ctx = new qlksEntities())
{
var emp = ctx.tblPhongs.AsEnumerable().Where(st => st.MaPhong == maPhong).Select(st => new
{
st.MaPhong,
st.TenPhong,
st.DonGia,
StrTrangThai = st.TrangThai == true ? "Đã đặt" : "Trống",
TrangThai = Convert.ToInt32(st.TrangThai)
}).ToList();
response.Data = emp;
}
return(response);
}
catch (Exception e)
{
return(response);
}
finally
{
}
}
private AjaxReponseModel <dynamic> UpdateCustomer()
{
var response = new AjaxReponseModel <dynamic>(AjaxReponseStatusEnum.Success);
try
{
var data = new StreamReader(Request.InputStream).ReadToEnd();
var dym = JsonConvert.DeserializeObject <Customer>(data);
int maKH = dym.MaKH;
using (var db = new qlksEntities())
{
tblKhachHang kh = db.tblKhachHangs.SingleOrDefault(w => w.MaKH == maKH);
kh.TenKH = String.IsNullOrEmpty(dym.TenKH.ToString()) ? String.Empty : dym.TenKH.ToString().Trim();
kh.SDT = String.IsNullOrEmpty(dym.SDT.ToString()) ? String.Empty : dym.SDT.ToString().Trim();
kh.Email = String.IsNullOrEmpty(dym.Email.ToString()) ? String.Empty : dym.Email.ToString().Trim();
kh.DiaChi = String.IsNullOrEmpty(dym.DiaChi.ToString()) ? String.Empty : dym.DiaChi.ToString().Trim();
kh.NgaySinh = dym.NgaySinh;
kh.GioiTinh = dym.GioiTinh;
kh.CMND = dym.CMND;
db.SaveChanges();
response.Message = "SUCCESS";
};
return(response);
}
catch (Exception e)
{
response.Message = "ERROR";
return(response);
}
finally
{
}
}
private AjaxReponseModel <dynamic> GetCustomerByID()
{
var response = new AjaxReponseModel <dynamic>(AjaxReponseStatusEnum.Success);
try
{
var data = new StreamReader(Request.InputStream).ReadToEnd();
var dym = JsonConvert.DeserializeObject <Customer>(data);
int maKH = dym.MaKH;
using (var ctx = new qlksEntities())
{
//var emp1 = ctx.tblNhanViens.ToList();
var emp = ctx.tblKhachHangs.AsEnumerable().Select(st => new
{
st.MaKH,
st.TenKH,
st.SDT,
NgaySinh = st.NgaySinh.GetValueOrDefault().ToString("dd-MM-yyyy"),
st.Email,
st.DiaChi,
st.CMND,
st.GioiTinh
}).Where(st => st.MaKH == maKH).ToList();
response.Data = emp;
}
return(response);
}
catch (Exception e)
{
return(response);
}
finally
{
}
}
private AjaxReponseModel <dynamic> UpdateBookingRoom()
{
var response = new AjaxReponseModel <dynamic>(AjaxReponseStatusEnum.Success);
var data = new StreamReader(Request.InputStream).ReadToEnd();
var dym = JsonConvert.DeserializeObject <BookingRoomModel>(data);
try
{
using (var db = new qlksEntities())
{
var room = db.tblPhongs.FirstOrDefault(f => f.MaPhong == dym.MaPhong);
if (room != null)
{
room.TrangThai = true;
}
if (dym.SanPhamPhong != null && dym.SanPhamPhong.Length != 0)
{
foreach (var item in dym.SanPhamPhong)
{
if (item.MaSPP != null && item.MaSPP != 0)
{
var dvp = db.tblSanPhamPhongs.FirstOrDefault(f => f.MaPhieuDP == dym.MaPhieuDP && f.MaSPP == item.MaSPP);
dvp.SoLuong = item.SoLuong;
dvp.ThanhTien = item.ThanhTien;
}
else
{
tblSanPhamPhong dichVuPhong = new tblSanPhamPhong()
{
MaPhieuDP = dym.MaPhieuDP,
MaSP = item.MaSP,
SoLuong = item.SoLuong,
DonGia = item.DonGia,
ThanhTien = item.ThanhTien
};
db.tblSanPhamPhongs.Add(dichVuPhong);
}
}
}
db.SaveChanges();
response.Message = "Cập nhật thành công.";
};
}
catch (Exception e)
{
response.Status = AjaxReponseStatusEnum.Fail;
response.Message = "Cập nhật thất bại (Exception).";
}
return(response);
}
private AjaxReponseModel <dynamic> GetBookingRoom()
{
var response = new AjaxReponseModel <dynamic>(AjaxReponseStatusEnum.Success);
var roomId = int.Parse(Request.Params["RoomId"]);
var customerId = int.Parse(Request.Params["CustomerId"]);
var phone = Request.Params["Phone"];
var maPhieuDP = int.Parse(Request.Params["MaPhieuDP"]);
using (var db = new qlksEntities())
{
var list = db.tblPhieuDatPhongs.Where(w => (maPhieuDP == 0 || w.MaPhieuDP == maPhieuDP) && (roomId == 0 || w.MaPhong == roomId) && (customerId == 0 || w.MaKH == customerId) && (phone == "" || w.tblKhachHang.SDT == phone)).Select(s => new
{
s.MaPhieuDP,
s.MaPhong,
s.MaKH,
s.MaNV,
s.NgayBD,
s.NgayKT,
s.DonGia,
s.TongTien,
TrangThai = s.TrangThai == null ? false : true,
s.tblKhachHang.TenKH,
s.tblKhachHang.SDT,
s.tblPhong.TenPhong,
DichVuPhong = s.tblDichVuPhongs.Select(s1 => new
{
s1.MaDVP,
s1.MaPhieuDP,
s1.MaDV,
s1.tblDichVu.TenDV,
s1.DonGia,
s1.ThanhTien,
s1.SoLuong
}).ToList(),
SanPhamPhong = s.tblSanPhamPhongs.Select(s2 => new
{
s2.MaSPP,
s2.MaPhieuDP,
s2.MaSP,
s2.tblSanPham.TenSP,
s2.SoLuong,
s2.DonGia,
s2.ThanhTien
}).ToList()
}).ToList();
response.Data = list;
};
return(response);
}
private AjaxReponseModel <dynamic> GetRoomList()
{
var response = new AjaxReponseModel <dynamic>(AjaxReponseStatusEnum.Success);
try
{
var data = new StreamReader(Request.InputStream).ReadToEnd();
var dym = JsonConvert.DeserializeObject <dynamic>(data);
string maPhong = dym.MaPhong;
string tenPhong = dym.TenPhong;
string trangThai = dym.TrangThai;
int lau = !string.IsNullOrEmpty(dym.Lau.ToString()) ? int.Parse(dym.Lau.ToString()) : 0;
string loaiPhong = !string.IsNullOrEmpty(dym.LoaiPhong.ToString()) ? dym.LoaiPhong : "";
using (var ctx = new qlksEntities())
{
var emp = ctx.tblPhongs.AsEnumerable()
.Where(st => (maPhong == "" || st.MaPhong == Convert.ToInt32(maPhong)) &&
(tenPhong == "" || st.TenPhong == tenPhong) &&
(trangThai == "" || st.TrangThai == trangThai.Equals("1")) &&
(lau == 0 || st.Lau == lau) &&
(loaiPhong == "" || st.LoaiPhong == loaiPhong))
.Select(st => new
{
st.MaPhong,
st.TenPhong,
st.DonGia,
StrTrangThai = st.TrangThai == true ? "Đã đặt" : "Trống",
TrangThai = Convert.ToInt32(st.TrangThai)
}).ToList();
response.Data = emp;
}
return(response);
}
catch (Exception e)
{
return(response);
}
finally
{
}
}
private AjaxReponseModel <dynamic> PaymentBookingRoom()
{
var response = new AjaxReponseModel <dynamic>(AjaxReponseStatusEnum.Success);
var data = new StreamReader(Request.InputStream).ReadToEnd();
var dym = JsonConvert.DeserializeObject <BookingRoomModel>(data);
try
{
using (var db = new qlksEntities())
{
var pdp = db.tblPhieuDatPhongs.FirstOrDefault(f => f.MaPhieuDP == dym.MaPhieuDP);
if (pdp != null)
{
pdp.TrangThai = true;
var p = db.tblPhongs.FirstOrDefault(f => f.MaPhong == pdp.MaPhong);
if (p != null)
{
p.TrangThai = false;
}
db.SaveChanges();
response.Message = "Trả phòng thành công.";
}
else
{
response.Status = AjaxReponseStatusEnum.Fail;
response.Message = "Trả phòng thất bại.";
}
};
}
catch (Exception e)
{
response.Status = AjaxReponseStatusEnum.Fail;
response.Message = "Trả phòng thất bại (Exception).";
}
return(response);
}
private AjaxReponseModel <dynamic> DeleteProduct()
{
var response = new AjaxReponseModel <dynamic>(AjaxReponseStatusEnum.Success);
try
{
var data = new StreamReader(Request.InputStream).ReadToEnd();
var dym = JsonConvert.DeserializeObject <Product>(data);
int maSP = dym.MaSP;
using (var db = new qlksEntities())
{
tblSanPham sp = db.tblSanPhams.SingleOrDefault(w => w.MaSP == maSP);
tblSanPhamPhong pdp = db.tblSanPhamPhongs.SingleOrDefault(w => w.MaSP == maSP);
if (pdp != null && pdp.MaPhieuDP > 0)
{
response.Message = "PDP_EXIST";
}
else
{
db.tblSanPhams.Remove(sp);
db.SaveChanges();
response.Message = "SUCCESS";
}
};
return(response);
}
catch (Exception e)
{
response.Message = "ERROR";
return(response);
}
finally
{
}
}
private AjaxReponseModel <dynamic> SaveBookingRoom()
{
var response = new AjaxReponseModel <dynamic>(AjaxReponseStatusEnum.Success);
var data = new StreamReader(Request.InputStream).ReadToEnd();
var dym = JsonConvert.DeserializeObject <BookingRoomModel>(data);
tblNhanVien userLogin = Session["UserLogin"] as tblNhanVien;
try
{
using (var db = new qlksEntities())
{
tblPhieuDatPhong datPhong = new tblPhieuDatPhong()
{
MaKH = dym.MaKH,
MaPhong = dym.MaPhong,
MaNV = userLogin.MaNV,
NgayBD = dym.NgayBD,
NgayKT = dym.NgayKT,
TongTien = dym.TongTien,
DonGia = dym.DonGia
};
db.tblPhieuDatPhongs.Add(datPhong);
var numberSave = db.SaveChanges();
if (numberSave > 0)
{
var room = db.tblPhongs.FirstOrDefault(f => f.MaPhong == dym.MaPhong);
if (room != null)
{
room.TrangThai = true;
}
if (dym.SanPhamPhong != null && dym.SanPhamPhong.Length != 0)
{
List <tblSanPhamPhong> listSPP = new List <tblSanPhamPhong>();
foreach (var item in dym.SanPhamPhong)
{
tblSanPhamPhong dichVuPhong = new tblSanPhamPhong()
{
MaPhieuDP = datPhong.MaPhieuDP,
MaSP = item.MaSP,
SoLuong = item.SoLuong,
DonGia = item.DonGia,
ThanhTien = item.ThanhTien
};
listSPP.Add(dichVuPhong);
}
db.tblSanPhamPhongs.AddRange(listSPP);
}
db.SaveChanges();
response.Message = "Đặt phòng thành công.";
}
else
{
response.Status = AjaxReponseStatusEnum.Fail;
response.Message = "Đặt phòng thất bại.";
}
};
}
catch (Exception e)
{
response.Status = AjaxReponseStatusEnum.Fail;
response.Message = "Đặt phòng thất bại (Exception).";
}
return(response);
}