private void btnEdit_Click(object sender, EventArgs e)
{
int ma = int.Parse(this.dataGridViewLuong.CurrentRow.Cells[0].Value.ToString());
luongnhanvien dt = db.luongnhanviens.Single(s => s.ma.Equals(ma));
if (this.tbxMaNV_L.Text.Length != 0)
{
dt.nhanvienma = tbxMaNV_L.Text;
}
if (this.tbxMaLCB.Text.Length != 0)
{
dt.luongcobanma = this.tbxMaLCB.Text;
}
if (this.tbxMaPC.Text.Length != 0)
{
dt.phucapma = this.tbxMaPC.Text;
}
if (this.tbxIDLuong.Text.Length != 0)
{
dt.ma = this.tbxIDLuong.Text;
}
if (this.tbxNgayCong.Text.Length != 0)
{
dt.SoNgayCong = Int32.Parse(tbxNgayCong.Text);
}
if (this.tbcGioLamThem.Text.Length != 0)
{
dt.SoGioLamThem = Int32.Parse(tbcGioLamThem.Text);
}
if (this.tbxThuong.Text.Length != 0)
{
dt.Thuong = Int32.Parse(tbxThuong.Text);
}
if (this.tbxTamUng.Text.Length != 0)
{
dt.TamUng = Int32.Parse(tbxTamUng.Text);
}
dt.NgayLap = DateTime.Parse(dtpkNgayLapLuong.Text);
db.SaveChanges();
}
private void btnDel_Click(object sender, EventArgs e)
{
String ma = this.dataGridViewLuong.CurrentRow.Cells[0].Value.ToString();
DialogResult dr = MessageBox.Show("Are you sure?", "Confirm", MessageBoxButtons.YesNo);
if (dr == System.Windows.Forms.DialogResult.Yes)
{
try
{
luongnhanvien h = db.luongnhanviens.Single(s => s.ma.Equals(ma));
db.luongnhanviens.Remove(h);
db.SaveChanges();
MessageBox.Show("Delete Success");
}
catch
{
MessageBox.Show("Delete fail!!");
}
}
Save();
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
luongnhanvien luongnv = new luongnhanvien();
luongnv.nhanvienma = this.tbxMaNV_L.Text;
luongnv.ma = this.tbxIDLuong.Text;
luongnv.phucapma = this.tbxMaPC.Text;
luongnv.luongcobanma = this.tbxMaLCB.Text;
luongnv.SoNgayCong = Int32.Parse(tbxNgayCong.Text);
luongnv.SoGioLamThem = Int32.Parse(tbcGioLamThem.Text);
luongnv.Thuong = Int32.Parse(tbxThuong.Text);
luongnv.TamUng = Int32.Parse(tbxTamUng.Text);
db.luongnhanviens.Add(luongnv);
MessageBox.Show("Thêm Thành Công!!!");
}
catch
{
MessageBox.Show("Thêm Thất bại!!");
}
Save();
}