public List<HOATDONG> SelectHOATDONGsAll()
{
List<HOATDONG> list = new List<HOATDONG>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<HOATDONG_getallResult> lp = db.HOATDONG_getall();
foreach (HOATDONG_getallResult HOATDONG in lp)
{
HOATDONG var1 = new HOATDONG();
var1.MaHoatDong = HOATDONG.MaHoatDong ;
var1.TenHoatDong = HOATDONG.TenHoatDong ;
var1.NgayDienRa = HOATDONG.NgayDienRa ;
var1.MaLoaiHoatDong = HOATDONG.MaLoaiHoatDong ;
var1.ThoiGianBatDauDangKy = HOATDONG.ThoiGianBatDauDangKy ;
var1.ThoiGianKetThucDangKy = HOATDONG.ThoiGianKetThucDangKy ;
var1.HinhAnh = HOATDONG.HinhAnh;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public JsonResult InHoaDon(int ban)
{
int SoHD = TableStatus.Get_HoaDonID_by_TableNumber(ban);
if (SoHD == -1)
{
return(Json(-1, JsonRequestBehavior.AllowGet));//không tìm được hóa đơn
}
else
{
var hd = db.HOADONs.Single(n => n.HoaDonID == SoHD);
hd.TrangThaiHoaDon = 2;
db.HOADONs.Attach(hd);
db.Entry(hd).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
NGUOIDUNG thungan = Session[Common.CommonConstants.CASHIER_SESSION_NAME] as NGUOIDUNG;
var hoatdong2 = new HOATDONG();
hoatdong2.NoiDung = "In hóa đơn bàn " + hd.SoBan + "";
hoatdong2.ThoiGian = DateTime.Now;
hoatdong2.LoaiHoatDong = 1;//nhóm hoạt động của thu ngân
hoatdong2.NguoiThucHien = thungan.NguoiDungID;
db.HOATDONGs.Add(hoatdong2);
db.SaveChanges();
return(Json(1, JsonRequestBehavior.AllowGet));
}
}
public JsonResult XoaCong(int id)
{
NGUOIDUNG thungan = Session[Common.CommonConstants.CASHIER_SESSION_NAME] as NGUOIDUNG;
Result res = new Result();
var cong = db.CHAMCONGs.FirstOrDefault(n => n.ChamCongID == id);
if (cong != null)
{
///Lưu vào nhật ký
var hoatdong = new HOATDONG();
hoatdong.NoiDung = thungan.HoTenNV + " đã xóa công " + cong.NGUOIDUNG.HoTenNV;
hoatdong.ThoiGian = DateTime.Now;
hoatdong.LoaiHoatDong = 1;//nhóm hoạt động của thu ngân
hoatdong.NguoiThucHien = thungan.NguoiDungID;
db.HOATDONGs.Add(hoatdong);
db.SaveChanges();
db.CHAMCONGs.Remove(cong);
db.SaveChanges();
res.res = 1;
return(Json(res, JsonRequestBehavior.AllowGet));
}
res.res = -1;//không tồn tại công
return(Json(res, JsonRequestBehavior.AllowGet));
}
public List<HOATDONG> SelectHOATDONGByLoai(int iMaLoaiHoatDong)
{
List<HOATDONG> KetQua = new List<HOATDONG>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<HOATDONG_GetByLoaiResult> dsHoatDong = db.HOATDONG_GetByLoai(iMaLoaiHoatDong);
foreach (HOATDONG_GetByLoaiResult HOATDONG in dsHoatDong)
{
HOATDONG aHoatDong = new HOATDONG();
aHoatDong.MaHoatDong = HOATDONG.MaHoatDong;
aHoatDong.TenHoatDong = HOATDONG.TenHoatDong;
aHoatDong.NgayDienRa = HOATDONG.NgayDienRa;
aHoatDong.MaLoaiHoatDong = HOATDONG.MaLoaiHoatDong;
aHoatDong.ThoiGianBatDauDangKy = HOATDONG.ThoiGianBatDauDangKy;
aHoatDong.ThoiGianKetThucDangKy = HOATDONG.ThoiGianKetThucDangKy;
aHoatDong.HinhAnh = HOATDONG.HinhAnh;
KetQua.Add(aHoatDong);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return KetQua;
}
public ActionResult ThemNhanVien(HttpPostedFileBase file, NGUOIDUNG nv)
{
if (ModelState.IsValid)
{
if (file != null)
{
if (file.ContentLength > 0)
{
string filename = Path.GetFileName(file.FileName);
/*Saving the file in server folder*/
//Xử lý upload trùng tên
var FullPath = Request.MapPath("~/Images/User/" + filename);
if (System.IO.File.Exists(FullPath))
{
filename = "1_" + filename;
}
//upload
file.SaveAs(Server.MapPath("~/Images/User/" + filename));
nv.AnhDaiDien = filename;
}
else
{
nv.AnhDaiDien = "default.jpg";
}
}
else
{
nv.AnhDaiDien = "default.jpg";
}
nv.LanCuoiDangNhap = DateTime.Now;
nv.SoLanDangNhap = 0;
nv.NgayVaoLam = DateTime.Now;
nv.MatKhau = Common.Encryptor.MD5Hash(nv.MatKhau);
nv.TenDangNhap = nv.TenDangNhap.Trim().ToLower();
nv.NgayTao = DateTime.Now;
db.NGUOIDUNGs.Add(nv);
db.SaveChanges();
var hd = new HOATDONG();
hd.NoiDung = "Thêm nhân viên " + nv.HoTenNV;
hd.ThoiGian = DateTime.Now;
hd.LoaiHoatDong = 2;//Nhóm hoạt động của quản trị viên
db.HOATDONGs.Add(hd);
db.SaveChanges();
return(RedirectToAction("DanhSachPhucVu"));
}
return(View());
}
public int CapNhat(HOATDONG lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
return db.HOATDONG_update(
lpDTO.MaHoatDong,
lpDTO.TenHoatDong,
lpDTO.NgayDienRa,
lpDTO.MaLoaiHoatDong ,
lpDTO.ThoiGianBatDauDangKy ,
lpDTO.ThoiGianKetThucDangKy ,
lpDTO.HinhAnh
);
}
catch (Exception ex)
{
throw (ex);
}
}
protected void btCapNhat_Click(object sender, EventArgs e)
{
if (KiemTra() == false)
{
txtThongTin.Text = "Thời gian không hợp lệ";
return;
}
HOATDONG hoatdong = new HOATDONG();
hoatdong.MaHoatDong = int.Parse(ddlMaHoatDong.SelectedValue);
hoatdong.TenHoatDong = txtTenHoatDong.Text;
hoatdong.MaLoaiHoatDong = int.Parse(ddlMaHoatDong.SelectedValue);
hoatdong.NgayDienRa = new DateTime(int.Parse(txtNgayDienRa.Text.Substring(6, 4)), int.Parse(txtNgayDienRa.Text.Substring(3, 2)), int.Parse(txtNgayDienRa.Text.Substring(0, 2)));
hoatdong.ThoiGianBatDauDangKy = new DateTime(int.Parse(txtThoiGianBatDauDK.Text.Substring(6, 4)), int.Parse(txtThoiGianBatDauDK.Text.Substring(3, 2)), int.Parse(txtThoiGianBatDauDK.Text.Substring(0, 2)));
hoatdong.ThoiGianKetThucDangKy = new DateTime(int.Parse(txtThoiGianKetThucDK.Text.Substring(6, 4)), int.Parse(txtThoiGianKetThucDK.Text.Substring(3, 2)), int.Parse(txtThoiGianKetThucDK.Text.Substring(0, 2)));
BUSHoatDong bushoatdong = new BUSHoatDong();
bushoatdong.CapNhat(hoatdong);
}
public ActionResult Order(FormCollection form)
{
NGUOIDUNG thungan = Session[Common.CommonConstants.CASHIER_SESSION_NAME] as NGUOIDUNG;
int soBan;
int.TryParse(form["ip_SoBan"].ToString(), out soBan);
string MH = form["ip_mon"].ToString();
int SoLuong;
int.TryParse(form["ip_sl"].ToString(), out SoLuong);
string NhanVien = form["ip_manv"].ToString();
string GhiChu = form["ip_ghi_chu"].ToString();
////Validate data input
int flag = 0;//Không lỗi
if (SoLuong <= 0)
{
flag = -1; //Lỗi số lượng
}
MATHANG mon = db.MATHANGs.FirstOrDefault(n => n.TenMatHang.Equals(MH));
if (mon == null)
{
flag = -2;//Tên món lỗi
}
NGUOIDUNG nhanvien = db.NGUOIDUNGs.FirstOrDefault(n => n.HoTenNV.Equals(NhanVien));
if (nhanvien == null)
{
flag = -3;//Lỗi tên nhân viên
}
if (flag == 0)
{
int SoHD = TableStatus.Get_HoaDonID_by_TableNumber(soBan);
if (SoHD != -1)//Đã có hóa đơn
{
CTHD order = new CTHD();
MATHANG mh = db.MATHANGs.SingleOrDefault(n => n.TenMatHang == MH);
NGUOIDUNG nv = db.NGUOIDUNGs.SingleOrDefault(n => n.HoTenNV == NhanVien);
//Order món
//Lưu vào CSDL
order.SoHD = SoHD;
order.MatHang = mh.MatHangID;
order.NhanVienPhucVu = nv.NguoiDungID;
order.GhiChu = GhiChu;
order.SoLuong = SoLuong;
order.TrangThai = true;
db.CTHDs.Add(order);
db.SaveChanges();
///Cập nhật tổng tiền
decimal tongtienHD = 0;
var hd = db.HOADONs.SingleOrDefault(n => n.HoaDonID == SoHD);
var lsCT = db.CTHDs.Where(n => n.SoHD == hd.HoaDonID).ToList();
foreach (var i in lsCT)
{
tongtienHD += (decimal)(i.MATHANG1.DonGia * i.SoLuong);
}
hd.TongTien = tongtienHD;
db.HOADONs.Attach(hd);
var entry = db.Entry(hd);
entry.State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else//Chưa có hóa đơn: Bàn đang trống
{
HOADON hd_new = new HOADON();
hd_new.SoBan = soBan;
hd_new.KhachHang = Common.CommonConstants.anonymousUserID;
hd_new.ThoiGianVao = DateTime.Now;
hd_new.ThoiGianRa = Common.CommonConstants.minDateTime;
hd_new.TongTien = 0;
hd_new.TrangThai = true;
hd_new.TrangThaiHoaDon = 1;
hd_new.GiamGia = 0;
hd_new.GhiChu = "";
db.HOADONs.Add(hd_new);
db.SaveChanges();
//var hoatdong = new HOATDONG();
//hoatdong.NoiDung = "Khách vào bàn " + hd_new.SoBan;
//hoatdong.ThoiGian = DateTime.Now;
//hoatdong.LoaiHoatDong = 1;//nhóm hoạt động của thu ngân
//hoatdong.NguoiThucHien = thungan.NguoiDungID;
//db.HOATDONGs.Add(hoatdong);
CTHD order = new CTHD();
MATHANG mh = db.MATHANGs.SingleOrDefault(n => n.TenMatHang == MH);
NGUOIDUNG nv = db.NGUOIDUNGs.SingleOrDefault(n => n.HoTenNV == NhanVien);
order.SoHD = hd_new.HoaDonID;
order.MatHang = mh.MatHangID;
order.NhanVienPhucVu = nv.NguoiDungID;
order.GhiChu = GhiChu;
order.SoLuong = SoLuong;
order.TrangThai = true;
db.CTHDs.Add(order);
db.SaveChanges();
var hoatdong2 = new HOATDONG();
hoatdong2.NoiDung = "Thêm khách vào bàn " + hd_new.SoBan;
hoatdong2.ThoiGian = DateTime.Now;
hoatdong2.LoaiHoatDong = 1;//nhóm hoạt động của thu ngân
hoatdong2.NguoiThucHien = thungan.NguoiDungID;
db.HOATDONGs.Add(hoatdong2);
///Cập nhật tổng tiền
decimal tongtienHD = 0;
var lsCT = db.CTHDs.Where(n => n.SoHD == hd_new.HoaDonID).ToList();
foreach (var i in lsCT)
{
tongtienHD += (decimal)(i.MATHANG1.DonGia * i.SoLuong);
}
hd_new.TongTien = tongtienHD;
db.HOADONs.Attach(hd_new);
var entry = db.Entry(hd_new);
entry.State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
ViewBag.Ban = soBan;
return(Redirect("/Cashier/TongQuan/?ban=" + soBan.ToString()));
}
public JsonResult ThemCongMoi(string tenNhanVien, string TenCaLam, string DiMuon = "", string GhiChu = "")
{
NGUOIDUNG thungan = Session[Common.CommonConstants.CASHIER_SESSION_NAME] as NGUOIDUNG;
Result res = new Result();
var nhanvien = db.NGUOIDUNGs.FirstOrDefault(n => n.HoTenNV.Equals(tenNhanVien) && n.TrangThai == true);
if (nhanvien == null)
{
res.res = -1;
return(Json(res, JsonRequestBehavior.AllowGet));
}
var calam = db.CALAMVIECs.FirstOrDefault(c => (c.TenCa.Equals(TenCaLam)));
if (calam == null)
{
res.res = -2;
return(Json(res, JsonRequestBehavior.AllowGet));
}
var cong = new CHAMCONG();
cong.NhanVienID = nhanvien.NguoiDungID;
cong.CaLam = calam.CaLamID;
cong.TrangThai = true;
cong.Ngay = DateTime.Now;
cong.GhiChu = GhiChu;
cong.NgayCham = DateTime.Now;
QUYDINHDIMUON dimuon;
if (DiMuon != null && !DiMuon.Equals(""))
{
dimuon = db.QUYDINHDIMUONs.FirstOrDefault(c => c.GhiChu.Equals(DiMuon));
if (dimuon != null)
{
cong.DiMuon = dimuon.QuyDinhDiMuonID;
}
else
{
res.res = -3;//Đi muộn lỗi
return(Json(res, JsonRequestBehavior.AllowGet));
}
}
db.CHAMCONGs.Add(cong);
db.SaveChanges();
///Lưu vào nhật ký
var hoatdong = new HOATDONG();
hoatdong.NoiDung = "Chấm công " + nhanvien.HoTenNV;
hoatdong.ThoiGian = DateTime.Now;
hoatdong.LoaiHoatDong = 1;//nhóm hoạt động của thu ngân
hoatdong.NguoiThucHien = thungan.NguoiDungID;
db.HOATDONGs.Add(hoatdong);
db.SaveChanges();
res.res = cong.ChamCongID;
return(Json(res, JsonRequestBehavior.AllowGet));
}
public int Them(HOATDONG lpDTO)
{
DAOHoatDong HOATDONG = new DAOHoatDong();
return HOATDONG.Them(lpDTO);
}
public int CapNhat(HOATDONG lpDTO)
{
DAOHoatDong HOATDONG = new DAOHoatDong();
return HOATDONG.CapNhat(lpDTO);
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
if (KiemTra() == false)
{
return;
}
try
{
//lay thong tin tu textbox
HOATDONG lpDTO = new HOATDONG();
lpDTO.MaHoatDong = int.Parse(Request.QueryString["id"]);
lpDTO.TenHoatDong = txttenhoatdong.Text;
lpDTO.MaLoaiHoatDong = int.Parse(ddlLoaiHoatDong.SelectedValue);
//
IFormatProvider culture = new CultureInfo("vi-VN", true);
lpDTO.NgayDienRa = DateTime.Parse(txtngaydienra.Text, culture);
lpDTO.ThoiGianBatDauDangKy = DateTime.Parse(txtthoigianbatdaudangky.Text, culture);
lpDTO.ThoiGianKetThucDangKy = DateTime.Parse(txtthoigianketthucdangky.Text, culture);
if (image.ImageUrl == link)
{
lpDTO.HinhAnh = link.Substring(defaultLink.Length);
}
else
{
if (image.ImageUrl != "")
{
lpDTO.HinhAnh = RenameHinhAnh(image.ImageUrl, lpDTO.TenHoatDong).Substring(defaultLink.Length);
}
}
//Goi ham cap nhat
BUSHoatDong BUSHoatDong = new BUSHoatDong();
if (BUSHoatDong.CapNhat(lpDTO) == 0)
{
//Thong bao
lbThongBao.Text = "Cập Nhật Thành Công";
lbThongBao.Visible = true;
link = "";
linkTemp = "";
Response.Redirect("~/administration/HoatDong.aspx?id=" + Request.QueryString["id"]);
}
else
{
lbThongBao.Text = "Cập Nhật Không Thành Công";
lbThongBao.Visible = true;
}
}
catch
{
lbThongBao.Text = "Cập nhật Không Thành Công";
lbThongBao.Visible = true;
}
DeleteHinhAnh(linkTemp);
link = "";
linkTemp = "";
}
