public static void themthietbi(THIETBI tb)
{
using (TSCDEntities ts = new TSCDEntities())
{
ts.THIETBIs.Add(tb);
ts.SaveChanges();
}
}
public static void xoathietbi(THIETBI tb)
{
using (TSCDEntities ts = new TSCDEntities())
{
THIETBI tbb = ts.THIETBIs.Find(tb.mathietbi);
ts.THIETBIs.Remove(tbb);
ts.SaveChanges();
}
}
public bool Xoa(string MATB)
{
try
{
THIETBI tb = db.THIETBIs.SingleOrDefault(t => t.MATHIETBI == MATB);
db.THIETBIs.DeleteOnSubmit(tb);
db.SubmitChanges();
return(true);
}
catch { return(false); };
}
public bool updateTBtrove(string ma, int slt)
{
THIETBI ct = (from cttb in db.THIETBIs
where (cttb.MATHIETBI == ma)
select cttb).First();
ct.MATHIETBI = ma;
ct.SOLUONGTON += slt;
db.SubmitChanges();
return(true);
}
//Thêm
public bool them_ThietBi(THIETBI tb)
{
try
{
data.THIETBIs.InsertOnSubmit(tb);
data.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
//Xóa
public bool xoa_ThietBi(string pMaTB)
{
try
{
THIETBI tb = data.THIETBIs.Where(t => t.MATHIETBI == pMaTB).FirstOrDefault();
data.THIETBIs.DeleteOnSubmit(tb);
data.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool xoaTB(string ma)
{
try
{
THIETBI tb = (db.THIETBIs.Where(t => t.MATHIETBI == ma).FirstOrDefault());
db.THIETBIs.DeleteOnSubmit(tb);
db.SubmitChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool suaTB(string ma, string ten, string dvt, float gt)
{
try
{
THIETBI tb = (db.THIETBIs.Where(t => t.MATHIETBI == ma).FirstOrDefault());
tb.TENTHIETBI = ten;
tb.DVT = dvt;
tb.GIATRI = gt;
db.SubmitChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool Sua(string matb, string tentb, string dvt, float giatri)
{
try
{
THIETBI tb = db.THIETBIs.SingleOrDefault(t => t.MATHIETBI == matb);
tb.MATHIETBI = matb;
tb.TENTHIETBI = tentb;
tb.DVT = dvt;
tb.GIATRI = giatri;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool themTB(string ma, string ten, int slt, string dvt, float gt)
{
try
{
THIETBI tb = new THIETBI();
tb.MATHIETBI = ma;
tb.TENTHIETBI = ten;
tb.SOLUONGTON = slt;
tb.DVT = dvt;
tb.GIATRI = gt;
db.THIETBIs.InsertOnSubmit(tb);
db.SubmitChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool Them(string matb, string tentb, int slton, string dvt, float giatri)
{
try
{
THIETBI tb = new THIETBI();
tb.MATHIETBI = matb;
tb.TENTHIETBI = tentb;
tb.SOLUONGTON = slton;
tb.DVT = dvt;
tb.GIATRI = giatri;
db.THIETBIs.InsertOnSubmit(tb);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public static void suathietbi(THIETBI tb)
{
using (TSCDEntities ts = new TSCDEntities())
{
THIETBI tbb = ts.THIETBIs.Find(tb.mathietbi);
tbb.tenthietbi = tb.tenthietbi;
tbb.dongia = tb.dongia;
tbb.thongsokythuat = tb.thongsokythuat;
tbb.ngaysanxuat = tb.ngaysanxuat;
tbb.ngayduavaosudung = tb.ngayduavaosudung;
tbb.ngaycapnhat = tb.ngaycapnhat;
tbb.soluong = tb.soluong;
tbb.madonvitinh = tb.madonvitinh;
tbb.maloai = tb.maloai;
tbb.maphongquantri = tb.maphongquantri;
tbb.matinhtrang = tb.matinhtrang;
ts.SaveChanges();
}
}
//Sửa
public bool sua_ThietBi(THIETBI pThietBi)
{
try
{
THIETBI nv = data.THIETBIs.Where(t => t.MATHIETBI == pThietBi.MATHIETBI).FirstOrDefault();
if (nv != null)
{
nv.TENTB = pThietBi.TENTB;
//nv.GIATB = pThietBi.GIATB;
//nv.SOLUONG_PHANBO = pThietBi.SOLUONG_PHANBO;
//nv.SOLUONG_HUHONG = pThietBi.SOLUONG_HUHONG;
//nv.SOLUONG_TONKHO = pThietBi.SOLUONG_TONKHO;
data.SubmitChanges();
}
return(true);
}
catch
{
return(false);
}
}
