public NhanSu getNhanVien(DataRow row)
{
NhanSu nv = new NhanSu();
nv.ma = row["ma"].ToString().Trim();
nv.ten = row["ten"].ToString().Trim();
int gt = 1;
if (int.TryParse(row["gioitinh"].ToString().Trim(), out gt))
{
nv.gioitinh = gt;
}
DateTime ns = new DateTime();
if (DateTime.TryParse(row["ngaysinh"].ToString().Trim(), out ns))
{
nv.ngaysinh = ns;
}
nv.diachi = row["diachi"].ToString().Trim();
nv.socmnd = row["socmnd"].ToString().Trim();
nv.dienthoai = row["dienthoai"].ToString().Trim();
nv.email = row["email"].ToString().Trim();
nv.maChucVu = row["chucvu"].ToString().Trim();
nv.maluong = row["maluong"].ToString().Trim();
nv.maphongban = row["phongban"].ToString().Trim();
nv.maTDHV = row["TDHV"].ToString().Trim();
return(nv);
}
public bool Update(NhanSu ns)
{
string sql = "update nhanvien ";
sql += " set ";
sql += " hoten = @hoten, ngaysinh = @ngaysinh, quequan = @quequan, gioitinh = @gioitinh, dantoc = @dantoc, sodienthoai = @sodienthoai, taikhoan = @taikhoan, luongcoban = @luong, chucvuma = @chucvu, phongbanma = @phongban, trinhdohocvanma = @hocvan ";
sql += " where ma like @ma ";
Dictionary <string, object> para = new Dictionary <string, object>();
para.Add("@ma", ns.Ma);
para.Add("@hoten", ns.HoTen);
para.Add("@ngaysinh", ns.NgaySinh);
para.Add("@quequan", ns.QueQuan);
para.Add("@gioitinh", ns.GioiTinh);
para.Add("@dantoc", ns.DanToc);
para.Add("@sodienthoai", ns.SoDienThoai);
para.Add("@taikhoan", ns.TaiKhoan);
para.Add("@luong", ns.LuongConBan);
para.Add("@chucvu", ns.ChuVuMa);
para.Add("@phongban", ns.PhongBanMa);
para.Add("@hocvan", ns.HocVanMa);
return(DataProvider.Instance.InsertUpdateDelete(sql, para, false));
}
public ActionResult Create([FromBody] NhanSuInsert c)
{
try
{
NhanSu nhanSu = new NhanSu();
nhanSu.DiaChiCQ = c.diaChiCq;
nhanSu.DiaChiNR = c.diaChiNr;
nhanSu.DienThoai = c.dienThoai;
if (c.gioiTinh != null)
{
nhanSu.GioiTinh = Convert.ToBoolean(c.gioiTinh);
}
nhanSu.Ten = c.ten;
nhanSu.MaNhanSu = c.maNhanSu;
nhanSu.MaPhong = c.maPhong;
if (!string.IsNullOrEmpty(c.ngaySinh))
{
nhanSu.NgaySinh = Convert.ToDateTime(c.ngaySinh);
}
nhansuRepo.Create(nhanSu);
return(Json(c));
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
}
return(View(c));
}
public bool Insert(NhanSu ns)
{
string sql = "insert into nhanvien ";
sql += " (ma, hoten, ngaysinh, quequan, gioitinh, dantoc, sodienthoai, taikhoan, luongcoban, chucvuma, phongbanma, trinhdohocvanma) ";
sql += " values ";
sql += " ( @ma, @hoten, @ngaysinh, @quequan, @gioitinh, @dantoc, @sodienthoai, @taikhoan, @luong, @chucvu, @phongban, @hocvan )";
Dictionary <string, object> para = new Dictionary <string, object>();
para.Add("@ma", ns.Ma);
para.Add("@hoten", ns.HoTen);
para.Add("@ngaysinh", ns.NgaySinh);
para.Add("@quequan", ns.QueQuan);
para.Add("@gioitinh", ns.GioiTinh);
para.Add("@dantoc", ns.DanToc);
para.Add("@sodienthoai", ns.SoDienThoai);
para.Add("@taikhoan", ns.TaiKhoan);
para.Add("@luong", ns.LuongConBan);
para.Add("@chucvu", ns.ChuVuMa);
para.Add("@phongban", ns.PhongBanMa);
para.Add("@hocvan", ns.HocVanMa);
return(DataProvider.Instance.InsertUpdateDelete(sql, para, false));
}
private void btnThem_Click(object sender, EventArgs e)
{
if (checkAdd())
{
NhanSu nv = new NhanSu();
nv.ten = txtten.Text.ToString().Trim();
nv.ngaysinh = DateTime.Parse(dtpngaysinh.Value.ToShortDateString());
if (rdbnam.Checked)
{
nv.gioitinh = 1;
}
else
{
nv.gioitinh = 0;
}
nv.diachi = txtdiachi.Text.ToString().Trim();
nv.socmnd = txtsocmnd.Text.ToString().Trim();
nv.dienthoai = txtdienthoai.Text.ToString().Trim();
nv.email = txtemali.Text.ToString().Trim();
nv.maChucVu = cbbmachucvu.SelectedValue.ToString().Trim();
nv.maluong = cbbmaluong.SelectedValue.ToString().Trim();
nv.maphongban = cbbmaphongban.SelectedValue.ToString().Trim();
nv.maTDHV = cbbmatdhv.SelectedValue.ToString().Trim();
if (control.Them(nv))
{
this.Close();
this.form1.Visible = true;
}
}
}
private void comboBoxMaNhanVien_SelectedIndexChanged(object sender, EventArgs e)
{
NhanSu nhanSu = khenThuongController.Show_1_NhanSu(comboBoxMaNhanVien.Text);
textBoxHoTen.Text = nhanSu.HoTenNV;
textBoxNgaySinh.Text = nhanSu.NgaySinh.ToShortDateString();
textBoxGioiTinh.Text = nhanSu.GioiTinh;
textBoxChucVu.Text = nhanSu.ChucVu;
textBoxBoPhan.Text = nhanSu.BoPhan;
textBoxPhongban.Text = nhanSu.PhongBan;
}
public ActionResult Update([FromBody] NhanSu c)
{
try
{
if (ModelState.IsValid)
{
nhansuRepo.Update(c);
return(Json(c));
}
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
}
return(View(c));
}
public void SuaNhanVien(string manv, string hoten, string hinhanh, string gioitinh, string chucvu,
DateTime ngaysinh, string diachi, string sdt, Decimal luongnv)
{
NhanSu ns = new NhanSu();
ns.MaNV = manv;
ns.HoTen = hoten;
ns.HinhAnh = hinhanh;
ns.GioiTinh = gioitinh;
ns.ChucVu = chucvu;
ns.NgaySinh = ngaysinh;
ns.DiaChi = diachi;
ns.SDT = sdt;
ns.Luong = luongnv;
nv.SuaNhanVien(ns);
}
public NhanSu[] getListNhanVienPB(string str)
{
DataTable table = da.Query("select *from NhanVien where maphongban=(select ma from PhongBan where ten=N'" + str + "')");
int n = table.Rows.Count;
int i;
if (n == 0)
{
return(null);
}
NhanSu[] list = new NhanSu[n];
for (i = 0; i < n; i++)
{
list[i] = getNhanVienTK(table.Rows[i]);
}
return(list);
}
public NhanSu[] getListNhanVienMa(string str)
{
DataTable table = da.Query("select *from NhanVien where ma like'" + str + "%'");
int n = table.Rows.Count;
int i;
if (n == 0)
{
return(null);
}
NhanSu[] list = new NhanSu[n];
for (i = 0; i < n; i++)
{
list[i] = getNhanVienTK(table.Rows[i]);
}
return(list);
}
public NhanSu Show_1_NhanSu(string maNV)
{
DataTable dt = DataProvider.Instance.ExecuteQuery("" +
"select MaNV,HoTenNV,NgaySinh,GioiTinh,ChucVu,BoPhan,MaPhongBan " +
"from HoSoNhanSu " +
$"where MaNV = {maNV}");
DataRow dr = dt.Rows[0];
NhanSu nhanSu = new NhanSu(
dr[0].ToString(),
dr[1].ToString(),
Convert.ToDateTime(dr[2].ToString()),
dr[3].ToString(),
dr[4].ToString(),
dr[5].ToString(),
DataProvider.Instance.ExecuteScalar($"select TenPB from PhongBan where MaPhongBan = '{dr[6]}'").ToString());
return(nhanSu);
}
public bool Them(NhanSu nv)
{
SqlParameter[] para =
{
new SqlParameter("ten", nv.ten),
new SqlParameter("ngaysinh", nv.ngaysinh),
new SqlParameter("gioitinh", nv.gioitinh),
new SqlParameter("diachi", nv.diachi),
new SqlParameter("socmnd", nv.socmnd),
new SqlParameter("dienthoai", nv.dienthoai),
new SqlParameter("email", nv.email),
new SqlParameter("maChucVu", getCode(nv.maChucVu, "ten", "chucvu")),
new SqlParameter("maluong", nv.maluong),
new SqlParameter("maphongban", getCode(nv.maphongban,"ten", "phongban")),
new SqlParameter("maTDHV", getCode(nv.maTDHV, "ten", "TrinhDoHocVan")),
};
da.Query("proc_insertNV", para);
return(true);
}
public bool insertNhanSu(NhanSu ns)
{
string query = " insert into NhanSu ";
query += " (ten, ngaysinh, anhdaidien, gioitinh, taikhoan, matkhau, quanly) ";
query += " values (@ten, @ngaysinh, @anhdaidien, @gioitinh, @taikhoan, @matkhau, @quanly) ";
Dictionary <string, object> paras = new Dictionary <string, object>();
paras.Add("@ten", ns.Hoten);
paras.Add("@ngaysinh", ns.Ngaysinh);
paras.Add("@anhdaidien", ns.Anhdaidien);
paras.Add("@gioitinh", ns.Gioitinh);
paras.Add("@taikhoan", ns.Taikhoan);
paras.Add("@matkhau", ns.Matkhau);
paras.Add("@quanly", ns.Quanly);
return(DBConnect.Instance.InsertUpdateDelete(query, paras));
}
public bool updateNhanSu(NhanSu ns)
{
string query = " update NhanSu ";
query += " set ten = @ten, ngaysinh = @ngaysinh, ";
query += " gioitinh = @gioitinh, taikhoan = @taikhoan, matkhau = @matkhau, quanly = @quanly ";
query += " where id = @ma";
Dictionary <string, object> paras = new Dictionary <string, object>();
paras.Add("@ma", ns.Ma);
paras.Add("@ten", ns.Hoten);
paras.Add("@ngaysinh", ns.Ngaysinh);
paras.Add("@gioitinh", ns.Gioitinh);
paras.Add("@taikhoan", ns.Taikhoan);
paras.Add("@matkhau", ns.Matkhau);
paras.Add("@quanly", ns.Quanly);
return(DBConnect.Instance.InsertUpdateDelete(query, paras));
}
public List <NhanSu> LayNhanVien()
{
List <NhanSu> listemp = new List <NhanSu>();
var lstemp = db.spNhanSu_SelectAll().ToList();
foreach (var n in lstemp)
{
NhanSu e = new NhanSu()
{
MaNV = n.MaNV,
HoTen = n.HoTen,
HinhAnh = n.HinhAnh,
GioiTinh = n.GioiTinh,
ChucVu = n.ChucVu,
NgaySinh = n.NgaySinh,
DiaChi = n.DiaChi,
SDT = n.SDT,
Luong = n.Luong
};
listemp.Add(e);
}
return(listemp);
}
public List <NhanSu> LayMaNhanVien(string manv)
{
List <NhanSu> listns = new List <NhanSu>();
var lstns = db.spNhanSu_SelectID(manv).ToList();
foreach (var n in lstns)
{
NhanSu ns = new NhanSu()
{
MaNV = n.MaNV,
HoTen = n.HoTen,
HinhAnh = n.HinhAnh,
GioiTinh = n.GioiTinh,
ChucVu = n.ChucVu,
NgaySinh = n.NgaySinh,
DiaChi = n.DiaChi,
SDT = n.SDT,
Luong = n.Luong
};
listns.Add(ns);
}
return(listns);
}
public NhanSu[] getListNhanVien()
{
// DataTable table = da.Query("Select *from NhanVien");
DataTable table = da.Query("select nv.ma, nv.ten, nv.ngaysinh, nv.gioitinh, nv.diachi,nv.socmnd, nv.dienthoai, "
+ " nv.email, cv.ten as chucvu, pb.ten as phongban, nv.maluong, tdhv.ten as TDHV from NhanVien nv "
+ " inner join ChucVu cv on nv.maChucVu = cv.ma inner join PhongBan pb on nv.maphongban = pb.ma "
+ " inner join TrinhDoHocVan tdhv on tdhv.ma = nv.maTDHV");
int n = table.Rows.Count;
int i;
if (n == 0)
{
return(null);
}
NhanSu[] list = new NhanSu[n];
for (i = 0; i < n; i++)
{
list[i] = getNhanVien(table.Rows[i]);
//list[i].gioitinh = (bool)table.Rows[0]["gioitinh"];
}
return(list);
}
public static DataTable LayNS(string manv)
{
return(NhanSu.LayNS(manv));
}
public static void SuaNS(NhanSu_DTO ns)
{
NhanSu.Sua(ns);
}
public static void XoaNS(string ma)
{
NhanSu.Xoa(ma);
}
public static void ThemNS(NhanSu_DTO ns, TaiKhoanDTO tk)
{
tk.Password = taoChuoiMD5(tk.Password);
NhanSu.Them(ns, tk);
}
public static DataTable LoadDataNS()
{
return(NhanSu.LoadData());
}
public bool Update(NhanSu ns)
{
return(NhanSuDAO.Instance.Update(ns));
}
public void ThemNhanVien(NhanSu ns)
{
db.spNhanSu_Insert(ns.MaNV, ns.HoTen, ns.HinhAnh, ns.GioiTinh, ns.ChucVu, ns.NgaySinh, ns.DiaChi, ns.SDT, ns.Luong);
}
public void SuaNhanVien(NhanSu ns)
{
db.spNhanSu_Update(ns.MaNV, ns.HoTen, ns.HinhAnh, ns.GioiTinh, ns.ChucVu, ns.NgaySinh, ns.DiaChi, ns.SDT, ns.Luong);
}
public bool Insert(NhanSu ns)
{
return(NhanSuDAO.Instance.Insert(ns));
}