public bool UpdatePurData(PurchaserData purData)
{
NpgsqlConnection con = DB.DBConnector.GetConnection();
NpgsqlCommand command = new NpgsqlCommand(null, con);
command.CommandText = "UPDATE auftraggeberdaten SET stundensatzauszahlung=@stundensatzauszahlung, " +
"Stundensatz=@Stundensatz,BeitragEinkommen=@BeitragEinkommen,FahrtkostenZusatz=@FahrtkostenZusatz,BetreuungsbedarfH=@BetreuungsbedarfH, EinkommenMonat=@EinkommenMonat, PflegegeldStufe=@PflegegeldStufe, " +
"FahrtkostenzusatzKM=@FahrtkostenzusatzKM, agdatenid=nextval('AGDatenIDGen') WHERE agid=@agid AND monat=@month AND jahr=@year";
DB.DBConnector.AddToCommand("@agid", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.Purchaser.Id);
DB.DBConnector.AddToCommand("@month", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.Month);
DB.DBConnector.AddToCommand("@year", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.Year);
DB.DBConnector.AddToCommand("@stundensatzauszahlung", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.HourlyRatePayoff);
DB.DBConnector.AddToCommand("@Stundensatz", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.HourlyRate);
DB.DBConnector.AddToCommand("@BeitragEinkommen", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.InputIncome);
DB.DBConnector.AddToCommand("@FahrtkostenZusatz", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.TravellingAllowance);
DB.DBConnector.AddToCommand("@BetreuungsbedarfH", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.AssistenceDemand);
DB.DBConnector.AddToCommand("@EinkommenMonat", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.Income);
DB.DBConnector.AddToCommand("@PflegegeldStufe", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.CareAllowance);
DB.DBConnector.AddToCommand("@FahrtkostenzusatzKM", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.TravellingAllowanceKM);
try { command.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.Message.ToString(), "Error"); }
con.Close();
return(true);
}
public void SelectAllTestPurchaserData()
{
//given (see setUp)
PurchaserDataDAO pdDao = new PurchaserDataDAO();
PurchaserData originalPur = d;
long id = pdDao.Insert(originalPur).Purchaser.Id;
idToDelete = id;
//when
List <PurchaserData> pds = pdDao.SelectAll();
//then
foreach (PurchaserData pd in pds)
{
if (pd.Purchaser.Id == id)
{
Assert.AreEqual(pd.Purchaser.FirstName, "testpersonDao");
Assert.AreEqual(pd.Purchaser.LastName, "testpersonDao");
Assert.AreEqual(pd.Purchaser.PhoneNumber, "9999");
Assert.AreEqual(pd.Purchaser.MobilePhone, "99999");
Assert.AreEqual(pd.Purchaser.EMail, "*****@*****.**");
Assert.AreEqual(pd.Purchaser.HomeAdress.Street, "Am Hügel");
Assert.AreEqual(pd.Purchaser.HomeAdress.HouseNumber, 12);
Assert.AreEqual(pd.Purchaser.HomeAdress.City, "LINZ");
Assert.AreEqual(pd.Purchaser.HomeAdress.Country, "schland");
Assert.AreEqual(pd.Purchaser.HomeAdress.DoorNumber, 11115);
Assert.AreEqual(pd.Purchaser.HomeAdress.StairNumber, 2345);
Assert.AreEqual(pd.Purchaser.HomeAdress.Etage, 2);
Assert.AreEqual(pd.Purchaser.HomeAdress.ZipCode, 5040);
Assert.AreEqual(pd.Purchaser.IBAN, "AT1254859888898");
Assert.AreEqual(pd.Purchaser.BIC, "SPPR2586XX");
Assert.AreEqual(pd.Purchaser.AccountHolder, "Helmut Günther");
Assert.AreEqual(pd.Purchaser.SVN, 1225020496);
Assert.AreEqual(pd.Purchaser.nationality, "Auenland");
Assert.AreEqual(pd.Purchaser.InfoField, "Infotext");
//purchaser
Assert.AreEqual(pd.Purchaser.Active, true);
Assert.AreEqual(pd.Purchaser.ApprovalBegin, new DateTime(2015, 05, 02));
Assert.AreEqual(pd.Purchaser.ApprovalEnd, new DateTime(2017, 05, 02));
Assert.AreEqual(pd.Purchaser.EntryDate, new DateTime(2015, 05, 02));
Assert.AreEqual(pd.Purchaser.hasContract, true);
Assert.AreEqual(pd.Purchaser.hasIntroCourse, true);
Assert.AreEqual(pd.Purchaser.DistrictCommision, "Perg");
//purchaserData
Assert.AreEqual(pd.AssistenceDemand, 12);
Assert.AreEqual(pd.CareAllowance, 2);
Assert.AreEqual(pd.HourlyRate, 30);
Assert.AreEqual(pd.HourlyRatePayoff, 20);
Assert.AreEqual(pd.Income, 29);
Assert.AreEqual(pd.InputIncome, 100);
Assert.AreEqual(pd.Month, 11);
Assert.AreEqual(pd.TravellingAllowance, 12);
Assert.AreEqual(pd.TravellingAllowanceKM, 11);
//Assert.AreEqual(pd.CareAllowanceMaximum, 16);
Assert.AreEqual(pd.Year, 2015);
}
}
}
/// <summary>
/// inserts PurchaserData WITHOUT the according purchaser
/// </summary>
/// <param name="purData"></param>
/// <returns></returns>
public PurchaserData InsertPurData(PurchaserData purData)
{
PurchaserDAO pdao = new PurchaserDAO();
NpgsqlConnection con = DB.DBConnector.GetConnection();
NpgsqlCommand command = new NpgsqlCommand(null, con);
command.CommandText = "INSERT INTO auftraggeberdaten (agid,monat,jahr, stundensatzauszahlung, " +
"Stundensatz,BeitragEinkommen,FahrtkostenZusatz,BetreuungsbedarfH, EinkommenMonat, PflegegeldStufe, " +
"FahrtkostenzusatzKM, agdatenid) VALUES (@agid,@month, @year, @stundensatzauszahlung, @Stundensatz, " +
"@BeitragEinkommen,@FahrtkostenZusatz,@BetreuungsbedarfH, @EinkommenMonat, @PflegegeldStufe, @FahrtkostenzusatzKM,nextval('AGDatenIDGen') )";
DB.DBConnector.AddToCommand("@agid", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.Purchaser.Id);
DB.DBConnector.AddToCommand("@month", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.Month);
DB.DBConnector.AddToCommand("@year", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.Year);
DB.DBConnector.AddToCommand("@stundensatzauszahlung", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.HourlyRatePayoff);
DB.DBConnector.AddToCommand("@Stundensatz", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.HourlyRate);
DB.DBConnector.AddToCommand("@BeitragEinkommen", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.InputIncome);
DB.DBConnector.AddToCommand("@FahrtkostenZusatz", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.TravellingAllowance);
DB.DBConnector.AddToCommand("@BetreuungsbedarfH", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.AssistenceDemand);
DB.DBConnector.AddToCommand("@EinkommenMonat", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.Income);
DB.DBConnector.AddToCommand("@PflegegeldStufe", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.CareAllowance);
DB.DBConnector.AddToCommand("@FahrtkostenzusatzKM", NpgsqlTypes.NpgsqlDbType.Numeric, command, purData.TravellingAllowanceKM);
try { command.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.Message.ToString(), "Error"); }
con.Close();
return(purData);
}
public void employementTimesTest()
{
PersonalAssistantDAO paDao = new PersonalAssistantDAO();
PurchaserDataDAO pdDao = new PurchaserDataDAO();
PurchaserData originalPd = d;
originalPd = pdDao.Insert(originalPd);
idToDelete = originalPd.Purchaser.Id;
List <PersonalAssistant> pas = paDao.SelectAll();
if (pas == null || pas.Count == 0)
{
Assert.Fail("Can not find personal assistants to add to purchasers employmentTimes");
}
PersonalAssistant pa = pas[0];
Purchaser p = originalPd.Purchaser;
paDao.insertEmploymentStatus(p, pa);
//when
PurchaserDAO purDao = new PurchaserDAO();
List <EmploymentStatus> empList = purDao.SelectEmploymentStatusList(p);
//then
Assert.IsNotNull(empList);
Assert.AreEqual(empList.Count, 1);
Assert.AreEqual(empList[0].Purchaser.Id, p.Id);
Assert.AreEqual(empList[0].Assistant.Id, pa.Id);
}
public MonthlyBillingPerPa(int month, int year, PersonalAssistant pa, PurchaserData p, List <EffortEntry> effortEntries)
{
this.Month = month;
this.Year = year;
this.Pa = pa;
this.Pur = p;
this.EffortList = effortEntries;
}
private void getPurchaser()
{
var a = App.Current as App;
AGidx = ((int)(a.AGIndex));
purData = bl.SelectPurchaser(AGidx);
fillFields(purData);
}
private decimal calculateMaxCareAllowance(PurchaserData pd)
{
if (pd.CareAllowanceMaximum == 0)
{
return(pd.CareAllowance * (decimal)0.8);
}
else
{
return(pd.CareAllowanceMaximum);
}
}
public bool UpdatePurchaser(PurchaserData p)
{
try {
PurDao.Update(p);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(true);
}
private void btnInfo_Click(object sender, RoutedEventArgs e)
{
if (purData == null)
{
purData = new PurchaserData();
}
infoW = new InfoWindow(purData.Purchaser.InfoField);
infoW.ShowDialog();
purData.Purchaser.InfoField = infoW.tbInfo.Text;
if (infoW.changed)
{
purData.Purchaser.InfoField = infoW.tbInfo.Text;
}
}
public PurchaserData SelectPurchaser(int id)
{
PurchaserData p = new PurchaserData(id);
try
{
p = PurDao.Select(p);
}
catch (ExceptionHandler e)
{
}
p.CareAllowanceMaximum = calculateMaxCareAllowance(p);
return(p);
}
public MonthlyBilling SelectMb(int selectedYear, int selectedMonth, PurchaserData selectedPurchaserData, List <PersonalAssistant> currentAssistents)
{
MonthlyBillingPerPaBL bl = new MonthlyBillingPerPaBL();
List <MonthlyBillingPerPa> monthlyBillingList = new List <MonthlyBillingPerPa>();
mb = new MonthlyBilling();
mb.Purchaser = new PurchaserData();
mb.Purchaser = selectedPurchaserData;
mb.Month = selectedMonth;
mb.Year = selectedYear;
//------ get all MonthlyBillingPerPa for this month
foreach (PersonalAssistant pa in currentAssistents)
{
MonthlyBillingPerPa monthb = new MonthlyBillingPerPa(selectedMonth, selectedYear, pa, selectedPurchaserData, new List <EffortEntry>());
monthlyBillingList.Add(monthb);
}
if (mb == null)
{
mb = new MonthlyBilling();
}
if (mb.MbPerPaList == null)
{
mb.MbPerPaList = new List <MonthlyBillingPerPa>();
}
mb.MbPerPaList = monthlyBillingList;
MonthlyBillingPerPaBL mbPpabl = new MonthlyBillingPerPaBL();
List <MonthlyBillingPerPa> tmp = new List <MonthlyBillingPerPa>();
//fill MonthlyBilling PerPa with data
foreach (MonthlyBillingPerPa mbPa in mb.MbPerPaList)
{
tmp.Add(SelectMb(mbPa));
}
mb.MbPerPaList = tmp;
mb.RehaDays = MbDao.selectReha(selectedPurchaserData.Purchaser.Id, selectedMonth, selectedYear);
//wenn keine Leistungseinträge vorhanden wird nichts berechnet
if (mb.MbPerPaList == null || mb.MbPerPaList.Count == 0)
{
}
else
{
//berechnet alles was für MB wichtig ist.
calculateValues();
}
return(mb);
}
public static void setUp(TestContext testContext)
{
Purchaser p = new Purchaser();
//Person Insert
p.FirstName = "testpersonDao";
p.LastName = "testpersonDao";
p.PhoneNumber = "9999";
p.MobilePhone = "99999";
p.EMail = "*****@*****.**";
p.HomeAdress.Street = "Am Hügel";
p.HomeAdress.HouseNumber = 12;
p.HomeAdress.City = "LINZ";
p.HomeAdress.Country = "schland";
p.HomeAdress.DoorNumber = 11115;
p.HomeAdress.StairNumber = 2345;
p.HomeAdress.Etage = 2;
p.HomeAdress.ZipCode = 5040;
p.IBAN = "AT1254859888898";
p.BIC = "SPPR2586XX";
p.AccountHolder = "Helmut Günther";
p.SVN = 1225020496;
p.nationality = "Auenland";
p.InfoField = "Infotext";
//purchaser
p.Active = true;
p.ApprovalBegin = new DateTime(2015, 05, 02);
p.ApprovalEnd = new DateTime(2017, 05, 02);
p.EntryDate = new DateTime(2015, 05, 02);
p.hasContract = true;
p.hasIntroCourse = true;
p.DistrictCommision = "Perg";
//purchaserData
d = new PurchaserData();
d.Purchaser = p;
d.AssistenceDemand = 12;
d.CareAllowance = 2;
d.HourlyRate = 30;
d.HourlyRatePayoff = 20;
d.Income = 29;
d.InputIncome = 100;
d.Month = 11;
d.TravellingAllowance = 12;
d.TravellingAllowanceKM = 11;
d.CareAllowanceMaximum = 16;
d.Year = 2015;
}
public bool CreatePurchaser(PurchaserData p)
{
if (p.CareAllowanceMaximum == 0)
{
p.CareAllowanceMaximum = p.CareAllowance * (decimal)0.8;
}
try
{
PurDao.Insert(p);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(true);
}
public PurchaserData Select(PurchaserData pur)
{
if (pur.Purchaser.Id == 54321)
{
pur.Purchaser.Active = true;
pur.Purchaser.FirstName = "Hugo";
pur.Purchaser.LastName = "Huber";
pur.Purchaser.MobilePhone = "982374283745";
pur.Purchaser.EntryDate = new DateTime(2010, 12, 12);
pur.Purchaser.EMail = "*****@*****.**";
pur.Purchaser.ApprovalBegin = new DateTime(2015, 01, 01);
pur.Purchaser.ApprovalEnd = new DateTime(2015, 12, 31);
pur.Purchaser.ContactPerson = new Person("Maria", "Huber", new Adress("Hauptstrasse", 12, 4040, "Linz"));
pur.Purchaser.Employees = new List <EmploymentStatus>();
EmploymentStatus e =
new EmploymentStatus(
new PersonalAssistant(new Person("Brigitte", "Fritte",
new Adress("Landstrasse", 22, 4209, "Engerwitzdorf"))), pur.Purchaser);
EmploymentStatus e1 =
new EmploymentStatus(
new PersonalAssistant(new Person("Max", "Moritz",
new Adress("Maienweg", 22, 4209, "Engerwitzdorf"))), pur.Purchaser);
pur.Purchaser.HomeAdress = new Adress("Heimatstrasse", 124, 2345, "Wien");
pur.Purchaser.PhoneNumber = "28374937453987";
pur.Income = 1500;
pur.InputIncome = 150;
pur.Month = 6;
pur.Year = 2015;
pur.TravellingAllowanceKM = (decimal)0.22;
pur.HourlyRate = 20;
pur.HourlyRatePayoff = (decimal)20.5;
pur.CareAllowanceMaximum = 300;
pur.CareAllowance = 2;
pur.AssistenceDemand = 60;
return(pur);
}
else
{
return(null);
}
}
public void UpdateMBEntry()
{
//given
pa = paDao.insert(pa);
d = pdDao.Insert(d);
mbDao.InsertMonthlyBilling(mb);
//when
mb.BillableKm = 12;
mb.PrivateKm = 15;
mb.WorkingHours = 14;
mbDao.UpdateMonthlyBillingEntry(mb);
//then
mb = mbDao.selectMBEntry(mb);
Assert.AreEqual(mb.BillableKm, 12);
Assert.AreEqual(mb.PrivateKm, 15);
Assert.AreEqual(mb.WorkingHours, 14);
}
private void btnContact_Click(object sender, RoutedEventArgs e)
{
if (purData == null)
{
purData = new PurchaserData();
}
if (purData.Purchaser == null)
{
purData.Purchaser = new Purchaser();
}
if (purData.Purchaser.ContactPerson == null)
{
purData.Purchaser.ContactPerson = new Person();
}
contactW = new ContactWindow(purData.Purchaser.ContactPerson);
contactW.ShowDialog();
purData.Purchaser.ContactPerson = contactW.person;
}
public void UpdateEffortEntry()
{
//given
pa = paDao.insert(pa);
d = pdDao.Insert(d);
mbDao.InsertMonthlyBilling(mb);
eeDao.InsertEntry(effortEntries[0]);
effortEntries[0].A1.Name = Activity.State.Grundversorgung;
effortEntries[0].A2.Name = Activity.State.Kommunikation;
effortEntries[0].From = new DateTime(mb.Year, mb.Month, effortEntries[0].Day, 13, 31, 0);
effortEntries[0].To = new DateTime(mb.Year, mb.Month, effortEntries[0].Day, 20, 47, 0);
effortEntries[0].Km = 0;
//when
eeDao.UpdateEntry(effortEntries[0]);
//then
List <EffortEntry> ees = eeDao.GetEntries(mb.Pa.Id, mb.Pur.Purchaser.Id, mb.Month, mb.Year);
Assert.AreEqual(ees.Count, 1);
if (ees[0].Day == 1)
{
Assert.AreEqual(ees[0].A1.Name, Activity.State.Grundversorgung);
Assert.AreEqual(ees[0].A2.Name, Activity.State.Kommunikation);
Assert.AreEqual(ees[0].Km, 0);
Assert.AreEqual(ees[0].From.Hour, 13);
Assert.AreEqual(ees[0].From.Minute, 31);
Assert.AreEqual(ees[0].To.Hour, 20);
Assert.AreEqual(ees[0].To.Minute, 47);
}
else
{
Assert.AreEqual(ees[1].A1.Name, Activity.State.Grundversorgung);
Assert.AreEqual(ees[1].A2.Name, Activity.State.Kommunikation);
Assert.AreEqual(ees[1].Km, 0);
Assert.AreEqual(ees[1].From.Hour, 13);
Assert.AreEqual(ees[1].From.Minute, 31);
Assert.AreEqual(ees[1].To.Hour, 20);
Assert.AreEqual(ees[1].To.Minute, 47);
}
}
private void purchaserSelected(object sender, SelectionChangedEventArgs e)
{
selectedPurchaserData = pdBl.Select(((PurchaserData)purchaserBox.SelectedItem));
getYears();
if (yearBox.SelectedIndex != Years.Count - 1)
{
yearBox.SelectedIndex = Years.Count - 1;
}
else
{
yearSelectionChanged(sender, e);
}
if (yearBox.SelectedIndex != Years.Count - 1)
{
monthBox.SelectedIndex = Months.Count - 1;
}
else
{
monthSelectionChanged(sender, e);
}
loadReha();
}
public void InsertEffortEntry()
{
//given
pa = paDao.insert(pa);
d = pdDao.Insert(d);
mbDao.InsertMonthlyBilling(mb);
//when
eeDao.InsertEntry(effortEntries[0]);
eeDao.InsertEntry(effortEntries[1]);
//then
List <EffortEntry> ees = eeDao.GetEntries(mb.Pa.Id, mb.Pur.Purchaser.Id, mb.Month, mb.Year);
Assert.AreEqual(ees.Count, 2);
Assert.AreEqual(ees[0].A1.Name, Activity.State.Begleitung);
Assert.AreEqual(ees[0].A2.Name, Activity.State.Hauswirtschaft);
Assert.AreEqual(ees[0].Km, 10);
Assert.AreEqual(ees[0].From.Hour, 12);
Assert.AreEqual(ees[0].From.Minute, 30);
Assert.AreEqual(ees[0].To.Hour, 18);
Assert.AreEqual(ees[0].To.Minute, 45);
}
public static void TestMonthlyBilling()
{
List <PurchaserData> pds = (new PurchaserDataDAO()).SelectAll();
PurchaserData pData = new PurchaserData();
pData.Purchaser = new Purchaser();
pData.Purchaser.Id = 998;
// pData.Month = 4;
// pData.Year = 2013;
pData = (new PurchaserDataDAO()).Select(pData);
PersonalAssistant pa = new PersonalAssistant(996);
pa = (new PersonalAssistantDAO()).select(pa);
MonthlyBillingPerPa mbPerPa = new MonthlyBillingPerPa();
mbPerPa.Pur = pData;
mbPerPa.Pa = pa;
mbPerPa.Month = 2;
mbPerPa.Year = 2015;
mbPerPa = (new MonthlyBillingDAO()).selectMBEntry(mbPerPa);
}
public void UpdatePurchaserDataTest()
{
PurchaserDataDAO pdDao = new PurchaserDataDAO();
PurchaserData originalPur = d;
PurchaserData pd = new PurchaserData();
PurchaserData p = pdDao.Insert(originalPur);
idToDelete = p.Purchaser.Id;
//Person Insert
p.Purchaser.FirstName = "Hermann";
p.Purchaser.LastName = "Mayr";
p.Purchaser.PhoneNumber = "1111";
p.Purchaser.MobilePhone = "1111";
p.Purchaser.EMail = "*****@*****.**";
p.Purchaser.HomeAdress.Street = "Am Tal";
p.Purchaser.HomeAdress.HouseNumber = 2;
p.Purchaser.HomeAdress.City = "LINZKeks";
p.Purchaser.HomeAdress.Country = "schiachland";
p.Purchaser.HomeAdress.DoorNumber = 2222;
p.Purchaser.HomeAdress.StairNumber = 1;
p.Purchaser.HomeAdress.Etage = 1;
p.Purchaser.HomeAdress.ZipCode = 54;
p.Purchaser.IBAN = "DE2554859888898";
p.Purchaser.BIC = "RAPR2586XX";
p.Purchaser.AccountHolder = "Herman Günther";
p.Purchaser.SVN = 3525020496;
p.Purchaser.nationality = "BAuenland";
p.Purchaser.InfoField = "Infotext erweitert";
//purchaser
p.Purchaser.Active = false;
p.Purchaser.ApprovalBegin = new DateTime(2016, 06, 08);
p.Purchaser.ApprovalEnd = new DateTime(2018, 08, 09);
p.Purchaser.EntryDate = new DateTime(2018, 04, 07);
p.Purchaser.hasContract = false;
p.Purchaser.hasIntroCourse = false;
p.Purchaser.DistrictCommision = "Freistadt";
//purchaserData
p.AssistenceDemand = 225;
p.CareAllowance = 84;
p.HourlyRate = 26;
p.HourlyRatePayoff = 12;
p.Income = 2900;
p.InputIncome = 1000;
p.Month = 11;
p.TravellingAllowance = 13;
p.TravellingAllowanceKM = 25;
p.CareAllowanceMaximum = 18;
p.Year = 2015;
pdDao.Update(p);
p = new PurchaserData();
p.Purchaser = new Purchaser();
p.Purchaser.Id = idToDelete;
pdDao.Select(p);
//Person Insert
Assert.AreEqual(p.Purchaser.FirstName, "Hermann");
Assert.AreEqual(p.Purchaser.LastName, "Mayr");
Assert.AreEqual(p.Purchaser.PhoneNumber, "1111");
Assert.AreEqual(p.Purchaser.MobilePhone, "1111");
Assert.AreEqual(p.Purchaser.EMail, "*****@*****.**");
Assert.AreEqual(p.Purchaser.HomeAdress.Street, "Am Tal");
Assert.AreEqual(p.Purchaser.HomeAdress.HouseNumber, 2);
Assert.AreEqual(p.Purchaser.HomeAdress.City, "LINZKeks");
Assert.AreEqual(p.Purchaser.HomeAdress.Country, "schiachland");
Assert.AreEqual(p.Purchaser.HomeAdress.DoorNumber, 2222);
Assert.AreEqual(p.Purchaser.HomeAdress.StairNumber, 1);
Assert.AreEqual(p.Purchaser.HomeAdress.Etage, 1);
Assert.AreEqual(p.Purchaser.HomeAdress.ZipCode, 54);
Assert.AreEqual(p.Purchaser.IBAN, "DE2554859888898");
Assert.AreEqual(p.Purchaser.BIC, "RAPR2586XX");
Assert.AreEqual(p.Purchaser.AccountHolder, "Herman Günther");
Assert.AreEqual(p.Purchaser.SVN, 3525020496);
Assert.AreEqual(p.Purchaser.nationality, "BAuenland");
Assert.AreEqual(p.Purchaser.InfoField, "Infotext erweitert");
//purchaser
Assert.AreEqual(p.Purchaser.Active, false);
Assert.AreEqual(p.Purchaser.ApprovalBegin, new DateTime(2016, 06, 08));
Assert.AreEqual(p.Purchaser.ApprovalEnd, new DateTime(2018, 08, 09));
Assert.AreEqual(p.Purchaser.EntryDate, new DateTime(2018, 04, 07));
Assert.AreEqual(p.Purchaser.hasContract, false);
Assert.AreEqual(p.Purchaser.hasIntroCourse, false);
Assert.AreEqual(p.Purchaser.DistrictCommision, "Freistadt");
//purchaserData
Assert.AreEqual(p.AssistenceDemand, 225);
Assert.AreEqual(p.CareAllowance, 84);
Assert.AreEqual(p.HourlyRate, 26);
Assert.AreEqual(p.HourlyRatePayoff, 12);
Assert.AreEqual(p.Income, 2900);
Assert.AreEqual(p.InputIncome, 1000);
Assert.AreEqual(p.Month, 11);
Assert.AreEqual(p.TravellingAllowance, 13);
Assert.AreEqual(p.TravellingAllowanceKM, 25);
Assert.AreEqual(p.Year, 2015);
}
public static void setUp(TestContext testContext)
{
eeDao = new EffortEntryDAO();
mbDao = new MonthlyBillingDAO();
pdDao = new PurchaserDataDAO();
paDao = new PersonalAssistantDAO();
Purchaser p = new Purchaser();
//Person Insert
p.FirstName = "testpersonDao";
p.LastName = "testpersonDao";
p.PhoneNumber = "9999";
p.MobilePhone = "99999";
p.EMail = "*****@*****.**";
p.HomeAdress.Street = "Am Hügel";
p.HomeAdress.HouseNumber = 12;
p.HomeAdress.City = "LINZ";
p.HomeAdress.Country = "schland";
p.HomeAdress.DoorNumber = 11115;
p.HomeAdress.StairNumber = 2345;
p.HomeAdress.Etage = 2;
p.HomeAdress.ZipCode = 5040;
p.IBAN = "AT1254859888898";
p.BIC = "SPPR2586XX";
p.AccountHolder = "Helmut Günther";
p.SVN = 1225020496;
p.nationality = "Auenland";
p.InfoField = "Infotext";
//purchaser
p.Active = true;
p.ApprovalBegin = new DateTime(2015, 05, 02);
p.ApprovalEnd = new DateTime(2017, 05, 02);
p.EntryDate = new DateTime(2015, 05, 02);
p.hasContract = true;
p.hasIntroCourse = true;
p.DistrictCommision = "Perg";
//purchaserData
d = new PurchaserData();
d.Purchaser = p;
d.AssistenceDemand = 12;
d.CareAllowance = 2;
d.HourlyRate = 30;
d.HourlyRatePayoff = 20;
d.Income = 29;
d.InputIncome = 100;
d.Month = 11;
d.TravellingAllowance = 12;
d.TravellingAllowanceKM = 11;
d.CareAllowanceMaximum = 16;
d.Year = 1998;
pa = new PersonalAssistant();
//Person Insert
pa.FirstName = "persöhnlicher";
pa.LastName = "assistent";
pa.PhoneNumber = "9999";
pa.MobilePhone = "99999";
pa.EMail = "*****@*****.**";
pa.HomeAdress.Street = "Am Hügel";
pa.HomeAdress.HouseNumber = 12;
pa.HomeAdress.City = "LINZ";
pa.HomeAdress.Country = "schland";
pa.HomeAdress.DoorNumber = 11115;
pa.HomeAdress.StairNumber = 2345;
pa.HomeAdress.Etage = 2;
pa.HomeAdress.ZipCode = 5040;
pa.IBAN = "AT1254859888898";
pa.BIC = "SPPR2586XX";
pa.AccountHolder = "Helmut Günther";
pa.SVN = 1225020496;
pa.nationality = "Auenland";
pa.InfoField = "Infotext";
//pa
pa.Active = true;
pa.ClosingDateDocuments = new DateTime(2016, 02, 03);
pa.SV = true;
pa.Dienstvertrag = true;
pa.BestBH = true;
pa.Grundkurs = true;
pa.consumedHours = 2.4M;
pa.deadLineHours = new DateTime(2017, 02, 04);
pa = paDao.insert(pa);
d = pdDao.Insert(d);
mb = new MonthlyBillingPerPa();
mb.PrivateKm = 21;
mb.Month = 7;
mb.Year = 1998;
mb.Pa = pa;
mb.Pur = d;
mb.WorkingHours = 15;
mb.BillableKm = 10;
effortEntries = new List <EffortEntry>();
EffortEntry a = new EffortEntry();
a.Month = mb.Month;
a.Year = mb.Year;
a.Pa = mb.Pa;
a.Purchaser = mb.Pur.Purchaser;
a.Day = 1;
a.From = new DateTime(a.Year, a.Month, a.Day, 12, 30, 0);
a.To = new DateTime(a.Year, a.Month, a.Day, 18, 45, 0);
a.Km = 10;
a.A1 = new Activity(Activity.State.Begleitung);
a.A2 = new Activity(Activity.State.Hauswirtschaft);
EffortEntry b = new EffortEntry();
b.Month = mb.Month;
b.Year = mb.Year;
b.Pa = mb.Pa;
b.Purchaser = mb.Pur.Purchaser;
b.Day = 2;
b.From = new DateTime(b.Year, b.Month, b.Day, 12, 30, 0);
b.To = new DateTime(b.Year, b.Month, b.Day, 18, 45, 0);
b.Km = 10;
b.A1 = new Activity(Activity.State.Begleitung);
b.A2 = new Activity(Activity.State.Hauswirtschaft);
effortEntries.Add(a);
effortEntries.Add(b);
}
public bool UpdatePurData(PurchaserData purData)
{
throw new NotImplementedException();
}
private void fillFields(PurchaserData pd)
{
FirstName.Text = pd.Purchaser.FirstName;
LastName.Text = pd.Purchaser.LastName;
Email.Text = pd.Purchaser.EMail;
PhoneNr.Text = pd.Purchaser.PhoneNumber;
MobileNr.Text = pd.Purchaser.MobilePhone;
SVN.Text = (pd.Purchaser.SVN == 0) ? "" : pd.Purchaser.SVN.ToString();
Street.Text = pd.Purchaser.HomeAdress.Street;
HNr.Text = pd.Purchaser.HomeAdress.HouseNumber.ToString();
Etage.Text = pd.Purchaser.HomeAdress.Etage.ToString();
StairNr.Text = pd.Purchaser.HomeAdress.StairNumber.ToString();
DoorNr.Text = pd.Purchaser.HomeAdress.DoorNumber.ToString();
City.Text = pd.Purchaser.HomeAdress.City;
Country.Text = pd.Purchaser.HomeAdress.Country;
ZIP.Text = pd.Purchaser.HomeAdress.ZipCode.ToString();
nationality.Text = pd.Purchaser.nationality;
EntryDate.Text = pd.Purchaser.EntryDate.ToString();
ApprovelFrom.Text = pd.Purchaser.ApprovalBegin.ToString();
ApprovelTo.Text = pd.Purchaser.ApprovalEnd.ToString();
PayperHour.Text = pd.HourlyRate.ToString();
KmPay.Text = pd.TravellingAllowanceKM.ToString();
billablePayperHour.Text = pd.HourlyRatePayoff.ToString();
Needof.Text = pd.AssistenceDemand.ToString();
Income.Text = pd.Income.ToString();
IncomeBetrag.Text = pd.InputIncome.ToString();
CareAllowence.Text = pd.CareAllowance.ToString();
districtcommission.Text = pd.Purchaser.DistrictCommision;
IBAN.Text = pd.Purchaser.IBAN;
BIC.Text = pd.Purchaser.BIC;
kontoinhaber.Text = pd.Purchaser.AccountHolder;
if (pd.Purchaser.Active)
{
activeRadioBtn.IsChecked = true;
inactiveRadioBtn.IsChecked = false;
}
else
{
activeRadioBtn.IsChecked = false;
inactiveRadioBtn.IsChecked = true;
}
if (pd.Purchaser.hasContract)
{
contract.IsChecked = true;
}
if (pd.Purchaser.hasIntroCourse)
{
einfuehrungskurs.IsChecked = true;
}
//employedPA.Clear();
//guiListEmployed.Clear();
employedPersonalAssistants.ItemsSource = guiListEmployed;
if (pd.Purchaser.Employees != null)
{
foreach (EmploymentStatus emp in pd.Purchaser.Employees)
{
employedPA.Add(emp.Assistant);
guiListEmployed.Add(new Track(emp.Assistant.Id, emp.Assistant.FirstName, emp.Assistant.LastName));
}
employedPersonalAssistants.ItemsSource = guiListEmployed;
}
}
public PurchaserData InsertPurData(PurchaserData purData)
{
throw new NotImplementedException();
}
public AgInformation(PurchaserData ag)
{
this.ag = ag;
getInformation();
}
private void save_Click(object sender, RoutedEventArgs e)
{
Purchaser purU = new Purchaser();
if (purData.Purchaser.ContactPerson != null)
{
purU.ContactPerson = new Person();
purU.ContactPerson = purData.Purchaser.ContactPerson;
}
PurchaserData purDataU = new PurchaserData();
purU.HomeAdress = new Adress();
InputEvaluator ie = new InputEvaluator();
if (ie.Evaluate(this))
{
purU.Id = AGidx;
purU.FirstName = FirstName.getContent();
purU.LastName = LastName.getmustContent();
purU.EMail = Email.getContent();
if (PhoneNr.getContent() != null)
{
purU.PhoneNumber = PhoneNr.getContent();
}
if (MobileNr.getContent() != null)
{
purU.MobilePhone = MobileNr.getContent();
}
purU.HomeAdress.AdressId = purData.Purchaser.HomeAdress.AdressId;
purU.HomeAdress.Street = Street.getContent();
purU.HomeAdress.StairNumber = parseInt(StairNr.getContent());
purU.HomeAdress.HouseNumber = parseInt(HNr.getContent());
purU.HomeAdress.Etage = parseInt(Etage.getContent());
purU.HomeAdress.DoorNumber = parseInt(DoorNr.getContent());
purU.HomeAdress.City = City.getContent();
purU.HomeAdress.Country = Country.getContent();
purU.HomeAdress.ZipCode = parseInt(ZIP.getContent());
purU.EntryDate = EntryDate.DisplayDate;
purU.ApprovalBegin = ApprovelFrom.DisplayDate;
purU.ApprovalEnd = ApprovelTo.DisplayDate;
purU.DistrictCommision = districtcommission.getContent();
purU.nationality = nationality.getContent();
purU.SVN = parseLong(SVN.getContent());
purDataU.HourlyRate = parseDecimal(PayperHour.getContent());
purDataU.TravellingAllowanceKM = parseDecimal(KmPay.getContent());
purDataU.HourlyRatePayoff = parseDecimal(billablePayperHour.getContent());
purDataU.Income = parseDecimal(Income.getContent());
purDataU.AssistenceDemand = parseInt(Needof.getContent());
purDataU.InputIncome = parseDecimal(IncomeBetrag.getContent());
purDataU.CareAllowance = parseInt((string)CareAllowence.SelectedValue);
purDataU.Purchaser.InfoField = purData.Purchaser.InfoField;
purDataU.Year = purData.Year;
purDataU.Month = purData.Month;
purU.IBAN = IBAN.getContent();
purU.BIC = BIC.getContent();
purU.AccountHolder = kontoinhaber.getContent();
if ((bool)activeRadioBtn.IsChecked)
{
purU.Active = true;
}
else if ((bool)inactiveRadioBtn.IsChecked)
{
purU.Active = false;
}
if ((bool)einfuehrungskurs.IsChecked)
{
purU.hasContract = true;
}
if ((bool)contract.IsChecked)
{
purU.hasIntroCourse = true;
}
if (purDataU.Purchaser.Employees != null)
{
foreach (EmploymentStatus emp in purData.Purchaser.Employees)
{
bool found = false;
foreach (PersonalAssistant pa in employedPA)
{
if (pa.Id.Equals(emp.Assistant.Id))
{
found = true;
}
}
if (found)
{
purU.Employees.Add(emp);
}
}
}
//add PA connection
PAtoPurchaserBL PBL = new PAtoPurchaserBL();
foreach (PersonalAssistant pa in addedPAs)
{
foreach (PersonalAssistant pad in deletedPAs)
{
if (pa.Id == pad.Id)
{
addedPAs.Remove(pa);
deletedPAs.Remove(pad);
}
}
}
foreach (PersonalAssistant pa in addedPAs)
{
PBL.add(pa, purU);
}
//delete PA connection
foreach (PersonalAssistant pa in deletedPAs)
{
PBL.delete(pa, purU);
}
//delete PA connection
//AKTIV RADIO BOXEN NAMEN
//switch to Übersicht
foreach (Window window in Application.Current.Windows)
{
if (window.GetType() == typeof(Main))
{
(window as Main).FrameÜbersicht.Source = new Uri("../Personenverwaltung/AG/AGÜbersicht.xaml", UriKind.Relative);
}
}
}
purU.InfoField = purData.Purchaser.InfoField;
purDataU.Purchaser = purU;
if (purU.FirstName != null && purU.LastName != null)
{
bl.UpdatePurchaser(purDataU);
}
}
public List <PurchaserData> SelectAll()
{
NpgsqlConnection con = DB.DBConnector.GetConnection();
NpgsqlCommand command = new NpgsqlCommand(null, con);
command.CommandText = "select ag.agid from auftraggeber ag inner join dienstverhaeltnis d on(ag.agid = d.agid) group by ag.agid having count(ag.agid) > 0";
List <PurchaserData> pds = new List <PurchaserData>();
//using the Connection to get Datas
try
{
NpgsqlDataReader reader = command.ExecuteReader();
List <int> employedPaIds = new List <int>();
while (reader.Read())
{
if (!(reader.IsDBNull(0)))
{
employedPaIds.Add(reader.GetInt32(0));
}
}
command.CommandText = "select * from (((((Person p inner Join Auftraggeber ag On (p.PersonId=ag.Agid)) Left Outer join Adresse adresse on " +
"(adresse.Adressid=p.adressId)) left Outer Join Person kontakt on (kontakt.personid=ag.kontaktperson) ) left outer join Adresse " +
"kontaktad on (kontakt.adressid=kontaktad.adressid))) Left outer Join Auftraggeberdaten agDaten on ( agDaten.agid=ag.agid) where agDaten.agDatenid " +
"IN ((select max(agDatenid) from Auftraggeberdaten group by agid))";
reader = command.ExecuteReader();
while (reader.Read())
{
Purchaser pur = new Purchaser();
PurchaserData purData = new PurchaserData();
if (!(reader.IsDBNull(0)))
{
pur.Id = reader.GetInt32(0);
}
if (!(reader.IsDBNull(1)))
{
pur.EMail = reader.GetString(1);
}
if (!(reader.IsDBNull(2)))
{
pur.FirstName = reader.GetString(2);
}
if (!(reader.IsDBNull(3)))
{
pur.LastName = reader.GetString(3);
}
if (!(reader.IsDBNull(4)))
{
pur.PhoneNumber = reader.GetString(4);
}
if (!(reader.IsDBNull(6)))
{
pur.MobilePhone = reader.GetString(6);
}
if (!(reader.IsDBNull(7)))
{
pur.IBAN = reader.GetString(7);
}
if (!(reader.IsDBNull(8)))
{
pur.BIC = reader.GetString(8);
}
if (!(reader.IsDBNull(9)))
{
pur.AccountHolder = reader.GetString(9);
}
if (!(reader.IsDBNull(10)))
{
pur.SVN = Convert.ToInt64(reader.GetDecimal(10));
}
if (!(reader.IsDBNull(11)))
{
pur.nationality = reader.GetString(11);
}
if (!(reader.IsDBNull(12)))
{
pur.InfoField = reader.GetString(12);
}
if (!(reader.IsDBNull(13)))
{
pur.Active = reader.GetBoolean(13);
}
if (!(reader.IsDBNull(14)))
{
pur.ApprovalBegin = reader.GetDateTime(14);
}
if (!(reader.IsDBNull(15)))
{
pur.ApprovalEnd = reader.GetDateTime(15);
}
if (!(reader.IsDBNull(16)))
{
pur.EntryDate = reader.GetDateTime(16);
} // 17 = AGid, 18 = kontaktperson id
if (!(reader.IsDBNull(19)))
{
pur.hasIntroCourse = reader.GetBoolean(19);
}
if (!(reader.IsDBNull(20)))
{
pur.hasContract = reader.GetBoolean(20);
}
if (!(reader.IsDBNull(21)))
{
pur.DistrictCommision = reader.GetString(21);
}
if (!(reader.IsDBNull(22)))
{
pur.HomeAdress = new Adress();
if (!(reader.IsDBNull(23)))
{
pur.HomeAdress.Street = reader.GetString(23);
}
if (!(reader.IsDBNull(24)))
{
pur.HomeAdress.City = reader.GetString(24);
}
if (!(reader.IsDBNull(25)))
{
pur.HomeAdress.Country = reader.GetString(25);
}
if (!(reader.IsDBNull(26)))
{
pur.HomeAdress.HouseNumber = reader.GetInt32(26);
}
if (!(reader.IsDBNull(27)))
{
pur.HomeAdress.StairNumber = reader.GetInt32(27);
}
if (!(reader.IsDBNull(28)))
{
pur.HomeAdress.Etage = reader.GetInt32(28);
}
if (!(reader.IsDBNull(29)))
{
pur.HomeAdress.ZipCode = reader.GetInt32(29);
}
if (!(reader.IsDBNull(30)))
{
pur.HomeAdress.DoorNumber = reader.GetInt32(30);
}
}
//kontaktperson
if (!(reader.IsDBNull(31)))
{
pur.ContactPerson = new Person();
pur.ContactPerson.Id = reader.GetInt32(31);
if (!(reader.IsDBNull(32)))
{
pur.ContactPerson.EMail = reader.GetString(32);
}
if (!(reader.IsDBNull(33)))
{
pur.ContactPerson.FirstName = reader.GetString(33);
}
if (!(reader.IsDBNull(34)))
{
pur.ContactPerson.LastName = reader.GetString(34);
}
if (!(reader.IsDBNull(35)))
{
pur.ContactPerson.PhoneNumber = reader.GetString(35);
}
if (!(reader.IsDBNull(37)))
{
pur.ContactPerson.MobilePhone = reader.GetString(37);
}
if (!(reader.IsDBNull(43)))
{
pur.ContactPerson.InfoField = reader.GetString(43);
}
int i = 44;
if (!(reader.IsDBNull(i++)))
{
pur.ContactPerson.HomeAdress = new Adress();
if (!(reader.IsDBNull(i)))
{
pur.ContactPerson.HomeAdress.Street = reader.GetString(i++);
}
if (!(reader.IsDBNull(i)))
{
pur.ContactPerson.HomeAdress.City = reader.GetString(i++);
}
if (!(reader.IsDBNull(i)))
{
pur.ContactPerson.HomeAdress.Country = reader.GetString(i++);
}
if (!(reader.IsDBNull(i)))
{
pur.ContactPerson.HomeAdress.HouseNumber = reader.GetInt32(i++);
}
if (!(reader.IsDBNull(i)))
{
pur.ContactPerson.HomeAdress.StairNumber = reader.GetInt32(i++);
}
if (!(reader.IsDBNull(i)))
{
pur.ContactPerson.HomeAdress.Etage = reader.GetInt32(i++);
}
if (!(reader.IsDBNull(i)))
{
pur.ContactPerson.HomeAdress.ZipCode = reader.GetInt32(i++);
}
if (!(reader.IsDBNull(i)))
{
pur.ContactPerson.HomeAdress.DoorNumber = reader.GetInt32(i++);
}
}
}
purData.Purchaser = pur;
if (!(reader.IsDBNull(53)))
{
purData.TravellingAllowanceKM = reader.GetDecimal(53);
}
if (!(reader.IsDBNull(54)))
{
purData.HourlyRatePayoff = reader.GetDecimal(54);
}
if (!(reader.IsDBNull(55)))
{
purData.HourlyRate = reader.GetDecimal(55);
}
if (!(reader.IsDBNull(56)))
{
purData.InputIncome = reader.GetDecimal(56);
}
if (!(reader.IsDBNull(57)))
{
purData.Month = Convert.ToInt32(reader.GetDecimal(57));
}
if (!(reader.IsDBNull(58)))
{
purData.Year = Convert.ToInt32(reader.GetDecimal(58));
}
//59 = agid
if (!(reader.IsDBNull(60)))
{
purData.TravellingAllowance = reader.GetDecimal(60);
}
if (!(reader.IsDBNull(61)))
{
purData.AssistenceDemand = reader.GetInt32(61);
}
if (!(reader.IsDBNull(62)))
{
purData.CareAllowance = reader.GetInt32(62);
}
if (!(reader.IsDBNull(63)))
{
purData.Income = reader.GetDecimal(63);
}
//64 = agdatenid
purData.Purchaser.Employees = new List <EmploymentStatus>();
if (employedPaIds.Contains(Convert.ToInt32(purData.Purchaser.Id)))
{
purData.Purchaser.Employees.Add(new EmploymentStatus());
}
pds.Add(purData);
}
reader.Close();
}
catch (Exception e) { MessageBox.Show(e.Message.ToString(), "Error"); }
con.Close();
return(pds);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (purData == null)
{
purData = new PurchaserData();
}
if (purData.Purchaser == null)
{
purData.Purchaser = new Purchaser();
}
Purchaser pur = purData.Purchaser;
//purData = new PurchaserData();
pur.HomeAdress = new Adress();
InputEvaluator ie = new InputEvaluator();
bool save = true;
if (doubles())
{
SystemSounds.Asterisk.Play();
switch (MessageBox.Show("Es existiert bereits ein Auftraggeber mit diesem Namen. Soll er wirklich hinzugefügt werden?",
"Achtung!",
MessageBoxButton.YesNo, MessageBoxImage.Question))
{
case MessageBoxResult.No:
save = false;
break;
case MessageBoxResult.Yes:
break;
}
}
if (save)
{
if (ie.Evaluate(this))
{
pur.FirstName = FirstName.getContent();
pur.LastName = LastName.getmustContent();
pur.EMail = Email.getContent();
if (PhoneNr.getContent() != null)
{
pur.PhoneNumber = PhoneNr.getContent();
}
if (MobileNr.getContent() != null)
{
pur.MobilePhone = MobileNr.getContent();
}
pur.HomeAdress.Street = Street.getContent();
pur.HomeAdress.StairNumber = parseInt(StairNr.getContent());
pur.HomeAdress.HouseNumber = parseInt(HNr.getContent());
pur.HomeAdress.Etage = parseInt(Etage.getContent());
pur.HomeAdress.DoorNumber = parseInt(DoorNr.getContent());
pur.HomeAdress.City = City.getContent();
pur.HomeAdress.Country = Country.getContent();
pur.HomeAdress.ZipCode = parseInt(ZIP.getContent());
pur.BIC = BIC.getContent();
pur.IBAN = IBAN.getContent();
pur.SVN = parseLong(SVN.getContent());
pur.AccountHolder = kontoinhaber.getContent();
pur.EntryDate = EntryDate.SelectedDate;
pur.ApprovalBegin = ApprovelFrom.SelectedDate;
pur.ApprovalEnd = ApprovelTo.SelectedDate;
pur.nationality = nationality.getContent();
purData.HourlyRate = parseDecimal(PayperHour.getContent());
purData.TravellingAllowanceKM = parseDecimal(KmPay.getContent());
purData.HourlyRatePayoff = parseDecimal(billablePayperHour.getContent());
purData.Income = parseDecimal(Income.getContent());
purData.AssistenceDemand = parseInt(Needof.getContent());
purData.InputIncome = parseDecimal(IncomeBetrag.getContent());
purData.CareAllowance = parseInt((string)CareAllowence.SelectedValue);
pur.DistrictCommision = districtcommission.getContent();
if ((bool)activeRadioBtn.IsChecked)
{
pur.Active = true;
}
if ((bool)einfuehrungskurs.IsChecked)
{
pur.hasContract = true;
}
if ((bool)contract.IsChecked)
{
pur.hasIntroCourse = true;
}
//switch to Übersicht
foreach (Window window in Application.Current.Windows)
{
if (window.GetType() == typeof(Main))
{
(window as Main).FrameÜbersicht.Source = new Uri("../Personenverwaltung/AG/AGÜbersicht.xaml", UriKind.Relative);
}
}
purData.Purchaser = pur;
if (pur.FirstName != null && pur.LastName != null)
{
_bl.CreatePurchaser(purData);
}
//add PA connection
PAtoPurchaserBL PBL = new PAtoPurchaserBL();
foreach (PersonalAssistant pa in addedPAs)
{
foreach (PersonalAssistant pad in deletedPAs)
{
if (pa.Id == pad.Id)
{
addedPAs.Remove(pa);
deletedPAs.Remove(pad);
}
}
}
foreach (PersonalAssistant pa in addedPAs)
{
PBL.add(pa, pur);
}
//delete PA connection
foreach (PersonalAssistant pa in deletedPAs)
{
PBL.delete(pa, pur);
}
}
}
}
public PurchaserData Select(PurchaserData pur)
{
return(PurDao.Select(pur));
}
