//get chuyen de duoc mo
public List <CHUYENDE> ChuyenDeMo(string maN)
{
List <CHUYENDE> chuyendes = new List <CHUYENDE>();
string query = "select * from CHUYENDE cd where cd.MaNganh = @maN and cd.MaChuyenDe in ( " +
"select ttm.MaChuyenDe from THONGTINMOCHUYENDE ttm where ttm.TrangThai = 1 )";
object[] para = new object[]
{
maN
};
DataTable data = DataProvider.Instance.ExecuteQuery(query, para);
foreach (DataRow item in data.Rows)
{
string MaCD = item["MaChuyenDe"].ToString();
string TenCD = item["TenChuyenDe"].ToString();
int SoSVMax = (int)item["SoSinhVienToiDa"];
string MaN = item["MaNganh"].ToString();
CHUYENDE CD = new CHUYENDE(MaCD, TenCD, SoSVMax, MaN);
chuyendes.Add(CD);
}
return(chuyendes);
}
private void frmSuaChuyenDe_Load(object sender, EventArgs e)
{
foreach (var item in NganhBUS.Instance.GetAll())
{
cmbNganh.Items.Add(new Item(item.tenNganh, item.maNganh));
}
CHUYENDE cd = ChuyenDeBUS.Instance.GetByID(_maCD);
// string maNganh =
int vitri = int.Parse(cd.maNganh.Substring(1, 1));
cmbNganh.SelectedIndex = vitri - 1;
txtTenChuyenDe.Text = cd.tenCDe;
txtSVToiDa.Text = cd.soSV.ToString();
}
public bool Update(string maCD, CHUYENDE cd)
{
string query = "Update CHUYENDE SET TenChuyenDe = @tecd , SoSinhVienToiDa = @svMAX , MaNganh = @maN WHERE MaChuyenDe = @maCD ";
object[] para = new object[]
{
cd.tenCDe,
cd.soSV,
cd.maNganh,
maCD
};
if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0)
{
return(true);
}
return(false);
}
public bool Insert(CHUYENDE cd)
{
string query = "Insert into CHUYENDE(MaChuyenDe, TenChuyenDe, SoSinhVienToiDa, MaNganh) values( @maCD , @tenCD , @svMAX , @maN )";
object[] para = new object[]
{
cd.maCDe,
cd.tenCDe,
cd.soSV,
cd.maNganh
};
if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0)
{
return(true);
}
return(false);
}
public List <CHUYENDE> GetAll()
{
List <CHUYENDE> chuyendes = new List <CHUYENDE>();
string query = "select * from CHUYENDE";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
string MaCD = item["MaChuyenDe"].ToString();
string TenCD = item["TenChuyenDe"].ToString();
int SoSVMax = (int)item["SoSinhVienToiDa"];
string MaN = item["MaNganh"].ToString();
CHUYENDE CD = new CHUYENDE(MaCD, TenCD, SoSVMax, MaN);
chuyendes.Add(CD);
}
return(chuyendes);
}
public CHUYENDE GetByID(string id)
{
string query = "SELECT * FROM CHUYENDE WHERE MaChuyenDe = @maCD ";
object[] para = new object[]
{
id
};
DataTable data = DataProvider.Instance.ExecuteQuery(query, para);
DataRow item = data.Rows[0];
string MaCD = item["MaChuyenDe"].ToString();
string TenCD = item["TenChuyenDe"].ToString();
int SoSVMax = (int)item["SoSinhVienToiDa"];
string MaN = item["MaNganh"].ToString();
CHUYENDE CD = new CHUYENDE(MaCD, TenCD, SoSVMax, MaN);
return(CD);
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
string tenCD = txtTenChuyenDe.Text;
int soSVMAX = int.Parse(txtSVToiDa.Text);
Item nganh = (Item)cmbNganh.SelectedItem;
string maNganh = nganh.Value.Trim();
string maCD = _maCD;
CHUYENDE cd = new CHUYENDE(maCD, tenCD, soSVMAX, maNganh);
if (ChuyenDeBUS.Instance.Update(maCD, cd))
{
MessageBox.Show("Cập nhật chuyên đề thành công");
}
else
{
MessageBox.Show("Cập nhật chuyên đề không thành công");
}
}
private void btnTaoChuyenDe_Click(object sender, EventArgs e)
{
string tenCD = txtTenChuyenDe.Text;
int soSVMAX = int.Parse(txtSVToiDa.Text);
Item nganh = (Item)cmbNganh.SelectedItem;
string maNganh = nganh.Value.Trim();
string maCD = ChuyenDeBUS.Instance.CreateMaCD();
MessageBox.Show(tenCD + "\n" + soSVMAX + "\n" + maNganh + "\n" + maCD);
CHUYENDE cd = new CHUYENDE(maCD, tenCD, soSVMAX, maNganh);
if (ChuyenDeBUS.Instance.Insert(cd))
{
MessageBox.Show("Thêm chuyên đề thành công");
}
else
{
MessageBox.Show("Thêm chuyên đề không thành công");
}
}
public bool Update(string maCD, CHUYENDE cd)
{
return(ChuyenDeDAO.Instance.Update(maCD, cd));
}
public bool Insert(CHUYENDE cd)
{
return(ChuyenDeDAO.Instance.Insert(cd));
}
