public void GiamSoLuongDat(string makh, string matua) { HangDoi hangdoi = db.HangDois.Where(x => x.MaKhacHangs == makh && x.MaTuaDe == matua).FirstOrDefault(); hangdoi.SoLuongDat -= 1; db.SubmitChanges(); }
public void GoHangDoi(string makh, string matua) { HangDoi hangdoi = db.HangDois.Where(x => x.MaKhacHangs == makh && x.MaTuaDe == matua).FirstOrDefault(); db.HangDois.DeleteOnSubmit(hangdoi); db.SubmitChanges(); }
public int LaySoLuongDat(string makh, string matua) { HangDoi hangdoi = db.HangDois.Where(x => x.MaKhacHangs == makh && x.MaTuaDe == matua).FirstOrDefault(); if (hangdoi != null) { return((int)hangdoi.SoLuongDat); } return(1); }
public bool KhachHangDaDatCho(string makhachhang, string matuade) { HangDoi hangdoi = db.HangDois.Where(x => x.MaKhacHangs == makhachhang && x.MaTuaDe == matuade).FirstOrDefault(); if (hangdoi != null) { return(true); } return(false); }
public bool TangSoLuongDiaDat(string makhachhang, string matuade, int soluong) { HangDoi hangdoi = db.HangDois.Where(x => x.MaKhacHangs == makhachhang && x.MaTuaDe == matuade).FirstOrDefault(); try { hangdoi.SoLuongDat += soluong; db.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
public bool ThemHangDoi(eHangDoi newhangDoi) { try { HangDoi hangdoi = new HangDoi(); hangdoi.MaKhacHangs = newhangDoi.MaKhachHang; hangdoi.MaTuaDe = newhangDoi.MaTuaDe; hangdoi.ThuTu = newhangDoi.ThuTu; hangdoi.SoLuongDat = newhangDoi.SoLuongDat; db.HangDois.InsertOnSubmit(hangdoi); db.SubmitChanges(); return(true); } catch (Exception) { return(false); } }