private void Show(int ID_Lop, string ms)
{
BLL_QLSV bll = new BLL_QLSV();
dtgSV.DataSource = bll.GetListSV_BLL(ID_Lop, ms);
//bll.LoadCBB(cbbLSH);
}
private void btnSort_Click(object sender, EventArgs e)
{
BLL_QLSV bll = new BLL_QLSV();
List <string> LMMS = new List <string>();
foreach (SV i in bll.GetListSV_BLL())
{
LMMS.Add(i.MSSV);
}
switch (cbbSort.Text)
{
case "Tên, A->Z":
dtgSV.DataSource = bll.ListSVSort(LMMS, SV.Compare_NameAZ);
break;
case "Tên, Z->A":
dtgSV.DataSource = bll.ListSVSort(LMMS, SV.Compare_NameZA);
break;
case "MSSV, Thấp -> Cao":
dtgSV.DataSource = bll.ListSVSort(LMMS, SV.Compare_MSSVThapCao);
break;
case "MSSV, Cao -> Thấp":
dtgSV.DataSource = bll.ListSVSort(LMMS, SV.Compare_MSSVCaoThap);
break;
default:
break;
}
}
private void Show(int ID_Lop, string txtSearch = "", string sortBy = "")
{
List <SV> listSV;
if (ID_Lop > 0)
{
listSV = BLL_QLSV.Instance.GetAllSVByIdLop(ID_Lop);
}
else
{
listSV = BLL_QLSV.Instance.GetAllSV();
}
List <string> listMSSV = new List <string>();
foreach (SV sv in listSV)
{
listMSSV.Add(sv.MSSV);
}
switch (sortBy)
{
case "NameSV":
listSV = BLL_QLSV.ListSVSort(listMSSV, BLL_QLSV.sortNameSVDESC);
break;
case "MSSV":
listSV = BLL_QLSV.ListSVSort(listMSSV, BLL_QLSV.sortMSSVDESC);
break;
}
if (!txtSearch.Equals(""))
{
listSV = BLL_QLSV.searchByText(txtSearch, listSV);
}
for (int i = 0; i < listSV.Count; i++)
{
foreach (CBBItem item in this.cbbLopSH.Items)
{
if (listSV[i].ID_Lop.Equals(Convert.ToInt32(item.value)))
{
listSV[i].Ten_Lop = item.key;
}
}
}
this.dgvDSSV.DataSource = listSV;
// Hide id column, Id_Lop column of SV in data gridview
this.dgvDSSV.Columns[0].Visible = false;
this.dgvDSSV.Columns[4].Visible = false;
}
private void btnDel_Click(object sender, EventArgs e)
{
BLL_QLSV bll = new BLL_QLSV();
DataGridViewSelectedRowCollection data = dtgSV.SelectedRows;
if (data.Count == 1)
{
string MSSV = data[0].Cells["MSSV"].Value.ToString();
SV s = bll.GetSVbyMSSV(MSSV);
bll.DELSVBLL(s);
}
Show(0, txbSearch.Text);
}
private void btnOK_Click(object sender, EventArgs e)
{
BLL_QLSV bll = new BLL_QLSV();
string MSSV = txbMSSV.Text;
string NameSV = txbName.Text;
bool Gender = rbMale.Checked;
DateTime BD = Convert.ToDateTime(dtNgaySinh.Value);
int LopSH = ((CBBItem)cbbLopSH.Items[cbbLopSH.SelectedIndex]).Value;
SV s = new SV(MSSV, NameSV, BD, LopSH, Gender);
bll.ExecuteDBB(s);
this.Dispose();
}
private void btn_sort_Click(object sender, EventArgs e)
{
if (cbb_Sort.SelectedItem != null)
{
BLL_QLSV bll = new BLL_QLSV();
List <string> LMSSV = getListMSSV();
string type = cbb_Sort.SelectedItem.ToString();
datagridview_dssv.DataSource = bll.SortListSV(bll.GetListSVDTGV(LMSSV), type);
}
else
{
MessageBox.Show("Vui lòng chọn kiểu sắp xếp !");
}
}
private void setCBBLSH()
{
BLL_QLSV bll = new BLL_QLSV();
foreach (LSH i in bll.GetListLSH_BLL())
{
CBB_Item item = new CBB_Item()
{
Text = i.NameLop,
Value = i.ID_Lop,
};
cbbLSH.Items.Add(item);
}
}
private void cbbLSH_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbbLSH.SelectedIndex >= 0)
{
int ID_Lop = Convert.ToInt32(((CBBItem)cbbLSH.SelectedItem).Value.ToString());
//DataTable dt = new DataTable();
BLL_QLSV bll = new BLL_QLSV();
if (ID_Lop == 0)
{
dtgSV.DataSource = bll.GetListSV_BLL();
}
else
{
dtgSV.DataSource = bll.GetListSVfromLSH_BLL(ID_Lop.ToString());
}
}
}
private void btn_delete_Click(object sender, EventArgs e)
{
DataGridViewSelectedRowCollection r = datagridview_dssv.SelectedRows;
if (r.Count == 0 || r[0].Cells["MSSV"].Value == null)
{
MessageBox.Show("Vui lòng chọn SV để xóa !");
}
else
{
string s = "";
foreach (DataGridViewRow i in r)
{
s += i.Cells["NameSV"].Value.ToString() + " ";
if (i.Cells == null)
{
MessageBox.Show("Vui lòng chọn toàn bộ nội dung SV để xóa !");
}
else
{
result = MessageBox.Show("Bạn chắc chắn muốn xóa SV " + s + " ?", "Confirmation", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
BLL_QLSV Bll = new BLL_QLSV();
string MSSV = i.Cells["MSSV"].Value.ToString();
if (Bll.DeleteSV_BLL(MSSV))
{
MessageBox.Show("Xóa thành công!");
show(1);
}
else
{
MessageBox.Show("Không thể xóa !");
s = "";
continue;
}
}
else
{
s = "";
continue;
}
}
}
}
}
private void show(int type)
{
BLL_QLSV bll = new BLL_QLSV();
if (type == 0)
{
datagridview_dssv.DataSource = bll.GetListSV_BLL(0);
}
else
{
datagridview_dssv.DataSource = bll.GetListSV_BLL(getCurrentClassID());
}
if (datagridview_dssv.DataSource == null)
{
MessageBox.Show("Không có sinh viên nào !");
}
}
private void setCBBLSH()
{
BLL_QLSV bll = new BLL_QLSV();
cbbLSH.Items.Add(new CBB_Item()
{
Text = "All",
Value = 0
});
foreach (LSH i in bll.GetListLSH_BLL())
{
cbbLSH.Items.Add(new CBB_Item()
{
Text = i.NameLop,
Value = i.ID_Lop,
});
}
cbbLSH.SelectedItem = cbbLSH.Items[0];
}
private void btn_confirm_Click(object sender, EventArgs e)
{
if (validateForm() != 0)
{
switch (validateForm())
{
case 1:
MessageBox.Show("Vui lòng nhập đầy đủ thông tin ");
break;
case 2:
MessageBox.Show("Vui Lòng Nhập Mã SV không chứa kí tự!");
break;
}
return;
}
else
{
BLL_QLSV bll = new BLL_QLSV();
if (MSSV != "-1")
{
bll.UpdateSV_BLL(setSV());
MessageBox.Show("Chỉnh sửa SV thành công !");
loadData(1);
this.Dispose();
}
else
{
if (bll.AddSV_BLL(setSV()))
{
MessageBox.Show("Thêm SV thành công !");
loadData(1);
this.Dispose();
}
else
{
MessageBox.Show("Mã SV đã tồn tại!");
}
}
}
}
private void btnSort_Click(object sender, EventArgs e)
{
List <string> listMSSV = new List <string>();
foreach (DataGridViewRow dr in this.dgvDSSV.Rows)
{
string s = dr.Cells["MSSV"].Value.ToString();
listMSSV.Add(s);
}
string sortBy = GetSortByFromCBB();
if (sortBy.Equals("NameSV"))
{
this.dgvDSSV.DataSource = BLL_QLSV.ListSVSort(listMSSV, BLL_QLSV.sortNameSVDESC);
}
else if (sortBy.Equals("MSSV"))
{
this.dgvDSSV.DataSource = BLL_QLSV.ListSVSort(listMSSV, BLL_QLSV.sortMSSVDESC);
}
}
private void search()
{
if (cbb_search_type.SelectedItem != null)
{
BLL_QLSV bll = new BLL_QLSV();
string type = cbb_search_type.SelectedItem.ToString();
string search_key = txt_search.Text;
if (search_key == "")
{
show(1);
}
else
{
datagridview_dssv.DataSource = bll.filterSV(type, search_key, bll.GetListSV_BLL(getCurrentClassID()));
}
}
else
{
MessageBox.Show("Vui lòng chọn kiểu tìm kiếm !");
}
}
public void SetCBBShow()
{
BLL_QLSV bll = new BLL_QLSV();
if (cbbLSH.Items != null)
{
cbbLSH.Items.Clear();
}
cbbLSH.Items.Add(new CBBItem {
Value = 0, Text = "All"
});
foreach (LSH i in bll.GetListLSH_BLL())
{
cbbLSH.Items.Add(new CBBItem
{
Value = i.ID_Lop,
Text = i.TenLop
});
cbbLSH.SelectedIndex = 0;
}
}
public void setInfo(string MSSV)
{
this.MSSV = MSSV;
if (MSSV == "-1")
{
BLL_QLSV bll = new BLL_QLSV();
gb_ttsv.Text = "Thêm Sinh Viên mới ";
cbbLSH.SelectedIndex = 0;
radio_male.Checked = true;
txt_masv.Text = bll.setNextMSSV();
txt_masv.Enabled = false;
}
else
{
gb_ttsv.Text = "Chỉnh sửa thông tin Sinh Viên ";
BLL_QLSV bll = new BLL_QLSV();
s = bll.GetSV_BLL(MSSV);
txt_masv.Text = s.MSSV;
txt_masv.Enabled = false;
txt_tensv.Text = s.NameSV;
txt_masv.Text = s.MSSV.ToString();
txt_tensv.Text = s.NameSV;
foreach (CBB_Item i in cbbLSH.Items)
{
if (s.ID_Lop == i.Value)
{
cbbLSH.SelectedItem = i;
}
}
if (s.Gender)
{
radio_male.Checked = true;
}
else
{
radioFemale.Checked = true;
}
dtp_ngaysinh.Value = Convert.ToDateTime(s.NS);
}
}
public void SetGUI(string ms)
{
BLL_QLSV bll = new BLL_QLSV();
if (bll.GetSVbyMSSV(ms) != null)
{
// Binding
SV s = bll.GetSVbyMSSV(ms);
txbMSSV.Text = s.MSSV;
txbName.Text = s.NameSV;
dtNgaySinh.Value = s.NgaySinh;
if (s.Gender == true)
{
rbMale.Checked = true;
}
else
{
rbFemale.Checked = true;
}
cbbLopSH.Text = ((CBBItem)cbbLopSH.Items[s.ID_Lop - 1]).Text;
}
}
