private void BtnEdit_Click(object sender, EventArgs e)
{
NhanVienDTO nv = getInfo();
int id = Convert.ToInt32(txtID.Text);
if (nhanvien.EditEmployee(nv, id) > 0)
{
LoadData();
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
if (IsNullValue())
{
MessageBox.Show("Không thể thêm nhân viên với tên rỗng!", "Thông Báo", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
}
else
{
NhanVienDTO nv = getInfo();
if (nhanvien.AddEmployee(nv) > 0)
{
LoadData();
}
}
}
public int AddEmployee(NhanVienDTO E)
{
string query = "insert into NhanVien values(@name,@gioi_tinh,@ngay_sinh,@ngay_lam_viec,@dia_chi,@dien_thoai,@luong,@phu_cap)";
SqlParameter para1 = new SqlParameter("@name", E.name);
SqlParameter para2 = new SqlParameter("@ngay_sinh", E.birthDay);
SqlParameter para3 = new SqlParameter("@ngay_lam_viec", E.startDay);
SqlParameter para4 = new SqlParameter("@dia_chi", E.address);
SqlParameter para5 = new SqlParameter("@dien_thoai", E.phoneNumber);
SqlParameter para6 = new SqlParameter("@luong", E.salary);
SqlParameter para7 = new SqlParameter("@phu_cap", E.bonus);
SqlParameter para8 = new SqlParameter("@gioi_tinh", E.gender);
SqlParameter[] parameters = { para1, para2, para3, para4, para5, para6, para7, para8 };
int status = DataAccess.Instance.ExecuteNonQuery(query, parameters);
return(status);
}
private NhanVienDTO getInfo()
{
string address = cbAddress.Text;
bool isMale = true ? radMale.Checked : false;
string name = txtName.Text;
DateTime birthDay = dtpBirthday.Value;
DateTime dayOfWork = dtpWorkDay.Value;
string phoneNumber = mskPhoneNumber.Text;
int bonus = Convert.ToInt32(cbOTMoney.Text);
double salary = Convert.ToDouble(mskSalary.Text);
if (salary < 0)
{
salary = 0;
}
NhanVienDTO nv = new NhanVienDTO(name, isMale, birthDay, dayOfWork, address, phoneNumber, salary, bonus);
return(nv);
}
public int EditEmployee(NhanVienDTO E, int id)
{
string query = "USP_Update @id, @ten, @gioi_tinh, @ngay_sinh, @ngay_lam_viec, @dia_chi, @dien_thoai, @luong, @phu_cap";
SqlParameter para0 = new SqlParameter("@id", id);
SqlParameter para1 = new SqlParameter("@ten", E.name);
SqlParameter para2 = new SqlParameter("@ngay_sinh", E.birthDay);
SqlParameter para3 = new SqlParameter("@ngay_lam_viec", E.startDay);
SqlParameter para4 = new SqlParameter("@dia_chi", E.address);
SqlParameter para5 = new SqlParameter("@dien_thoai", E.phoneNumber);
SqlParameter para6 = new SqlParameter("@luong", E.salary);
SqlParameter para7 = new SqlParameter("@phu_cap", E.bonus);
SqlParameter para8 = new SqlParameter("@gioi_tinh", E.gender);
SqlParameter[] parameters = { para0, para1, para2, para3, para4, para5, para6, para7, para8 };
int status = DataAccess.Instance.ExecuteNonQuery(query, parameters);
return(status);
}
