public List <CongNhan> ViewCongNhan(string sql)
{
try
{
List <CongNhan> list = new List <CongNhan>();
SqlDataReader dr = p.View(sql);
if (dr != null)
{
string MaCN, Ho, Ten, NoiSinh, DanToc, TonGiao, QueQuan, DCThuongTru, NoiOHienNay, Email, TTHonNhan, MaCV, NoiLamViec, TrinhDoVanHoa, MaHeSoLuong, MaPhuCap, TaiKhoanNganHang, NoiCapCMND,
Hinh, QuocTich, MaBHYT, MaBHXH, GioiTinh, CMND, DienThoaiNha, DienThoaiDD, TinhTrang;
DateTime NgayTuyenDung, NgayCapCMND, NgaySinh;
while (dr.Read())
{
MaCN = dr.GetString(0);
Ho = dr.GetString(1);
Ten = dr.GetString(2);
GioiTinh = dr.GetString(3);
NgaySinh = dr.GetDateTime(4);
NoiSinh = dr.GetString(5);
CMND = dr.GetString(6);
DanToc = dr.GetString(7);
TonGiao = dr.GetString(8);
QueQuan = dr.GetString(9);
DCThuongTru = dr.GetString(10);
NoiOHienNay = dr.GetString(11);
DienThoaiNha = dr.GetString(12);
DienThoaiDD = dr.GetString(13);
Email = dr.GetString(14);
TTHonNhan = dr.GetString(15);
NgayTuyenDung = dr.GetDateTime(16);
NoiLamViec = dr.GetString(17);
TrinhDoVanHoa = dr.GetString(18);
MaHeSoLuong = dr.GetString(19);
MaCV = dr.GetString(31);
MaPhuCap = dr.GetString(21);
TaiKhoanNganHang = dr.GetString(22);
NgayCapCMND = dr.GetDateTime(23);
NoiCapCMND = dr.GetString(24);
Hinh = dr.GetString(25);
TinhTrang = dr.GetString(26);
QuocTich = dr.GetString(27);
MaBHYT = dr.GetString(28);
MaBHXH = dr.GetString(29);
CongNhan congnhan = new CongNhan(MaCN, Ho, Ten, GioiTinh, NgaySinh, NoiSinh,
CMND, DanToc, TonGiao, QueQuan, DCThuongTru, NoiOHienNay,
DienThoaiNha, DienThoaiDD, Email, TTHonNhan, NgayTuyenDung,
NoiLamViec, TrinhDoVanHoa, MaCV, MaHeSoLuong, MaPhuCap, TaiKhoanNganHang,
NoiCapCMND, NgayCapCMND, Hinh, TinhTrang, QuocTich,
MaBHYT, MaBHXH);
list.Add(congnhan);
}
dr.Close();
}
return(list);
}
catch (SqlException p)
{
throw p;
}
}
public CongNhanViewModel(CongNhan congnhan)
{
Id = congnhan.ID;
Name = congnhan.Name;
Address = congnhan.Address;
Phone = congnhan.Phone;
Hobbit = congnhan.Hobbit;
Birth = congnhan.Birth;
Gender = congnhan.Gender;
}
public int UpdateCongNhan(CongNhan cn)
{
try
{
return(new Congnhan().UpdateCongNhan(cn));
}
catch (Exception p)
{
throw p;
}
}
/// <summary>Subscribe message Events.CongNhanUpdated from FormCongNhanViewModel.</summary>
/// <param name="source">The source.</param>
/// <param name="congnhan">The congnhan.</param>
/// <Modified>
/// Name Date Comments
/// quangnt2 16/03/2020 created
/// </Modified>
private void OnContactUpdated(FormCongNhanViewModel source, CongNhan congnhan)
{
var item = CongNhans.Single(c => c.Id == congnhan.ID);
item.Id = congnhan.ID;
item.Name = congnhan.Name;
item.Address = congnhan.Address;
item.Phone = congnhan.Phone;
item.Hobbit = congnhan.Hobbit;
item.Birth = congnhan.Birth;
item.Gender = congnhan.Gender;
}
private void btThem_CN_Click(object sender, EventArgs e)
{
if (txtHo.Text == "" || txtTen.Text == "" || cbGioitinh.Text == "" || dtNgaysinh.Value == null || txtNoisinh.Text == "" || txtCmnd.Text == "" || txtDantoc.Text == "" || txttongiao.Text == "" || txtQuequan.Text == "" || txtSonha.Text == "" || txtNoiOHien.Text == "" || txtSDTN.Text == "" || txtSDT.Text == "" || txtEmail.Text == "" || cbhonnhan.Text == "" || dtNgay.Value == null || txtNoilamviec.Text == "" || txtTrinhdoVH.Text == "" || txtMaCN_CC.Text == "" || txtMahesoluong.Text == "" || txtPhuCap.Text == "" || txtTKnganhang.Text == "" || txtNoicap.Text == "" || dtNgaycap.Value == null || picCongnhan.ImageLocation == "" || txtQuoctich.Text == "" || txtMaBHXH.Text == "" || txtMaBHYT.Text == "")
{
MessageBox.Show("Không có dữ liệu để thêm", "Thông báo");
return;
}
CongNhan cn = new CongNhan(txtMaCN_CN.Text, txtHo.Text, txtTen.Text, cbGioitinh.Text, dtNgaysinh.Value, txtNoisinh.Text, txtCmnd.Text, txtDantoc.Text, txttongiao.Text, txtQuequan.Text, txtSonha.Text, txtNoiOHien.Text, txtSDTN.Text, txtSDT.Text, txtEmail.Text, cbhonnhan.Text, dtNgay.Value, txtNoilamviec.Text, txtTrinhdoVH.Text, txtMaCN_CC.Text, txtMahesoluong.Text, txtPhuCap.Text, txtTKnganhang.Text, txtNoicap.Text, dtNgaycap.Value, picCongnhan.ImageLocation, "1", txtQuoctich.Text, txtMaBHXH.Text, txtMaBHYT.Text);
try
{
cnb.AddCongNhan(cn);
}
catch (Exception p)
{
MessageBox.Show(p.ToString());
}
}
private void btThem_CN_Click(object sender, EventArgs e)
{
if (txtHoCN.Text == "" || txtTenCN.Text == "" || cbGioitinh.Text == "" || dtNgaysinh.Value == null || txtNoisinh.Text == "" || txtCMND.Text == "" || txtDantoc.Text == "" || txttongiao.Text == "" || txtQuequan.Text == "" || txtSonha.Text == "" || txtNoiOHien.Text == "" || txtSDTN.Text == "" || txtSDT.Text == "" || txtEmail.Text == "" || cbTTHonnhan.Text == "" || dtNgaycap.Value == null || txtNoiLV.Text == "" || txtTrinhdoVH.Text == "" || txtMaCN.Text == "" || txtMahesoluong.Text == "" || txtPhuCap.Text == "" || txtTKNganhang.Text == "" || txtNoicap.Text == "" || dtNgaycap.Value == null || picCN.ImageLocation == "" || txtQuoctich.Text == "" || txtBHXH.Text == "" || txtBHYT.Text == "")
{
MessageBox.Show("Lỗi!! Vui lòng nhập thông tin");
return;
}
CongNhan cn = new CongNhan(txtMaCN.Text, txtHoCN.Text, txtTenCN.Text, cbGioitinh.Text, dtNgaysinh.Value, txtNoisinh.Text, txtCMND.Text, txtDantoc.Text, txttongiao.Text, txtQuequan.Text, txtSonha.Text, txtNoiOHien.Text, txtSDTN.Text, txtSDT.Text, txtEmail.Text, cbTTHonnhan.Text, dtNgaytuyendung.Value, txtNoiLV.Text, txtTrinhdoVH.Text, cbChucvu.Text, txtMahesoluong.Text, txtPhuCap.Text, txtTKNganhang.Text, txtNoicap.Text, dtNgaycap.Value, picCN.ImageLocation, "1", txtQuoctich.Text, txtBHXH.Text, txtBHYT.Text);
CongnhanBUS cnb = new CongnhanBUS();
try
{
cnb.AddCongNhan(cn);
}
catch (Exception p)
{
MessageBox.Show(p.ToString());
}
}
public int UpdateCongNhan(CongNhan congnhan)
{
List <SqlParameter> paras = new List <SqlParameter>();
paras.Add(new SqlParameter("@macn", congnhan.MaCN));
paras.Add(new SqlParameter("@ho", congnhan.Ho));
paras.Add(new SqlParameter("@ten", congnhan.Ten));
paras.Add(new SqlParameter("@gioitinh", congnhan.GioiTinh));
paras.Add(new SqlParameter("@ngaysinh", congnhan.NgaySinh));
paras.Add(new SqlParameter("@noisinh", congnhan.NoiSinh));
paras.Add(new SqlParameter("@cmnd", congnhan.CMND));
paras.Add(new SqlParameter("@dantoc", congnhan.DanToc));
paras.Add(new SqlParameter("@tongiao", congnhan.TonGiao));
paras.Add(new SqlParameter("@quequan", congnhan.QueQuan));
paras.Add(new SqlParameter("@dcthuongtru", congnhan.DCThuongTru));
paras.Add(new SqlParameter("@noiohiennay", congnhan.NoiOHienNay));
paras.Add(new SqlParameter("@dienthoainha", congnhan.DienThoaiNha));
paras.Add(new SqlParameter("@dienthoaidd", congnhan.DienThoaiDD));
paras.Add(new SqlParameter("@email", congnhan.Email));
paras.Add(new SqlParameter("@ttranghonnhan", congnhan.TTHonNhan));
paras.Add(new SqlParameter("@ngaytuyendung", congnhan.NgayTuyenDung));
paras.Add(new SqlParameter("@noilamviec", congnhan.NoiLamViec));
paras.Add(new SqlParameter("@trinhdovanhoa", congnhan.TrinhDoVanHoa));
paras.Add(new SqlParameter("@mahesoluong", congnhan.MaHeSoLuong));
paras.Add(new SqlParameter("@machucvu", congnhan.MaCV));
paras.Add(new SqlParameter("@maphucap", congnhan.MaPhuCap));
paras.Add(new SqlParameter("@taikhoangnganhang", congnhan.TaiKhoanNganHang));
paras.Add(new SqlParameter("@ngaycapcmnd", congnhan.NgayCapCMND));
paras.Add(new SqlParameter("@noicapcmnd", congnhan.NoiCapCMND));
paras.Add(new SqlParameter("@hinh", congnhan.Hinh));
paras.Add(new SqlParameter("@tinhtranglamviec", congnhan.TinhTrang));
paras.Add(new SqlParameter("@quoctich", congnhan.QuocTich));
paras.Add(new SqlParameter("@mabhyt", congnhan.MaBHYT));
paras.Add(new SqlParameter("@mabhxh", congnhan.MaBHXH));
try
{
return(p.ExecNonQuery("updatecongnhan", CommandType.StoredProcedure, paras));
}
catch (SqlException p)
{
throw p;
}
}
/// <summary>Initializes service, Command.</summary>
/// <param name="viewModel">The view model.</param>
/// <param name="congNhanService">The cong nhan service.</param>
/// <param name="pageService">The page service.</param>
/// <exception cref="ArgumentNullException">viewModel</exception>
/// <Modified>
/// Name Date Comments
/// quangnt2 16/03/2020 created
/// </Modified>
public FormCongNhanViewModel(CongNhanViewModel viewModel, ICongNhanService congNhanService, IPageService pageService)
{
if (viewModel == null)
{
throw new ArgumentNullException(nameof(viewModel));
}
_pageService = pageService;
_congnhanService = congNhanService;
SaveCommand = new Command(async() => await Save());
CongNhan = new CongNhan()
{
ID = viewModel.Id,
Name = viewModel.Name,
Address = viewModel.Address,
Phone = viewModel.Phone,
Hobbit = viewModel.Hobbit,
Birth = viewModel.Id > 0 ? viewModel.Birth : DateTime.Now,
Gender = viewModel.Gender
};
}
public int AddCongNhan(CongNhan cn)
{
switch (cn.MaCV)
{
case "Giám đốc":
cn.MaCV = "CV01";
break;
case "Phó Giám Đốc":
cn.MaCV = "CV02";
break;
case "Tổ Trưởng":
cn.MaCV = "CV03";
break;
case "Tổ Phó":
cn.MaCV = "CV04";
break;
case "Công Nhân":
cn.MaCV = "CV05";
break;
case "Công Nhân Thời Vụ":
cn.MaCV = "CV06";
break;
}
try
{
return(new Congnhan().AddCongNhan(cn));
}
catch (Exception p)
{
throw p;
}
}
/// <summary>Subscribe message Events.CongNhanAdded from FormCongNhanViewModel.</summary>
/// <param name="source">The source.</param>
/// <param name="congnhan">The congnhan.</param>
/// <Modified>
/// Name Date Comments
/// quangnt2 16/03/2020 created
/// </Modified>
private void OnContactAdded(FormCongNhanViewModel source, CongNhan congnhan)
{
CongNhans.Add(new CongNhanViewModel(congnhan));
}
/// <summary>Update item.</summary>
/// <param name="congnhan">The congnhan.</param>
/// <Modified>
/// Name Date Comments
/// quangnt2 16/03/2020 created
/// </Modified>
public async Task UpdateCongNhan(CongNhan congnhan)
{
await _connection.UpdateAsync(congnhan);
}
/// <summary>Add item.</summary>
/// <param name="congnhan">The congnhan.</param>
/// <Modified>
/// Name Date Comments
/// quangnt2 16/03/2020 created
/// </Modified>
public async Task AddCongNhan(CongNhan congnhan)
{
await _connection.InsertAsync(congnhan);
}
/// <summary>Delte item.</summary>
/// <param name="congnhan">The congnhan.</param>
/// <Modified>
/// Name Date Comments
/// quangnt2 16/03/2020 created
/// </Modified>
public async Task DeleteCongNhan(CongNhan congnhan)
{
await _connection.DeleteAsync(congnhan);
}
