//Add CTPDX
public bool addCTPDX(string masp, string soluong, PHIEUDEXUAT pdx)
{
db = new CMART8Entities();
try
{
try
{
CTPHIEUDEXUAT ctdx = db.CTPHIEUDEXUATs.Single(st => st.SOPHIEU.Equals(pdx.SOPHIEUDX) && st.MASP.Equals(masp));
int dem = int.Parse(ctdx.SOLUONG.ToString()) + int.Parse(soluong);
ctdx.SOLUONG = dem;
db.SaveChanges();
return(true);
}
catch
{
CTPHIEUDEXUAT ctdx = new CTPHIEUDEXUAT();
ctdx.SOPHIEU = pdx.SOPHIEUDX;
ctdx.MASP = masp;
ctdx.SOLUONG = int.Parse(soluong);
db.CTPHIEUDEXUATs.Add(ctdx);
db.SaveChanges();
return(true);
}
}
catch {
return(false);
}
}
public bool addTTKM(string masp, float giakm, DateTime tgbd, DateTime tgkt, string noidung, string hinhanh)
{
db = new CMART8Entities();
KHUYENMAI TTKM = new KHUYENMAI();
try
{
TTKM.MAKM = DateTime.Now.ToString();
TTKM.MASP = masp;
TTKM.GIAKM = giakm;
TTKM.HINHANH = hinhanh;
//TTKM.THOIGIANBD = DateTime.Parse(tgbd);
//TTKM.THOIGIANKT = DateTime.Parse(tgkt);
TTKM.THOIGIANBD = tgbd;
TTKM.THOIGIANKT = tgkt;
TTKM.NOIDUNG = noidung;
db.KHUYENMAIs.AddObject(TTKM);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool deleteSP(String id)
{
db = new CMART8Entities();
SANPHAM SP = db.SANPHAMs.Single(st => st.MASP.Contains(id));
db.SANPHAMs.DeleteObject(SP);
db.SaveChanges();
return(true);
}
public bool deleteNCC(String id)
{
db = new CMART8Entities();
NHACUNGCAP ncc = db.NHACUNGCAPs.Single(st => st.MANCC.Contains(id));
db.NHACUNGCAPs.DeleteObject(ncc);
db.SaveChanges();
return(true);
}
public bool deleteLSP(String id)
{
db = new CMART8Entities();
LOAISANPHAM LSP = db.LOAISANPHAMs.Single(st => st.MALOAI.Contains(id));
db.LOAISANPHAMs.DeleteObject(LSP);
db.SaveChanges();
return(true);
}
public bool deleteTTKM(String id)
{
db = new CMART8Entities();
KHUYENMAI TTKM = db.KHUYENMAIs.Single(st => st.MAKM.Contains(id));
db.KHUYENMAIs.DeleteObject(TTKM);
db.SaveChanges();
return(true);
}
//tao mới phiếu đề xuất
public PHIEUDEXUAT createPDX(string maTK)
{
db = new CMART8Entities();
PHIEUDEXUAT pdx = new PHIEUDEXUAT();
pdx.SOPHIEUDX = autoID();
pdx.NGAYDEXUAT = DateTime.Now;
pdx.MATK = maTK;
db.PHIEUDEXUATs.Add(pdx);
db.SaveChanges();
return(pdx);
}
//Delete CTPDX
public bool deleteCTPDX(string masp, PHIEUDEXUAT pdx)
{
db = new CMART8Entities();
try
{
CTPHIEUDEXUAT ctdx = db.CTPHIEUDEXUATs.Single(st => st.SOPHIEU.Equals(pdx.SOPHIEUDX) && st.MASP.Equals(masp));
db.CTPHIEUDEXUATs.Remove(ctdx);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (lblMKM.Visible == false && lblXNMK.Visible == false && lbTDN.Visible == false && lbMKHT.Visible == false && flag == true)
{
TAIKHOAN tk = db.TAIKHOANs.Single(st => st.MATK == TK.MATK);
tk.MATKHAU = txtPass.Text;
TK = tk;
db.SaveChanges();
MessageBox.Show("Cập nhật mật khẩu mới thành công!");
btnCancel_Click(null, null);
}
else
{
MessageBox.Show("Cập nhật mật khẩu mới không thành công!");
}
}
//Update PDX
public bool updatePDX(PHIEUDEXUAT pdx, string mancc)
{
try
{
db = new CMART8Entities();
PHIEUDEXUAT dx = db.PHIEUDEXUATs.Find(pdx.SOPHIEUDX);
dx.MANCC = mancc;
db.Entry(dx).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool editLSP(string id, string ten)
{
db = new CMART8Entities();
LOAISANPHAM LSP = db.LOAISANPHAMs.Single(st => st.MALOAI.Equals(id));
try
{
LSP.TENLOAI = ten;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool updatePNHCN(PHIEUNHAPHANGCHINHANH PN, string sophieuTS, string chinhanh, DateTime ngay)
{
try
{
db = new CMART8Entities();
PHIEUNHAPHANGCHINHANH pn = db.PHIEUNHAPHANGCHINHANHs.Find(PN.SOPHIEU);
pn.SOPHIEUNHTS = sophieuTS;
pn.CHINHANH = chinhanh;
pn.NGAYNHAP = ngay;
db.Entry(pn).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool addLSP(string ten)
{
db = new CMART8Entities();
LOAISANPHAM LSP = new LOAISANPHAM();
try
{
LSP.MALOAI = DateTime.Now.ToString();
LSP.TENLOAI = ten;
LSP.SOLUONGSP = 0;
db.LOAISANPHAMs.AddObject(LSP);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool editNCC(string id, string ten, string diachi, string sdt)
{
db = new CMART8Entities();
NHACUNGCAP ncc = db.NHACUNGCAPs.Single(st => st.MANCC.Equals(id));
try
{
ncc.TENNCC = ten;
ncc.DIACHI = diachi;
ncc.SDT = sdt;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool addNCC(string ten, string diachi, string sdt)
{
db = new CMART8Entities();
NHACUNGCAP ncc = new NHACUNGCAP();
try {
ncc.MANCC = DateTime.Now.ToString();
ncc.TENNCC = ten;
ncc.DIACHI = diachi;
ncc.SDT = sdt;
db.NHACUNGCAPs.AddObject(ncc);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool updatePNHTS(PHIEUNHAPHANGTRUSO PN, string sophieudx, string tongtien, string maTK, DateTime ngay)
{
try
{
db = new CMART8Entities();
PHIEUNHAPHANGTRUSO pn = db.PHIEUNHAPHANGTRUSOes.Find(PN.SOPHIEU);
pn.SOPHIEUDX = sophieudx;
pn.TONGTIEN = ulong.Parse(tongtien);
pn.MATK = maTK;
pn.NGAYNHAP = ngay;
db.Entry(pn).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool addSP(string ten, string hinhanh, string maloai, string mancc)
{
db = new CMART8Entities();
SANPHAM SP = new SANPHAM();
try {
SP.MASP = DateTime.Now.ToString();
SP.TENSP = ten;
SP.HINHANH = hinhanh;
SP.MALOAI = maloai;
SP.MANCC = mancc;
db.SANPHAMs.AddObject(SP);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool editSP(string id, string ten, string hinhanh, string maloai, string mancc)
{
db = new CMART8Entities();
SANPHAM SP = db.SANPHAMs.Single(st => st.MASP.Equals(id));
try
{
SP.TENSP = ten;
SP.HINHANH = hinhanh;
SP.MALOAI = maloai;
SP.MANCC = mancc;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
//Hủy phiếu đề xuất
public bool deletePDX(PHIEUDEXUAT pdx)
{
try
{
db = new CMART8Entities();
List <CTPHIEUDEXUAT> lst = db.CTPHIEUDEXUATs.Where(x => x.SOPHIEU.Equals(pdx.SOPHIEUDX)).ToList();
foreach (CTPHIEUDEXUAT item in lst)
{
db.CTPHIEUDEXUATs.Remove(item);
}
db.SaveChanges();
db = new CMART8Entities();
PHIEUDEXUAT PDX = db.PHIEUDEXUATs.Find(pdx.SOPHIEUDX);
db.PHIEUDEXUATs.Remove(PDX);
db.SaveChanges();
return(true);
}
catch {
return(false);
}
}
//Cập nhật chi tiết nhập hàng trụ sở
public bool updateListCTTS(List <CTPHIEUNHAPHANGTRUSO> list, PHIEUNHAPHANGTRUSO PN)
{
db = new CMART8Entities();
try
{
List <CTPHIEUNHAPHANGTRUSO> tmp = db.CTPHIEUNHAPHANGTRUSOes.Where(st => st.SOPHIEUNHTS.Equals(PN.SOPHIEU)).ToList();
foreach (CTPHIEUNHAPHANGTRUSO it in tmp)
{
db.CTPHIEUNHAPHANGTRUSOes.Remove(it);
db.SaveChanges();
}
db = new CMART8Entities();
foreach (CTPHIEUNHAPHANGTRUSO item in list)
{
db.CTPHIEUNHAPHANGTRUSOes.Add(item);
}
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool editTTKM(string makm, string masp, float giakm, DateTime tgbd, DateTime tgkt, string noidung, string hinhanh)
{
db = new CMART8Entities();
KHUYENMAI TTKM = db.KHUYENMAIs.Single(st => st.MAKM.Equals(makm));
try
{
TTKM.MASP = masp;
TTKM.GIAKM = giakm;
TTKM.HINHANH = hinhanh;
//TTKM.THOIGIANBD = DateTime.Parse(tgbd);
//TTKM.THOIGIANKT = DateTime.Parse(tgkt);
TTKM.THOIGIANBD = tgbd;
TTKM.THOIGIANKT = tgkt;
TTKM.NOIDUNG = noidung;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}