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