/// <summary>
///
/// </summary>
/// <param name="lvDS"></param>
public void HienThiDS(ListView lvDS)
{
if (this.Data == null)
{
this.Data = new LopMonHocData();
}
DataTable table = this.Data.LayDS(false);
lvDS.Items.Clear();
foreach (DataRow row in table.Rows)
{
LopMonHocInfo info = new LopMonHocInfo();
info.MaLopMonHoc = int.Parse(row["MaLopMonHoc"].ToString());
LopController lopCtrl = new LopController();
info.Lop = lopCtrl.LayTuMa(row["MaLop"].ToString());
MonHocController monHocCtrl = new MonHocController();
info.MonHoc = monHocCtrl.LayTuMa(row["MaMonHoc"].ToString());
ListViewItem item = new ListViewItem();
item.Text = info.Lop.TenLop;
item.SubItems.Add(info.MonHoc.TenMonHoc);
object[] tag = new object[2];
tag[0] = info;
tag[1] = row;
item.Tag = tag;
lvDS.Items.Add(item);
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btRemoveAll_Click(object sender, EventArgs e)
{
this.cmbNamHoc.Enabled = false;
this.cmbKhoiLop.Enabled = false;
this.cmbLop.Enabled = false;
IEnumerator ie = this.lvDSMonHocDuocChon.Items.GetEnumerator();
while (ie.MoveNext())
{
ListViewItem item = (ListViewItem)ie.Current;
this.lvDSMonHocDuocChon.Items.Remove(item);
this.lvDMMonHoc.Items.Add(item);
}
//Tao mot doi tuong PhanCongController dung de xoa mon hoc duoc phan cong khi mon hoc do bi xoa khoi danh sach mon hoc cua lop
PhanCongController phanCongCtrl = new PhanCongController();
foreach (DataRow row in this.LopMonHocController.Data.DataService.Rows)
{
if (row["MaLopMonHoc"].ToString() != "")
{
LopMonHocInfo lopMonHoc = new LopMonHocInfo();
lopMonHoc.MaLopMonHoc = int.Parse(row["MaLopMonHoc"].ToString());
phanCongCtrl.Xoa(lopMonHoc);
}
this.LopMonHocController.Data.DataService.Rows[this.LopMonHocController.Data.DataService.Rows.IndexOf(row)].Delete();
}
this.LopMonHocController.Update();
}
/// <summary>
///
/// </summary>
/// <param name="monHoc"></param>
/// <returns></returns>
public bool Xoa(LopMonHocInfo lopMonHoc)
{
if (this.DataService == null)
{
this.DataService = new DataService();
}
SqlCommand cmd = new SqlCommand("DELETE FROM PHAN_CONG WHERE MaLopMonHoc=@maLopMonHoc");
cmd.Parameters.Add("maLopMonHoc", SqlDbType.Int).Value = lopMonHoc.MaLopMonHoc;
if (this.DataService.ExecuteNonQuery(cmd) == 0)
{
return(false);
}
return(true);
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btLuu_Click(object sender, EventArgs e)
{
this.cmbNamHoc.Enabled = true;
this.cmbKhoiLop.Enabled = true;
this.cmbLop.Enabled = true;
foreach (ListViewItem item in this.lvDSMonHocDuocChon.Items)
{
DataRow r = (DataRow)((object[])item.Tag)[1];
if (this.LopMonHocController.Data.DataService.Rows.IndexOf(r) == -1)
{
this.LopMonHocController.Data.DataService.Rows.Add(r);
}
}
//Tao mot doi tuong PhanCongController dung de xoa mon hoc duoc phan cong khi mon hoc do bi xoa khoi danh sach mon hoc cua lop
PhanCongController phanCongCtrl = new PhanCongController();
bool daXoa = false;
foreach (DataRow row in this.LopMonHocController.Data.DataService.Rows)
{
foreach (ListViewItem item in this.lvDSMonHocDuocChon.Items)
{
DataRow r = (DataRow)((object[])item.Tag)[1];
if (row.Equals(r))
{
daXoa = false;
break;
}
daXoa = true;
}
if (daXoa)
{
if (row["MaLopMonHoc"].ToString() != "")
{
LopMonHocInfo lopMonHoc = new LopMonHocInfo();
lopMonHoc.MaLopMonHoc = int.Parse(row["MaLopMonHoc"].ToString());
phanCongCtrl.Xoa(lopMonHoc);
}
this.LopMonHocController.Data.DataService.Rows[this.LopMonHocController.Data.DataService.Rows.IndexOf(row)].Delete();
daXoa = false;
}
}
this.LopMonHocController.Update();
}
/// <summary>
///
/// </summary>
/// <param name="maLopMonHoc"></param>
/// <returns></returns>
public LopMonHocInfo LayTuMa(int maLopMonHoc)
{
if (this.Data == null)
{
this.Data = new LopMonHocData();
}
DataTable table = this.Data.LayTuMa(maLopMonHoc);
if (table.Rows.Count > 0)
{
LopMonHocInfo info = new LopMonHocInfo();
info.MaLopMonHoc = int.Parse(table.Rows[0]["MaLopMonHoc"].ToString());
LopController lopCtrl = new LopController();
info.Lop = lopCtrl.LayTuMa(table.Rows[0]["MaLop"].ToString());
MonHocController monHocCtrl = new MonHocController();
info.MonHoc = monHocCtrl.LayTuMa(table.Rows[0]["MaMonHoc"].ToString());
return(info);
}
return(null);
}
