public string AddDANHMUC(DANHMUC_ViewModel model)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var checkDanhMuc = db.DANHMUCs.FirstOrDefault(x => x.iddmuc == model.iddmuc);
if (checkDanhMuc == null)
{
var danhMuc = new DANHMUC
{
tendmuc = model.tendmuc,
CreateBy = model.CreateBy,
CreateDate = DateTime.Now,
};
var result = db.DANHMUCs.Add(danhMuc);
db.SaveChanges();
return("Thêm danh mục món ăn thành công!");
}
else
{
checkDanhMuc.tendmuc = model.tendmuc;
checkDanhMuc.ModifyBy = model.ModifyBy;
checkDanhMuc.ModifyDate = DateTime.Now;
db.SaveChanges();
return("Cập nhật danh mục món ăn thành công!");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public PYC AddPYC(PYC yC)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var check = db.PYCs.FirstOrDefault(x => x.idyc == yC.idyc);
if (check == null)
{
var PYC = new PYC
{
ngayyc = yC.ngayyc,
CreateDate = DateTime.Now,
CreateBy = yC.ModifyBy
};
check = db.PYCs.Add(PYC);
db.SaveChanges();
return(check);
}
else
{
check.ngayyc = yC.ngayyc;
check.ModifyDate = DateTime.Now;
check.ModifyBy = yC.ModifyBy;
db.SaveChanges();
return(check);
}
}
}
catch (Exception ex)
{
return(null);
}
}
public HOADONM AddHOADONM(HOADONM model, List <D_HOADONM> details, string loginUser)
{
using (var db = new RestaurantManagerDataEntities())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
var check = db.HOADONMs.FirstOrDefault(x => x.idhoadonm == model.idhoadonm);
if (check == null)
{
var pnhap = db.PNHAPs.AsNoTracking().FirstOrDefault(x => x.idpnhap == model.idpnhap);
var pgiao = db.GIAOHANGs.AsNoTracking().FirstOrDefault(x => x.idpgiao == pnhap.idpgiao);
model.CreateBy = loginUser;
model.CreateDate = DateTime.Now;
var result = db.HOADONMs.Add(model);
db.SaveChanges();
foreach (D_HOADONM item in details)
{
item.idhoadonm = result.idhoadonm;
item.CreateBy = loginUser;
item.CreateDate = DateTime.Now;
db.D_HOADONM.Add(item);
}
db.SaveChanges();
//cập nhật lại số lượng và giá nguyên liệu
foreach (D_HOADONM item in details)
{
var Nlieu = db.NLIEUx.FirstOrDefault(x => x.idhang == item.idhang);
if (Nlieu != null)
{
Nlieu.slton += item.slmua;
Nlieu.dongianl = item.dongiamua;
Nlieu.ModifyBy = loginUser;
Nlieu.ModifyDate = DateTime.Now;
}
}
db.SaveChanges();
trans.Commit();
return(result);
}
return(null);
}
catch (Exception ex)
{
trans.Rollback();
return(null);
}
}
}
}
public string saveDONMH(DONMH_ViewModel donmh, List <D_DONMH_ViewModel> lstDdonmh, string nameLog)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
//master
var check = db.DONMHs.FirstOrDefault(e => e.iddonmh == donmh.iddonmh);
if (check == null)
{
check = new DONMH();
check.CreateBy = nameLog;
check.CreateDate = DateTime.Now;
db.Entry(check).State = EntityState.Added;
db.DONMHs.Add(check);
}
else
{
check.ModifyBy = nameLog;
check.ModifyDate = DateTime.Now;
db.Entry(check).State = EntityState.Modified;
}
check.iddonmh = donmh.iddonmh;
check.ngaydonmh = donmh.ngaydonmh;
check.idncc = donmh.idncc;
db.SaveChanges();
//detail
var checkD = db.D_DONMH.Where(e => e.iddonmh == check.iddonmh).ToList();
if (checkD.Count() > 0)
{
db.D_DONMH.RemoveRange(checkD);
}
foreach (var item in lstDdonmh)
{
var detail = new D_DONMH
{
iddonmh = check.iddonmh,
idhang = item.idhang,
slmh = item.slmh,
dongiamh = int.Parse(item.dongiamh.ToString()), //đổi sang double
CreateBy = nameLog,
CreateDate = DateTime.Now,
};
db.D_DONMH.Add(detail);
}
db.SaveChanges();
return("success");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public HOADONTT AddHOADONTT(HOADONTT_ViewModel model)
{
using (var db = new RestaurantManagerDataEntities())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
var check = db.HOADONTTs.FirstOrDefault(x => x.idhoadontt == model.idhoadontt);
if (check == null)
{
var HOADONTT = new HOADONTT
{
iddondat = model.iddondat,
ngayhd = model.ngayhd,
thoigian = DateTime.Now,
thungan = model.CreateBy,
idkh = model.idkh,
CreateBy = model.CreateBy,
CreateDate = DateTime.Now,
};
var result = db.HOADONTTs.Add(HOADONTT);
db.SaveChanges();
foreach (D_HOADONTT_ViewModel item in model.D_HOADONTT)
{
var D_HOADONTT = new D_HOADONTT
{
idhoadontt = HOADONTT.idhoadontt,
idmon = item.idmon,
slban = item.slban,
dongiaban = item.dongiaban,
CreateBy = model.CreateBy,
CreateDate = DateTime.Now,
};
db.D_HOADONTT.Add(D_HOADONTT);
}
db.SaveChanges();
trans.Commit();
return(result);
}
}
catch
{
trans.Rollback();
return(null);
}
return(null);
}
}
}
public string AddGIAOHANG(GIAOHANG_ViewModel model, List <D_GIAOHANG_ViewModel> lstD_GIAOHANG, string userLogin)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var check = db.GIAOHANGs.FirstOrDefault(x => x.idpgiao == model.idpgiao);
if (check == null)
{
var GIAOHANG = new GIAOHANG
{
iddonmh = model.iddonmh,
idncc = model.idncc,
diachi = model.diachi,
cuahang = model.cuahang,
ngaygiao = model.ngaygiao,
nguoigiao = model.nguoigiao,
nguoilapphieu = model.nguoilapphieu,
nguoinhan = model.nguoinhan,
CreateBy = userLogin,
CreateDate = DateTime.Now,
};
var result = db.GIAOHANGs.Add(GIAOHANG);
db.SaveChanges();
foreach (D_GIAOHANG_ViewModel item in lstD_GIAOHANG)
{
var D_GIAOHANG = new D_GIAOHANG
{
idpgiao = GIAOHANG.idpgiao,
idhang = item.idhang,
slgiaohang = item.slgiaohang,
slnhanhang = item.slnhanhang,
CreateBy = userLogin,
CreateDate = DateTime.Now,
};
db.D_GIAOHANG.Add(D_GIAOHANG);
}
db.SaveChanges();
return("success");
}
return("Tạo phiếu giao hàng không thành công!");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string saveUser(USER user, ref string outmess)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var result = db.USERS.AsNoTracking().FirstOrDefault(x => x.UserName == user.UserName);
if (result == null)
{
db.USERS.Add(user);
db.SaveChanges();
outmess = "success";
return("Thêm nhân viên thành công!");
}
else
{
result.Password = user.Password;
result.SoDT = user.SoDT;
result.DiaChi = user.DiaChi;
result.ten = user.ten;
//result. = user.ChucVu;
result.ChucVu = user.ChucVu;
outmess = "success";
return("Cập nhật nhân viên thành công!");
}
}
}
catch (Exception ex)
{
outmess = "error";
return(ex.Message);
}
}
public string AddMONAN(MONAN_ViewModel model)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var check = db.MONANs.FirstOrDefault(x => x.idmon == model.idmon);
if (check == null)
{
var MONAN = new MONAN
{
temon = model.temon,
dongiamon = model.dongiamon,
dvt = model.dvt,
hinhanh = model.hinhanh,
iddmuc = model.iddmuc,
CreateBy = model.CreateBy,
CreateDate = DateTime.Now,
};
var result = db.MONANs.Add(MONAN);
db.SaveChanges();
return("Thêm món ăn thành công!");
}
else
{
check.temon = model.temon;
check.dongiamon = model.dongiamon;
check.dvt = model.dvt;
check.hinhanh = model.hinhanh;
check.iddmuc = model.iddmuc;
check.ModifyBy = model.ModifyBy;
check.ModifyDate = DateTime.Now;
db.SaveChanges();
return("Cập nhật món ăn thành công!");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string AddNCC(NCC_ViewModel model)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var check = db.NCCs.FirstOrDefault(x => x.idncc == model.idncc);
if (check == null)
{
var NCC = new NCC
{
idncc = model.idncc,
tenncc = model.tenncc,
diachi = model.diachi,
sdt = model.sdt,
stk = model.stk,
CreateBy = model.CreateBy,
CreateDate = DateTime.Now,
};
var result = db.NCCs.Add(NCC);
db.SaveChanges();
return("Thêm nhà cung cấp thành công!");
}
else
{
check.tenncc = model.tenncc;
check.diachi = model.diachi;
check.sdt = model.sdt;
check.stk = model.stk;
check.ModifyBy = model.ModifyBy;
check.ModifyDate = DateTime.Now;
db.SaveChanges();
return("Cập nhật nhà cung cấp thành công!");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string AddNLIEU(NLIEU_ViewModel model)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var checkNLieu = db.NLIEUx.FirstOrDefault(x => x.idhang == model.idhang);
if (checkNLieu == null)
{
var NLieu = new NLIEU
{
tenhang = model.tenhang,
slton = model.slton,
nguong = model.nguong,
dongianl = model.dongianl,
CreateBy = model.CreateBy,
CreateDate = DateTime.Now,
};
var result = db.NLIEUx.Add(NLieu);
db.SaveChanges();
return("Thêm nguyên liệu thành công!");
}
else
{
checkNLieu.tenhang = model.tenhang;
checkNLieu.slton = model.slton;
checkNLieu.nguong = model.nguong;
checkNLieu.dongianl = model.dongianl;
checkNLieu.ModifyBy = model.ModifyBy;
checkNLieu.ModifyDate = DateTime.Now;
db.SaveChanges();
return("Cập nhật nguyên liệu thành công!");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string AddD_PYC(D_PYC model)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var check = db.D_PYC.FirstOrDefault(x => x.idyc == model.idyc && x.idhang == model.idhang);
if (check == null)
{
var D_PYC = new D_PYC
{
idyc = model.idyc,
idhang = model.idhang,
sldukien = model.sldukien,
slton = model.slton,
nguong = model.nguong,
CreateDate = DateTime.Now,
CreateBy = model.ModifyBy
};
check = db.D_PYC.Add(D_PYC);
db.SaveChanges();
return("success");
}
else
{
check.sldukien = model.sldukien;
check.slton = model.slton;
check.nguong = model.nguong;
check.ModifyDate = DateTime.Now;
check.ModifyBy = model.ModifyBy;
db.SaveChanges();
return("success");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string AddCONGTHUC(CONGTHUC_ViewModel model)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var check = db.CONGTHUCs.FirstOrDefault(x => x.idmon == model.idmon && x.idhang == model.idhang);
if (check == null)
{
var CONGTHUC = new CONGTHUC
{
idmon = model.idmon,
idhang = model.idhang,
hamluong = model.hamluong,
CreateBy = model.CreateBy,
CreateDate = DateTime.Now,
};
var result = db.CONGTHUCs.Add(CONGTHUC);
db.SaveChanges();
return("Thêm thành công!");
}
else
{
check.hamluong = model.hamluong;
check.ModifyBy = model.ModifyBy;
check.ModifyDate = DateTime.Now;
db.SaveChanges();
return("Cập nhật thành công!");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string AddKHACHHANG(KHACHHANG_ViewModel model)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var check = db.KHACHHANGs.FirstOrDefault(x => x.idkh == model.idkh);
if (check == null)
{
var KHACHHANG = new KHACHHANG
{
tenkh = model.tenkh,
sdt = model.sdt,
CreateBy = model.CreateBy,
CreateDate = DateTime.Now,
};
var result = db.KHACHHANGs.Add(KHACHHANG);
db.SaveChanges();
return("Thêm khách hàng thành công!");
}
else
{
check.tenkh = model.tenkh;
check.sdt = model.sdt;
check.ModifyBy = model.ModifyBy;
check.ModifyDate = DateTime.Now;
db.SaveChanges();
return("Cập nhật khách hàng thành công!");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string DeleteKHACHHANG(int id)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var checkDanhMuc = db.KHACHHANGs.FirstOrDefault(x => x.idkh == id);
if (checkDanhMuc == null)
{
return("Xóa không thành công!");
}
else
{
db.KHACHHANGs.Remove(checkDanhMuc);
db.SaveChanges();
return("Xóa khách hàng thành công!");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string DeleteNCC(int id)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var check = db.NCCs.FirstOrDefault(x => x.idncc == id);
if (check == null)
{
return("Xóa không thành công!");
}
else
{
db.NCCs.Remove(check);
db.SaveChanges();
return("Xóa nhà cung cấp thành công!");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public USER ChangePassword(string username, string password, ref string outmess)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var result = db.USERS.AsNoTracking().FirstOrDefault(x => x.UserName == username);
if (result == null)
{
outmess = "Tài khoản không tồn tại!";
return(null);
}
result.Password = password;
db.SaveChanges();
outmess = "success";
return(result);
}
}
catch (Exception ex)
{
outmess = ex.Message;
return(null);
}
}
public string DeleteHOADONTT(int id)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var check = db.DONDATDAs.FirstOrDefault(x => x.iddondat == id);
if (check == null)
{
return("Xóa không thành công!");
}
else
{
db.DONDATDAs.Remove(check);
db.SaveChanges();
return("Xóa thành công!");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string DeleteCONGTHUC(int idmon, int idhang)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var check = db.CONGTHUCs.FirstOrDefault(x => x.idmon == idmon && x.idhang == idhang);
if (check == null)
{
return("Xóa không thành công!");
}
else
{
db.CONGTHUCs.Remove(check);
db.SaveChanges();
return("Xóa thành công!");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string AddDONDATDA(DONDATDA_ViewModel model, ref string mess, ref int idhoadontt)
{
using (var db = new RestaurantManagerDataEntities())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
var check = db.DONDATDAs.FirstOrDefault(x => x.iddondat == model.iddondat);
if (check == null)
{
var DONDATDA = new DONDATDA
{
ngaydat = model.ngaydat,
ban = model.ban,
idkh = model.idkh,
CreateBy = model.CreateBy,
CreateDate = DateTime.Now,
};
var result = db.DONDATDAs.Add(DONDATDA);
db.SaveChanges();
foreach (D_DONDATDA_ViewModel item in model.D_DONDATDA)
{
var D_DONDATDA = new D_DONDATDA
{
iddondat = DONDATDA.iddondat,
idmon = item.idmon,
sldat = item.sldat,
CreateBy = model.CreateBy,
CreateDate = DateTime.Now,
};
db.D_DONDATDA.Add(D_DONDATDA);
}
db.SaveChanges();
//trừ nguyên liệu món ăn đi
foreach (D_DONDATDA_ViewModel item in model.D_DONDATDA)
{
var conthuc = db.CONGTHUCs.AsNoTracking().Where(x => x.idmon == item.idmon).ToList();
foreach (var iNlieu in conthuc)
{
var nlieu = db.NLIEUx.FirstOrDefault(x => x.idhang == iNlieu.idhang);
if (nlieu != null)
{
var slton = nlieu.slton.Value;
int.TryParse(iNlieu.hamluong, out int hamluong);
if (slton < hamluong * item.sldat)
{
var monan = db.MONANs.AsNoTracking().FirstOrDefault(x => x.idmon == item.idmon);
mess = "warning";
return(String.Format("Món {0} đã hết nguyên liệu {1}!", monan.temon, nlieu.tenhang));
}
slton -= hamluong * item.sldat;
nlieu.slton = slton;
}
}
}
db.SaveChanges();
//Lưu hóa đơn thanh toán
var modelHOADONTT = new HOADONTT_ViewModel
{
iddondat = result.iddondat,
ngayhd = model.ngaydat.Value,
thoigian = DateTime.Now,
idkh = model.idkh,
thungan = model.CreateBy,
CreateBy = model.CreateBy,
ModifyBy = model.CreateBy
};
List <D_HOADONTT_ViewModel> lstD_HOADONTT = new List <D_HOADONTT_ViewModel>();
foreach (D_DONDATDA_ViewModel item in model.D_DONDATDA)
{
var D_HOADONTT = new D_HOADONTT_ViewModel
{
idmon = item.idmon,
slban = item.sldat,
tenmon = item.tenmon,
dongiaban = item.dongiamon,
CreateBy = model.CreateBy,
ModifyBy = model.CreateBy,
};
lstD_HOADONTT.Add(D_HOADONTT);
}
var hoadontt = new HOADONTTBll().AddHOADONTT(modelHOADONTT);
if (hoadontt != null)
{
trans.Commit();
mess = "success";
idhoadontt = hoadontt.idhoadontt;
return("Thanh toán thành công!");
}
mess = "error";
idhoadontt = 0;
return("Thanh toán không thành công!");
}
else
{
check.ngaydat = model.ngaydat;
check.ban = model.ban;
check.idkh = model.idkh;
check.ModifyBy = model.ModifyBy;
check.ModifyDate = DateTime.Now;
db.SaveChanges();
mess = "success";
idhoadontt = 0;
return("Cập nhật món ăn thành công!");
}
}
catch (Exception ex)
{
trans.Rollback();
mess = "error";
idhoadontt = 0;
return(ex.Message);
}
}
}
}
public string savePNHAP(PNHAP_ViewModel model, List <D_PNHAP_ViewModel> lstDetail, string nameLog)
{
using (var db = new RestaurantManagerDataEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
//master
var check = db.PNHAPs.FirstOrDefault(e => e.idpnhap == model.idpnhap);
if (check == null)
{
check = new PNHAP();
check.CreateBy = nameLog;
check.CreateDate = DateTime.Now;
db.PNHAPs.Add(check);
}
else
{
check.ModifyBy = nameLog;
check.ModifyDate = DateTime.Now;
db.Entry(check).State = EntityState.Modified;
}
check.thukho = model.thukho;
check.ngaynhap = model.ngaynhap;
check.idpgiao = model.idpgiao;
check.nguoigiao = model.nguoigiao;
check.nguoilapphieu = nameLog;
db.SaveChanges();
//detail
var details = db.D_PNHAP.Where(p => p.idpnhap == check.idpnhap).ToList();
if (details.Count() > 0)
{
db.D_PNHAP.RemoveRange(details);
}
db.SaveChanges();
foreach (var item in lstDetail)
{
var detail = new D_PNHAP
{
idpnhap = check.idpnhap,
idhang = item.idhang,
slgiao = item.slgiao,
slnhan = item.slnhan,
CreateBy = nameLog,
CreateDate = DateTime.Now,
};
db.D_PNHAP.Add(detail);
}
db.SaveChanges();
transaction.Commit();
return("success");
}
catch (Exception ex)
{
transaction.Rollback();
return(ex.Message);
}
}
}
}
public string SavePYC(PYC obj, List <D_PYC_ViewModel> details, string loginUser)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var check = db.PYCs.FirstOrDefault(x => x.idyc == obj.idyc);
if (check == null)
{
var PYC = new PYC
{
ngayyc = obj.ngayyc,
CreateDate = DateTime.Now,
CreateBy = loginUser
};
check = db.PYCs.Add(PYC);
db.SaveChanges();
foreach (D_PYC_ViewModel item in details)
{
var d_pyc = new D_PYC
{
idyc = check.idyc,
idhang = item.idhang,
sldukien = item.sldukien,
slton = item.slton,
nguong = item.nguong,
CreateBy = loginUser,
CreateDate = DateTime.Now,
};
db.D_PYC.Add(d_pyc);
}
db.SaveChanges();
return("success");
}
else
{
check.ngayyc = obj.ngayyc;
check.ModifyDate = DateTime.Now;
check.ModifyBy = loginUser;
db.SaveChanges();
db.D_PYC.RemoveRange(db.D_PYC.Where(x => x.idyc == obj.idyc));
db.SaveChanges();
foreach (D_PYC_ViewModel item in details)
{
var d_pyc = new D_PYC
{
idyc = check.idyc,
idhang = item.idhang,
sldukien = item.sldukien,
slton = item.slton,
nguong = item.nguong,
CreateBy = loginUser,
CreateDate = DateTime.Now,
};
db.D_PYC.Add(d_pyc);
}
db.SaveChanges();
return("success");
}
}
}
catch (Exception ex)
{
return(null);
}
}
