private Interface.IcompanyOrder TblCompanyOrderToCompanyOrder(tblCompanyOrder item)
{
return(new InterfaceAdaptor.CompanyOrder()
{
CreateBy = new InterfaceAdaptor.Worker()
{
Active = (bool)item.tblWorker.active,
Address = item.tblWorker.homeAddress,
AltPhoneNo = item.tblWorker.altPhoneNo,
Email = item.tblWorker.email,
Name = item.tblWorker.name,
PhoneNo = item.tblWorker.phoneNo,
PostNo = new InterfaceAdaptor.PostNo()
{
City = item.tblWorker.tblPostNo.city,
Id = item.tblWorker.tblPostNo.ID,
PostNumber = item.tblWorker.tblPostNo.postNo
},
Surname = item.tblWorker.surname,
WorkerStatus = new InterfaceAdaptor.WorkerStatus()
{
Staus = item.tblWorker.tblWorkerStatus.status,
StautsNo = item.tblWorker.tblWorkerStatus.statusNo
},
WorkNo = item.tblWorker.workNo,
},
CreateDate = (DateTime)item.createdDate,
Customer = new InterfaceAdaptor.CompanyCustomer()
{
Active = (bool)item.tblCompanyCustomer.active,
Address = item.tblCompanyCustomer._address,
AltPhoneNo = item.tblCompanyCustomer.altPhoneNo,
CompanyCustomersNo = item.tblCompanyCustomer.companyCustomersNo,
ContactPerson = item.tblCompanyCustomer.companyContactPerson,
CvrNo = item.tblCompanyCustomer.cvrNo,
Email = item.tblCompanyCustomer.email,
Name = item.tblCompanyCustomer.companyName,
PhoneNo = item.tblCompanyCustomer.phoneNo,
PostNo = new InterfaceAdaptor.PostNo()
{
City = item.tblCompanyCustomer.tblPostNo.city,
Id = item.tblCompanyCustomer.tblPostNo.ID,
PostNumber = item.tblCompanyCustomer.tblPostNo.postNo
},
},
DateSendBill = item.dateSendBill,
DaysToPaid = (int)item.daysToPaid,
DescriptionTask = item.descriptionTask,
HoutsUse = (int)item.hoursUse,
InvoiceNo = item.invoiceNo,
Paid = (bool)item.paid,
PaidHour = (int)item.paidHour,
PaidToAcc = (int)item.paidToACC,
TaskDate = (DateTime)item.taskDate
});
}
public void Add(Interface.IcompanyOrder companyOrder)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var newCompanyOrder = new tblCompanyOrder()
{
createBy = companyOrder.CreateBy.WorkNo,
createdDate = companyOrder.CreateDate,
customer = companyOrder.Customer.CompanyCustomersNo,
dateSendBill = companyOrder.DateSendBill,
daysToPaid = companyOrder.DaysToPaid,
descriptionTask = companyOrder.DescriptionTask,
hoursUse = Convert.ToDecimal(companyOrder.HoutsUse),
paid = companyOrder.Paid,
paidHour = Convert.ToDecimal(companyOrder.PaidHour),
paidToACC = companyOrder.PaidToAcc,
taskDate = companyOrder.TaskDate,
};
dbContext.tblCompanyOrders.InsertOnSubmit(newCompanyOrder);
dbContext.SubmitChanges();
}
}
