internal vwWorker AddWorker(vwWorker worker)
{
try
{
using (WorkerDatabaseEntities context = new WorkerDatabaseEntities())
{
tblWorker newWorker = new tblWorker();
newWorker.FirstName = worker.FirstName;
newWorker.LastName = worker.LastName;
newWorker.DateOfBirth = worker.DateOfBirth;
newWorker.PersonalIDNumber = worker.PersonalIDNumber;
newWorker.JMBG = worker.JMBG;
newWorker.GenderID = worker.GenderID;
newWorker.PhoneNumber = worker.PhoneNumber;
newWorker.SectorID = worker.SectorID;
newWorker.LocationID = worker.LocationID;
newWorker.ManagerID = worker.ManagerID;
context.tblWorkers.Add(newWorker);
context.SaveChanges();
worker.WorkerID = newWorker.WorkerID;
return(worker);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
internal vwWorker EditWorker(vwWorker worker)
{
try
{
using (WorkerDatabaseEntities context = new WorkerDatabaseEntities())
{
tblWorker workerToEdit = (from w in context.tblWorkers where w.WorkerID == worker.WorkerID select w).First();
workerToEdit.FirstName = worker.FirstName;
workerToEdit.LastName = worker.LastName;
workerToEdit.DateOfBirth = worker.DateOfBirth;
workerToEdit.PersonalIDNumber = worker.PersonalIDNumber;
workerToEdit.JMBG = worker.JMBG;
workerToEdit.GenderID = worker.GenderID;
workerToEdit.PhoneNumber = worker.PhoneNumber;
workerToEdit.SectorID = worker.SectorID;
workerToEdit.LocationID = worker.LocationID;
workerToEdit.ManagerID = worker.ManagerID;
context.SaveChanges();
return(worker);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
internal void DeleteWorker(int workerID)
{
try
{
using (WorkerDatabaseEntities context = new WorkerDatabaseEntities())
{
tblWorker workerToDelete = (from w in context.tblWorkers where w.WorkerID == workerID select w).First();
context.tblWorkers.Remove(workerToDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
internal List <tblLocation> AddLocationsToDataBase(List <tblLocation> locationListFromFile)
{
try
{
using (WorkerDatabaseEntities context = new WorkerDatabaseEntities())
{
foreach (var location in locationListFromFile)
{
tblLocation locations = new tblLocation();
locations.Address = location.Address;
locations.City = location.City;
locations.Country = location.Country;
context.tblLocations.Add(locations);
context.SaveChanges();
}
return(locationListFromFile);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}