// POST: api/ChuDe
public ChuDe Post([FromBody] ChuDe chude)
{
ChuDe cd = new ChuDe();
SqlConnection conn = DataProvider.Connect();
conn.Open();
if (cd.kiemtra(chude.maChuDe))
{
String sQuery = "INSERT INTO [dbo].[ChuDe]([MaCD],[TenCD],[MaMonHoc],[TrangThai],[MaGV])VALUES(@macd,@tencd,@mamonhoc,@trangthai,@magv)";
SqlCommand insertcommand = new SqlCommand(sQuery, conn);
insertcommand.Parameters.AddWithValue("@macd", chude.maChuDe);
insertcommand.Parameters.AddWithValue("@tencd", chude.tenChuDe);
insertcommand.Parameters.AddWithValue("@mamonhoc", chude.maMonHoc);
insertcommand.Parameters.AddWithValue("@trangthai", chude.trangThai);
insertcommand.Parameters.AddWithValue("@magv", chude.maGiaoVien);
int result = insertcommand.ExecuteNonQuery();
conn.Close();
cd = cd.cd(chude.maChuDe);
if (result > 0)
{
return(cd);
}
}
else
{
return(cd);
}
return(cd);
}
// GET: api/ChuDe/5
public IEnumerable <ChuDe> Get(string machude)
{
ChuDe cd = new ChuDe();
cd = cd.cd(machude);
yield return(cd);
}
