private void textBox8_TextChanged(object sender, EventArgs e)
{
NhanvienDataContext db = new NhanvienDataContext();
var q = db.NHANVIENs.Where(p => p.HOTEN.Contains(textBox8.Text)).Select(p => new { p.MANV, p.HOTEN, p.NGAYSINH, p.DIACHI, p.DIENTHOAI, p.HSLUONG, p.MADONVI });
dataGridView1.DataSource = q;
}
private void button5_Click(object sender, EventArgs e)
{
NhanvienDataContext db = new NhanvienDataContext();
var q = db.NHANVIENs.Select(p => new { p.MANV, p.HOTEN, p.NGAYSINH, p.DIACHI, p.DIENTHOAI, p.HSLUONG, p.MADONVI }).OrderByDescending(p => p.HOTEN);
dataGridView1.DataSource = q;
}
private void button3_Click(object sender, EventArgs e)
{
int dongchon = dataGridView1.CurrentCell.RowIndex;
NhanvienDataContext db = new NhanvienDataContext();
NHANVIEN q = db.NHANVIENs.Single(p => Convert.ToString(p.MANV) == dataGridView1.Rows[dongchon].Cells["MANV"].Value.ToString());
db.NHANVIENs.DeleteOnSubmit(q);
db.SubmitChanges();
load();
}
private void Form1_Load(object sender, EventArgs e)
{
NhanvienDataContext db = new NhanvienDataContext();
var q = db.NHANVIENs.Select(p => new { p.MANV, p.HOTEN, p.NGAYSINH, p.DIACHI, p.DIENTHOAI, p.HSLUONG, p.MADONVI, LUONG = p.HSLUONG * 1490000 });
var sum = db.NHANVIENs.Sum(p => p.HSLUONG * 1490000);
var c = db.DONVIs.Select(k => new { k.MADONVI });
dataGridView1.DataSource = q;
comboBox1.ValueMember = "MADONVI";
comboBox1.DataSource = c;
textBox7.Text = sum.ToString();
}
private void button2_Click(object sender, EventArgs e)
{
int dongchon = dataGridView1.CurrentCell.RowIndex;
NhanvienDataContext db = new NhanvienDataContext();
NHANVIEN q = db.NHANVIENs.Single(p => p.MANV == Convert.ToInt32(textBox1.Text));
q.MANV = Convert.ToInt32(textBox1.Text);
q.HOTEN = textBox2.Text;
q.NGAYSINH = textBox3.Text;
q.DIACHI = textBox4.Text;
q.DIENTHOAI = textBox5.Text;
q.HSLUONG = Convert.ToDouble(textBox6.Text);
q.MADONVI = Convert.ToInt32(comboBox1.Text);
db.SubmitChanges();
load();
}
private void button1_Click(object sender, EventArgs e)
{
NhanvienDataContext db = new NhanvienDataContext();
NHANVIEN dv = new NHANVIEN();
dv.MANV = Convert.ToInt32(textBox1.Text);
dv.HOTEN = textBox2.Text;
dv.NGAYSINH = textBox3.Text;
dv.DIACHI = textBox4.Text;
dv.DIENTHOAI = textBox5.Text;
dv.HSLUONG = Convert.ToDouble(textBox6.Text);
dv.MADONVI = Convert.ToInt32(comboBox1.Text);
db.NHANVIENs.InsertOnSubmit(dv);
db.SubmitChanges();
load();
}