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