public void Test()
{
using (TerembeosztoEntitasok ctx = new TerembeosztoEntitasok())
{
var terem = new Terem();
terem.Nev = "V2.637";
terem.Gepek_szama = 20;
terem.Ulohelyek_szama = 25;
ctx.TeremSet.AddObject(terem);
ctx.SaveChanges();
}
}
public void Test()
{
using (TerembeosztoEntitasok ctx = new TerembeosztoEntitasok())
{
var terem = new Terem();
terem.Nev = "V2.637";
terem.Gepek_szama = 20;
terem.Ulohelyek_szama = 25;
ctx.TeremSet.AddObject(terem);
ctx.SaveChanges();
}
}
static void Main(string[] args)
{
ServiceClient client = new ServiceClient();
using (TerembeosztoEntitasok context = new TerembeosztoEntitasok())
{
Hallgato h = client.GetHallgato();
h.Nev = "Gipsz Jakab";
h.Neptun = "ABC123";
context.SaveChanges();
}
Console.WriteLine();
Console.WriteLine("Press <ENTER> to terminate client.");
Console.ReadLine();
}
public void TestImport()
{
String path = @"C:\worksheet.xlsx";
String name = "név";
String neptun = "neptun kód";
int? nameCol = null;
int? neptunCol = null;
// open an Excel application
Excel.Application excelApp = new Excel.Application();
excelApp.Visible = false;
// open the workbook in read-only mode
Excel.Workbook workbook = excelApp.Workbooks.Open(path, Type.Missing, true);
Excel.Worksheet worksheet = excelApp.ActiveSheet;
Excel.Range usedRange = worksheet.UsedRange;
// scan through the first row to get the column indices
for (int j = 1; j <= worksheet.UsedRange.Columns.Count; j++)
{
Excel.Range cell = usedRange.Cells[1, j];
if (cell.Value != null)
{
String cellValue = cell.Value.ToString();
if (cellValue.ToLower() == name.ToLower())
{
nameCol = j;
}
if (cellValue.ToLower() == neptun.ToLower())
{
neptunCol = j;
}
}
}
// throw exception if a required a column does not exist
if (nameCol == null || neptunCol == null)
{
throw new Exception("Nem találhatók a szükséges oszlopok.");
}
using (TerembeosztoEntitasok ctx = new TerembeosztoEntitasok())
{
// scan through the rows from the second row
for (int i = 2; i <= usedRange.Rows.Count; i++)
{
String aktNev = usedRange.Cells[i, nameCol].Value.ToString();
String aktNeptun = usedRange.Cells[i, neptunCol].Value.ToString();
Hallgato hallgato = new Hallgato();
hallgato.Felev = "";
hallgato.Nev = aktNev;
hallgato.Neptun = aktNeptun;
hallgato.Kurzus = null;
hallgato.Csoport = null;
ctx.HallgatoSet.AddObject(hallgato);
Console.WriteLine("#" + (i - 1));
Console.WriteLine(" név: " + aktNev);
Console.WriteLine(" neptun: " + aktNeptun);
}
ctx.SaveChanges();
}
excelApp.Quit();
}
public void TestImport()
{
String path = @"C:\worksheet.xlsx";
String name = "név";
String neptun = "neptun kód";
int? nameCol = null;
int? neptunCol = null;
// open an Excel application
Excel.Application excelApp = new Excel.Application();
excelApp.Visible = false;
// open the workbook in read-only mode
Excel.Workbook workbook = excelApp.Workbooks.Open(path, Type.Missing, true);
Excel.Worksheet worksheet = excelApp.ActiveSheet;
Excel.Range usedRange = worksheet.UsedRange;
// scan through the first row to get the column indices
for (int j = 1; j <= worksheet.UsedRange.Columns.Count; j++)
{
Excel.Range cell = usedRange.Cells[1, j];
if (cell.Value != null)
{
String cellValue = cell.Value.ToString();
if (cellValue.ToLower() == name.ToLower())
{
nameCol = j;
}
if (cellValue.ToLower() == neptun.ToLower())
{
neptunCol = j;
}
}
}
// throw exception if a required a column does not exist
if (nameCol == null || neptunCol == null)
{
throw new Exception("Nem találhatók a szükséges oszlopok.");
}
using (TerembeosztoEntitasok ctx = new TerembeosztoEntitasok())
{
// scan through the rows from the second row
for (int i = 2; i <= usedRange.Rows.Count; i++)
{
String aktNev = usedRange.Cells[i, nameCol].Value.ToString();
String aktNeptun = usedRange.Cells[i, neptunCol].Value.ToString();
Hallgato hallgato = new Hallgato();
hallgato.Felev = "";
hallgato.Nev = aktNev;
hallgato.Neptun = aktNeptun;
hallgato.Kurzus = null;
hallgato.Csoport = null;
ctx.HallgatoSet.AddObject(hallgato);
Console.WriteLine("#" + (i - 1));
Console.WriteLine(" név: " + aktNev);
Console.WriteLine(" neptun: " + aktNeptun);
}
ctx.SaveChanges();
}
excelApp.Quit();
}
