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