private void btMonHoc_Search_Click(object sender, EventArgs e)
{
string text = txbSearch.Text;
if (text == "")
{
return;
}
BUS_MonHoc busMonHoc = new BUS_MonHoc();
EC_MonHoc MonHoc1 = busMonHoc.Select_ByPrimaryKey(text);
List <EC_MonHoc> listResult = new List <EC_MonHoc>();
if (MonHoc1 != null)
{
listResult.Add(MonHoc1);
}
List <EC_MonHoc> listMonHoc2 = busMonHoc.SelectByFields("Ten_MonHoc", text);
foreach (EC_MonHoc ec in listMonHoc2)
{
listResult.Add(ec);
}
dgSearchResult.Rows.Clear();
foreach (EC_MonHoc ec in listResult)
{
dgSearchResult.Rows.Add(ec.Ma_MonHoc, ec.Ten_MonHoc, ec.Lop, null);
}
}
void LoadForm()
{
cbTenMon.Items.Clear();
cbLop.Items.Clear();
cbLop.Items.Add("Tất cả");
for (int j = 1; j <= 12; j++)
{
cbLop.Items.Add(j.ToString());
}
EC_LopHoc ecLop = new EC_LopHoc();
EC_MonHoc ecMon = new EC_MonHoc();
dgLopHoc.DataSource = ft.LopHoc_Select_Manager(ecLop, ecMon);
List <EC_MonHoc> listMonHoc = new BUS_MonHoc().SelectAll();
List <string> listTen_MonHoc = new List <string>();
listTen_MonHoc.Add(listMonHoc[0].Ten_MonHoc);
cbTenMon.Items.Add(listTen_MonHoc[0]);
foreach (EC_MonHoc MonHoc in listMonHoc)
{
if (listTen_MonHoc.IndexOf(MonHoc.Ten_MonHoc) == -1)
{
cbTenMon.Items.Add(MonHoc.Ten_MonHoc);
}
listTen_MonHoc.Add(MonHoc.Ten_MonHoc);
}
dtNgayBatdau.Value = DateTime.Now;
cbLop.SelectedIndex = 12;
cbTenMon.SelectedIndex = 0;
cbTrinhDo.SelectedIndex = 0;
}
//Hàm sửa
public bool SuaDuLieu(EC_MonHoc ec)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "dbo.[MonHoc_Update]";
cmd.CommandType = CommandType.StoredProcedure;
try
{
con.MoKetNoi();
// Use connection object of base class
cmd.Connection = con.connect;
cmd.Parameters.AddWithValue("@Ma_MonHoc", ec.Ma_MonHoc);
cmd.Parameters.AddWithValue("@Ten_MonHoc", ec.Ten_MonHoc);
cmd.Parameters.AddWithValue("@Lop", ec.Lop);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
throw new Exception("Lỗi khi sửa mon học: " + e.ToString());
return(false);
}
finally
{
con.DongKetNoi();
cmd.Dispose();
}
}
private void btThem_MonHoc_Click(object sender, EventArgs e)
{
if (dgSearchResult.Rows.Count == 0)
{
return;
}
int count_Check = 0;
List <EC_MonHoc> listChecked = new List <EC_MonHoc>();
foreach (DataGridViewRow row in dgSearchResult.Rows)
{
if (row.Cells[3].Value != null)
{
if (Convert.ToBoolean(row.Cells[3].Value.ToString()) == true)
{
count_Check++;
EC_MonHoc MonHoc = new BUS_MonHoc().Select_ByPrimaryKey(row.Cells[0].Value.ToString());
listChecked.Add(MonHoc);
}
}
}
if (count_Check == 0)
{
MessageBox.Show("Chọn môn học để thêm!", "Thông báo");
return;
}
List <EC_PhanCong_Day> listPhanCong_Day = new BUS_PhanCong_Day().SelectByFields("Ma_GiaoVien", Ma_GiaoVien);
int count_Success = 0;
foreach (EC_MonHoc i in listChecked)
{
bool check = true;
foreach (EC_PhanCong_Day ec in listPhanCong_Day)
{
if (ec.Ma_MonHoc == i.Ma_MonHoc)
{
check = false;
}
}
if (check == true)
{
new BUS_PhanCong_Day().ThemDuLieu(new EC_PhanCong_Day(Ma_GiaoVien, i.Ma_MonHoc));
count_Success++;
}
}
MessageBox.Show("Thêm thành công " + count_Success.ToString() + " môn học", "Thông báo");
dgPhanCong_Day.Rows.Clear();
List <EC_PhanCong_Day> list = new BUS_PhanCong_Day().SelectByFields("Ma_GiaoVien", Ma_GiaoVien);
BUS_MonHoc busMonHoc = new BUS_MonHoc();
int index = 1;
foreach (EC_PhanCong_Day ec in listPhanCong_Day)
{
EC_MonHoc MonHoc = busMonHoc.Select_ByPrimaryKey(ec.Ma_MonHoc);
dgPhanCong_Day.Rows.Add(index.ToString(), MonHoc.Ma_MonHoc, MonHoc.Ten_MonHoc, MonHoc.Lop.ToString());
index++;
}
}
/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of SinhVien</returns>
internal List <EC_MonHoc> PopulateObjectsFromReader(IDataReader dataReader)
{
List <EC_MonHoc> list = new List <EC_MonHoc>();
while (dataReader.Read())
{
EC_MonHoc businessObject = new EC_MonHoc();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(EC_MonHoc businessObject, IDataReader dataReader)
{
businessObject.Ma_MonHoc = dataReader.GetString(dataReader.GetOrdinal(EC_MonHoc.MonHocField.Ma_MonHoc.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(EC_MonHoc.MonHocField.Ten_MonHoc.ToString())))
{
businessObject.Ten_MonHoc = dataReader.GetString(dataReader.GetOrdinal(EC_MonHoc.MonHocField.Ten_MonHoc.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(EC_MonHoc.MonHocField.Ma_MonHoc.ToString())))
{
businessObject.Lop = dataReader.GetInt32(dataReader.GetOrdinal(EC_MonHoc.MonHocField.Lop.ToString()));
}
}
void Load()
{
EC_GiaoVien GiaoVien = new BUS_GiaoVien().Select_ByPrimaryKey(Ma_GiaoVien);
if (GiaoVien.Anh != null)
{
picAvt.Image = HinhAnh.ByteToImage(GiaoVien.Anh);
}
txbMa_GiaoVien.Text = GiaoVien.Ma_GiaoVien;
txbTen_GiaoVien.Text = GiaoVien.Ten_GiaoVien;
txbDiaChi.Text = GiaoVien.DiaChi;
txbEmail.Text = GiaoVien.Email;
txbSDT.Text = GiaoVien.SDT;
dtNgaySinh.Value = GiaoVien.NgaySinh;
cbGioiTinh.SelectedItem = GiaoVien.GioiTinh == true ? "Nam" : "Nữ";
cbTrinhDo.SelectedItem = GiaoVien.TrinhDo;
List <EC_PhanCong_Day> listPhanCong_Day = new BUS_PhanCong_Day().SelectByFields("Ma_GiaoVien", Ma_GiaoVien);
BUS_MonHoc busMonHoc = new BUS_MonHoc();
int index = 1;
foreach (EC_PhanCong_Day ec in listPhanCong_Day)
{
EC_MonHoc MonHoc = busMonHoc.Select_ByPrimaryKey(ec.Ma_MonHoc);
dgPhanCong_Day.Rows.Add(index.ToString(), MonHoc.Ma_MonHoc, MonHoc.Ten_MonHoc, MonHoc.Lop.ToString());
index++;
}
index = 1;
List <EC_LopHoc> listLopHoc = new BUS_LopHoc().SelectByFields("Ma_GiaoVien", Ma_GiaoVien);
foreach (EC_LopHoc ec in listLopHoc)
{
List <EC_LichHoc> listBuoiHoc = new BUS_LichHoc().SelectByFields("Ma_LopHoc", ec.Ma_LopHoc);
if (listBuoiHoc.Count == 0)
{
continue;
}
List <EC_BuoiHoc_HocSinh> listBHHS = new BUS_BuoiHoc_HocSinh().SelectByFields("Ma_BuoiHoc", listBuoiHoc[0].Ma_BuoiHoc);
EC_MonHoc MonHoc = busMonHoc.Select_ByPrimaryKey(ec.Ma_MonHoc);
dgLopDay.Rows.Add(index.ToString(), ec.Ma_LopHoc, MonHoc.Ten_MonHoc, MonHoc.Lop, ec.SoBuoi, listBHHS.Count);
index++;
}
}
public DataTable LopHoc_Select_Manager(EC_LopHoc ecLop, EC_MonHoc ecMon)
{
using (SqlConnection con = new SqlConnection(connect))
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from LopHoc_Select_Manager(@Ten_MonHoc, @Lop, @Ma_GiaoVien, @TrinhDo, @TongSoBuoi)", con);
cmd.Parameters.AddWithValue("@Ten_MonHoc", ecMon.Ten_MonHoc);
cmd.Parameters.Add(new SqlParameter("@Lop", SqlDbType.Int)).Value = ecMon.Lop;
cmd.Parameters.AddWithValue("@Ma_GiaoVien", ecLop.Ma_GiaoVien);
cmd.Parameters.AddWithValue("@TrinhDo", ecLop.TrinhDo);
cmd.Parameters.Add(new SqlParameter("@TongSoBuoi", SqlDbType.Int)).Value = ecLop.SoBuoi;
SqlDataAdapter adt = new SqlDataAdapter(cmd);
DataTable tb = new DataTable();
adt.Fill(tb);
con.Close();
return(tb);
}
}
public EC_MonHoc Select_ByPrimaryKey(string Ma_MonHoc)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[MonHoc_Select_By_Ma]";
sqlCommand.CommandType = CommandType.StoredProcedure;
try
{
sqlCommand.Parameters.AddWithValue("@Ma_MonHoc", Ma_MonHoc);
con.MoKetNoi();
// Use connection object of base class
sqlCommand.Connection = con.connect;
IDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
EC_MonHoc businessObject = new EC_MonHoc();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return(businessObject);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception("Lỗi khi lấy tất cả mon học.", ex);
}
finally
{
con.DongKetNoi();
sqlCommand.Dispose();
}
}
void LayDuLieu()
{
string MaGV;
if (txbMaGV.Text == "" || txbMaGV.Text == null)
{
MaGV = "All";
}
else
{
MaGV = txbMaGV.Text;
}
string TrinhDo;
if (cbTrinhDo.SelectedIndex == 0)
{
TrinhDo = "All";
}
else
{
TrinhDo = cbTrinhDo.SelectedItem.ToString();
}
string SoBuoi = txbSoBuoi.Text;
for (int i = 0; i < SoBuoi.Length; i++)
{
if (SoBuoi[i] > 9 || SoBuoi[i] < 0)
{
MessageBox.Show("Số buổi không hợp lệ!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
break;
}
}
int SB;
if (SoBuoi == "")
{
SB = 0;
}
else
{
SB = Int32.Parse(SoBuoi);
}
string TenMon;
if (cbTenMon.SelectedIndex == 0)
{
TenMon = "All";
}
else
{
TenMon = cbTenMon.SelectedItem.ToString();
}
int Lop;
if (cbLop.SelectedIndex == 0)
{
Lop = 0;
}
else
{
Lop = Convert.ToInt32(cbLop.SelectedItem);
}
EC_LopHoc ecLop = new EC_LopHoc("All", "All", "All", TrinhDo, 0, SB, dtNgayBatdau.Value);
EC_MonHoc ecMon = new EC_MonHoc("All", TenMon, Lop);
dgLopHoc.DataSource = ft.LopHoc_Select_Manager(ecLop, ecMon);
}
public DataTable LopHoc_Select_Manager(EC_LopHoc ecLop, EC_MonHoc ecMon)
{
return(ft.LopHoc_Select_Manager(ecLop, ecMon));
}
public void SuaDuLieu(EC_MonHoc ec)
{
sql.SuaDuLieu(ec);
}
public void ThemDuLieu(EC_MonHoc ec)
{
sql.ThemDuLieu(ec);
}
