public bool deletedata(En_MonHoc en) { string query = string.Format("DELETE FROM MonHoc WHERE MaMH=@MaMH"); SqlParameter[] sqlPara = new SqlParameter[1]; sqlPara[0] = new SqlParameter("@MaMH", en.MaMH); return(cnn.executeDeleteQuery(query, sqlPara)); }
private void frmMonHoc_Load(object sender, EventArgs e) { en = new En_MonHoc(); NapTrangThai(); NapDuLieu(); EvenButton(0); EnableOrDisable(true); }
public bool updatedata(En_MonHoc en) { string query = string.Format("UPDATE MonHoc SET TenMH = @TenMH, SoTC = @SoTC, BieuPhi = @BieuPhi, DonVi = @DonVi, TrangThai = @TrangThai, NgayCapNhat = @NgayCapNhat WHERE MaMH = @MaMH"); SqlParameter[] sqlPara = new SqlParameter[7]; sqlPara[0] = new SqlParameter("@TenMH", en.TenMH); sqlPara[1] = new SqlParameter("@SoTC", en.SoTC); sqlPara[2] = new SqlParameter("@BieuPhi", en.BieuPhi); sqlPara[3] = new SqlParameter("@DonVi", en.DonVi); sqlPara[4] = new SqlParameter("@TrangThai", en.TrangThai); sqlPara[5] = new SqlParameter("@NgayCapNhat", en.NgayCapNhat); sqlPara[6] = new SqlParameter("@MaMH", en.MaMH); return(cnn.executeUpdateQuery(query, sqlPara)); }
public bool insertdata(En_MonHoc en) { string query = string.Format("INSERT INTO MonHoc(MaMH, TenMH, SoTC, BieuPhi, DonVi, TrangThai, NgayTao, NgayCapNhat) VALUES(@MaMH, @TenMH, @SoTC, @BieuPhi, @DonVi, @TrangThai, @NgayTao, @NgayCapNhat)"); SqlParameter[] sqlPara = new SqlParameter[8]; sqlPara[0] = new SqlParameter("@MaMH", en.MaMH); sqlPara[1] = new SqlParameter("@TenMH", en.TenMH); sqlPara[2] = new SqlParameter("@SoTC", en.SoTC); sqlPara[3] = new SqlParameter("@BieuPhi", en.BieuPhi); sqlPara[4] = new SqlParameter("@DonVi", en.DonVi); sqlPara[5] = new SqlParameter("@TrangThai", en.TrangThai); sqlPara[6] = new SqlParameter("@NgayTao", en.NgayTao); sqlPara[7] = new SqlParameter("@NgayCapNhat", en.NgayCapNhat); return(cnn.executeInsertQuery(query, sqlPara)); }
public void deletedata(En_MonHoc en) { dal.deletedata(en); }
public void updatedata(En_MonHoc en) { dal.updatedata(en); }
public void insertdata(En_MonHoc en) { dal.insertdata(en); }