public void AddLocations()
{
try
{
string[] lines = File.ReadAllLines(@"../../Location.txt");
List <string> list = new List <string>();
for (int i = 0; i < lines.Length; i++)
{
tblLocation location = new tblLocation();
list = lines[i].Split(',').ToList();
location.Adress = list[0];
location.Place = list[1];
location.States = list[2];
using (DAN_LXEntities1 context = new DAN_LXEntities1())
{
if (context.tblLocations.Where(x => x.Adress == location.Adress && x.Place == location.Place && x.States == location.States).ToList().Count == 0)
{
context.tblLocations.Add(location);
context.SaveChanges();
}
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
/// <summary>
/// Method for changing employee data
/// </summary>
/// <param name="employee"></param>
/// <returns></returns>
public bool EditEmployee(vwEmployee employee)
{
try
{
using (DAN_LXEntities1 context = new DAN_LXEntities1())
{
tblEmployee employeeToEdit = context.tblEmployees.Where(x => x.EmployeeID == employee.EmployeeID).FirstOrDefault();
employeeToEdit.NameandSurname = employee.NameandSurname;
employeeToEdit.DateOfBirth = employee.DateOfBirth;
employeeToEdit.JMBG = employee.JMBG;
employeeToEdit.RegistrationNumber = employee.RegistrationNumber;
employeeToEdit.Gender = employee.Gender;
employeeToEdit.PhoneNumber = employee.PhoneNumber;
employeeToEdit.SectorID = employee.SectorID;
employeeToEdit.LocationID = employee.LocationID;
employeeToEdit.Manager = employee.Manager;
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
public bool AddEmployee(vwEmployee employeeToAdd)
{
try
{
using (DAN_LXEntities1 context = new DAN_LXEntities1())
{
tblEmployee employee = new tblEmployee
{
NameandSurname = employeeToAdd.NameandSurname,
DateOfBirth = employeeToAdd.DateOfBirth,
RegistrationNumber = employeeToAdd.RegistrationNumber,
JMBG = employeeToAdd.JMBG,
Gender = employeeToAdd.Gender,
PhoneNumber = employeeToAdd.PhoneNumber,
SectorID = employeeToAdd.SectorID,
LocationID = employeeToAdd.LocationID,
Manager = employeeToAdd.Manager
};
context.tblEmployees.Add(employee);
context.SaveChanges();
employeeToAdd.EmployeeID = employee.EmployeeID;
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
/// <summary>
/// This method creates a list of data from view of employees.
/// </summary>
/// <returns>List of employees.</returns>
public List <vwEmployee> GetAllEmployees()
{
try
{
using (DAN_LXEntities1 context = new DAN_LXEntities1())
{
List <vwEmployee> employees = new List <vwEmployee>();
employees = (from x in context.vwEmployees select x).ToList();
return(employees);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public List <vwSector> GetAllSectors()
{
try
{
using (DAN_LXEntities1 context = new DAN_LXEntities1())
{
List <vwSector> sectors = new List <vwSector>();
sectors = (from x in context.vwSectors select x).ToList();
return(sectors);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
/// <summary>
/// List of all employees who are managers
/// </summary>
/// <param name="employee"></param>
/// <returns></returns>
public List <vwEmployee> GetAllManagers(vwEmployee employee)
{
try
{
using (DAN_LXEntities1 context = new DAN_LXEntities1())
{
List <vwEmployee> employees = new List <vwEmployee>();
employees = context.vwEmployees.Where(x => x.JMBG != employee.JMBG).ToList();
return(employees);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public List <vwLocation> GetAllLocations()
{
try
{
using (DAN_LXEntities1 context = new DAN_LXEntities1())
{
List <vwLocation> locations = new List <vwLocation>();
locations = (from x in context.vwLocations select x).OrderBy(x => x.Adress).ToList();
return(locations);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public void AddSector(string sectorToAdd)
{
try
{
using (DAN_LXEntities1 context = new DAN_LXEntities1())
{
tblSector sector = new tblSector
{
SectorName = sectorToAdd
};
context.tblSectors.Add(sector);
context.SaveChanges();
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
/// <summary>
/// Method for deleting employee data
/// </summary>
/// <param name="employeeID"></param>
/// <returns></returns>
public bool DeleteEmployee(int employeeID)
{
try
{
using (DAN_LXEntities1 context = new DAN_LXEntities1())
{
var employeeOfThisManager = context.tblEmployees.Where(x => x.Manager == employeeID).ToList();
if (employeeOfThisManager.Count() > 0)
{
foreach (var employee in employeeOfThisManager)
{
employee.Manager = null;
}
}
tblEmployee employeeToDelete = context.tblEmployees.Where(x => x.EmployeeID == employeeID).FirstOrDefault();
var peopleInSector = context.tblEmployees.Where(x => x.SectorID == employeeToDelete.SectorID).ToList();
if (peopleInSector.Count() == 1)
{
var sector = context.tblSectors.Where(x => x.SectorID == employeeToDelete.SectorID).FirstOrDefault();
context.tblSectors.Remove(sector);
context.SaveChanges();
}
context.tblEmployees.Remove(employeeToDelete);
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
