private void btAdd_Click(object sender, EventArgs e) { DBQLSVDataContext db = new DBQLSVDataContext(); bool gender = false; if (radioMale.Checked) { gender = true; } var list_class = db.Lops.Select(l => l).Where(p => p.NameLop == boxClass_info.SelectedItem.ToString()); SV sv_add = new SV { MSSV = txtId.Text, Gender = gender, SVName = txtName.Text, IDLop = list_class.First().IDLop, Birthday = datePick.Value.Date, Tel = txtTel.Text, DTB = Convert.ToDouble(txtTB.Text), THPT = cbTHPT.Checked ? true:false, CMND = cbCMND.Checked ? true : false, HocBa = cbHB.Checked ? true : false }; db.SVs.InsertOnSubmit(sv_add); db.SubmitChanges(); View_Show.DataSource = db.SVs.Select(p => new { p.MSSV, p.SVName, p.Lop.NameLop, p.Birthday, p.Gender, p.DTB, p.Tel, p.THPT, p.HocBa, p.CMND }); }
private void btUpdate_Click(object sender, EventArgs e) { DBQLSVDataContext db = new DBQLSVDataContext(); string MSSV = txtId.Text; var sv_up = db.SVs.Where(p => p.MSSV == MSSV).FirstOrDefault(); var list_class = db.Lops.Select(l => l).Where(p => p.NameLop == boxClass_info.SelectedItem.ToString()); if (sv_up != null) { sv_up.Gender = radioMale.Checked ? true : false; sv_up.SVName = txtName.Text; sv_up.IDLop = list_class.First().IDLop; sv_up.Birthday = datePick.Value.Date; sv_up.Tel = txtTel.Text; sv_up.DTB = Convert.ToDouble(txtTB.Text); sv_up.THPT = cbTHPT.Checked ? true : false; sv_up.CMND = cbCMND.Checked ? true : false; sv_up.HocBa = cbHB.Checked ? true : false; } db.SubmitChanges(); View_Show.DataSource = db.SVs.Select(p => new { p.MSSV, p.SVName, p.Lop.NameLop, p.Birthday, p.Gender, p.DTB, p.Tel, p.THPT, p.HocBa, p.CMND }); }
private void btDelete_Click(object sender, EventArgs e) { DBQLSVDataContext db = new DBQLSVDataContext(); DataGridViewSelectedRowCollection r = View_Show.SelectedRows; if (r.Count > 0) { foreach (DataGridViewRow i in r) { string MSSV = null; MSSV = i.Cells["MSSV"].Value.ToString(); if (MSSV == null) { MessageBox.Show("Not found"); return; } var sv_del = db.SVs.Where(p => p.MSSV == MSSV).FirstOrDefault(); db.SVs.DeleteOnSubmit(sv_del); //Đồng bộ từ LINQ lên SQLServer db.SubmitChanges(); } View_Show.DataSource = db.SVs.Select(p => new { p.MSSV, p.SVName, p.Lop.NameLop, p.Birthday, p.Gender, p.DTB, p.Tel, p.THPT, p.HocBa, p.CMND }); } }