public List <EffortEntry> GetEntriesByPa(PersonalAssistant pa, int month, int year)
{
EffortEntryDAO eDao = new EffortEntryDAO();
List <EffortEntry> entry = eDao.GetEntriesByPa(pa, month, year);
return(null);
}
public async Task PerformLongRunningTaskAsync_if_year_is_2020_Returns_true()
{
// Arrange
httpMessageHandler
.Protected()
.Setup <Task <HttpResponseMessage> >(
"SendAsync",
ItExpr.IsAny <HttpRequestMessage>(),
ItExpr.IsAny <CancellationToken>())
.ReturnsAsync(new HttpResponseMessage
{
StatusCode = HttpStatusCode.OK,
Content = new StringContent("")
});
// Act
var todaysDate = PersonalAssistant.GetTodaysDate();
bool result;
if (todaysDate.Contains("2020"))
{
result = await personalAssistant.PerformLongRunningTaskAsync(3000);
}
else
{
throw new XunitException("Can't perform task because the date is:");
}
// Assert
Assert.True(result);
}
public bool CreatePa(PersonalAssistant pa)
{
if (EntriesValid())
{
_paDao = new PersonalAssistantDAO();
try
{
pa = checkEmployee(pa);
pa = checkWeiterbidlung(pa);
PaDao.insert(pa);
// adding employment status
if (pa.Purchasers != null)
{
foreach (Purchaser p in pa.Purchasers)
{
PaDao.insertEmploymentStatus(p, pa);
}
}
}
catch (ExceptionHandler e)
{
}
return(true);
}
else
{
return(false);
}
}
internal void delete(PersonalAssistant pa, Purchaser p)
{
NpgsqlConnection con = DB.DBConnector.GetConnection();
NpgsqlCommand cmd = new NpgsqlCommand(null, con);
try
{
cmd.CommandText = "DELETE FROM Dienstverhaeltnis WHERE \"agid\"=@agid AND \"paid\"=@paid";
DB.DBConnector.AddToCommand("@agid", NpgsqlTypes.NpgsqlDbType.Numeric, cmd, p.Id);
DB.DBConnector.AddToCommand("@paid", NpgsqlTypes.NpgsqlDbType.Numeric, cmd, pa.Id);
try { cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.Message.ToString(), "Error"); }
}
catch (Exception e)
{
MessageBox.Show(e.Message.ToString(), "Error");
}
/*
* NpgsqlCommand commit = new NpgsqlCommand(null, con);
* commit.CommandText = "COMMIT";
* cmd.ExecuteNonQuery();
*/
con.Close();
}
public void employingPurchasersTest()
{
PersonalAssistantDAO paDao = new PersonalAssistantDAO();
PurchaserDataDAO pdDao = new PurchaserDataDAO();
PersonalAssistant originalPa = pa;
originalPa = paDao.insert(originalPa);
idToDelete = originalPa.Id;
List <PurchaserData> purs = pdDao.SelectAll();
if (purs == null || purs.Count == 0)
{
Assert.Fail("Can not add purchaser to personal assistants purchasersList");
}
Purchaser p = purs[0].Purchaser;
paDao.insertEmploymentStatus(p, originalPa);
//when
paDao.selectPurchaserList(originalPa);
//then
Assert.IsNotNull(originalPa.Purchasers);
Assert.AreEqual(originalPa.Purchasers.Count, 1);
Assert.AreEqual(originalPa.Purchasers[0].Id, p.Id);
}
/*
* public static void TestPurchaser()
* {
* Purchaser p = new Purchaser();
* PurchaserDAO pdao = new PurchaserDAO();
*
* //test Insert
* p.FirstName = "testpersonDao";
* p.LastName = "testpersonDao";
* p.PhoneNumber = 9999;
* p.MobilePhone = 99999;
* p.EMail = "*****@*****.**";
* p.HomeAdress.City = "LINZ";
* p.HomeAdress.Country = "schland";
* p.HomeAdress.DoorNumber = 11115;
* p.HomeAdress.StairNumber = 2345;
* pdao.Insert(p);
*
* PurchaserData d = new PurchaserData();
* d.Purchaser = p;
* d.AssistenceDemand = 12;
* d.CareAllowance = 13;
* d.HourlyRate = 30;
* d.HourlyRatePayoff = 20;
* d.Income = 29;
* d.InputIncome = 100;
* d.Month = 11;
* d.TravellingAllowance = 12;
* d.TravellingAllowanceKM = 11;
* d.Year = 2015;
* PurchaserDataDAO pdDao = new PurchaserDataDAO();
* pdDao.Insert(d);
*
* d.Income = 350;
* pdDao.Update(d);
*
*
* }
* */
static void Test2()
{
PersonalAssistantDAO pdao = new PersonalAssistantDAO();
PersonalAssistant pa = new PersonalAssistant();
pa.Id = 991;
}
public static void TestAdressDao()
{
/* Adress a = new Adress();
* IAdressDAO Adao = new AdressDAO();
* //test Insert @street, @houseNumber, @doorNumber, @stairNumber, @zipCode, @city, @country) WHERE adressId =@adressId";
* a.street = "Karl-Steiger-Strasse";
* a.houseNumber = 11;
* a.doorNumber = 2;
* a.stairNumber = 0;
* a.zipCode = 4030;
* a.city = "Linz";
* a.country = "Austria";
* Adao.insert(a);
*
* //test update
* Adao.update(a);*/
PersonalAssistant p = new PersonalAssistant();
PersonalAssistantDAO pdao = new PersonalAssistantDAO();
//test Insert
p.FirstName = "Susanne";
p.LastName = "Ludwig";
p.PhoneNumber = "9999";
p.MobilePhone = "99999";
p.EMail = "*****@*****.**";
p.HomeAdress.City = "Wartberg";
pdao.insert(p);
}
//Auswählen Button
private void button_Click(object sender, RoutedEventArgs e)
{
if (GridÜbersicht.SelectedIndex != -1)
{
PersonalAssistant pa = new PersonalAssistant();
pa.Id = Data[GridÜbersicht.SelectedIndex].Id;
pa.FirstName = Data[GridÜbersicht.SelectedIndex].FirstName;
pa.LastName = Data[GridÜbersicht.SelectedIndex].LastName;
if (newAG != null)
{
newAG.employedPA.Add(pa);
newAG.addedPAs.Add(pa);
newAG.guiListEmployed.Add(new Track(pa.Id, pa.FirstName, pa.LastName));
newAG.employedPersonalAssistants.ItemsSource = newAG.guiListEmployed;
}
else if (editAG != null)
{
editAG.employedPA.Add(pa);
editAG.addedPAs.Add(pa);
editAG.guiListEmployed.Add(new Track(pa.Id, pa.FirstName, pa.LastName));
editAG.employedPersonalAssistants.ItemsSource = editAG.guiListEmployed;
}
this.Close();
}
}
public static void setUp(TestContext testContext)
{
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);
}
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);
}
private PersonalAssistant checkEmployee(PersonalAssistant pa)
{
if (pa.EmploymentTimes == null)
{
pa.EmploymentTimes = new List <Employment>();
Employment e = new Employment();
DateTime d = DateTime.Now;
e.EmplBegin = d;
pa.EmploymentTimes.Add(e);
}
else if (pa.EmploymentTimes.Count == 0)
{
Employment e = new Employment();
DateTime d = DateTime.Now;
e.EmplBegin = d;
pa.EmploymentTimes.Add(e);
}
if (pa.EmploymentTimes.Last().EmplBegin.Year == 1)
{
pa.EmploymentTimes.Last().EmplBegin = DateTime.Now;
}
PaDao.update(pa);
return(pa);
}
public LAAuswählen(PersonalAssistant pa, Purchaser pur, int month, int year)
{
InitializeComponent();
CenterWindowOnScreen();
A1.Items.Add(Activity.State.Nachtbereitschaft);
A1.Items.Add(Activity.State.Grundversorgung);
A1.Items.Add(Activity.State.Hauswirtschaft);
A1.Items.Add(Activity.State.Begleitung);
A1.Items.Add(Activity.State.Freizeitgestaltung);
A1.Items.Add(Activity.State.Kommunikation);
A2.Items.Add(Activity.State.Grundversorgung);
A2.Items.Add(Activity.State.Hauswirtschaft);
A2.Items.Add(Activity.State.Begleitung);
A2.Items.Add(Activity.State.Freizeitgestaltung);
A2.Items.Add(Activity.State.Kommunikation);
A3.Items.Add(Activity.State.Grundversorgung);
A3.Items.Add(Activity.State.Hauswirtschaft);
A3.Items.Add(Activity.State.Begleitung);
A3.Items.Add(Activity.State.Freizeitgestaltung);
A3.Items.Add(Activity.State.Kommunikation);
if (pa != null && pur != null)
{
paName.Text = pa.FirstName + " " + pa.LastName;
monthBox.Text = new DateTime(year, month, 1).ToString("MMMM yyyy");;
eeList = bl.GetEntries(pa, pur, month, year);
Übersicht.ItemsSource = eeList;
}
}
//-----------------------------------------------------------------------------------------------------
public PersonalAssistant update(PersonalAssistant person)
{
PersonDAO pdao = new PersonDAO();
pdao.Update(person);
NpgsqlConnection con = DB.DBConnector.GetConnection();
NpgsqlCommand command = new NpgsqlCommand(null, con);
command.CommandText = "UPDATE persoenlicherassistent SET aktiv=@aktiv,abgabedatumunterlagen=@datumunterlagen,SV=@SV,Dienstvertrag=@Dienstvertrag,BestaetigungBH=@BH,Grundkurs=@Grundkurs,DeadLineWeiterbildung=@DeadLineWeiterbildung,WeiterbildungsStunden=@WeiterbildungsStunden WHERE paid=@paid";
//command.CommandText = "UPDATE persoenlicherassistent SET aktiv=@aktiv WHERE paid=@paid";
DB.DBConnector.AddToCommand("@paid", NpgsqlTypes.NpgsqlDbType.Numeric, command, person.Id);
DB.DBConnector.AddToCommand("@aktiv", NpgsqlTypes.NpgsqlDbType.Boolean, command, person.Active);
DB.DBConnector.AddToCommand("@datumunterlagen", NpgsqlTypes.NpgsqlDbType.Date, command, person.ClosingDateDocuments);
DB.DBConnector.AddToCommand("@SV", NpgsqlTypes.NpgsqlDbType.Boolean, command, person.SV);
DB.DBConnector.AddToCommand("@Dienstvertrag", NpgsqlTypes.NpgsqlDbType.Boolean, command, person.Dienstvertrag);
DB.DBConnector.AddToCommand("@BH", NpgsqlTypes.NpgsqlDbType.Boolean, command, person.BestBH);
DB.DBConnector.AddToCommand("@Grundkurs", NpgsqlTypes.NpgsqlDbType.Boolean, command, person.Grundkurs);
DB.DBConnector.AddToCommand("@DeadLineWeiterbildung", NpgsqlTypes.NpgsqlDbType.Date, command, person.deadLineHours);
DB.DBConnector.AddToCommand("@WeiterbildungsStunden", NpgsqlTypes.NpgsqlDbType.Numeric, command, person.consumedHours);
try { command.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.Message.ToString(), "Error"); }
con.Close();
return(person);
}
public EffortEntry GetEntry(PersonalAssistant pa, int month, int year, int day)
{
EffortEntryDAO eDao = new EffortEntryDAO();
EffortEntry entry = eDao.GetEntry(pa, month, year, day);
return(null);
}
public List <PersonalAssistant> SelectSpecificPa(PersonalAssistant pa)
{
List <PersonalAssistant> paList = new List <PersonalAssistant>();
paList = PaDao.SelectSpecific(pa);
//Fehlerbehandlung
return(paList);
}
public bool UpdatePa(PersonalAssistant pa)
{
pa = checkEmployee(pa);
pa = checkWeiterbidlung(pa);
PaDao.update(pa);
//Fehlerbehandlung
return(true);
}
private void openLAA()
{
selectedPersonalAssistent = ((PersonalAssistant)personalAssistentsBox.SelectedItem);
LAAuswählen la = new LAAuswählen(selectedPersonalAssistent, selectedPurchaserData.Purchaser, selectedMonth, selectedYear);
la.ShowDialog();
showPurchaserData();
}
public void GetTodaysDate_Returns_formatted_date_in_Portuguese()
{
// Arrange
// Act
var todaysDate = PersonalAssistant.GetTodaysDate();
// Assert
Assert.NotNull(todaysDate);
Assert.NotEmpty(todaysDate);
Assert.True(todaysDate.IndexOf("de ") > 0, $"today's date should contain the article 'de'. got this instead: {todaysDate}");
}
public void GetTodaysDate_Returns_formatted_date()
{
// Arrange
// Act
var todaysDate = PersonalAssistant.GetTodaysDate();
// Assert
Assert.NotNull(todaysDate);
Assert.NotEmpty(todaysDate);
Assert.True(todaysDate.IndexOf("2020") > 0, "today's date should contain the year 2020");
}
public NonIsolatedTests()
{
httpMessageHandler = new Mock <HttpMessageHandler>();
var httpClient = new Mock <HttpClient>(httpMessageHandler.Object);
var logger = new Mock <ILogger <PersonalAssistant> >();
var houseService = new Mock <IHouseService>();
var weatherApiKey = "won't matter";
personalAssistant = new PersonalAssistant(logger.Object, httpClient.Object, new WeatherApiConfig {
ApiKey = weatherApiKey
}, houseService.Object);
}
private PersonalAssistant checkWeiterbidlung(PersonalAssistant p)
{
if (p.deadLineHours == null || p.deadLineHours.Value.Year == 1)
{
p.deadLineHours = DateTime.Now;
}
if (p.consumedHours >= 16)
{
p.deadLineHours = p.deadLineHours.Value.AddYears(2);
p.consumedHours = 0;
p = PaDao.update(p);
}
return(p);
}
public PersonalAssistant SelectPa(int id)
{
PersonalAssistant p = new PersonalAssistant(id);
try
{
p = PaDao.select(p);
}
catch (Exception e)
{
Console.WriteLine("Select hat nix gefunden");
}
return(p);
}
private void btnInfo_Click(object sender, RoutedEventArgs e)
{
if (pa == null)
{
pa = new PersonalAssistant();
}
infoW = new InfoWindow(pa.InfoField);
infoW.ShowDialog();
if (infoW.changed)
{
pa.InfoField = infoW.tbInfo.Text;
}
}
public void SelectAllTestPersonalAss()
{
//given (see setUp)
PersonalAssistant p = pa;
PersonalAssistantDAO pDao = new PersonalAssistantDAO();
//when
p = pDao.insert(p);
idToDelete = p.Id;
List <PersonalAssistant> pas = pDao.SelectAll();
//then
foreach (PersonalAssistant pa in pas)
{
if (pa.Id == p.Id)
{
//person
Assert.AreEqual(pa.FirstName, "persöhnlicher");
Assert.AreEqual(pa.LastName, "assistent");
Assert.AreEqual(pa.PhoneNumber, "9999");
Assert.AreEqual(pa.MobilePhone, "99999");
Assert.AreEqual(pa.EMail, "*****@*****.**");
Assert.AreEqual(pa.HomeAdress.Street, "Am Hügel");
Assert.AreEqual(pa.HomeAdress.HouseNumber, 12);
Assert.AreEqual(pa.HomeAdress.City, "LINZ");
Assert.AreEqual(pa.HomeAdress.Country, "schland");
Assert.AreEqual(pa.HomeAdress.DoorNumber, 11115);
Assert.AreEqual(pa.HomeAdress.StairNumber, 2345);
Assert.AreEqual(pa.HomeAdress.Etage, 2);
Assert.AreEqual(pa.HomeAdress.ZipCode, 5040);
Assert.AreEqual(pa.IBAN, "AT1254859888898");
Assert.AreEqual(pa.BIC, "SPPR2586XX");
Assert.AreEqual(pa.AccountHolder, "Helmut Günther");
Assert.AreEqual(pa.SVN, 1225020496);
Assert.AreEqual(pa.nationality, "Auenland");
Assert.AreEqual(pa.InfoField, "Infotext");
//pa
Assert.AreEqual(pa.Active, true);
Assert.AreEqual(pa.ClosingDateDocuments, new DateTime(2016, 02, 03));
Assert.AreEqual(pa.SV, true);
Assert.AreEqual(pa.Dienstvertrag, true);
Assert.AreEqual(pa.BestBH, true);
Assert.AreEqual(pa.Grundkurs, true);
Assert.AreEqual(pa.consumedHours, 2.4M);
Assert.AreEqual(pa.deadLineHours, new DateTime(2017, 02, 04));
}
}
}
public PersonalAssistant Select(PersonalAssistant pa)
{
if (pa.Id == 54321)
{
pa.Active = true;
pa.ClosingDateDocuments = new DateTime(2015, 10, 10);
pa.EMail = "*****@*****.**";
pa.EmploymentTimes = new List <Employment>();
Employment first = new Employment();
first.EmplBegin = new DateTime(2000, 01, 01);
first.EmplEnd = new DateTime(2001, 01, 01);
first.EmplId = 12345;
Employment sec = new Employment();
sec.EmplBegin = new DateTime(2014, 01, 01);
sec.EmplId = 12333;
pa.EmploymentTimes = new List <Employment>();
pa.EmploymentTimes.Add(first);
pa.EmploymentTimes.Add(sec);
pa.FirstName = "Muster";
pa.LastName = "Franz";
pa.MobilePhone = "07327773546";
EmploymentStatus es = new EmploymentStatus();
es.Assistant = pa;
Person p1 = new Person();
p1.Id = 88888;
p1.LastName = "Huber";
p1.FirstName = "Hansl";
es.Purchaser = new Purchaser(p1);
pa.PhoneNumber = "18923742774";
pa.Documents = new List <Document>();
pa.Documents.Add(new Document());
Adress ad = new Adress();
ad.AdressId = 98765;
ad.City = "Hagenberg";
ad.Country = "Österreich";
ad.DoorNumber = 2;
ad.HouseNumber = 12;
ad.Street = "Teststreet";
ad.ZipCode = 4209;
pa.HomeAdress = ad;
return(pa);
}
else
{
return(null);
}
}
/// <summary>
/// Einfügen eines Dienstverhältnisses, kann nur über PADAO eingefügt werden, nicht über PurchaserDataDAO!
/// </summary>
/// <param name="pur"></param>
/// <param name="pa"></param>
public void insertEmploymentStatus(Purchaser pur, PersonalAssistant pa)
{
NpgsqlConnection con = DB.DBConnector.GetConnection();
NpgsqlCommand command = new NpgsqlCommand(null, con);
command.CommandText = "INSERT INTO Dienstverhaeltnis VALUES (@agid,@paid)";
DB.DBConnector.AddToCommand("@paid", NpgsqlTypes.NpgsqlDbType.Numeric, command, pa.Id);
DB.DBConnector.AddToCommand("@agid", NpgsqlTypes.NpgsqlDbType.Numeric, command, pur.Id);
try { command.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.Message.ToString(), "Error"); }
con.Close();
}
public void deleteEmploymentStatus(Purchaser pur, PersonalAssistant pa)
{
//eventuell alte Dienstverträge in einen dafür vorgesehenen Ordner verschieben
NpgsqlConnection con = DB.DBConnector.GetConnection();
NpgsqlCommand command = new NpgsqlCommand(null, con);
command.CommandText = "DELETE FROM Dienstverhaeltnis WHERE agid=@agid AND paid=@paid";
DB.DBConnector.AddToCommand("@paid", NpgsqlTypes.NpgsqlDbType.Numeric, command, pa.Id);
DB.DBConnector.AddToCommand("@agid", NpgsqlTypes.NpgsqlDbType.Numeric, command, pur.Id);
try { command.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.Message.ToString(), "Error"); }
con.Close();
}
public void updateEmployment(PersonalAssistant person)
{
NpgsqlConnection con = DB.DBConnector.GetConnection();
NpgsqlCommand command = new NpgsqlCommand(null, con);
command.CommandText = "UPDATE dienst SET (Ende=@ende)WHERE paid=@paid AND beginn=@begin";
DB.DBConnector.AddToCommand("@paid", NpgsqlTypes.NpgsqlDbType.Integer, command, person.Id);
DB.DBConnector.AddToCommand("@begin", NpgsqlTypes.NpgsqlDbType.Date, command, person.EmploymentTimes[person.EmploymentTimes.Count - 1].EmplBegin);
DB.DBConnector.AddToCommand("@ende", NpgsqlTypes.NpgsqlDbType.Date, command, person.EmploymentTimes[person.EmploymentTimes.Count - 1].EmplEnd);
try { command.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.Message.ToString(), "Error"); }
con.Close();
}
public void Insert(PersonalAssistant pa)
{
SqlConnection con = connector.getConnection();
using (con)
{
con.Open();
SqlCommand command = new SqlCommand(null, con);
command.CommandText = "Insert INTO persoenlicherassistentview" +
"(personid,vorname,nachname,telnummer,mobiltelefonnummer,email," +
"addressid,strasse,stadt,land,hausnummer,stiege,stock,plz,tuer,abgabeunterlagenbis,aktiv)" +
"Values (@personid,@vorname,@nachname,@telnummer,@mobiltelefonnummer,@email," +
"@addressid,@strass,@stadt,@land,@hausnummer,@stiege,@stock,@plz,@tuer@," +
"@abgabeunterlagenbis,@aktiv)";
SqlParameter personid = new SqlParameter("@personid", SqlDbType.Int);
}
}
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);
}
