public static void Initialize(MyData context) { context.Database.EnsureCreated(); if (context.NhanViens.Any()) { return; } context.SaveChanges(); }
public static void Initialize(MyData context) { context.Database.EnsureCreated(); if (context.NhanViens.Any()) { return; } context.Accounts.AddRange(new List <Account>() { new Account() { AccountId = "nv00000", TaiKhoan = "*****@*****.**", MatKhau = "123", Quyen = 0 } }); context.PhongBans.AddRange(new List <PhongBan>() { new PhongBan() { PhongBanId = "null", TenPhongBan = "Admin", SDTPhongBan = "Admin", TrangThai = 1 }, new PhongBan() { PhongBanId = "pb00001", TenPhongBan = "Phòng ban 1", SDTPhongBan = "0935444555", TrangThai = 1 } }); context.CongViecs.AddRange(new List <CongViec>() { new CongViec() { CongViecId = "congviec1", TenCongViec = "Phân tích dữ liệu" }, new CongViec() { CongViecId = "congviec2", TenCongViec = "Lập trình" }, new CongViec() { CongViecId = "congviec3", TenCongViec = "Kiểm thử phần mềm" }, new CongViec() { CongViecId = "congviec4", TenCongViec = "Hỗ trợ kỹ thuật" }, }); context.TrangThaiChamCongs.AddRange(new List <TrangThaiChamCong>() { new TrangThaiChamCong() { TrangThaiChamCongId = "tt1", TenTrangThai = "Làm việc", HSTrangThai = 0 }, new TrangThaiChamCong() { TrangThaiChamCongId = "tt2", TenTrangThai = "Nghỉ phép", HSTrangThai = 0.7 }, new TrangThaiChamCong() { TrangThaiChamCongId = "tt3", TenTrangThai = "Nghỉ không phép", HSTrangThai = 1 }, new TrangThaiChamCong() { TrangThaiChamCongId = "tt4", TenTrangThai = "Nghỉ bệnh", HSTrangThai = 0.5 }, }); context.DuAns.AddRange(new List <DuAn>() { new DuAn() { DuAnId = "da00000", TenDuAn = "", PhanTramDuAn = 0, ThuongDuAn = "0", NgayBatDau = new DateTime(2000, 1, 1), NgayKetThuc = new DateTime(2000, 1, 1), TrangThai = 0, }, }); context.ChucVus.AddRange(new List <ChucVu>() { new ChucVu() { ChucVuId = "chucvu1", TenChucVu = "Trưởng phòng ban", HSChucVu = 0.5, TienPhuCapChucVu = "500000", }, new ChucVu() { ChucVuId = "chucvu2", TenChucVu = "Phó phòng ban", HSChucVu = 0.3, TienPhuCapChucVu = "300000", }, new ChucVu() { ChucVuId = "chucvu3", TenChucVu = "Nhân viên", HSChucVu = 0.1, TienPhuCapChucVu = "100000", }, }); context.PhuCaps.AddRange(new List <PhuCap>() { new PhuCap() { PhuCapId = "pc00000", TenPhuCap = "Admin", TienPhuCap = "0", TrangThai = 0, }, }); context.NhanViens.AddRange(new List <NhanVien>() { new NhanVien() { NhanVienId = "nv00000", HoNhanVien = "", TenNhanVien = "Admin", PhongBanId = "null", ChucVuId = "chucvu1", TrangThai = 1, AccountId = "nv00000", }, }); context.NhanVienCongViecs.AddRange(new List <NhanVienCongViec>() { new NhanVienCongViec() { NhanVienCongViecId = "0", NhanVienId = "nv00000", CongViecId = "congviec1", HSCongViec = 0.5, NgayBatDau = new DateTime(2000, 1, 1), NgayKetThuc = new DateTime(2000, 1, 1), }, }); context.HopDongs.AddRange(new List <HopDong>() { new HopDong() { HopDongId = "0", NhanVienId = "nv00000", CongViecId = "congviec1", NgayKyHopDong = new DateTime(2000, 1, 1), LuongCanBan = "0", TrangThai = 0, }, }); context.ChiTietNhanViens.AddRange(new List <ChiTietNhanVien>() { new ChiTietNhanVien() { ChiTietNhanVienId = "nv00000", NhanVienId = "nv00000", NgaySinh = new DateTime(2000, 1, 1), NoiSinh = "", TrinhDoHocVan = "", GioiTinh = "Nam", CMND = "", NgayCapCMND = new DateTime(2000, 1, 1), DiaChi = "", SDT = "", Email = "", HinhAnh = null, }, }); context.NhanVienDuAns.AddRange(new List <NhanVienDuAn>() { new NhanVienDuAn() { NhanVienDuAnId = "0", NhanVienId = "nv00000", DuAnId = "da00000", PhanTramCV = 0, }, }); context.BangChamCongs.AddRange(new List <BangChamCong>() { new BangChamCong() { BangChamCongId = "0", NhanVienId = "nv00000", TrangThaiChamCongId = "tt1", NgayLamViec = new DateTime(2000, 1, 1), }, }); context.NhanVienPhuCaps.AddRange(new List <NhanVienPhuCap>() { new NhanVienPhuCap() { NhanVienPhuCapId = "0", NhanVienId = "nv00000", PhuCapId = "pc00000", }, }); context.LuongThangs.AddRange(new List <LuongThang>() { new LuongThang() { LuongThangId = "0", NhanVienId = "nv00000", LuongCoBan = "0", HSChucVu = 0, HSCongViec = 0, SoNgayLam = 0, SoNgayNghiCoPhep = 0, SoNgayNghiKhongPhep = 0, SoNgayNghiOm = 0, PhuCapNhanVien = "0", PhuCapChucVu = "0", PhuCapThamNien = 0, ThuongLe = "0", TienDuAn = "0", NgayTinhLuong = new DateTime(2000, 1, 1), LuongThucLanh = "0", }, }); context.ThongTinDuLieuCuois.AddRange(new List <ThongTinDuLieuCuoi>() { new ThongTinDuLieuCuoi() { ThongTinDuLieuCuoiId = "1", NhanVienId = "nv00000", DuAnId = "da00000", PhongBanId = "pb00001", PhuCapId = "pc00000", }, }); context.ThuongLes.AddRange(new List <ThuongLe>() { new ThuongLe() { ThuongLeId = "0", NgayLe = new DateTime(2000, 1, 1), TienThuongLe = "0", }, }); context.SaveChanges(); }