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 Add(Interface.IworkerStatus workerStatus) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var newWorkerStatus = new tblWorkerStatus() { status = workerStatus.Staus }; dbContext.tblWorkerStatus.InsertOnSubmit(newWorkerStatus); dbContext.SubmitChanges(); } }