private void Btn_Save_Click(object sender, EventArgs e) { try { QUANLYNHANSUEntities db = new QUANLYNHANSUEntities(); LUONG luong = new LUONG(); luong.MaNV = (string)Cbb_Name.SelectedValue; luong.Luong1 = Convert.ToInt32(Txt_Salary.Text); luong.Nam = Txt_Year.Text; luong.PhuCap = Convert.ToInt32(Txt_Bonus.Text); luong.SoNgayCong = Convert.ToInt32(Txt_DayWorking.Text); luong.Thang = Txt_Month.Text; luong.SoGioLamThem = Convert.ToInt32(Txt_OverTime.Text); luong.GhiChu = Txt_Note.Text; luong.SoNgayNghi = Convert.ToInt32(Txt_DayOff.Text); luong.BaoHiem = Convert.ToInt32(Txt_Insurrance.Text); db.LUONGs.Add(luong); db.SaveChanges(); MessageBox.Show("Thêm Thành công"); this.Close(); } catch { MessageBox.Show("Nhập Sai, vui lòng nhập lại!"); } }
private void EditSalary_Load(object sender, EventArgs e) { LUONG luong = db.LUONGs.Single(l => l.MaNV == maNV); Txt_Bonus.Text = luong.PhuCap.ToString(); Txt_DayOff.Text = luong.SoNgayNghi.ToString(); Txt_DayWorking.Text = luong.SoNgayCong.ToString(); Txt_Insurrance.Text = luong.BaoHiem.ToString(); Txt_Month.Text = luong.Thang; Txt_Note.Text = luong.GhiChu; Txt_OverTime.Text = luong.SoGioLamThem.ToString(); Txt_Salary.Text = luong.Luong1.ToString(); Txt_Year.Text = luong.Nam; Txt_MaNV.Text = luong.MaNV; }
private void dELETEToolStripMenuItem_Click(object sender, EventArgs e) { if (Dtg_Salary.SelectedRows.Count == 1) { var row = Dtg_Salary.SelectedRows[0]; var cell = row.Cells["id"]; int id = (int)cell.Value; db = new QUANLYNHANSUEntities(); LUONG salary = db.LUONGs.Single(nv => nv.id == id); db.LUONGs.Remove(salary); db.SaveChanges(); MessageBox.Show("Xóa Thành công"); } else { MessageBox.Show("Mời bạn chọn 1 dòng"); } LoadSalary(); }
private void Btn_Save_Click(object sender, EventArgs e) { try { LUONG luong = db.LUONGs.Single(l => l.MaNV == maNV); luong.MaNV = Txt_MaNV.Text; luong.PhuCap = Convert.ToInt32(Txt_Bonus.Text); luong.Luong1 = Convert.ToInt32(Txt_Salary.Text); luong.Nam = Txt_Year.Text; luong.SoGioLamThem = Convert.ToInt32(Txt_OverTime.Text); luong.SoNgayCong = Convert.ToInt32(Txt_DayWorking.Text); luong.SoNgayNghi = Convert.ToInt32(Txt_DayOff.Text); luong.Thang = Txt_Month.Text; luong.GhiChu = Txt_Note.Text; luong.BaoHiem = Convert.ToInt32(Txt_Insurrance.Text); db.SaveChanges(); MessageBox.Show("EDIT OK"); this.Close(); } catch { MessageBox.Show("nhập sai,Vui lòng nhập lại!"); } }