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(); } }
public void Update(Interface.IcompanyOrder companyOrder) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var companyOrderUpdateing = dbContext.tblCompanyOrders.SingleOrDefault( x => x.invoiceNo == companyOrder.InvoiceNo); if (companyOrder.CreateBy != null) { companyOrderUpdateing.createBy = companyOrder.CreateBy.WorkNo; } if (companyOrder.CreateDate != new DateTime()) { companyOrderUpdateing.createdDate = companyOrder.CreateDate; } if (companyOrder.Customer != null) { companyOrderUpdateing.customer = companyOrder.Customer.CompanyCustomersNo; } if (companyOrder.DateSendBill != null) { if (companyOrder.DateSendBill != new DateTime()) { companyOrderUpdateing.dateSendBill = companyOrder.DateSendBill; } } if (companyOrder.DaysToPaid != -1) { companyOrderUpdateing.daysToPaid = companyOrder.DaysToPaid; } if (companyOrder.DescriptionTask != string.Empty && companyOrder.DescriptionTask != null) { companyOrderUpdateing.descriptionTask = companyOrder.DescriptionTask; } if (companyOrder.HoutsUse != -1) { companyOrderUpdateing.hoursUse = Convert.ToDecimal(companyOrder.HoutsUse); } companyOrderUpdateing.paid = companyOrder.Paid; if (companyOrder.PaidHour != -1) { companyOrderUpdateing.paidHour = Convert.ToDecimal(companyOrder.PaidHour); } if (companyOrder.PaidToAcc != -1) { companyOrderUpdateing.paidToACC = companyOrder.PaidToAcc; } if (companyOrder.TaskDate != new DateTime()) { companyOrderUpdateing.taskDate = companyOrder.TaskDate; } dbContext.SubmitChanges(); } }
public Interface.IcompanyOrder Find(int id) { Interface.IcompanyOrder companyOrder = null; using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var companyOrderFound = dbContext.tblCompanyOrders.SingleOrDefault( x => x.invoiceNo == id); companyOrder = new InterfaceAdaptor.CompanyOrder() { CreateBy = new InterfaceAdaptor.Worker() { Active = (bool)companyOrderFound.tblWorker.active, Address = companyOrderFound.tblWorker.homeAddress, AltPhoneNo = companyOrderFound.tblWorker.altPhoneNo, Email = companyOrderFound.tblWorker.email, Name = companyOrderFound.tblWorker.name, PhoneNo = companyOrderFound.tblWorker.phoneNo, PostNo = new InterfaceAdaptor.PostNo() { City = companyOrderFound.tblWorker.tblPostNo.city, Id = companyOrderFound.tblWorker.tblPostNo.ID, PostNumber = companyOrderFound.tblWorker.tblPostNo.postNo }, Surname = companyOrderFound.tblWorker.surname, WorkerStatus = new InterfaceAdaptor.WorkerStatus() { Staus = companyOrderFound.tblWorker.tblWorkerStatus.status, StautsNo = companyOrderFound.tblWorker.tblWorkerStatus.statusNo }, WorkNo = companyOrderFound.tblWorker.workNo, }, CreateDate = (DateTime)companyOrderFound.createdDate, Customer = new InterfaceAdaptor.CompanyCustomer() { Active = (bool)companyOrderFound.tblCompanyCustomer.active, Address = companyOrderFound.tblCompanyCustomer._address, AltPhoneNo = companyOrderFound.tblCompanyCustomer.altPhoneNo, CompanyCustomersNo = companyOrderFound.tblCompanyCustomer.companyCustomersNo, ContactPerson = companyOrderFound.tblCompanyCustomer.companyContactPerson, CvrNo = companyOrderFound.tblCompanyCustomer.cvrNo, Email = companyOrderFound.tblCompanyCustomer.email, Name = companyOrderFound.tblCompanyCustomer.companyName, PhoneNo = companyOrderFound.tblCompanyCustomer.phoneNo, PostNo = new InterfaceAdaptor.PostNo() { City = companyOrderFound.tblCompanyCustomer.tblPostNo.city, Id = companyOrderFound.tblCompanyCustomer.tblPostNo.ID, PostNumber = companyOrderFound.tblCompanyCustomer.tblPostNo.postNo }, }, DateSendBill = companyOrderFound.dateSendBill, DaysToPaid = (int)companyOrderFound.daysToPaid, DescriptionTask = companyOrderFound.descriptionTask, HoutsUse = (double)companyOrderFound.hoursUse, InvoiceNo = companyOrderFound.invoiceNo, Paid = (bool)companyOrderFound.paid, PaidHour = (double)companyOrderFound.paidHour, PaidToAcc = (int)companyOrderFound.paidToACC, TaskDate = (DateTime)companyOrderFound.taskDate }; } return(companyOrder); }