public static bool SuaHocKy(HocKyDTO hkDTO)
{
string sQuery = string.Format("UPDATE HocKy SET TenHK=N'{0}', GhiChu=N'{1}' WHERE MaHK={2}", hkDTO.STenHK, hkDTO.SGhiChu, hkDTO.IMaHK);
con = DataProvider.Connect();
try
{
DataProvider.ExecuteQueriesNonQuery(sQuery, con);
DataProvider.CloseConnect(con);
return(true);
}
catch (Exception ex) { DataProvider.CloseConnect(con); return(false); }
}
public KQLHHocKyDTO(
LopDTO lop,
NamHocDTO namHoc,
HocKyDTO hocKy,
int soLuongDat,
float tiLe)
{
this.lop = lop;
this.namHoc = namHoc;
this.hocKy = hocKy;
this.soLuongDat = soLuongDat;
this.tiLe = tiLe;
}
public async Task <IActionResult> Post([FromBody] HocKyDTO model)
{
using (var context = new UserProfileDbContext())
{
context.HocKies.Add(new HocKy
{
Id = model.Id,
TenHocKy = model.TenHocKy
});
//context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[UserProfiles] ON");
return(Ok(await context.SaveChangesAsync()));
}
}
public static bool XoaHocKy(HocKyDTO hkDTO)
{
string sQuery = string.Format("DELETE HocKy WHERE MaHK={0}", hkDTO.IMaHK);
con = DataProvider.Connect();
try
{
DataProvider.ExecuteQueriesNonQuery(sQuery, con);
DataProvider.CloseConnect(con);
return(true);
}
catch (Exception ex) { DataProvider.CloseConnect(con); return(false); }
}
public static bool ThemHocKy(HocKyDTO hkDTO)
{
string sQuery = string.Format("INSERT INTO HocKy VALUES (N'{0}', N'{1}')", hkDTO.STenHK, hkDTO.SGhiChu);
con = DataProvider.Connect();
try
{
DataProvider.ExecuteQueriesNonQuery(sQuery, con);
DataProvider.CloseConnect(con);
return(true);
}
catch (Exception ex) { DataProvider.CloseConnect(con); return(false); }
}
public async Task <IActionResult> Put(int id, [FromBody] HocKyDTO model)
{
using (var context = new UserProfileDbContext())
{
var user = await context.HocKies.FirstOrDefaultAsync(x => x.Id.Equals(id));
if (user == null)
{
return(NotFound());
}
user.Id = model.Id;
user.TenHocKy = model.TenHocKy;
return(Ok(await context.SaveChangesAsync()));
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (txtMahk.Text == "")
{
MessageBox.Show("Bạn phải chọn học kỳ cần xóa.");
return;
}
HocKyDTO hk = new HocKyDTO();
hk.IMaHK = int.Parse(txtMahk.Text);
if (HocKyBLL.XoaHocKy(hk))
{
MessageBox.Show("Xóa thành công.");
LoadHocKy();
return;
}
else
{
MessageBox.Show("Xóa thất bại.");
}
}
private void btnThem_Click(object sender, EventArgs e)
{
if (txtTenhk.Text == "")
{
MessageBox.Show("Bạn phải nhập vào học ky.");
return;
}
HocKyDTO hk = new HocKyDTO();
hk.STenHK = txtTenhk.Text;
hk.SGhiChu = txtGhichu.Text;
if (HocKyBLL.ThemHocKy(hk))
{
MessageBox.Show("Thêm thành công.");
LoadHocKy();
return;
}
else
{
MessageBox.Show("Thêm thất bại.");
}
}
public KQHSMonHocDTO(
HocSinhDTO hocSinh,
LopDTO lop,
NamHocDTO namHoc,
MonHocDTO monHoc,
HocKyDTO hocKy,
float diemMiengTB,
float diem15PhutTB,
float diem45PhutTB,
float diemThi,
float diemTBHK)
{
this.hocSinh = hocSinh;
this.lop = lop;
this.namHoc = namHoc;
this.monHoc = monHoc;
this.hocKy = hocKy;
this.diemMiengTB = diemMiengTB;
this.diem15PhutTB = diem15PhutTB;
this.diem45PhutTB = diem45PhutTB;
this.diemThi = diemThi;
this.diemTBHK = diemTBHK;
}
private void btnSua_Click(object sender, EventArgs e)
{
if (txtTenhk.Text == "")
{
MessageBox.Show("Bạn phải nhập vào học kỳ.");
return;
}
HocKyDTO hk = new HocKyDTO();
hk.IMaHK = int.Parse(txtMahk.Text);
hk.STenHK = txtTenhk.Text;
hk.SGhiChu = txtGhichu.Text;
if (HocKyBLL.SuaHocKy(hk))
{
MessageBox.Show("Sửa thành công.");
LoadHocKy();
return;
}
else
{
MessageBox.Show("Sửa thất bại.");
}
}
public static List <HocKyDTO> LoadcbHocKy()
{
string sQuery = @"SELECT * FROM HocKy";
con = DataProvider.Connect();
DataTable dt = DataProvider.LayDataTable(sQuery, con);
if (dt.Rows.Count == 0)
{
return(null);
}
List <HocKyDTO> lsthk = new List <HocKyDTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
HocKyDTO hk = new HocKyDTO();
hk.IMaHK = int.Parse(dt.Rows[i]["MaHK"].ToString());
hk.STenHK = dt.Rows[i]["TenHK"].ToString();
hk.SGhiChu = dt.Rows[i]["GhiChu"].ToString();
lsthk.Add(hk);
}
DataProvider.CloseConnect(con);
return(lsthk);
}
public static bool SuaHocKy(HocKyDTO hkDTO)
{
return(HocKyProvider.SuaHocKy(hkDTO));
}
public static bool ThemHocKy(HocKyDTO hkDTO)
{
return(HocKyProvider.ThemHocKy(hkDTO));
}
