public int Update(CHITETTHIETBI ct)
{
int count = 0;
using (SqlConnection connection = con())
{
count = connection.Execute("UPDATE CHITETTHIETBI SET MaThietBi=@MaThietBi,maphong=@maphong,soLuong=@soLuong where MaCTTB= @MaCTTB", ct);
}
return(count);
}
public CHITETTHIETBI GetId(int maCT)
{
CHITETTHIETBI ct = new CHITETTHIETBI();
using (SqlConnection connection = con())
{
ct = (CHITETTHIETBI)connection.Query <CHITETTHIETBI>("select MaCTTB,THIETBI.TenThietBi,THIETBI.MaThietBi,soLuong,maphong,TenPhongTro from THIETBI,CHITETTHIETBI,PHONGTRO where THIETBI.MaThietBi=CHITETTHIETBI.MaThietBi and PHONGTRO.MaPhongTro=CHITETTHIETBI.maphong and MaCTTB =" + maCT).FirstOrDefault();
return(ct);
}
}
public int Add(CHITETTHIETBI ct)
{
int count = 0;
using (SqlConnection connection = con())
{
count = connection.Execute("insert CHITETTHIETBI values(@MaThietBi,@soLuong,@maphong)", ct);
}
return(count);
}
public IActionResult Put(CHITETTHIETBI CT)
{
unitOfWork.ChiTiet.Update(CT);
return(Ok());
}
public IActionResult Post(CHITETTHIETBI CT)
{
unitOfWork.ChiTiet.Add(CT);
return(Ok());
}
