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, }); }