public void Add(Interface.IprivetOrder privetOrder)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var newPrivetOrderFound = new tblPrivetOrder()
{
createBy = privetOrder.CreateBy.WorkNo,
createdDate = privetOrder.CreateDate,
customers = privetOrder.Customer.PrivateCustomersNo,
dateSendBill = privetOrder.DateSendBill,
daysToPaid = privetOrder.DaysToPaid,
descriptionTask = privetOrder.DescriptionTask,
hoursUse = Convert.ToDecimal(privetOrder.HourUse),
paid = privetOrder.Paid,
paidHour = Convert.ToDecimal(privetOrder.PaidHour),
paidToACC = privetOrder.PaidToAcc,
taskDate = privetOrder.TaskDate,
};
if (newPrivetOrderFound.dateSendBill != null)
{
if (newPrivetOrderFound.dateSendBill.Value.Year == 1)
{
newPrivetOrderFound.dateSendBill = null;
}
}
dbContext.tblPrivetOrders.InsertOnSubmit(newPrivetOrderFound);
dbContext.SubmitChanges();
}
}
public InterfaceAdaptor.PrivetOrder tblPrivetOrderToPrivetOrder(tblPrivetOrder item)
{
return(new InterfaceAdaptor.PrivetOrder()
{
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()
{
StautsNo = item.tblWorker.tblWorkerStatus.statusNo,
Staus = item.tblWorker.tblWorkerStatus.status
},
WorkNo = item.tblWorker.workNo
},
CreateDate = (DateTime)item.createdDate,
Customer = new InterfaceAdaptor.PrivetCustomer()
{
Active = (bool)item.tblPrivateCustomer.active,
AltPhoneNo = item.tblPrivateCustomer.altPhoneNo,
Email = item.tblPrivateCustomer.email,
HomeAddress = item.tblPrivateCustomer.homeAddress,
Name = item.tblPrivateCustomer.name,
PhoneNo = item.tblPrivateCustomer.phoneNo,
PostNo = new InterfaceAdaptor.PostNo()
{
City = item.tblPrivateCustomer.tblPostNo.city,
Id = item.tblPrivateCustomer.tblPostNo.ID,
PostNumber = item.tblPrivateCustomer.tblPostNo.postNo
},
PrivateCustomersNo = item.tblPrivateCustomer.privateCustomersNo,
Surname = item.tblPrivateCustomer.surname
},
DateSendBill = item.dateSendBill,
DaysToPaid = (int)item.daysToPaid,
DescriptionTask = item.descriptionTask,
HourUse = Convert.ToDouble(item.hoursUse),
InvoiceNo = item.invoiceNo,
Paid = (bool)item.paid,
PaidHour = Convert.ToDouble(item.paidHour),
PaidToAcc = item.paidToACC,
TaskDate = item.taskDate,
});
}
