public bool UpdateHocSinh(HOCSINH hs, PHANLOP pl) { try { SQLDataContext.SQLData.sp_SuaThongtinHocSinh(hs.MAHS, hs.HOTEN, hs.GIOITINH, hs.NGAYSINH, hs.DIACHI, hs.EMAIL, hs.TONGIAO, hs.HOTENCHAC, hs.NGHENGHIEPCHA, hs.HOTENME, hs.NGHENGHIEPME, pl.MALOP, hs.IMAGEE); return(true); } catch { return(false); } }
public int ThemHocSinh(HOCSINH hs, PHANLOP pl) { try { var a = SQLDataContext.SQLData.sp_ThemHocSinh(hs.MAHS, hs.HOTEN, hs.GIOITINH, hs.NGAYSINH, hs.DIACHI, hs.EMAIL, hs.TONGIAO, hs.HOTENCHAC, hs.NGHENGHIEPCHA, hs.HOTENME, hs.NGHENGHIEPME, pl.MALOP, pl.MANAMHOC, pl.MAKHOI, hs.IMAGEE); return(int.Parse(a.ToString())); } catch { return(1); } }
private void btnSave_Click(object sender, EventArgs e) { if (cbbDesClass.Text != "" && cbbDesTerm.Text != "" && cbbDesGrade.Text != "") { foreach (DataGridViewRow _studentDesItem in dGVDes.Rows) { if (_studentDesItem.Cells[2].Value == null) { var _checkClassQuery = (from P in frmLogin._database.GetTable <PHANLOP>() where P.mahs == _studentDesItem.Cells[0].Value.ToString() select P).ToList(); if (_checkClassQuery.Count == 1) { _checkClassQuery[0].manh = _idDesTerm[cbbDesTerm.SelectedIndex]; _checkClassQuery[0].makl = _idDesGrade[cbbDesGrade.SelectedIndex]; _checkClassQuery[0].malop = _idDesClass[cbbDesClass.SelectedIndex]; } else { PHANLOP _newMember = new PHANLOP(); _newMember.mahs = _studentDesItem.Cells[0].Value.ToString(); _newMember.manh = _idDesTerm[cbbDesTerm.SelectedIndex]; _newMember.malop = _idDesClass[cbbDesClass.SelectedIndex]; _newMember.makl = _idDesGrade[cbbDesGrade.SelectedIndex]; frmLogin._database.PHANLOPs.InsertOnSubmit(_newMember); } } } try { frmLogin._database.SubmitChanges(); } catch (Exception Ex) { MessageBox.Show(Ex.Message); } } }