public bool updateUser(ST_employee em, Int64 id)
{
var boolUpdate = _userDao.updateUser(em, id);
if (boolUpdate)
{
return(true);
}
else
{
return(false);
}
}
public Int64 insertUser(ST_employee em)
{
try
{
db.ST_employees.InsertOnSubmit(em);
db.SubmitChanges( );
Int64 id = Int64.Parse(em.employee_id.ToString( ));
return(id);
}
catch {
return(0);
}
}
public bool updateUser(ST_employee em, Int64 id)
{
try{
var user = (from b in db.ST_employees
where b.employee_id == id
select b).Single();
if (user != null)
{
user.employee_username = em.employee_username;
user.employee_password = em.employee_password;
user.employee_name = em.employee_name;
user.employee_phone = em.employee_phone;
user.employee_status = em.employee_status;
user.employee_image = em.employee_image;
user.employee_gender = em.employee_gender;
user.employee_date_of_birth = em.employee_date_of_birth;
user.employee_address = em.employee_address;
user.employee_bank_account_number = em.employee_bank_account_number;
user.department_id = em.department_id;
user.permission_id = em.permission_id;
user.employee_created_date = em.employee_created_date;
db.SubmitChanges( );
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public Int64 insertUser(ST_employee em)
{
return(_userDao.insertUser(em));
}
private void btn_Update_Click(object sender, EventArgs e)
{
Int64 idUser = 0;
if (user_id == 0)
{
idUser = frm_Main.Vitual_id;
}
else
{
idUser = user_id;
}
var user = userBus.getUserByID(idUser);
var _username = txt_UserName.Text;
var _password = txt_Pass.Text;
var _name = txt_Name.Text;
var _add = txt_Address.Text;
var _phone = txt_Phone.Text;
var _email = txt_Email.Text;
var _bank = txt_BankNumber.Text;
var _gender = gender;
var _status = check;
if (idDeparment == 0)
{
messeage.error("Bạn chưa chọn chức vụ !");
}
else
{
//user name
if (txt_UserName.Text == "")
{
messeage.error("Bạn nhập tên đăng nhập !");
}
else
{
//pass
if (txt_Pass.Text == "")
{
messeage.error("Bạn chưa nhập mật khẩu !");
}
else
{
ST_employee employee = new ST_employee
{
employee_name = _name,
employee_username = _username,
employee_password = _password,
employee_address = _add,
employee_phone = _phone,
employee_email = _email,
employee_bank_account_number = _bank,
employee_status = _status,
employee_gender = gender,
department_id = idDeparment,
};
if (dt_DateOfBirth.Text != "")
{
var dateS = Convert.ToDateTime(dt_DateOfBirth.Text).ToString("dd-MM-yyyy hh:mm:ss");
var dateT = Convert.ToDateTime(dateS);
employee.employee_date_of_birth = dateT;
}
if (linkImage != "")
{
employee.employee_image = imageToByteArray(pic_Logo.Image);
}
var id = userBus.updateUser(employee, idUser);
if (id)
{
messeage.success("Cập nhật thành công !");
}
else
{
messeage.error("Cập nhật thất bại !");
//reset
}
}
}
}
}
private void btn_New_Click(object sender, EventArgs e)
{
var _username = txt_UserName.Text;
var _password = txt_Pass.Text;
var _name = txt_Name.Text;
var _add = txt_Address.Text;
var _phone = txt_Phone.Text;
var _email = txt_Email.Text;
var _bank = txt_BankNumber.Text;
var _gender = gender;
var _status = check;
//DateTime dt5 = date.ToDateTime( );
if (idDeparment == 0)
{
messeage.error("Bạn chưa chọn chức vụ !");
}
else
{
//user name
if (txt_UserName.Text == "")
{
messeage.error("Bạn nhập tên đăng nhập !");
}
else
{
//pass
if (txt_Pass.Text == "")
{
messeage.error("Bạn chưa nhập mật khẩu !");
}
else
{
ST_employee employee = new ST_employee
{
employee_name = _name,
employee_username = _username,
employee_password = _password,
employee_address = _add,
employee_phone = _phone,
employee_email = _email,
employee_bank_account_number = _bank,
employee_status = _status,
employee_gender = _gender,
department_id = idDeparment,
employee_created_date = DateTime.Now
};
if (dt_DateOfBirth.Text != "")
{
var dateS = dt_DateOfBirth.Text;
var dateT = Convert.ToDateTime(dateS);
employee.employee_date_of_birth = dateT;
}
if (linkImage != "")
{
employee.employee_image = imageToByteArray(pic_Logo.Image);
}
var id = userBus.insertUser(employee);
if (id > 0)
{
messeage.success("Thêm mới thành công !");
resetForm();
//reset
linkImage = "";
gender = false;
check = false;
idDeparment = 0;
}
else
{
messeage.error("Thêm mới thất bại !");
//reset
linkImage = "";
gender = false;
check = false;
idDeparment = 0;
}
}
}
}
}
