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