public bool SuaMonAn(MonAnObj monAn) { db = new DataClasses_QLMADataContext(); MonAn temp = db.MonAns.Where(x => x.maMonAn == monAn.MaMonAn).FirstOrDefault(); if (temp != null) { temp.maMonAn = monAn.MaMonAn; temp.tenMonAn = monAn.TenMonAn; temp.donViTinh = monAn.DonviTinh; temp.maNhom = (int)monAn.MaNhom; temp.donGia = (decimal)monAn.DonGia; temp.ghiChu = monAn.GhiChu; db.MonAns.InsertOnSubmit(temp); db.SubmitChanges(); } return(true); }
public List <MonAnObj> GetTheoNhom(int maNhom) { List <MonAnObj> lst = new List <MonAnObj>(); db = new DataClasses_QLMADataContext(); foreach (var item in db.MonAns.Where(x => x.maNhom == maNhom)) { MonAnObj monAn = new MonAnObj(); monAn.MaMonAn = item.maMonAn; monAn.TenMonAn = item.tenMonAn; monAn.DonviTinh = item.donViTinh; monAn.MaNhom = (int)item.maNhom; monAn.DonGia = (decimal)item.donGia; monAn.GhiChu = item.ghiChu; lst.Add(monAn); } return(lst); }
public List <NhomObj> GetNhomMon() { db = new DataClasses_QLMADataContext(); List <NhomObj> lst = new List <NhomObj>(); List <NhomMonAn> templst = db.NhomMonAns.ToList(); if (templst.Count > 0) { foreach (var item in templst) { NhomObj tempnhomObj = new NhomObj(); tempnhomObj.MaNhom = item.maNhom; tempnhomObj.TenNhom = item.tenNhom; lst.Add(tempnhomObj); } } return(lst); }
public bool AddNhom(NhomObj nhomObj) { db = new DataClasses_QLMADataContext(); NhomMonAn nhomMon = db.NhomMonAns.Where(x => x.maNhom == nhomObj.MaNhom).FirstOrDefault(); if (nhomMon != null) { throw new Exception("Nhom da co"); } else { NhomMonAn tempnhomMon = new NhomMonAn(); tempnhomMon.maNhom = nhomObj.MaNhom; tempnhomMon.tenNhom = nhomObj.TenNhom; db.NhomMonAns.InsertOnSubmit(tempnhomMon); db.SubmitChanges(); return(true); } }
public MonAn_Data() { db = new DataClasses_QLMADataContext(); }