//-----------------------------------------------------------------------------------------------------
public bool CreateMb(MonthlyBilling m)
{
// m = MbDao.InsertMonthlyBilling(m);
foreach (MonthlyBillingPerPa mbp in m.MbPerPaList)
{
//ermittelt die KM und Stunden Summen
if (mbp.EffortList != null)
{
foreach (EffortEntry ee in mbp.EffortList)
{
DateTime currentDate = new DateTime(ee.Year, ee.Month, ee.Day);
if (IsNightShift(ee.A1))
{
m.SumHours += 4;
}
else if (IsHoliday(currentDate) || IsNight(ee.From, ee.To))
{
TimeSpan diff = ee.To.Subtract(ee.From);
m.SumHours += (decimal)((diff.TotalHours * 1.5));
}
else
{
TimeSpan diff = ee.To.Subtract(ee.From);
m.SumHours += (int)(diff.TotalHours);
}
m.SumKm += ee.Km;
}
}
}
return(true);
}
private List <MonthlyBillingPerPa> selectAllMbpa(MonthlyBilling mb)
{
List <MonthlyBillingPerPa> mbppa = new List <MonthlyBillingPerPa>();
mbppa = MbDao.SelectMBperPa(mb);
return(mbppa);
}
//-----------------------------------------------------------------------------------------------------
public bool UpdateMb(MonthlyBilling mb)
{
if (MbDao.UpdateMonthlyBilling(mb))
{
return(true);
}
return(false);
}
public MonthlyBilling InsertMonthlyBilling(MonthlyBilling mb)
{
foreach (MonthlyBillingPerPa mbpa in mb.MbPerPaList)
{
mb.MbPerPaList.Add(InsertMonthlyBilling(mbpa));
}
return(mb);
}
//-----------------------------------------------------------------------------------------------------
/// <summary>
/// Liste von Monatsabrechnungen für einen PA aus DB holen
/// </summary>
/// <returns></returns>
public List <MonthlyBillingPerPa> SelectMbPerPa()
{
MonthlyBilling mb = new MonthlyBilling();
List <MonthlyBillingPerPa> mbppa = new List <MonthlyBillingPerPa>();
mbppa = MbDao.SelectMBperPa(mb);
return(mbppa);
}
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);
}
/// <summary>
/// for GUI selecting all Leistungseinträge and calculate all important values for MB
///
/// </summary>
/// <param name="mb"></param>
public void selectMB(MonthlyBilling mb)
{
this.mb = mb;
mb.MbPerPaList = selectAllMbpa(mb);
//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();
}
}
/// get MonthlyBilling
/// </summary>
private void showPurchaserData()
{
selectedMonthlyBilling = new MonthlyBilling();
selectedMonthlyBilling = mbBl.SelectMb(selectedYear, selectedMonth, selectedPurchaserData, currentAssistents);
selectedMonthlyBilling.Purchaser = selectedPurchaserData;
tbFahrtkostenAnzahl.Text = selectedMonthlyBilling.SumKm.ToString();
if (selectedMonthlyBilling.Purchaser != null)
{
tbAnzahlfestgelegterBetrag.Text = selectedMonthlyBilling.Purchaser.AssistenceDemand.ToString();
}
tbBetragfestgelegterBetrag.Text = selectedMonthlyBilling.BetragFestgelegterBedarf.ToString();
tbBetragAusEK.Text = selectedMonthlyBilling.Purchaser.InputIncome.ToString();
tbBetragAusPG.Text = selectedMonthlyBilling.ContributionCareAllowance.ToString();
tbDiffVormonatBetrag.Text = selectedMonthlyBilling.DifferenceToPreviousMonth.ToString();
tbAuszahlunsbetrag.Content = selectedMonthlyBilling.PayOut.ToString();
tbAnzahltatsVerbrStunden.Text = selectedMonthlyBilling.SumHours.ToString();
tbBetrtasVerbrStunden.Text = selectedMonthlyBilling.ConsumedHoursAmount.ToString();
tbBetragAusEKAbr.Text = selectedMonthlyBilling.Purchaser.InputIncome.ToString();
tbBetragAusPGAbr.Text = selectedMonthlyBilling.ContributionCareAllowance.ToString();
tbFahrtkostenAnzahl.Text = selectedMonthlyBilling.SumKm.ToString();
tbBetragFahrtkosten.Text = selectedMonthlyBilling.TravelExpences.ToString();
tbAbrechnungsbetrag.Content = selectedMonthlyBilling.PayOff.ToString();
tbausbezBetrag.Text = selectedMonthlyBilling.AmountActuallyPaid.ToString();
tbabgerechnBetrag.Text = selectedMonthlyBilling.PayOff.ToString();
tbDiff.Content = selectedMonthlyBilling.Difference.ToString();
tbStundenkontingent.Text = selectedMonthlyBilling.HourContingent.ToString();
tbbisherBeansprStunden.Text = selectedMonthlyBilling.SoFarTookHours.ToString();
tbverblStunden.Text = selectedMonthlyBilling.RemainingHours.ToString();
tbStundenguthaben.Text = selectedMonthlyBilling.CurrentHourDeposit.ToString();
assistenceDemand.Text = selectedMonthlyBilling.Purchaser.AssistenceDemand.ToString();
travellingAllowanceKM.Text = selectedMonthlyBilling.Purchaser.TravellingAllowanceKM.ToString();
income.Text = selectedMonthlyBilling.Purchaser.Income.ToString();
careAllowance.Text = selectedMonthlyBilling.Purchaser.CareAllowance.ToString();
hourlyRate.Text = selectedMonthlyBilling.Purchaser.HourlyRate.ToString();
hourlyRatePayoff.Text = selectedMonthlyBilling.Purchaser.HourlyRatePayoff.ToString();
inputIncome.Text = selectedMonthlyBilling.Purchaser.InputIncome.ToString();
careAllowanceMaximum.Text = selectedMonthlyBilling.Purchaser.CareAllowanceMaximum.ToString();
rehaDays.Text = selectedMonthlyBilling.RehaDays.ToString();
loadReha();
}
public List <MonthlyBillingPerPa> SelectMBperPa(MonthlyBilling mb)
{
throw new NotImplementedException();
}
public MonthlyBilling SelectAllMB(MonthlyBilling mb)
{
throw new NotImplementedException();
}
public List <MonthlyBilling> selectAllMB(MonthlyBilling pur)
{
throw new NotImplementedException();
}
public List <MonthlyBilling> selectAllFrom(DateTime?nullable)
{
NpgsqlConnection con = DB.DBConnector.GetConnection();
if (nullable == null)
{
nullable = new DateTime(2000, 01, 01);
}
;
NpgsqlCommand command = new NpgsqlCommand(null, con);
command.CommandText = "select * from monatsabrechnung where (monat >= @monat and jahr=@jahr) or jahr > @jahr ";
DB.DBConnector.AddToCommand("@monat", NpgsqlTypes.NpgsqlDbType.Numeric, command, nullable.Value.Month);
DB.DBConnector.AddToCommand("@jahr", NpgsqlTypes.NpgsqlDbType.Numeric, command, nullable.Value.Year);
NpgsqlDataReader reader = command.ExecuteReader();
List <MonthlyBilling> mbs = new List <MonthlyBilling>();
MonthlyBilling mb = new MonthlyBilling();
mb.MbPerPaList = new List <MonthlyBillingPerPa>();
MonthlyBillingPerPa currmba = null;
while (reader.Read())
{
MonthlyBillingPerPa mbPerPA = new MonthlyBillingPerPa();
if (!(reader.IsDBNull(0)))
{
mbPerPA.PrivateKm = reader.GetInt32(0);
}
if (!(reader.IsDBNull(1)))
{
mbPerPA.Month = Convert.ToInt32(reader.GetDecimal(1));
mb.Month = mbPerPA.Month;
}
if (!(reader.IsDBNull(2)))
{
mbPerPA.Year = Convert.ToInt32(reader.GetDecimal(2));
mb.Year = mbPerPA.Year;
}
if (!(reader.IsDBNull(3)))
{
mbPerPA.Pa = new PersonalAssistant(reader.GetInt32(3));
}
if (!(reader.IsDBNull(4)))
{
mbPerPA.Pur = new PurchaserData();
mbPerPA.Pur.Purchaser = new Purchaser();
mbPerPA.Pur.Purchaser.Id = reader.GetInt32(4);
if (mb.Purchaser == null)
{
mb.Purchaser = new PurchaserData();
mb.Purchaser.Purchaser = new Purchaser();
mb.Purchaser.Purchaser.Id = mbPerPA.Pur.Purchaser.Id;
}
}
if (!(reader.IsDBNull(5)))
{
mbPerPA.WorkingHours = reader.GetInt32(5);
}
if (!(reader.IsDBNull(6)))
{
mbPerPA.BillableKm = reader.GetInt32(6);
}
if (currmba != null && currmba.Month == mbPerPA.Month && currmba.Year == mbPerPA.Year && currmba.Pur.Purchaser.Id == mbPerPA.Pur.Purchaser.Id)
{
}
else if (currmba != null)
{
mbs.Add(mb);
mb = new MonthlyBilling();
mb.MbPerPaList = new List <MonthlyBillingPerPa>();
}
else
{
currmba = mbPerPA;
}
mb.MbPerPaList.Add(mbPerPA);
currmba = mbPerPA;
}
reader.Close();
con.Close();
return(mbs);
}
public MonthlyBilling InsertMonthlyBilling(MonthlyBilling mb)
{
//falsches Insert
return(null);
}
//-----------------------------------------------------------------------------------------------------
/// <summary>
/// holt eine bestimmte Monatsabrechnung aus der DB (bestimmtes Monat für bestimmten AG)
/// </summary>
/// <param name="mb"></param>
/// <returns></returns>
public MonthlyBilling SelectSpecificMb(MonthlyBilling mb)
{
return(null); //MbDao.SelectAllMB(mb);
}
public void selectMB(MonthlyBilling mb)
{
throw new NotImplementedException();
}
public List <MonthlyBilling> selectSpecificMB(MonthlyBilling mb)
{
throw new NotImplementedException();
}
public MonthlyBilling InsertMonthlyBilling(MonthlyBilling mb)
{
//falsches Insert
throw new NotImplementedException();
}
public List <MonthlyBilling> selectAllMB()
{
NpgsqlConnection con = DB.DBConnector.GetConnection();
NpgsqlCommand command = new NpgsqlCommand(null, con);
command.CommandText = "SELECT * FROM Monatsabrechnung ORDER BY agid,monat,jahr";
NpgsqlDataReader reader = command.ExecuteReader();
List <MonthlyBilling> mbs = new List <MonthlyBilling>();
MonthlyBilling mb = new MonthlyBilling();
mb.MbPerPaList = new List <MonthlyBillingPerPa>();
MonthlyBillingPerPa currmba = null;
while (reader.Read())
{
MonthlyBillingPerPa mbPerPA = new MonthlyBillingPerPa();
if (!(reader.IsDBNull(0)))
{
mbPerPA.PrivateKm = reader.GetInt32(0);
}
if (!(reader.IsDBNull(1)))
{
mbPerPA.Month = Convert.ToInt32(reader.GetDecimal(1));
mb.Month = mbPerPA.Month;
}
if (!(reader.IsDBNull(2)))
{
mbPerPA.Year = Convert.ToInt32(reader.GetDecimal(2));
mb.Year = mbPerPA.Year;
}
if (!(reader.IsDBNull(3)))
{
mbPerPA.Pa = new PersonalAssistant(reader.GetInt32(3));
}
if (!(reader.IsDBNull(4)))
{
mbPerPA.Pur = new PurchaserData();
mbPerPA.Pur.Purchaser = new Purchaser();
mbPerPA.Pur.Purchaser.Id = reader.GetInt32(4);
if (mb.Purchaser == null)
{
mb.Purchaser = new PurchaserData();
mb.Purchaser.Purchaser = new Purchaser();
mb.Purchaser.Purchaser.Id = mbPerPA.Pur.Purchaser.Id;
}
}
if (!(reader.IsDBNull(5)))
{
mbPerPA.WorkingHours = reader.GetInt32(5);
}
if (!(reader.IsDBNull(6)))
{
mbPerPA.BillableKm = reader.GetInt32(6);
}
if (currmba != null && currmba.Month == mbPerPA.Month && currmba.Year == mbPerPA.Year && currmba.Pur.Purchaser.Id == mbPerPA.Pur.Purchaser.Id)
{
}
else if (currmba != null)
{
mbs.Add(mb);
mb = new MonthlyBilling();
mb.MbPerPaList = new List <MonthlyBillingPerPa>();
}
else
{
currmba = mbPerPA;
}
mb.MbPerPaList.Add(mbPerPA);
currmba = mbPerPA;
}
reader.Close();
con.Close();
return(mbs);
}
public List <MonthlyBilling> selectAllFrom(DateTime?nullable)
{
List <MonthlyBilling> mb = new List <MonthlyBilling>();
MonthlyBilling mb1 = new MonthlyBilling();
MonthlyBilling mb2 = new MonthlyBilling();
MonthlyBillingPerPa mbppa1 = new MonthlyBillingPerPa();
MonthlyBillingPerPa mbppa2 = new MonthlyBillingPerPa();
MonthlyBillingPerPa mbppa3 = new MonthlyBillingPerPa();
MonthlyBillingPerPa mbppa4 = new MonthlyBillingPerPa();
MonthlyBillingPerPa mbppa5 = new MonthlyBillingPerPa();
mb1.Month = 6;
mb1.Year = 2015;
mb2.Month = 5;
mb2.Year = 2015;
EffortEntry e1 = new EffortEntry(2011, 06, 12,
new Purchaser(new Person("Hansi", "Müller", new Adress("Teststrasse", 2, 2323, "City"))), new PersonalAssistant(new Person("Elisabeth", "Schütz", new Adress("Hausstrasse", 12, 3445, "Linz"))), new DateTime(2011, 5, 6), new DateTime(2012, 7, 7), 22);
EffortEntry e2 = new EffortEntry(2011, 06, 12,
new Purchaser(new Person("Lisa", "Bauer", new Adress("Hochstrasse", 34, 7654, "Town"))), new PersonalAssistant(new Person("Hans", "Kunz", new Adress("testtest", 87, 6354, "Enns"))), new DateTime(2013, 5, 6), new DateTime(2015, 7, 7), 242);
EffortEntry e3 = new EffortEntry(2011, 06, 12,
new Purchaser(new Person("Thomas", "Mann", new Adress("Klammstrasse", 2, 2323, "City"))), new PersonalAssistant(new Person("Uwe", "Lamm", new Adress("Hausstrasse", 12, 1234, "Steyr"))), new DateTime(2011, 5, 6), new DateTime(2012, 7, 7), 22);
EffortEntry e4 = new EffortEntry(2011, 06, 12,
new Purchaser(new Person("Tom", "Bauer", new Adress("Friedlstrasse", 344, 9876, "Hall"))), new PersonalAssistant(new Person("Julia", "Niedermaier", new Adress("Lastenstrasse", 56, 6354, "Wels"))), new DateTime(2013, 5, 6), new DateTime(2015, 7, 7), 242);
e1.A1 = new Activity();
e1.A2 = new Activity();
e1.A3 = new Activity();
e1.A1.Name = new Activity.State();
e1.A2.Name = new Activity.State();
e1.A3.Name = new Activity.State();
e1.A1.Name = Activity.State.Nachtbereitschaft;
e1.A2.Name = Activity.State.Grundversorgung;
e1.A3.Name = Activity.State.Begleitung;
e1.Day = 1;
e1.Month = 2;
e1.Year = 2015;
e1.From = new DateTime(2015, 2, 1, 10, 23, 00);
e1.To = new DateTime(2015, 2, 1, 20, 00, 00);
e1.Km = 15;
e2.A1 = new Activity();
e2.A2 = new Activity();
e2.A1.Name = new Activity.State();
e2.A2.Name = new Activity.State();
e2.A1.Name = Activity.State.Begleitung;
e2.A2.Name = Activity.State.Freizeitgestaltung;
e2.Day = 3;
e2.Month = 7;
e2.Year = 2015;
e2.From = new DateTime(2015, 7, 3, 6, 20, 00);
e2.To = new DateTime(2015, 7, 3, 6, 20, 00);
e2.Km = 15;
e3.A1 = new Activity();
e3.A2 = new Activity();
e3.A1.Name = new Activity.State();
e3.A2.Name = new Activity.State();
e3.A1.Name = Activity.State.Begleitung;
e3.A2.Name = Activity.State.Freizeitgestaltung;
e3.Day = 3;
e3.Month = 7;
e3.Year = 2015;
e3.From = new DateTime();
e3.From.AddHours(12);
e3.From.AddMinutes(00);
e3.To = new DateTime();
e3.To.AddHours(15);
e3.To.AddMinutes(00);
e3.Km = 15;
e4.A1 = new Activity();
e4.A2 = new Activity();
e4.A1.Name = new Activity.State();
e4.A2.Name = new Activity.State();
e4.A1.Name = Activity.State.Begleitung;
e4.A2.Name = Activity.State.Freizeitgestaltung;
e4.Day = 3;
e4.Month = 7;
e4.Year = 2015;
e4.From = new DateTime(2015, 2, 1, 07, 25, 00);
e4.To = new DateTime(2015, 2, 1, 16, 00, 00);
e4.Km = 15;
mbppa1.EffortList = new List <EffortEntry>();
mbppa2.EffortList = new List <EffortEntry>();
mbppa3.EffortList = new List <EffortEntry>();
mbppa1.EffortList.Add(e2);
mbppa1.EffortList.Add(e1);
mbppa1.EffortList.Add(e4);
mbppa2.EffortList.Add(e3);
mbppa2.EffortList.Add(e4);
mbppa1.BillableKm = 22;
mbppa1.Pa = new PersonalAssistant(new Person("Franz", "Müller", new Adress("Sandl", 2, 2345, "Altstadt")));
mbppa1.Pur = new PurchaserData();
mbppa1.Pur.Purchaser.Active = true;
mbppa1.Pur.Purchaser.FirstName = "Hugo";
mbppa1.Pur.Purchaser.LastName = "Huber";
mbppa1.Pur.Purchaser.MobilePhone = "982374283745";
mbppa1.Pur.Purchaser.EntryDate = new DateTime(2010, 12, 12);
mbppa1.Pur.Purchaser.EMail = "*****@*****.**";
mbppa1.Pur.Purchaser.ApprovalBegin = new DateTime(2015, 01, 01);
mbppa1.Pur.Purchaser.ApprovalEnd = new DateTime(2015, 12, 31);
mbppa1.Pur.Purchaser.ContactPerson = new Person("Maria", "Huber", new Adress("Hauptstrasse", 12, 4040, "Linz"));
mbppa1.Pur.Purchaser.Employees = new List <EmploymentStatus>();
EmploymentStatus e0 =
new EmploymentStatus(
new PersonalAssistant(new Person("Brigitte", "Fritte",
new Adress("Landstrasse", 22, 4209, "Engerwitzdorf"))), mbppa1.Pur.Purchaser);
EmploymentStatus e5 =
new EmploymentStatus(
new PersonalAssistant(new Person("Max", "Moritz",
new Adress("Maienweg", 22, 4209, "Engerwitzdorf"))), mbppa1.Pur.Purchaser);
mbppa1.Pur.Purchaser.HomeAdress = new Adress("Heimatstrasse", 124, 2345, "Wien");
mbppa1.Pur.Purchaser.PhoneNumber = "28374937453987";
mbppa1.Pur.Income = 1500;
mbppa1.Pur.InputIncome = 150;
mbppa1.Pur.Month = 6;
mbppa1.Pur.Year = 2015;
mbppa1.Pur.TravellingAllowanceKM = (decimal)0.22;
mbppa1.Pur.HourlyRate = 20;
mbppa1.Pur.HourlyRatePayoff = (decimal)20.5;
mbppa1.Pur.CareAllowanceMaximum = 300;
mbppa1.Pur.CareAllowance = 2;
mbppa1.Pur.AssistenceDemand = 60;
mbppa2.BillableKm = 34;
mbppa2.Pa = new PersonalAssistant(new Person("Franz", "Müller", new Adress("Sandl", 2, 2345, "Altstadt")));
mbppa2.Pur = new PurchaserData();
mbppa2.Pur.Purchaser.Active = true;
mbppa2.Pur.Purchaser.FirstName = "Hugo";
mbppa2.Pur.Purchaser.LastName = "Huber";
mbppa2.Pur.Purchaser.MobilePhone = "982374283745";
mbppa2.Pur.Purchaser.EntryDate = new DateTime(2010, 12, 12);
mbppa2.Pur.Purchaser.EMail = "*****@*****.**";
mbppa2.Pur.Purchaser.ApprovalBegin = new DateTime(2015, 01, 01);
mbppa2.Pur.Purchaser.ApprovalEnd = new DateTime(2015, 12, 31);
mbppa2.Pur.Purchaser.ContactPerson = new Person("Maria", "Huber", new Adress("Hauptstrasse", 12, 4040, "Linz"));
mbppa2.Pur.Purchaser.Employees = new List <EmploymentStatus>();
EmploymentStatus e9 =
new EmploymentStatus(
new PersonalAssistant(new Person("Brigitte", "Fritte",
new Adress("Landstrasse", 22, 4209, "Engerwitzdorf"))), mbppa2.Pur.Purchaser);
EmploymentStatus e7 =
new EmploymentStatus(
new PersonalAssistant(new Person("Max", "Moritz",
new Adress("Maienweg", 22, 4209, "Engerwitzdorf"))), mbppa2.Pur.Purchaser);
mbppa2.Pur.Purchaser.HomeAdress = new Adress("Heimatstrasse", 124, 2345, "Wien");
mbppa2.Pur.Purchaser.PhoneNumber = "28374937453987";
mbppa2.Pur.Income = 1500;
mbppa2.Pur.InputIncome = 150;
mbppa2.Pur.Month = 6;
mbppa2.Pur.Year = 2015;
mbppa2.Pur.TravellingAllowanceKM = (decimal)0.22;
mbppa2.Pur.HourlyRate = 20;
mbppa2.Pur.HourlyRatePayoff = (decimal)20.5;
mbppa2.Pur.CareAllowanceMaximum = 300;
mbppa2.Pur.CareAllowance = 2;
mbppa2.Pur.AssistenceDemand = 60;
mb1.MbPerPaList = new List <MonthlyBillingPerPa>();
mb2.MbPerPaList = new List <MonthlyBillingPerPa>();
mb1.MbPerPaList.Add(mbppa1);
mb1.MbPerPaList.Add(mbppa2);
mb2.MbPerPaList.Add(mbppa2);
List <MonthlyBilling> list = new List <MonthlyBilling>();
list.Add(mb1);
list.Add(mb2);
return(list);
}
public bool UpdateMonthlyBilling(MonthlyBilling mb)
{
//falsches update
throw new NotImplementedException();
}
