public void Delete(int id) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var workerStatusDeleteing = dbContext.tblWorkerStatus.SingleOrDefault( x => x.statusNo == id); var workerStatusDeletInfo = new StringBuilder(); workerStatusDeletInfo.Append("[tblWorkerStatus] { "); workerStatusDeletInfo.Append("statusNo = " + workerStatusDeleteing.statusNo.ToString() + ", "); workerStatusDeletInfo.Append("status = " + workerStatusDeleteing.status + " }"); var newDelete = new tblDeleteItem() { deleteDate = DateTime.Now, itemInfo = workerStatusDeletInfo.ToString(), restored = false }; dbContext.tblDeleteItems.InsertOnSubmit(newDelete); dbContext.tblWorkerStatus.DeleteOnSubmit(workerStatusDeleteing); dbContext.SubmitChanges(); } }
public void Add(Interface.IinvoiceCompany obj) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var newInvoice = new tblInvoiceCompany() { Active = obj.Active, Id = obj.Id, OrderNr1 = obj.Order[0], OrderNr2 = obj.Order[1], OrderNr3 = obj.Order[2], OrderNr4 = obj.Order[3], OrderNr5 = obj.Order[4], OrderNr6 = obj.Order[5], OrderNr7 = obj.Order[6], OrderNr8 = obj.Order[7], OrderNr9 = obj.Order[8], OrderNr10 = obj.Order[9], OrderNr11 = obj.Order[10], OrderNr12 = obj.Order[11], OrderNr13 = obj.Order[12], OrderNr14 = obj.Order[13], OrderNr15 = obj.Order[14], OrderNr16 = obj.Order[15], OrderNr17 = obj.Order[16], OrderNr18 = obj.Order[17], OrderNr19 = obj.Order[18], OrderNr20 = obj.Order[19], }; dbContext.tblInvoiceCompanies.InsertOnSubmit(newInvoice); dbContext.SubmitChanges(); } }
public void Update(Interface.IinvoiceCompany obj) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var updateing = dbContext.tblInvoiceCompanies.SingleOrDefault( x => x.Id == obj.Id); updateing.Active = obj.Active; updateing.OrderNr1 = obj.Order[0]; updateing.OrderNr2 = obj.Order[1]; updateing.OrderNr3 = obj.Order[2]; updateing.OrderNr4 = obj.Order[3]; updateing.OrderNr5 = obj.Order[4]; updateing.OrderNr6 = obj.Order[5]; updateing.OrderNr7 = obj.Order[6]; updateing.OrderNr8 = obj.Order[7]; updateing.OrderNr9 = obj.Order[8]; updateing.OrderNr10 = obj.Order[9]; updateing.OrderNr11 = obj.Order[10]; updateing.OrderNr12 = obj.Order[11]; updateing.OrderNr13 = obj.Order[12]; updateing.OrderNr14 = obj.Order[13]; updateing.OrderNr15 = obj.Order[14]; updateing.OrderNr16 = obj.Order[15]; updateing.OrderNr17 = obj.Order[16]; updateing.OrderNr18 = obj.Order[17]; updateing.OrderNr19 = obj.Order[18]; updateing.OrderNr20 = obj.Order[19]; dbContext.SubmitChanges(); } }
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 Delete(int id) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var bankAccountsDeleteing = dbContext.tblBankAccounts.SingleOrDefault( x => x.Id == id); var deleteInfo = new StringBuilder(); deleteInfo.Append("[tblBankAccounts] { "); deleteInfo.Append("indexId = " + bankAccountsDeleteing.Id.ToString() + ", "); deleteInfo.Append("bank = " + bankAccountsDeleteing.bank + ", "); deleteInfo.Append("accountName = " + bankAccountsDeleteing.accountName + ", "); deleteInfo.Append("regNo = " + bankAccountsDeleteing.regNo.ToString() + ", "); deleteInfo.Append("accountNo = " + bankAccountsDeleteing.accountNo + ", "); deleteInfo.Append("balance = " + bankAccountsDeleteing.balance.ToString() + " }"); var deleteingItem = new tblDeleteItem() { deleteDate = DateTime.Now, itemInfo = deleteInfo.ToString(), restored = false }; dbContext.tblBankAccounts.DeleteOnSubmit(bankAccountsDeleteing); dbContext.tblDeleteItems.InsertOnSubmit(deleteingItem); dbContext.SubmitChanges(); } }
public void Update(Interface.IpostNo postNumber) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { tblPostNo postNo = dbContext.tblPostNos.SingleOrDefault(x => x.ID == postNumber.Id); postNo.city = postNumber.City; postNo.postNo = postNumber.PostNumber; dbContext.SubmitChanges(); } }
public void Update(Interface.IworkerStatus workerStatus) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var workerStatusUpdateing = dbContext.tblWorkerStatus.SingleOrDefault( x => x.statusNo == workerStatus.StautsNo); workerStatusUpdateing.status = workerStatus.Staus; dbContext.SubmitChanges(); } }
public void Delete(int id) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var deleteing = dbContext.tblInvoiceCompanies.SingleOrDefault( x => x.Id == id); var deleteInfo = new StringBuilder(); deleteInfo.Append("[tblInvoiceCompany] { "); deleteInfo.Append("ID = " + deleteing.Id.ToString() + ", "); deleteInfo.Append("Active = "); if (deleteing.Active) { deleteInfo.Append("1"); } else { deleteInfo.Append("1"); } deleteInfo.Append(", "); deleteInfo.Append("OrderNr1 = " + deleteing.OrderNr1.ToString() + ", "); deleteInfo.Append("OrderNr2 = " + deleteing.OrderNr2.ToString() + ", "); deleteInfo.Append("OrderNr3 = " + deleteing.OrderNr3.ToString() + ", "); deleteInfo.Append("OrderNr4 = " + deleteing.OrderNr4.ToString() + ", "); deleteInfo.Append("OrderNr5 = " + deleteing.OrderNr5.ToString() + ", "); deleteInfo.Append("OrderNr6 = " + deleteing.OrderNr6.ToString() + ", "); deleteInfo.Append("OrderNr7 = " + deleteing.OrderNr7.ToString() + ", "); deleteInfo.Append("OrderNr8 = " + deleteing.OrderNr8.ToString() + ", "); deleteInfo.Append("OrderNr9 = " + deleteing.OrderNr9.ToString() + ", "); deleteInfo.Append("OrderNr10 = " + deleteing.OrderNr10.ToString() + ", "); deleteInfo.Append("OrderNr11 = " + deleteing.OrderNr11.ToString() + ", "); deleteInfo.Append("OrderNr12 = " + deleteing.OrderNr12.ToString() + ", "); deleteInfo.Append("OrderNr13 = " + deleteing.OrderNr13.ToString() + ", "); deleteInfo.Append("OrderNr14 = " + deleteing.OrderNr14.ToString() + ", "); deleteInfo.Append("OrderNr15 = " + deleteing.OrderNr15.ToString() + ", "); deleteInfo.Append("OrderNr16 = " + deleteing.OrderNr16.ToString() + ", "); deleteInfo.Append("OrderNr17 = " + deleteing.OrderNr17.ToString() + ", "); deleteInfo.Append("OrderNr18 = " + deleteing.OrderNr18.ToString() + ", "); deleteInfo.Append("OrderNr19 = " + deleteing.OrderNr19.ToString() + ", "); deleteInfo.Append("OrderNr20 = " + deleteing.OrderNr20.ToString() + " }"); dbContext.tblDeleteItems.InsertOnSubmit(new tblDeleteItem() { deleteDate = DateTime.Now, itemInfo = deleteInfo.ToString(), restored = false }); dbContext.tblInvoiceCompanies.DeleteOnSubmit(deleteing); dbContext.SubmitChanges(); } }
public void Add(Interface.IworkerStatus workerStatus) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var newWorkerStatus = new tblWorkerStatus() { status = workerStatus.Staus }; dbContext.tblWorkerStatus.InsertOnSubmit(newWorkerStatus); dbContext.SubmitChanges(); } }
public void Add(Interface.IpostNo postNumber) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { tblPostNo newPostNumber = new tblPostNo { postNo = postNumber.PostNumber, city = postNumber.City }; dbContext.tblPostNos.InsertOnSubmit(newPostNumber); dbContext.SubmitChanges(); } }
public void Update(Interface.Iworker worker) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { tblWorker updateWorker = dbContext.tblWorkers.SingleOrDefault( x => x.workNo == worker.WorkNo); updateWorker.active = worker.Active; updateWorker.altPhoneNo = worker.AltPhoneNo; if (worker.Email != string.Empty) { updateWorker.email = worker.Email; } if (worker.Email != string.Empty) { updateWorker.homeAddress = worker.Address; } if (worker.Name != string.Empty) { updateWorker.name = worker.Name; } if (worker.PhoneNo != string.Empty) { updateWorker.phoneNo = worker.PhoneNo; } if (worker.PhoneNo != null) { updateWorker.postNo = worker.PostNo.Id; } if (worker.Surname != string.Empty) { updateWorker.surname = worker.Surname; } if (worker.WorkerStatus != null) { updateWorker.workerStatus = worker.WorkerStatus.StautsNo; } dbContext.SubmitChanges(); } }
public void Update(Interface.IbankAccounts bankAccounts) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var bankAccUpdateing = dbContext.tblBankAccounts.SingleOrDefault( x => x.Id == bankAccounts.Id); bankAccUpdateing.accountName = bankAccounts.AccountName; bankAccUpdateing.accountNo = bankAccounts.AccountNo; bankAccUpdateing.balance = Convert.ToDecimal(bankAccounts.Balance); bankAccUpdateing.bank = bankAccounts.Bank; bankAccUpdateing.regNo = bankAccounts.RegNo; dbContext.SubmitChanges(); } }
public void Add(Interface.IbankAccounts bankAccounts) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var newBankAcc = new tblBankAccount() { accountName = bankAccounts.AccountName, accountNo = bankAccounts.AccountNo, balance = Convert.ToDecimal(bankAccounts.Balance), bank = bankAccounts.Bank, regNo = bankAccounts.RegNo, }; dbContext.tblBankAccounts.InsertOnSubmit(newBankAcc); dbContext.SubmitChanges(); } }
public void Update(Interface.IcompanyCustomer companyCustomer) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var companyCustomerUpdateing = dbContext.tblCompanyCustomers.SingleOrDefault( x => x.companyCustomersNo == companyCustomer.CompanyCustomersNo); if (companyCustomer.Address != string.Empty) { companyCustomerUpdateing._address = companyCustomer.Address; } companyCustomerUpdateing.active = companyCustomer.Active; companyCustomerUpdateing.altPhoneNo = companyCustomer.AltPhoneNo; if (companyCustomer.ContactPerson != string.Empty) { companyCustomerUpdateing.companyContactPerson = companyCustomer.ContactPerson; } if (companyCustomer.Name != string.Empty) { companyCustomerUpdateing.companyName = companyCustomer.Name; } if (companyCustomer.CvrNo != -1) { companyCustomerUpdateing.cvrNo = companyCustomer.CvrNo; } companyCustomerUpdateing.email = companyCustomer.Email; if (companyCustomer.PhoneNo != string.Empty) { companyCustomerUpdateing.phoneNo = companyCustomer.PhoneNo; } if (companyCustomer.PostNo.Id != -1) { companyCustomerUpdateing.postNo = companyCustomer.PostNo.Id; } dbContext.SubmitChanges(); } }
public void Delete(int id) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var companyOrderDeleteing = dbContext.tblCompanyOrders.SingleOrDefault( x => x.invoiceNo == id); var deleteInfo = new StringBuilder(); deleteInfo.Append("[tblCompanyOrders] { "); deleteInfo.Append("invoiceNo = " + companyOrderDeleteing.ToString() + ", "); deleteInfo.Append("createdDate = " + companyOrderDeleteing.createdDate.ToString() + ", "); deleteInfo.Append("taskDate = " + companyOrderDeleteing.taskDate.ToString() + ", "); deleteInfo.Append("descriptionTask = " + companyOrderDeleteing.descriptionTask + ", "); deleteInfo.Append("dateSendBill = " + companyOrderDeleteing.dateSendBill.Value.ToShortDateString() + ", "); deleteInfo.Append("daysToPaid = " + companyOrderDeleteing.daysToPaid.ToString() + ", "); deleteInfo.Append("hoursUse = " + companyOrderDeleteing.hoursUse.ToString() + ", "); deleteInfo.Append("paidHour = " + companyOrderDeleteing.paidHour.ToString() + ", "); deleteInfo.Append("createBy = " + companyOrderDeleteing.createBy.ToString() + ", "); deleteInfo.Append("paidToACC = " + companyOrderDeleteing.paidToACC.ToString() + ", "); deleteInfo.Append("customer = " + companyOrderDeleteing.customer.ToString() + ", "); deleteInfo.Append("paid = "); if ((bool)companyOrderDeleteing.paid) { deleteInfo.Append("1"); } else { deleteInfo.Append("0"); } deleteInfo.Append(" }"); dbContext.tblDeleteItems.InsertOnSubmit(new tblDeleteItem() { deleteDate = DateTime.Now, itemInfo = deleteInfo.ToString(), restored = false }); dbContext.tblCompanyOrders.DeleteOnSubmit(companyOrderDeleteing); dbContext.SubmitChanges(); } }
public void Update(Interface.IprivetCustomer privetCustomer) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var privetCustomerUpdateing = dbContext.tblPrivateCustomers.SingleOrDefault( x => x.privateCustomersNo == privetCustomer.PrivateCustomersNo); privetCustomerUpdateing.active = privetCustomer.Active; privetCustomerUpdateing.altPhoneNo = privetCustomer.AltPhoneNo; privetCustomerUpdateing.email = privetCustomer.Email; privetCustomerUpdateing.homeAddress = privetCustomer.HomeAddress; privetCustomerUpdateing.name = privetCustomer.Name; privetCustomerUpdateing.phoneNo = privetCustomer.PhoneNo; privetCustomerUpdateing.postNo = privetCustomer.PostNo.Id; privetCustomerUpdateing.surname = privetCustomer.Surname; dbContext.SubmitChanges(); } }
public bool UpdateActive(int id, bool active) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var item = dbContext.tblInvoiceCompanies.SingleOrDefault( x => x.Id == id); if (item == null) { return(false); } item.Active = active; dbContext.SubmitChanges(); } return(true); }
public void Delete(int WorkNumber) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { tblWorker workerItem = dbContext.tblWorkers.SingleOrDefault(x => x.workNo == WorkNumber); var workerDelete = new StringBuilder(); workerDelete.Append("[tblWorkers] { "); workerDelete.Append("workNo = " + workerItem.workNo.ToString() + ", "); workerDelete.Append("name = " + workerItem.name + ", "); workerDelete.Append("surname = " + workerItem.surname + ", "); workerDelete.Append("workerStatus = " + workerItem.workerStatus.ToString() + ", "); workerDelete.Append("phoneNo = " + workerItem.phoneNo + ", "); workerDelete.Append("altPhoneNo = " + workerItem.altPhoneNo + ", "); workerDelete.Append("homeAddress = " + workerItem.homeAddress + ", "); workerDelete.Append("postNo = " + workerItem.postNo.ToString() + ", "); workerDelete.Append("email = " + workerItem.email + ", "); workerDelete.Append("active = "); if (workerItem.active == true) { workerDelete.Append("1"); } else { workerDelete.Append("0"); } workerDelete.Append(" }"); var newDeleteItem = new tblDeleteItem() { deleteDate = DateTime.Now, itemInfo = workerDelete.ToString(), restored = false }; workerItem.active = false; dbContext.tblDeleteItems.InsertOnSubmit(newDeleteItem); dbContext.SubmitChanges(); } }
public void Delete(int department) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { tblDepartment item = dbContext.tblDepartments.SingleOrDefault( x => x.department == department); var itemString = new StringBuilder(); itemString.Append("[tblDepartment] { "); itemString.Append("department = " + item.department.ToString() + ", "); itemString.Append("cvrNo = " + item.cvrNo.ToString() + ", "); itemString.Append("phoneNo = " + item.phoneNo + ", "); itemString.Append("altPhoneNo = " + item.altPhoneNo + ", "); itemString.Append("_address = " + item._address + ", "); itemString.Append("postNo = " + item.postNo.ToString() + ","); itemString.Append("email = " + item.email + ", "); if ((bool)item.active) { itemString.Append("active = " + "1, "); } else { itemString.Append("active = " + "1, "); } itemString.Append("departmentHeadNo = " + item.departmentHeadNo.ToString() + " }"); var deleteItem = new tblDeleteItem() { itemInfo = itemString.ToString(), deleteDate = DateTime.Now, restored = false, }; item.active = false; dbContext.tblDeleteItems.InsertOnSubmit(deleteItem); dbContext.SubmitChanges(); } }
public void Delete(int id) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var deletingItem = dbContext.tblCompanyCustomers.SingleOrDefault( x => x.companyCustomersNo == id); var deletingInfo = new StringBuilder(); deletingInfo.Append("[tblCompanyCustomers] { "); deletingInfo.Append("companyCustomersNo = " + deletingItem.companyCustomersNo.ToString() + ", "); deletingInfo.Append("companyName = " + deletingItem.companyName + ", "); deletingInfo.Append("companyContactPerson = " + deletingItem.companyContactPerson + ", "); deletingInfo.Append("cvrNo = " + deletingItem.cvrNo.ToString() + ", "); deletingInfo.Append("phoneNo = " + deletingItem.phoneNo + ", "); deletingInfo.Append("altPhoneNo = " + deletingItem.altPhoneNo + ", "); deletingInfo.Append("_address = " + deletingItem._address + ", "); deletingInfo.Append("postNo = " + deletingItem.postNo.ToString() + ", "); deletingInfo.Append("email = " + deletingItem.email + ", "); deletingInfo.Append("active = "); if ((bool)deletingItem.active) { deletingInfo.Append("1"); } else { deletingInfo.Append("0"); } deletingInfo.Append(" }"); deletingItem.active = false; dbContext.tblDeleteItems.InsertOnSubmit(new tblDeleteItem() { deleteDate = DateTime.Now, itemInfo = deletingInfo.ToString(), restored = false }); dbContext.SubmitChanges(); } }
public void Delete(int id) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var deleteingItem = dbContext.tblPrivateCustomers.SingleOrDefault( x => x.privateCustomersNo == id); var deleteingInfo = new StringBuilder(); deleteingInfo.Append("[tblPrivateCustomers] { "); deleteingInfo.Append("privateCustomersNo = " + deleteingItem.privateCustomersNo.ToString() + ", "); deleteingInfo.Append("name = " + deleteingItem.name + ", "); deleteingInfo.Append("surname = " + deleteingItem.surname + ", "); deleteingInfo.Append("phoneNo = " + deleteingItem.phoneNo + ", "); deleteingInfo.Append("altPhoneNo = " + deleteingItem.altPhoneNo + ", "); deleteingInfo.Append("homeAddress = " + deleteingItem.homeAddress + ", "); deleteingInfo.Append("postNo = " + deleteingItem.postNo.ToString() + ", "); deleteingInfo.Append("email = " + deleteingItem.email + ", "); deleteingInfo.Append("active = "); if (deleteingItem.active == true) { deleteingInfo.Append("1"); } else { deleteingInfo.Append("0"); } deleteingInfo.Append(" }"); var deleteData = new tblDeleteItem() { deleteDate = DateTime.Now, itemInfo = deleteingItem.ToString(), restored = false }; deleteingItem.active = false; dbContext.tblDeleteItems.InsertOnSubmit(deleteData); dbContext.SubmitChanges(); } }
public void Update(Interface.Idepartment department) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { tblDepartment updateDepartment = dbContext.tblDepartments.SingleOrDefault( x => x.department == department.Deparment); updateDepartment._address = department.Address; updateDepartment.active = department.Active; updateDepartment.altPhoneNo = department.AltPhoneNo; updateDepartment.companyName = department.CompanyName; updateDepartment.cvrNo = department.CvrNo; updateDepartment.department = department.Deparment; updateDepartment.departmentHeadNo = department.DeparmentHead.WorkNo; updateDepartment.email = department.Email; updateDepartment.phoneNo = department.PhoneNo; updateDepartment.postNo = department.PostNo.Id; dbContext.SubmitChanges(); } }
public void Add(Interface.Iworker worker) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var newWorker = new tblWorker() { active = worker.Active, altPhoneNo = worker.AltPhoneNo, email = worker.Email, homeAddress = worker.Address, name = worker.Name, phoneNo = worker.PhoneNo, postNo = worker.PostNo.Id, surname = worker.Surname, workerStatus = worker.WorkerStatus.StautsNo, }; dbContext.tblWorkers.InsertOnSubmit(newWorker); dbContext.SubmitChanges(); } }
public void Add(Interface.IprivetCustomer privetCustomer) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { tblPrivateCustomer newPrivateCustomer = new tblPrivateCustomer() { active = privetCustomer.Active, altPhoneNo = privetCustomer.AltPhoneNo, email = privetCustomer.Email, homeAddress = privetCustomer.HomeAddress, name = privetCustomer.Name, postNo = privetCustomer.PostNo.Id, phoneNo = privetCustomer.PhoneNo, surname = privetCustomer.Surname, }; dbContext.tblPrivateCustomers.InsertOnSubmit(newPrivateCustomer); dbContext.SubmitChanges(); } }
public void Add(Interface.IcompanyCustomer companyCustomer) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var newCompanyCustomer = new tblCompanyCustomer() { _address = companyCustomer.Address, active = companyCustomer.Active, altPhoneNo = companyCustomer.AltPhoneNo, companyContactPerson = companyCustomer.ContactPerson, companyCustomersNo = companyCustomer.CompanyCustomersNo, companyName = companyCustomer.Name, cvrNo = companyCustomer.CvrNo, email = companyCustomer.Email, phoneNo = companyCustomer.PhoneNo, postNo = companyCustomer.PostNo.Id, }; dbContext.tblCompanyCustomers.InsertOnSubmit(newCompanyCustomer); dbContext.SubmitChanges(); } }
public void Add(Interface.Idepartment department) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { tblDepartment newDepartment = new tblDepartment { _address = department.Address, active = department.Active, altPhoneNo = department.AltPhoneNo, companyName = department.CompanyName, cvrNo = department.CvrNo, department = department.Deparment, departmentHeadNo = department.DeparmentHead.WorkNo, email = department.Email, phoneNo = department.PhoneNo, postNo = department.PostNo.Id }; dbContext.tblDepartments.InsertOnSubmit(newDepartment); dbContext.SubmitChanges(); } }
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 Delete(Interface.IpostNo postNumber) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { tblPostNo postNo = dbContext.tblPostNos.SingleOrDefault(x => x.ID == postNumber.Id); dbContext.tblPostNos.DeleteOnSubmit(postNo); var deleteItem = new StringBuilder(); deleteItem.Append("[tblPostNo] { "); deleteItem.Append("ID = " + postNo.ID + ", "); deleteItem.Append("postNo = " + postNo.postNo + ", "); deleteItem.Append("city = " + postNo.city); deleteItem.Append("} "); tblDeleteItem newDelete = new tblDeleteItem { itemInfo = deleteItem.ToString(), deleteDate = DateTime.Now, restored = false }; 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 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(); } }