public List <Entity.NhanVien> NhanVien_GetByTop(string Top, string Where, string Order)
{
List <Entity.NhanVien> list = new List <Entity.NhanVien>();
using (SqlCommand dbCmd = new SqlCommand("sp_NhanVien_GetByTop", GetConnection()))
{
Entity.NhanVien obj = new Entity.NhanVien();
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@Top", Top));
dbCmd.Parameters.Add(new SqlParameter("@Where", Where));
dbCmd.Parameters.Add(new SqlParameter("@Order", Order));
SqlDataReader dr = dbCmd.ExecuteReader();
dr.Close();
dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.NhanVienIDataReader(dr));
}
}
dr.Close();
obj = null;
}
return(list);
}
public Entity.NhanVien NhanVienIDataReader(IDataReader dr)
{
Entity.NhanVien obj = new Entity.NhanVien();
obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString();
obj.TenNV = (dr["TenNV"] is DBNull) ? string.Empty : dr["TenNV"].ToString();
obj.NgaySinh = (dr["NgaySinh"] is DBNull) ? string.Empty : dr["NgaySinh"].ToString();
obj.Gioitinh = (dr["Gioitinh"] is DBNull) ? string.Empty : dr["Gioitinh"].ToString();
obj.ChucVu = (dr["ChucVu"] is DBNull) ? string.Empty : dr["ChucVu"].ToString();
obj.Id_quyen = (dr["Id_quyen"] is DBNull) ? string.Empty : dr["Id_quyen"].ToString();
obj.UserName = (dr["UserName"] is DBNull) ? string.Empty : dr["UserName"].ToString();
obj.Password = (dr["Password"] is DBNull) ? string.Empty : dr["Password"].ToString();
return(obj);
}
private void btnAdd_Click(object sender, EventArgs e)
{
//// Bước 1: kiểm tra dữ liệu
//if (txtId.Text.Trim() == "")
//{
// MessageBox.Show("Bạn phải nhập mã sinh viên","Thông báo");
// ActiveControl = txtId;
// return;
//}
//DateTime date = dtpBirth.Value;
//int _ID = 0;
//int _Luong = 0;
//_Luong = Convert.ToInt32(txtPay.Text.Trim());
//_ID = Convert.ToInt16(txtId.Text.Trim());
////Bước 2: tạo đối tượng
//Entity.NhanVien objNhanvien = new Entity.NhanVien();
//objNhanvien.ID = _ID;
//objNhanvien.Hoten = txtName.Text.Trim();
//objNhanvien.Quequan = txtAddress.Text.Trim();
//objNhanvien.Chucvu = txtJob.Text.Trim();
//objNhanvien.Luong = _Luong;
//objNhanvien.Ngaysinh = date;
//// Bước 3 chèn danh sách
//string[] str = new string[7];
//str[0] = objNhanvien.ID.ToString();
//str[1] = objNhanvien.Hoten;
//if (cbMales.CheckState == CheckState.Checked)
//{
// cbFemales.CheckState = CheckState.Unchecked;
// str[2] = "Nam";
//}
//if (cbFemales.CheckState == CheckState.Checked)
//{
// cbMales.CheckState = CheckState.Unchecked;
// str[2] = "Nữ";
//}
//str[3] = objNhanvien.Ngaysinh.ToString();
//str[4] = objNhanvien.Quequan;
//str[5] = objNhanvien.Luong.ToString();
//str[6] = objNhanvien.Chucvu;
//ListViewItem item = new ListViewItem(str);
//lsvEmployee.Items.Add(item);
//lsvEmployee.Refresh();
if (txtId.Text.Trim() == "")
{
MessageBox.Show("Bạn phải nhập mã PB", "Thông báo");
ActiveControl = txtId;
return;
}
Entity.NhanVien objNhanvien = new Entity.NhanVien();
if (cbMales.CheckState == CheckState.Checked)
{
//cbFemales.CheckState = CheckState.Unchecked;
objNhanvien.Gioitinh = "Nam";
}
if (cbFemales.CheckState == CheckState.Checked)
{
//cbMales.CheckState = CheckState.Unchecked;
objNhanvien.Gioitinh = "Nữ";
}
string query = "INSERT INTO NHANVIEN(MaNV,HoTen,NgaySinh,GioiTinh,QueQuan,ChucVu,Luong,MaPB,MaKhu,MaTro)" +
" VALUES('" + txtId.Text + "', N'" + txtName.Text + "','" + dtpBirth.Value.ToString("MM/dd/yyyy") +
"','" + objNhanvien + "','" + txtAddress.Text + "','" + txtJob.Text + "','" + txtPay.Text + "','" + txtIdDpm.Text + "','" + txtIdGround.Text + "','" + txtIdGame.Text + "')";
DataProvider.Instance.ExecuteNonQuery(query);
query = "SELECT * FROM NHANVIEN";
dtgEmployee.DataSource = DataProvider.Instance.ExecuteQuery(query);
dtgEmployee.Refresh();
}
