public static JobDAO mapToJobDAO(jobDTO b)
{
JobDAO a = new JobDAO();
if (b.client != null)
{
a.Client = Mapping.ClientMapper.MapToClientDAO(b.client);
}
a.ClientID = b.ClientId;
a.Complete = b.Complete;
a.EstimatedDuration = b.EstimatedDuration;
a.Id = b.Id;
a.Notes = b.Notes;
a.ServiceTypeID = b.ServiceTypeId;
if (b.StartDate != null)
{
a.StartDate = b.StartDate;
}
if (b.type != null)
{
a.ServiceType = Mapping.ServiceTypeMapper.MaptoServiceTypeDAO(b.type);
}
if (b.user != null)
{
a.User = Mapping.AspNetUserMapper.mapToUserDAO(b.user);
}
a.UserID = b.UserId;
a.Hours = b.Hours;
return(a);
}
public bool insertJob(jobDTO job)
{
var a = logic.getClientsByName(job.client.Name).FirstOrDefault();
var b = logic.getServiceTypes().Where(m => m.Name.Equals(job.type.Name)).FirstOrDefault();
var c = logic.getAspNetUsersByName(job.user.Name).FirstOrDefault();
job.UserId = c.Id;
job.ServiceTypeId = b.Id;
job.ClientId = a.Id;
return(logic.insertJob(job));
}
public void testInsertJob()
{
var testjob = new jobDTO();
testjob.client = myLogic.getClientsByName("Derek Geter").FirstOrDefault();
testjob.type = myLogic.getServiceTypes().Where(m => m.Name.Equals("Butcher")).FirstOrDefault();
testjob.user = myLogic.getAspNetUsersByName("My Company").FirstOrDefault();
testjob.ClientId = testjob.client.Id;
testjob.UserId = testjob.user.Id;
testjob.ServiceTypeId = testjob.type.Id;
var result = myLogic.insertJob(testjob);
Assert.True(result);
}
public Invoice generateInvoice(jobDTO job)
{
Invoice invoice = new Invoice();
invoice.expenses = new List <InvoiceExpenses>();
invoice.BusinessName = job.user.Name;
invoice.BusinessPhoneNumber = job.user.PhoneNumber;
invoice.ClientName = job.client.Name;
invoice.ClientNumber = job.client.PhoneNumber;
invoice.ClientStreet = job.client.Address.Street;
invoice.ClientCity = job.client.Address.City;
invoice.ClientState = job.client.Address.State;
invoice.ZipCode = job.client.Address.Zip;
invoice.ServiceType = job.type.Name;
invoice.StartDate = job.StartDate.GetValueOrDefault().ToString();
invoice.EndDate = job.StartDate.GetValueOrDefault().AddDays(job.EstimatedDuration.GetValueOrDefault()).ToString();
invoice.HourlyRate = job.type.Rate.GetValueOrDefault().ToString();
invoice.BilledHours = job.Hours.GetValueOrDefault().ToString();
var jobexpenses = getJobExpenseByJobId(job);
var expenses = new List <ExpenseDTO>();
foreach (var item in jobexpenses)
{
var x = getExpenses().Where(m => m.Id == item.ExpenseId).FirstOrDefault();
expenses.Add(x);
InvoiceExpenses ie = new InvoiceExpenses();
ie.Cost = x.Cost.ToString();
ie.Name = x.Name;
invoice.expenses.Add(ie);
}
var expensetotal = 0.00m;
foreach (var item in expenses)
{
expensetotal += item.Cost;
}
var subtotal = (job.type.Rate * job.Hours) + expensetotal;
invoice.totalExpenses = Decimal.Round(expensetotal, 2);
invoice.subTotal = Decimal.Round(subtotal.GetValueOrDefault(), 2);
invoice.totalExpensesString = "$" + expensetotal.ToString();
invoice.subTotalString = "$" + subtotal.ToString();
invoice.Notes = job.Notes;
return(invoice);
}
public static jobDTO mapToJobDTO(JobDAO b)
{
jobDTO a = new jobDTO();
a.client = Mapping.ClientMapper.MapToClientDTO(b.Client);
a.ClientId = b.ClientID;
a.Complete = b.Complete;
a.EstimatedDuration = b.EstimatedDuration;
a.Id = b.Id;
a.Notes = b.Notes;
a.ServiceTypeId = b.ServiceTypeID;
a.StartDate = b.StartDate;
a.type = Mapping.ServiceTypeMapper.MaptoServiceTypeDTO(b.ServiceType);
a.user = Mapping.AspNetUserMapper.mapToAspNetUsers(b.User);
a.UserId = b.UserID;
a.Hours = b.Hours;
return(a);
}
public bool ScheduleJob(DateTime startDate, int estDuration, string notes, string userId, string clientName, string serviceTypeName)
{
//Define data memebers that need to be assigned for InsertJob in the logic layer
jobDTO newJob = new jobDTO();
AspNetUsers user = new AspNetUsers();
ClientDTO client = new ClientDTO();
ServiceTypeDTO serviceType = new ServiceTypeDTO();
//Assign data members given the data from the Jobs controller
user = cmLogicService.getUserById(userId).First();
client = cmLogicService.getClientsByName(clientName).First();
serviceType = cmLogicService.getServiceTypeByName(serviceTypeName).First();
//Create JobDTO object and pass to logic layer
newJob.StartDate = startDate;
newJob.EstimatedDuration = estDuration;
newJob.Notes = notes;
newJob.user = user;
newJob.client = client;
newJob.type = serviceType;
return(cmLogicService.insertJob(newJob));
}
public bool deleteJob(jobDTO job)
{
return(sc.DeleteJob(Mapping.JobMapper.mapToJobDAO(job)));
}
public bool insertJob(jobDTO job)
{
return(sc.AddJob(Mapping.JobMapper.mapToJobDAO(job)));
}
public Invoice generateInvoice(jobDTO job)
{
return(logic.generateInvoice(job));
}
public bool insertJobExpense(jobDTO job, ExpenseDTO expense)
{
return(logic.insertJobExpense(job, expense));
}
public bool deleteJob(jobDTO job)
{
return(logic.deleteJob(job));
}
public bool completeJob(jobDTO job)
{
return(logic.completeJob(job));
}
public bool insertJobExpense(jobDTO job, ExpenseDTO expense)
{
return(sc.AddJobExpense(Mapping.JobMapper.mapToJobDAO(job), Mapping.ExpenseMapper.mapToExpenseDAO(expense)));
}
List <JobExpenseDTO> getJobExpenseByJobId(jobDTO job)
{
var list = getJobExpenses().Where(m => m.JobId == job.Id).ToList();
return(list);
}
public bool updateJob(jobDTO job)
{
return(sc.UpdateJob(Mapping.JobMapper.mapToJobDAO(job)));
}
public bool completeJob(jobDTO job)
{
job.Complete = true;
return(sc.UpdateJob(Mapping.JobMapper.mapToJobDAO(job)));
}
public bool updateJob(jobDTO job)
{
return(logic.updateJob(job));
}
