private frmEmp GetEmp()
{
frmEmp emp = new frmEmp();
emp.emp_id = int.Parse(txtEmpID.Text);
emp.empcode = txtEmpCode.Text;
emp.emp_lnkh = txtKh1.Text;
emp.emp_fnkh = txtKh2.Text;
emp.emp_lnen = txtEn1.Text;
emp.emp_fnen = txtEn2.Text;
emp.gender = cbBGender.SelectedItem.ToString();
emp.idcard = txtIDCard.Text;
emp.address = rtxtAddress2.Text;
emp.phone = txtPhone.Text;
emp.email = txtEmail.Text;
emp.pos_id = Helper.ifnull(cbBPos.SelectedValue)?0: Convert.ToInt32(cbBPos.SelectedValue);
emp.salary = Helper.ifnull(txtSalary.Text) ? 0 : Convert.ToInt32(txtSalary.Text);
emp.join_date = Join_date.Text;
MemoryStream mem = new MemoryStream();
if (extensionImg == "jpg")
{
pictureBox1.Image.Save(mem, System.Drawing.Imaging.ImageFormat.Jpeg);
}
else
{
pictureBox1.Image.Save(mem, System.Drawing.Imaging.ImageFormat.Png);
}
emp.img = mem.ToArray();
return(emp);
}
public object InsertScalar(frmEmp emp)
{
return(base.ExecScalar("INSERT INTO " +
"Employee(emplnkh, empfnkh, emplnen, empfnen, gender, idcard, address, phone, email, posid, salary, joindate) " +
"OUTPUT INSERTED.empid VALUES(@emplnkh, @empfnkh, @emplnen, @empfnen, @gender, @idcard, @address, @phone, @email, @posid, @salary, @joindate)",
GetParameter(emp)));
}
public int Insert(frmEmp emp)
{
return(base.ExecNonQuery("INSERT INTO " +
"Employee(emplnkh, empfnkh, emplnen, empfnen, gender, idcard, address, phone, email, posid, salary, joindate,Image) " +
"VALUES(@emplnkh, @empfnkh, @emplnen, @empfnen, @gender, @idcard, @address, @phone, @email, @posid, @salary, @joindate,convert(Varbinary(max),@img))",
GetParameter(emp)));
}
private frmEmp GetEmp()
{
frmEmp emp = new frmEmp();
emp.emp_id = int.Parse(txtEmpID.Text);
emp.empcode = txtEmpCode.Text;
emp.emp_lnkh = txtKh1.Text;
emp.emp_fnkh = txtKh2.Text;
emp.emp_lnen = txtEn1.Text;
emp.emp_fnen = txtEn2.Text;
emp.gender = cbBGender.SelectedItem.ToString();
emp.idcard = txtIDCard.Text;
emp.address = rtxtAddress.Text;
emp.phone = txtPhone.Text;
emp.email = txtEmail.Text;
emp.pos_id = Convert.ToInt32(txtPosID.Text);
emp.salary = Convert.ToInt32(txtSalary.Text);
emp.join_date = Join_date.Text;
return(emp);
}
public SqlParameter[] GetParameter(frmEmp emp)
{
SqlParameter[] param = new SqlParameter[15];
param[0] = new SqlParameter("empid", emp.emp_id);
param[1] = new SqlParameter("empcode", emp.empcode);
param[2] = new SqlParameter("emplnkh", emp.emp_lnkh);
param[3] = new SqlParameter("empfnkh", emp.emp_fnkh);
param[4] = new SqlParameter("emplnen", emp.emp_lnen);
param[5] = new SqlParameter("empfnen", emp.emp_fnen);
param[6] = new SqlParameter("gender", emp.gender);
param[7] = new SqlParameter("idcard", emp.idcard);
param[8] = new SqlParameter("address", emp.address);
param[9] = new SqlParameter("phone", emp.phone);
param[10] = new SqlParameter("email", emp.email);
param[11] = new SqlParameter("posid", emp.pos_id);
param[12] = new SqlParameter("salary", emp.salary);
param[13] = new SqlParameter("joindate", emp.join_date);
param[14] = new SqlParameter("@img", emp.img);
return(param);
}
public int Update(frmEmp emp)
{
return(base.ExecNonQuery("UPDATE Employee " +
"SET emplnkh=@emplnkh, empfnkh=@empfnkh, emplnen=@emplnen, empfnen=@empfnen, gender=@gender, idcard=@idcard, address=@address, phone=@phone, email=@email, posid=@posid, salary=@salary, joindate=@joindate,Image=Convert(varbinary(max),@img)" +
"WHERE empid=@empid", GetParameter(emp)));
}
