public static Building Read_BuildingID(int BuildingID)
{
using (var db = new M120_ProjektEntities())
{
return((from rec in db.Buildings where rec.BuildingID == BuildingID select rec).FirstOrDefault());
}
}
public static Int64 Create(Building building)
{
if (building.name == null)
{
building.name = "";
}
if (building.street == null)
{
building.street = "";
}
if (building.streetNr == null)
{
building.streetNr = "0";
}
if (building.place == null)
{
building.place = "";
}
if (building.purpose == null)
{
building.purpose = "";
}
using (var db = new M120_ProjektEntities())
{
db.Buildings.Add(building);
db.SaveChanges();
db.Entry(building).Reload();
return(building.BuildingID);
}
}
public static List <Building> ReadAll()
{
using (var db = new M120_ProjektEntities())
{
return((from rec in db.Buildings select rec).ToList());
}
}
private void button_Click_1(object sender, RoutedEventArgs e)
{
Console.WriteLine(Birthday.DisplayDate);
using (var context = new M120_ProjektEntities())
{
context.Citizens.ToList();
}
string gender;
if (Male.IsChecked == true)
{
gender = "Herr";
}
else
{
gender = "Frau";
}
try //Absturz bei falschem Datenformat wird verhindert
{
format.Opacity = 0;
Console.WriteLine(Birthday.DisplayDate);
CreateCitizen(Convert.ToInt32(CitizenID.Text), Name.Text, FirstName.Text, gender, Convert.ToDateTime(Birthday.Text), Convert.ToInt32(Income.Text), Convert.ToInt32(Building.Text));
}
catch
{
format.Opacity = 1;
}
addSuccessful();
}
public static Int64 Create(Citizen citizen)
{
if (citizen.name == null)
{
citizen.name = "";
}
if (citizen.firstName == null)
{
citizen.firstName = "";
}
if (citizen.gender == null)
{
citizen.gender = "";
}
if (citizen.birthday == null)
{
citizen.birthday = DateTime.Today;
}
if (citizen.incomePerMonth == null)
{
citizen.incomePerMonth = 0;
}
if (citizen.fk_buildingID == null)
{
citizen.fk_buildingID = 1;
}
using (var db = new M120_ProjektEntities())
{
db.Citizens.Add(citizen);
db.SaveChanges();
db.Entry(citizen).Reload();
return(citizen.citizenID);
}
}
public static Citizen Read_CitizenID(int citizenID)
{
using (var db = new M120_ProjektEntities())
{
return((from rec in db.Citizens where rec.citizenID == citizenID select rec).FirstOrDefault());
}
}
public static void Delete(Building building)
{
using (var db = new M120_ProjektEntities())
{
db.Entry(building).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
public static void Delete(Citizen citizen)
{
using (var db = new M120_ProjektEntities())
{
db.Entry(citizen).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
private void button_Click_1(object sender, RoutedEventArgs e)
{
using (var context = new M120_ProjektEntities())
{
context.Users.ToList();
}
try
{
format.Opacity = 0;
CreateBuilding(Convert.ToInt32(ID.Text), name.Text, street.Text, streetNr.Text, Convert.ToInt16(postcode.Text), place.Text, purpose.Text);
}
catch
{
format.Opacity = 100;
}
}