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