You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
92 lines
3.5 KiB
92 lines
3.5 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using BWPMModels;
|
|
using BlazorApp.Helper;
|
|
using Newtonsoft.Json;
|
|
using System.Data;
|
|
using Microsoft.AspNetCore.Mvc;
|
|
|
|
namespace BlazorApp.Controller
|
|
|
|
{
|
|
|
|
public class LehrerKlassenuebersichtController : ControllerBase
|
|
{
|
|
public static List<LehrerKlassenuebersicht> GetAllData()
|
|
{
|
|
dbhelper dbh = new dbhelper();
|
|
dbh.Get_Tabledata("Select * from LehrerKlassenuebersicht", false, true);
|
|
return dbh.ConvertDataTable<LehrerKlassenuebersicht>(dbh.dsdaten.Tables[0]);
|
|
}
|
|
|
|
public static List<LehrerKlassenuebersicht> GetByID(int ID)
|
|
{
|
|
dbhelper dbh = new dbhelper();
|
|
dbh.Get_Tabledata("Select * from LehrerKlassenuebersicht where id=" + ID.ToString(), false, true);
|
|
return dbh.ConvertDataTable<LehrerKlassenuebersicht>(dbh.dsdaten.Tables[0]);
|
|
}
|
|
|
|
public static List<LehrerKlassenuebersicht> GetByLehrerID(int ID)
|
|
{
|
|
dbhelper dbh = new dbhelper();
|
|
dbh.Get_Tabledata("Select * from LehrerKlassenuebersicht where lehrerid=" + ID.ToString(), false, true);
|
|
return dbh.ConvertDataTable<LehrerKlassenuebersicht>(dbh.dsdaten.Tables[0]);
|
|
}
|
|
|
|
public static List<LehrerKlassenuebersicht> GetLast()
|
|
{
|
|
dbhelper dbh = new dbhelper();
|
|
dbh.Get_Tabledata("Select top 1 * from LehrerKlassenuebersicht order by mutiert_am desc", false, true);
|
|
return dbh.ConvertDataTable<LehrerKlassenuebersicht>(dbh.dsdaten.Tables[0]);
|
|
}
|
|
public static List<LehrerKlassenuebersicht> GetLastByMutierer(string Mutierer)
|
|
{
|
|
dbhelper dbh = new dbhelper();
|
|
dbh.Get_Tabledata("Select top 1 * from LehrerKlassenuebersicht where mutierer='" + Mutierer + "' order by mutiert_am desc", false, true);
|
|
return dbh.ConvertDataTable<LehrerKlassenuebersicht>(dbh.dsdaten.Tables[0]);
|
|
}
|
|
|
|
public static List<LehrerKlassenuebersicht> GetbyUserSQL(string SQL)
|
|
{
|
|
dbhelper dbh = new dbhelper();
|
|
dbh.Get_Tabledata(SQL, false, true);
|
|
return dbh.ConvertDataTable<LehrerKlassenuebersicht>(dbh.dsdaten.Tables[0]);
|
|
}
|
|
|
|
|
|
|
|
public static void PUT(LehrerKlassenuebersicht LehrerKlassenuebersichtdata)
|
|
{
|
|
dbhelper dbh = new dbhelper();
|
|
dbh.Get_Tabeldata_for_Update("Select top 1 * from [LehrerKlassenuebersicht] where id=" + LehrerKlassenuebersichtdata.ID.ToString(), false, true);
|
|
DataRow dr = dbh.dsdaten.Tables[0].Rows[0];
|
|
LehrerKlassenuebersichtdata.GetType().GetProperties().ToList().ForEach(f =>
|
|
{
|
|
try
|
|
{
|
|
if (f.PropertyType == typeof(DateTime))
|
|
{
|
|
dr[f.Name] = (DateTime)f.GetValue(LehrerKlassenuebersichtdata, null);
|
|
}
|
|
else
|
|
{
|
|
dr[f.Name] = f.GetValue(LehrerKlassenuebersichtdata, null);
|
|
}
|
|
}
|
|
catch (Exception ex) { string s = ex.Message; }
|
|
});
|
|
dbh.Update_Tabeldata();
|
|
|
|
}
|
|
|
|
public static void DELETE(LehrerKlassenuebersicht LehrerKlassenuebersichtdata)
|
|
{
|
|
dbhelper dbh = new dbhelper();
|
|
dbh.Get_Tabeldata_for_Update("delete from [LehrerKlassenuebersicht] where id=" + LehrerKlassenuebersichtdata.ID.ToString(), false, true);
|
|
}
|
|
}
|
|
|
|
|
|
|
|
} |