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");
}
}
}
