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 });
}
}
