/*
* res : callback goi lai truyen tu main
* code : phan loai chuc nang ( them/sua+xoa) . Xem phan constant
* */
public DialogBangDiem(Response <Int32> res, int code, bangdiem l)
{
this.response = res;
InitializeComponent();
setViewControl(code);
mCode = code;
mItem = l;
}
internal static int DeleteProfile(bangdiem b)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@ma", b.mabd),
};
return(DataProvider.ExecuteNonQuery("xoabangdiem", para));
}
private void gridDiem_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (user.Quyen == Constants.CODE_QUYEN_SV)
{
return;
}
bangdiem item = (bangdiem)gridDiem.CurrentRow.DataBoundItem;
new DialogBangDiem(this, DialogController.CODE_UPDATE, item).Show();
}
private void btnAdd_Click(object sender, EventArgs e)
{
bangdiem item = getDataFromView();
bool result = new BangdiemSerivices().add(item);
if (result)
{
this.Hide();
//refresh list
response.onResponse(Constants.CODE_DIEM);
}
else
{
MessageBox.Show("Khong the them vao danh sach");
}
}
private bangdiem getDataFromView()
{
String masv = mListSinhVien[cboMaSv.SelectedIndex].masv;
String mamonhoc = mListMonHoc[cboMaMonHoc.SelectedIndex].mamonhoc;
String soTietNghi = txtSoTietNghi.Text;
String diemtp = txtDiemTp.Text;
String diemlan1 = txtDiemLan1.Text;
String diemlan2 = txtDiemLan2.Text;
bangdiem item = new bangdiem();
item.masv = masv;
item.mamonhoc = mamonhoc;
item.sotietnghi = soTietNghi;
item.diemthilan1 = diemlan1;
item.diemthilan2 = diemlan2;
item.diemtp = diemtp;
return(item);
}
public static int UpdateProfile(bangdiem b)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@ma", b.mabd),
new SqlParameter("@mahs", b.mahs),
new SqlParameter("@tb", b.diemtb),
new SqlParameter("@toan", b.diemtoan),
new SqlParameter("@van", b.diemvan),
new SqlParameter("@anh", b.diemanh),
new SqlParameter("@hoa", b.diemhoa),
new SqlParameter("@ly", b.diemly),
new SqlParameter("@sinh", b.diemsinh),
new SqlParameter("@su", b.diemsu),
new SqlParameter("@dia", b.diemdia),
new SqlParameter("@gv", b.giaovienquanly)
};
return(DataProvider.ExecuteNonQuery("suabangdiem", para));
}
private List <bangdiem> getListDiemFromExcel(String path)
{
List <bangdiem> listKhoa = new List <bangdiem>();
xlApp = new Microsoft.Office.Interop.Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(path, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
if (xlWorkSheet != null)
{
range = xlWorkSheet.UsedRange;
int row = range.Rows.Count;
int col = range.Columns.Count;
for (int r = 2; r <= row; r++)
{
bangdiem item = new bangdiem();
bool badRow = false;
for (int c = 1; c <= col; c++)
{
String content = "" + (range[r, c] as Range).Value2;
if (content.Equals(""))
{
badRow = true;
break;
}
if (c == 1)
{
item.masv = content;
}
else
{
// item. = content;
}
}
if (!badRow)
{
listKhoa.Add(item);
}
}
}
return(listKhoa);
}
private void butluu_Click(object sender, EventArgs e)
{
if (txtma.Text == "")
{
MessageBox.Show("Chưa nhập đủ thông tin!");
return;
}
bangdiem b = new bangdiem();
b.mabd = txtma.Text;
b.mahs = cbxmahs.Text;
b.diemtb = txttb.Text;
b.diemtoan = txttoan.Text;
b.diemvan = txtvan.Text;
b.diemanh = txtanh.Text;
b.diemhoa = txthoa.Text;
b.diemly = txtly.Text;
b.diemsinh = txtsinh.Text;
b.diemsu = txtsu.Text;
b.diemdia = txtdia.Text;
b.giaovienquanly = cbxgv.Text;
if (MessageBox.Show(string.Format("Bạn có muốn lưu Bang diem của học sinh này không?"),
"", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
if (Bus.InsertProfile(b) > 0)
{
MessageBox.Show("lưu thành công!");
Bangdiem_Load(sender, e);
}
else
{
MessageBox.Show("bị Lỗi");
}
}
}
public static int DeleteProfile(bangdiem b)
{
return(Dao.DeleteProfile(b));
}
public static int UpdateProfile(bangdiem b)
{
return(Dao.UpdateProfile(b));
}
public static int InsertProfile(bangdiem b)
{
return(Dao.InsertProfile(b));
}
public bool update(bangdiem lop)
{
return(bangdiemController.update(lop));
}
public bool delete(bangdiem lop)
{
return(bangdiemController.delete(lop));
}
public bool add(bangdiem lop)
{
return(bangdiemController.insert(lop));
}
