public List <DTONhanVien> GetNV(string sql)
{
dp.connect();
List <DTONhanVien> list = new List <DTONhanVien>();
{
string ma, ho, ten, cmnd, dc, sdt, gt, bc;
DateTime ngaysinh;
try
{
SqlDataReader dr = dp.ExecuteReader(sql);
while (dr.Read())
{
ma = dr.GetString(0);
ho = dr.GetString(1);
ten = dr.GetString(2);
ngaysinh = dr.GetDateTime(3);
gt = dr.GetString(4);
cmnd = dr.GetString(5);
dc = dr.GetString(7);
sdt = dr.GetString(6);
bc = dr.GetString(8);
DTONhanVien nv = new DTONhanVien(ma, ho, ten, ngaysinh, gt, cmnd, sdt, dc, bc);
list.Add(nv);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally { dp.disconnect(); }
}
}
private void btThemNV_Click(object sender, EventArgs e)
{
string ma, ho, ten, cmnd, dc, sdt, gt, bc; DateTime ngaysinh;
ma = txtMaNV.Text.Trim();
ho = txtHoNV.Text.Trim();
ten = txtTenNV.Text.Trim();
ngaysinh = Convert.ToDateTime(dtpNgaySinh.Text);
cmnd = txtCMND.Text.Trim();
sdt = txtSDT.Text.Trim();
dc = txtDiaChi.Text.Trim();
gt = txtGioiTinh.Text.Trim();
bc = txtBangCap.Text.Trim();
DTONhanVien nv = new DTONhanVien(ma, ho, ten, ngaysinh, gt, cmnd, sdt, dc, bc);
try
{
int i = new BUSNhanVien().Add(nv);
dgvNhanVien.DataSource = GetNV();
load();
XoaNV();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
tabControl1.SelectedTab = tabControl1.TabPages[3];
}
public bool Edit(DTONhanVien nv)
{
SqlParameter[] sqlP = new SqlParameter[8];
sqlP[0] = new SqlParameter("@MaNV", nv.MaNV);
sqlP[1] = new SqlParameter("@TenNV", nv.TenNV);
sqlP[2] = new SqlParameter("@GioiTinh", nv.GioiTinh);
sqlP[3] = new SqlParameter("@NgaySinh", nv.NgaySinh);
sqlP[4] = new SqlParameter("@DiaChi", nv.DiaChi);
sqlP[5] = new SqlParameter("@DienThoai", nv.DienThoai);
sqlP[6] = new SqlParameter("@MaCa", nv.MaCa);
sqlP[7] = new SqlParameter("@MaCV", nv.MaCV);
return(dalGeneric.execNonQuery("updateNhanVien", sqlP));
}
public int Add(DTONhanVien nv)
{
List <SqlParameter> paras = new List <SqlParameter>();
paras.Add(new SqlParameter("@ma", nv.MaNV));
paras.Add(new SqlParameter("@ho", nv.Ho));
paras.Add(new SqlParameter("@ten", nv.Ten));
paras.Add(new SqlParameter("@ngaysinh", nv.NgaySinh));
paras.Add(new SqlParameter("@gt", nv.SDT));
paras.Add(new SqlParameter("@cmnd", nv.CMND));
paras.Add(new SqlParameter("@sdt", nv.SDT));
paras.Add(new SqlParameter("@dc", nv.DiaChi));
paras.Add(new SqlParameter("@bc", nv.BangCap));
try
{
return(dp.ExcuteNonQuery("ThemNV", System.Data.CommandType.StoredProcedure, paras));
}
catch (SqlException ex)
{
throw ex;
}
}
public static bool Edit(DTONhanVien nv)
{
return(dalNhanVien.Edit(nv));
}
public static bool Add(DTONhanVien nv)
{
return(dalNhanVien.Add(nv));
}
public int Add(DTONhanVien nv)
{
return(new DAONhanVien().Add(nv));
}
