public static void uploadJadwal() { BogorHealthEntities db = new BogorHealthEntities(); string pathToExcelFile = "" + @"D:\rsud.xlsx"; string sheetName = "JadwalLayanan"; var excelFile = new ExcelQueryFactory(pathToExcelFile); IQueryable <Jadwal> artistAlbums = (from a in excelFile.Worksheet <Jadwal>(sheetName) select a); IQueryable <JadwalLayanan> sp = artistAlbums.Select(dok => new JadwalLayanan { IdJadwal = dok.IdLayananRS + dok.IdDokter + dok.JamMulai.TimeOfDay.TotalHours + dok.Hari, IdLayananRS = dok.IdLayananRS, IdDokter = dok.IdDokter, Hari = dok.Hari, JamMulai = (dok.JamMulai.TimeOfDay), JamSelesai = dok.JamSelesai.TimeOfDay, }); foreach (var k in sp) { var cek = db.JadwalLayanans.Find(k.IdJadwal); if (cek == null) { db.JadwalLayanans.Add(k); db.SaveChanges(); } } Console.Write(sp); }
public static void uploadAdmin() { BogorHealthEntities db = new BogorHealthEntities(); string pathToExcelFile = "" + @"D:\rsud.xlsx"; string sheetName = "Admin"; var excelFile = new ExcelQueryFactory(pathToExcelFile); var artistAlbums = from a in excelFile.Worksheet(sheetName) select a; IQueryable <Admin> sp = (from a in excelFile.Worksheet <Admin>(sheetName) select a); foreach (Admin dok in sp) { db.Admins.Add(dok); db.SaveChanges(); Console.WriteLine("Ok"); } }
public static void uploadSpesialis() { BogorHealthEntities db = new BogorHealthEntities(); string pathToExcelFile = "" + @"D:\rsud.xlsx"; string sheetName = "Spesialis"; var excelFile = new ExcelQueryFactory(pathToExcelFile); var artistAlbums = from a in excelFile.Worksheet(sheetName) select a; IQueryable <Spesiali> sp = (from a in excelFile.Worksheet <Spesiali>(sheetName) select a); foreach (Spesiali spesiali in sp) { db.Spesialis.Add(spesiali); db.SaveChanges(); Console.WriteLine("Ok"); } }
public static void uploadLayananRS() { BogorHealthEntities db = new BogorHealthEntities(); string pathToExcelFile = "" + @"D:\rsud.xlsx"; string sheetName = "rrLayanan RS"; var excelFile = new ExcelQueryFactory(pathToExcelFile); var artistAlbums = from a in excelFile.Worksheet(sheetName) select a; IQueryable <LayananR> sp = (from a in excelFile.Worksheet <LayananR>(sheetName) select a); foreach (LayananR dok in sp) { var l = db.LayananRS.Find(dok.IdLayananRS); if (l == null) { db.LayananRS.Add(dok); db.SaveChanges(); Console.WriteLine("Ok"); } } }