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