/// <summary>
/// Saves the created Worker in database
/// </summary>
private void SaveWorker()
{
try
{
using (WorkersDbEntities db = new WorkersDbEntities())
{
if (ValideteJMBG(Worker.JMBG))
{
if (counter == 0)
{
Worker.Gender = Gender;
db.tblWorkers.Add(Worker);
db.SaveChanges();
counter++;
}
WriteWorker();
}
else
{
MessageBox.Show("Invalid JMBG");
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
}
}
/// <summary>
/// Find Worker thats being updated
/// </summary>
/// <returns>Worker thats being updated</returns>
private tblWorker FindWorker()
{
try
{
tblWorker worker = new tblWorker();
using (WorkersDbEntities db = new WorkersDbEntities())
{
worker = db.tblWorkers.Where(x => x.Id == ViewWorker.Id).FirstOrDefault();
return(worker);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
return(null);
}
}
/// <summary>
/// Deletes Worker from database
/// </summary>
private void WorkerDelete(object sender, DoWorkEventArgs e)
{
try
{
using (WorkersDbEntities db = new WorkersDbEntities())
{
Thread.Sleep(2000);
tblWorker worker = db.tblWorkers.Where(x => x.Id == viewWorker.Id).FirstOrDefault();
db.tblWorkers.Remove(worker);
db.SaveChanges();
AllInfoAboutWorker = GetAllInfoAboutWorkers();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
}
}
/// <summary>
/// Gets all info about Workers
/// </summary>
/// <returns>All Workers and info about them</returns>
private List <vwWorker> GetAllInfoAboutWorkers()
{
try
{
using (WorkersDbEntities db = new WorkersDbEntities())
{
List <vwWorker> allInfoAboutWorkers = new List <vwWorker>();
allInfoAboutWorkers = db.vwWorkers.OrderBy(X => X.Id).ToList();
AllInfoAboutWorker = allInfoAboutWorkers;
return(AllInfoAboutWorker);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
return(null);
}
}
/// <summary>
/// Deletes Selected Worker
/// </summary>
private void DeleteWorker()
{
try
{
MessageBoxResult messageBoxResult = MessageBox.Show("Are you sure?", "Delete Confirmation", MessageBoxButton.YesNo);
if (messageBoxResult == MessageBoxResult.Yes)
{
using (WorkersDbEntities db = new WorkersDbEntities())
{
bgWorker.DoWork += WorkerDelete;
bgWorker.RunWorkerCompleted += WorkerDeleted;
bgWorker.RunWorkerAsync();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
/// <summary>
/// Gets all Locations form txt file and write them into the database
/// </summary>
private void WriteLocations()
{
using (WorkersDbEntities db = new WorkersDbEntities())
{
List <tblLocation> locations = new List <tblLocation>();
foreach (tblLocation location1 in db.tblLocations)
{
locations.Add(location1);
}
if (locations.Count == 0)
{
string location = @"~\..\..\..\Locations.txt";
if (File.Exists(location))
{
string[] allLocations = File.ReadAllLines(location);
foreach (string oneLocation in allLocations)
{
string[] separeted = oneLocation.Split(',');
string address = separeted[0];
string city = separeted[1];
string country = separeted[2];
tblLocation newLocation = new tblLocation();
newLocation.Address = address;
newLocation.City = city;
newLocation.Country = country;
using (WorkersDbEntities dbase = new WorkersDbEntities())
{
dbase.tblLocations.Add(newLocation);
dbase.SaveChanges();
}
}
}
else
{
System.Diagnostics.Debug.WriteLine("File not found");
}
}
}
}
/// <summary>
/// Gets all locations from the Database
/// </summary>
/// <returns>All Locations</returns>
private List <string> GetAllLocations()
{
try
{
using (WorkersDbEntities db = new WorkersDbEntities())
{
List <tblLocation> list = new List <tblLocation>();
list = db.tblLocations.Where(x => x.Id > 0).OrderBy(x => x.Address).ToList();
List <string> allLocations = new List <string>();
foreach (tblLocation location in list)
{
string fullLocation = location.Address + "," + location.City + "," + location.Country;
allLocations.Add(fullLocation);
}
return(allLocations);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
return(null);
}
}
/// <summary>
/// Saves created Worker to the database
/// </summary>
private void SaveExecute()
{
tblLocation location = new tblLocation();
string[] fullLocation = Location.Split(',');
string address = fullLocation[0];
try
{
using (WorkersDbEntities db = new WorkersDbEntities())
{
location = db.tblLocations.Where(x => x.Address == address).FirstOrDefault();
Worker.FKLocation = location.Id;
Worker.Gender = Gender;
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
}
tblSector sector = new tblSector();
sector.Sector = Sector;
List <tblSector> sectors = new List <tblSector>();
try
{
using (WorkersDbEntities db = new WorkersDbEntities())
{
foreach (tblSector dbSector in db.tblSectors)
{
sectors.Add(dbSector);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
}
if (sectors.Count == 0)
{
try
{
using (WorkersDbEntities db = new WorkersDbEntities())
{
db.tblSectors.Add(sector);
db.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
}
try
{
using (WorkersDbEntities db = new WorkersDbEntities())
{
tblSector sector1 = db.tblSectors.Where(x => x.Sector == sector.Sector).FirstOrDefault();
Worker.FKSector = sector1.Id;
db.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
}
}
else
{
for (int i = 0; i < sectors.Count; i++)
{
if (sectors[i].Sector == sector.Sector)
{
Worker.FKSector = sectors[i].Id;
}
else if (i == sectors.Count - 1 && sectors[i].Sector != sector.Sector)
{
try
{
using (WorkersDbEntities db = new WorkersDbEntities())
{
db.tblSectors.Add(sector);
db.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
}
try
{
using (WorkersDbEntities db = new WorkersDbEntities())
{
tblSector sector1 = db.tblSectors.Where(x => x.Sector == sector.Sector).FirstOrDefault();
Worker.FKSector = sector1.Id;
db.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
}
}
else
{
continue;
}
}
}
SaveWorker();
}
