public static BHXH.Data.ListBangCap New(string MaBangCap, string TenBangCap)
{
if (MaBangCap == "" || TenBangCap == "")
{
return(null);
}
if (IsExisted(MaBangCap, TenBangCap) != null)
{
return(IsExisted(MaBangCap, TenBangCap));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListBangCap n = new Data.ListBangCap();
n.MaBangCap = MaBangCap;
n.TenBangCap = TenBangCap;
ctx.ListBangCap.Add(n);
try
{
ctx.SaveChanges();
ctx.Dispose();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.ListTDQLNN New(string MaTDQLNN, string TenTDQLNN)
{
if (MaTDQLNN == "" || TenTDQLNN == "")
{
return(null);
}
if (IsExisted(MaTDQLNN, TenTDQLNN) != null)
{
return(IsExisted(MaTDQLNN, TenTDQLNN));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListTDQLNN n = new Data.ListTDQLNN();
n.MaTDQLNN = MaTDQLNN;
n.TenTDQLNN = TenTDQLNN;
ctx.ListTDQLNN.Add(n);
try
{
ctx.SaveChanges();
ctx.Dispose();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.ListQuanHuyen New(string MaQuanHuyen, string TenQuanHuyen)
{
if (MaQuanHuyen == "" || TenQuanHuyen == "")
{
return(null);
}
if (IsExisted(MaQuanHuyen, TenQuanHuyen) != null)
{
return(IsExisted(MaQuanHuyen, TenQuanHuyen));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListQuanHuyen n = new Data.ListQuanHuyen();
n.MaQuanHuyen = MaQuanHuyen;
n.TenQuanHuyen = TenQuanHuyen;
ctx.ListQuanHuyen.Add(n);
try
{
ctx.SaveChanges();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.ListDienCS New(string MaDienCS, string TenDienCS)
{
if (MaDienCS == "" || TenDienCS == "")
{
return(null);
}
if (IsExisted(MaDienCS, TenDienCS) != null)
{
return(IsExisted(MaDienCS, TenDienCS));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListDienCS n = new Data.ListDienCS();
n.MaDienCS = MaDienCS;
n.TenDienCS = TenDienCS;
ctx.ListDienCS.Add(n);
try
{
ctx.SaveChanges();
ctx.Dispose();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.HrQuaTrinhCongTac New(string MaNhanVien, int STT, string ThoiGian, string CongViec)
{
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.HrQuaTrinhCongTac n = new Data.HrQuaTrinhCongTac();
n.MaNhanVien = new Guid(MaNhanVien);
n.STT = STT;
n.ThoiGian = ThoiGian;
n.CongViec = CongViec;
n.QuaTrinhCongTacID = Guid.NewGuid();
ctx.HrQuaTrinhCongTac.Add(n);
try
{
ctx.SaveChanges();
ctx.Dispose();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
BHXH.HR.UI.Report.rptLyLich2C cr1 = new BHXH.HR.UI.Report.rptLyLich2C();
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
var result = (from a in ctx.HrNhanVien
join b in ctx.HrChiTietDaoTao on a.MaNhanVien equals b.MaNhanVien
join c in ctx.HrQuaTrinhCongTac on a.MaNhanVien equals c.MaNhanVien
where a.MaNhanVien.ToString() == BHXH.HR.UI.frmHrNhanVien.bientoancuc.MaNhanVien.ToString()
select new
{
a.TenNhanVien,
a.SoHieuNV
}
).ToList();
if (result == null)
{
MessageBox.Show("null");
}
else
{
cr1.Load(@"rptLyLich2C.rpt");
cr1.SetDataSource(result);
crystalReportViewer1.ReportSource = cr1;
}
}
public static BHXH.Data.ListDanToc New(string MaDanToc, string TenDanToc)
{
if (MaDanToc == "" || TenDanToc == "")
{
return(null);
}
if (IsExisted(MaDanToc, TenDanToc) != null)
{
return(IsExisted(MaDanToc, TenDanToc));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListDanToc n = new Data.ListDanToc();
n.MaDanToc = MaDanToc;
n.TenDanToc = TenDanToc;
ctx.ListDanToc.Add(n);
try
{
ctx.SaveChanges();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.ListLoaiTB New(string MaLoaiTB, string TenLoaiTB)
{
if (MaLoaiTB == "" || TenLoaiTB == "")
{
return(null);
}
if (IsExisted(MaLoaiTB, TenLoaiTB) != null)
{
return(IsExisted(MaLoaiTB, TenLoaiTB));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListLoaiTB n = new Data.ListLoaiTB();
n.MaLoaiTB = MaLoaiTB;
n.TenLoaiTB = TenLoaiTB;
ctx.ListLoaiTB.Add(n);
try
{
ctx.SaveChanges();
ctx.Dispose();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BindingSource GetDataReport(string data)
{
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
var query = (from a in ctx.HrNhanVien
join b in ctx.HrChiTietDaoTao on a.MaNhanVien equals b.MaNhanVien
join c in ctx.ListCMDaoTao on b.MaCMDaoTao equals c.MaCMDaoTao
join d in ctx.ListLHDaoTao on b.MaLHDaoTao equals d.MaLHDaoTao
join e in ctx.ListBangCap on b.MaBangCap equals e.MaBangCap
where a.MaNhanVien.ToString() == data
orderby b.STT ascending
select new
{
a.MaNhanVien,
b.STT,
b.NganhHoc,
c.TenCMDaoTao,
b.TenTruong,
b.ThoiGian,
d.TenLHDaoTao,
e.TenBangCap,
b.XepLoai,
b.QuaTrinhDaoTaoID
}
).ToList();
BindingSource bs = new BindingSource();
bs.DataSource = query;
return(bs);
}
public static BHXH.Data.HrQuanHeGiaDinh New(string MaNhanVien, int STT, string MaQuanHeGD, string HoTen, string NamSinh, string ChiTiet)
{
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.HrQuanHeGiaDinh n = new Data.HrQuanHeGiaDinh();
n.MaNhanVien = new Guid(MaNhanVien);
n.STT = STT;
n.MaQuanHeGD = MaQuanHeGD;
n.HoTen = HoTen;
n.NamSinh = NamSinh;
n.QuanHeGiaDinhID = Guid.NewGuid();
ctx.HrQuanHeGiaDinh.Add(n);
try
{
ctx.SaveChanges();
ctx.Dispose();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.ListTDVanHoa New(string MaTDVanHoa, string TenTDVanHoa)
{
if (MaTDVanHoa == "" || TenTDVanHoa == "")
{
return(null);
}
if (IsExisted(MaTDVanHoa, TenTDVanHoa) != null)
{
return(IsExisted(MaTDVanHoa, TenTDVanHoa));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListTDVanHoa n = new Data.ListTDVanHoa();
n.MaTDVanHoa = MaTDVanHoa;
n.TenTDVanHoa = TenTDVanHoa;
ctx.ListTDVanHoa.Add(n);
try
{
ctx.SaveChanges();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.HrKhenThuongKyLuat New(string MaNhanVien, int STT, string MaKTKL, string Nam, string GhiChu)
{
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.HrKhenThuongKyLuat n = new Data.HrKhenThuongKyLuat();
n.MaNhanVien = new Guid(MaNhanVien);
n.STT = STT;
n.MaKTKL = MaKTKL;;
n.Nam = Nam;
n.GhiChu = GhiChu;
n.KhenThuongKyLuatID = Guid.NewGuid();
ctx.HrKhenThuongKyLuat.Add(n);
try
{
ctx.SaveChanges();
ctx.Dispose();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.ListChucVuDang New(string MaChucVu, string TenChucVu)
{
if (MaChucVu == "" || TenChucVu == "")
{
return(null);
}
if (IsExisted(MaChucVu, TenChucVu) != null)
{
return(IsExisted(MaChucVu, TenChucVu));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListChucVuDang n = new Data.ListChucVuDang();
n.MaChucVu = MaChucVu;
n.TenChucVu = TenChucVu;
ctx.ListChucVuDang.Add(n);
try
{
ctx.SaveChanges();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.ListChiBo New(string MaChiBo, string TenChiBo)
{
if (MaChiBo == "" || TenChiBo == "")
{
return(null);
}
if (IsExisted(MaChiBo, TenChiBo) != null)
{
return(IsExisted(MaChiBo, TenChiBo));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListChiBo n = new Data.ListChiBo();
n.MaChiBo = MaChiBo;
n.TenChiBo = TenChiBo;
ctx.ListChiBo.Add(n);
try
{
ctx.SaveChanges();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
/// <summary>
/// Tạo mới user
/// </summary>
/// <param name="UserID"></param>
/// <param name="NhanVienID"></param>
/// <param name=""></param>
/// <returns></returns>
public static BHXH.Data.SysUser NewUser(Guid MaNhanVien, string UserID, string Password, bool IsActive) // Nam tự thêm các tham số
{
if (UserID == "" || Password == "")
{
return(null);
}
if (IsExisted(UserID) != null)
{
return(IsExisted(UserID));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.SysUser n = new Data.SysUser();
n.UserID = UserID;
n.Pwd = Password;
n.MaNhanVien = MaNhanVien;
n.CreatedDate = DateTime.Now;
n.IsActive = true;
ctx.SysUser.Add(n);
try
{
ctx.SaveChanges();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.ListPhongBan New(string MaPhongBan, string TenPhongBan)
{
if (MaPhongBan == "" || TenPhongBan == "")
{
return(null);
}
if (IsExisted(MaPhongBan, TenPhongBan) != null)
{
return(IsExisted(MaPhongBan, TenPhongBan));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListPhongBan n = new Data.ListPhongBan();
n.MaPhongBan = MaPhongBan;
n.TenPhongBan = TenPhongBan;
ctx.ListPhongBan.Add(n);
try
{
ctx.SaveChanges();
ctx.Dispose();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.ListTDLLCT New(string MaTDLLCT, string TenTDLLCT)
{
if (MaTDLLCT == "" || TenTDLLCT == "")
return null;
if (IsExisted(MaTDLLCT, TenTDLLCT) != null)
return IsExisted(MaTDLLCT, TenTDLLCT);
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListTDLLCT n = new Data.ListTDLLCT();
n.MaTDLLCT = MaTDLLCT;
n.TenTDLLCT = TenTDLLCT;
ctx.ListTDLLCT.Add(n);
try
{
ctx.SaveChanges();
return n;
}
catch (Exception)
{
return null;
}
finally
{ }
}
public static BHXH.Data.ListCMDaoTao New(string MaCMDaoTao, string TenCMDaoTao, string LoaiCMDaoTao)
{
if (MaCMDaoTao == "" || TenCMDaoTao == "" || LoaiCMDaoTao == "")
{
return(null);
}
if (IsExisted(MaCMDaoTao, TenCMDaoTao, LoaiCMDaoTao) != null)
{
return(IsExisted(MaCMDaoTao, TenCMDaoTao, LoaiCMDaoTao));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListCMDaoTao n = new Data.ListCMDaoTao();
n.MaCMDaoTao = MaCMDaoTao;
n.TenCMDaoTao = TenCMDaoTao;
n.LoaiCMDaoTao = LoaiCMDaoTao;
ctx.ListCMDaoTao.Add(n);
try
{
ctx.SaveChanges();
ctx.Dispose();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.ListQuocGia New(string MaQuocGia, string TenQuocGia)
{
if (MaQuocGia == "" || TenQuocGia == "")
{
return(null);
}
if (IsExisted(MaQuocGia, TenQuocGia) != null)
{
return(IsExisted(MaQuocGia, TenQuocGia));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListQuocGia n = new Data.ListQuocGia();
n.MaQuocGia = MaQuocGia;
n.TenQuocGia = TenQuocGia;
ctx.ListQuocGia.Add(n);
try
{
ctx.SaveChanges();
ctx.Dispose();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.ListTinh New(string MaTinh, string TenTinh)
{
if (MaTinh == "" || TenTinh == "")
{
return(null);
}
if (IsExisted(MaTinh, TenTinh) != null)
{
return(IsExisted(MaTinh, TenTinh));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListTinh n = new Data.ListTinh();
n.MaTinh = MaTinh;
n.TenTinh = TenTinh;
ctx.ListTinh.Add(n);
try
{
ctx.SaveChanges();
ctx.Dispose();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
//public static BHXH.Data.ListXaPhuong New(int XaPhuongID, string MaXaPhuong, string TenXaPhuong, int QuanHuyenID)
//{
//if (MaXaPhuong == "" || TenXaPhuong == "" || XaPhuongID ==0 || QuanHuyenID == 0)
// return null;
//if (IsExisted( XaPhuongID, MaXaPhuong, TenXaPhuong, QuanHuyenID) != null)
// return IsExisted(XaPhuongID, MaXaPhuong, TenXaPhuong, QuanHuyenID);
// BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
//BHXH.Data.ListXaPhuong n = new Data.ListXaPhuong();
//n.XaPhuongID = XaPhuongID;
//n.MaXaPhuong = MaXaPhuong;
//n.TenXaPhuong = TenXaPhuong;
//n.QuanHuyenID = QuanHuyenID;
//ctx.ListXaPhuong.Add(n);
//try
//{
// ctx.SaveChanges();
// return n;
//}
//catch (Exception)
//{
// return null;
//}
//finally
//{ }
//}
//public static void Edit(int XaPhuongID, string MaXaPhuong, string TenXaPhuong, int QuanHuyenID)
//{
// BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
// var query = from c in ctx.ListXaPhuong
// where c.XaPhuongID == XaPhuongID
// select c;
// BHXH.Data.ListXaPhuong n = query.First();
// n.MaXaPhuong = MaXaPhuong;
// n.TenXaPhuong = TenXaPhuong;
// try
// {
// ctx.SaveChanges();
// }
// finally
// { }
//}
//public static Data.ListXaPhuong IsExisted(int XaPhuongID, string MaXaPhuong, string TenXaPhuong, int QuanHuyenID)
//{
// BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
// var query = from c in ctx.ListXaPhuong
// where c.XaPhuongID == XaPhuongID && c.TenXaPhuong == TenXaPhuong
// select c;
// if (query.Count() > 0)
// return query.First();
// else
// return null;
//}
//public static void Delete(int XaPhuongID)
//{
// BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
// Data.ListXaPhuong obj = GetData(XaPhuongID);
// ctx.ListXaPhuong.Attach(obj);
// ctx.ListXaPhuong.Remove(obj);
// ctx.SaveChanges();
//}
public static BHXH.Data.ListXaPhuong GetData(int XaPhuongID)
{
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
return(ctx.ListXaPhuong.SingleOrDefault(x => x.XaPhuongID == XaPhuongID));
}
public static BHXH.Data.ListHopDong New(string MaHopDong, string TenHopDong, string LoaiHopDong)
{
if (MaHopDong == "" || TenHopDong == "" || LoaiHopDong == "")
{
return(null);
}
if (IsExisted(MaHopDong, TenHopDong, LoaiHopDong) != null)
{
return(IsExisted(MaHopDong, TenHopDong, LoaiHopDong));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListHopDong n = new Data.ListHopDong();
n.MaHopDong = MaHopDong;
n.TenHopDong = TenHopDong;
n.LoaiHopDong = LoaiHopDong;
ctx.ListHopDong.Add(n);
try
{
ctx.SaveChanges();
ctx.Dispose();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.ListKTKL New(string MaKTKL, string TenKTKL, string LoaiKTKL)
{
if (MaKTKL == "" || TenKTKL == "" || LoaiKTKL == "")
{
return(null);
}
if (IsExisted(MaKTKL, TenKTKL, LoaiKTKL) != null)
{
return(IsExisted(MaKTKL, TenKTKL, LoaiKTKL));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListKTKL n = new Data.ListKTKL();
n.MaKTKL = MaKTKL;
n.TenKTKL = TenKTKL;
n.LoaiKTKL = LoaiKTKL;
ctx.ListKTKL.Add(n);
try
{
ctx.SaveChanges();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.ListTDNgoaiNgu New(string MaTDNgoaiNgu, string TenTDNgoaiNgu)
{
if (MaTDNgoaiNgu == "" || TenTDNgoaiNgu == "")
{
return(null);
}
if (IsExisted(MaTDNgoaiNgu, TenTDNgoaiNgu) != null)
{
return(IsExisted(MaTDNgoaiNgu, TenTDNgoaiNgu));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListTDNgoaiNgu n = new Data.ListTDNgoaiNgu();
n.MaTDNgoaiNgu = MaTDNgoaiNgu;
n.TenTDNgoaiNgu = TenTDNgoaiNgu;
ctx.ListTDNgoaiNgu.Add(n);
try
{
ctx.SaveChanges();
ctx.Dispose();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.ListQuanHeGD New(string MaQuanHeGD, string TenQuanHeGD)
{
if (MaQuanHeGD == "" || TenQuanHeGD == "")
{
return(null);
}
if (IsExisted(MaQuanHeGD, TenQuanHeGD) != null)
{
return(IsExisted(MaQuanHeGD, TenQuanHeGD));
}
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
BHXH.Data.ListQuanHeGD n = new Data.ListQuanHeGD();
n.MaQuanHeGD = MaQuanHeGD;
n.TenQuanHeGD = TenQuanHeGD;
ctx.ListQuanHeGD.Add(n);
try
{
ctx.SaveChanges();
return(n);
}
catch (Exception)
{
return(null);
}
finally
{ }
}
public static BHXH.Data.ListTinh GetTinh(string MaTinh)
{
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
ctx.Dispose();
return(ctx.ListTinh.SingleOrDefault(x => x.MaTinh == MaTinh));
// return query.ToList().First();
}
public static BHXH.Data.HrThangBangLuong GetTenNgach(string MaNgach)
{
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
var query = from c in ctx.HrThangBangLuong
where c.MaNgach.ToString() == MaNgach.ToString()
select c;
return(query.ToList().First());
}
public static BHXH.Data.ListLHDaoTao GetData(string MaLHDaoTao)
{
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
var query = from c in ctx.ListLHDaoTao
where c.MaLHDaoTao == MaLHDaoTao
select c;
return(query.ToList().First());
}
public static BHXH.Data.ListKTKL GetData(string MaKTKL)
{
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
var query = from c in ctx.ListKTKL
where c.MaKTKL == MaKTKL
select c;
return(query.ToList().First());
}
public static BHXH.Data.ListQuanHeGD GetData(string MaQuanHeGD)
{
BHXH.Data.BHXHEntities ctx = new Data.BHXHEntities();
var query = from c in ctx.ListQuanHeGD
where c.MaQuanHeGD == MaQuanHeGD
select c;
return(query.ToList().First());
}
