public void Test_UpdateApplication()
{
ApplicationDAO application4 = new ApplicationDAO() { ID = 3, ApplicationID = 3, ApplicationStatus = "TestStatus2", SalaryExpectation = "TestSalary2" };
applicationService.UpdateApplication(application4);
Assert.AreEqual(applicationService.GetApplicationByID(3).SalaryExpectation, "TestSalary2");
Assert.AreEqual(applicationService.GetApplications().Count, 3);
}
private void initializeApplication(ApplicationDAO application, int id, int applicationID, string applicationStatus, string salaryExpect )
{
//ApplicationDAO application = new ApplicationDAO();
application.ID = id;
application.ApplicationID = applicationID;
application.ApplicationStatus = applicationStatus;
application.SalaryExpectation = salaryExpect;
application.FullTime = null;
application.AvailableForDays = null;
application.AvailableForEvenings = null;
application.AvailableForWeekends = null;
application.MondayFrom = null;
application.TuesdayFrom = null;
application.WednesdayFrom = null;
application.ThursdayFrom = null;
application.FridayFrom = null;
application.SaturdayFrom = null;
application.SundayFrom = null;
application.MondayTo = null;
application.TuesdayTo = null;
application.WednesdayTo = null;
application.ThursdayTo = null;
application.FridayTo = null;
application.SaturdayTo = null;
application.SundayTo = null;
}
public void Test_CreateApplication()
{
ApplicationDAO application4 = new ApplicationDAO() { ID = 4, ApplicationID = 4, ApplicationStatus = "TestStatus", SalaryExpectation = "TestSalary" };
applicationService.CreateApplication(application4);
Assert.AreEqual(applicationService.GetApplicationByID(4).SalaryExpectation, "TestSalary");
Assert.AreEqual(applicationService.GetApplications().Count, 4);
}
internal void SetUp()
{
ApplicationDAO applicationA = new ApplicationDAO() { ID = 1, ApplicationID = 1, ApplicationStatus = "Rejected", SalaryExpectation = "20.00" };
ApplicationDAO applicationB = new ApplicationDAO() { ID = 2, ApplicationID = 2, ApplicationStatus = "Accepted", SalaryExpectation = "21.00" };
ApplicationDAO applicationC = new ApplicationDAO() { ID = 3, ApplicationID = 3, ApplicationStatus = "Reviewed", SalaryExpectation = "22.00" };
Applications.Add(applicationA);
Applications.Add(applicationB);
Applications.Add(applicationC);
}
public bool UpdateApplication(ApplicationDAO newApp)
{
foreach (var application in Applications)
if (application.ApplicationID == newApp.ApplicationID)
{
Applications.Remove(application);
Applications.Add(newApp);
return true;
}
return false;
}
public bool CreateApplication(ApplicationDAO app)
{
Application a = new Application
{
Application_ID = app.ApplicationID,
ApplicationStatus = app.ApplicationStatus,
SalaryExpectation = app.SalaryExpectation,
FullTime = app.FullTime,
AvailableForDays = app.AvailableForDays,
AvailableForEvenings = app.AvailableForEvenings,
AvailableForWeekends = app.AvailableForWeekends,
MondayFrom = app.MondayFrom,
TuesdayFrom = app.TuesdayFrom,
WednesdayFrom = app.WednesdayFrom,
ThursdayFrom = app.ThursdayFrom,
FridayFrom = app.FridayFrom,
SaturdayFrom = app.SaturdayFrom,
SundayFrom = app.SundayFrom,
MondayTo = app.MondayTo,
TuesdayTo = app.TuesdayTo,
WednesdayTo = app.WednesdayTo,
ThursdayTo = app.ThursdayTo,
FridayTo = app.FridayTo,
SaturdayTo = app.SaturdayTo,
SundayTo = app.SundayTo
};
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
db.Applications.InsertOnSubmit(a);
try
{
db.SubmitChanges();
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
return true;
}
public bool CreateApplication(ApplicationDAO app)
{
Applications.Add(app);
return true;
}
public bool UpdateApplication(ApplicationDAO newApp)
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
Application a = db.Applications.Single(app => app.Application_ID == newApp.ApplicationID);
a.ApplicationStatus = newApp.ApplicationStatus;
a.AvailableForDays = newApp.AvailableForDays;
a.AvailableForEvenings = newApp.AvailableForEvenings;
a.AvailableForWeekends = newApp.AvailableForWeekends;
a.FridayFrom = newApp.FridayFrom;
a.FridayTo = newApp.FridayTo;
a.FullTime = newApp.FullTime;
a.MondayFrom = newApp.MondayFrom;
a.MondayTo = newApp.MondayTo;
a.SalaryExpectation = newApp.SalaryExpectation;
a.SaturdayFrom = newApp.SaturdayFrom;
a.SaturdayTo = newApp.SaturdayTo;
a.SundayFrom = newApp.SundayFrom;
a.SundayTo = newApp.SundayTo;
a.ThursdayFrom = newApp.ThursdayFrom;
a.ThursdayTo = newApp.ThursdayTo;
a.TuesdayFrom = newApp.TuesdayFrom;
a.TuesdayTo = newApp.TuesdayTo;
a.WednesdayFrom = newApp.WednesdayFrom;
a.WednesdayTo = newApp.WednesdayTo;
try
{
db.SubmitChanges();
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
return true;
}
// get applications for this particular applicant ID
public IList<ApplicationDAO> GetApplicationsByApplicant(int id)
{
try
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
IList<Applied> allApplieds = (from a in db.Applieds where a.Applicant_ID==id select a).ToList();
IList<Application> allApplications = (from a in db.Applications select a).ToList();
List<ApplicationDAO> result = new List<ApplicationDAO>();
foreach (var applied in allApplieds)
{
foreach (var application in allApplications)
{
if (applied.Application_ID == application.Application_ID)
{
ApplicationDAO app = new ApplicationDAO
{
ApplicationID = application.Application_ID,
ID = application.Application_ID,
ApplicationStatus = application.ApplicationStatus,
SalaryExpectation = application.SalaryExpectation,
FullTime = application.FullTime,
AvailableForDays = application.AvailableForDays,
AvailableForEvenings = application.AvailableForEvenings,
AvailableForWeekends = application.AvailableForWeekends,
MondayFrom = application.MondayFrom,
TuesdayFrom = application.TuesdayFrom,
WednesdayFrom = application.WednesdayFrom,
ThursdayFrom = application.ThursdayFrom,
FridayFrom = application.FridayFrom,
SaturdayFrom = application.SaturdayFrom,
SundayFrom = application.SundayFrom,
MondayTo = application.MondayTo,
TuesdayTo = application.TuesdayTo,
WednesdayTo = application.WednesdayTo,
ThursdayTo = application.ThursdayTo,
FridayTo = application.FridayTo,
SaturdayTo = application.SaturdayTo,
SundayTo = application.SundayTo
};
result.Add(app);
}
}
}
return result;
}
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
public IList<ApplicationDAO> GetApplications()
{
try
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
IList<Application> apps = db.Applications.ToList();
List<ApplicationDAO> result = new List<ApplicationDAO>();
foreach (var application in apps)
{
ApplicationDAO temp = new ApplicationDAO
{
ApplicationID = application.Application_ID,
ID = application.Application_ID,
ApplicationStatus = application.ApplicationStatus,
SalaryExpectation = application.SalaryExpectation,
FullTime = application.FullTime,
AvailableForDays = application.AvailableForDays,
AvailableForEvenings = application.AvailableForEvenings,
AvailableForWeekends = application.AvailableForWeekends,
MondayFrom = application.MondayFrom,
TuesdayFrom = application.TuesdayFrom,
WednesdayFrom = application.WednesdayFrom,
ThursdayFrom = application.ThursdayFrom,
FridayFrom = application.FridayFrom,
SaturdayFrom = application.SaturdayFrom,
SundayFrom = application.SundayFrom,
MondayTo = application.MondayTo,
TuesdayTo = application.TuesdayTo,
WednesdayTo = application.WednesdayTo,
ThursdayTo = application.ThursdayTo,
FridayTo = application.FridayTo,
SaturdayTo = application.SaturdayTo,
SundayTo = application.SundayTo
};
result.Add(temp);
}
return (result != null ? result : null);
}
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
public ApplicationDAO GetApplicationByID(int id)
{
try
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
Application application = (from a in db.Applications where a.Application_ID == id select a).FirstOrDefault();
ApplicationDAO result = new ApplicationDAO
{
ApplicationID = application.Application_ID,
ID = application.Application_ID,
ApplicationStatus = application.ApplicationStatus,
SalaryExpectation = application.SalaryExpectation,
FullTime = application.FullTime,
AvailableForDays = application.AvailableForDays,
AvailableForEvenings = application.AvailableForEvenings,
AvailableForWeekends = application.AvailableForWeekends,
MondayFrom = application.MondayFrom,
TuesdayFrom = application.TuesdayFrom,
WednesdayFrom = application.WednesdayFrom,
ThursdayFrom = application.ThursdayFrom,
FridayFrom = application.FridayFrom,
SaturdayFrom = application.SaturdayFrom,
SundayFrom = application.SundayFrom,
MondayTo = application.MondayTo,
TuesdayTo = application.TuesdayTo,
WednesdayTo = application.WednesdayTo,
ThursdayTo = application.ThursdayTo,
FridayTo = application.FridayTo,
SaturdayTo = application.SaturdayTo,
SundayTo = application.SundayTo
};
return (result != null ? result : null);
}
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}