public IHttpActionResult addEmployee([FromBody] Employee_Data data)
{
if (data == null)
{
//Bad request code 400
return(BadRequest());
}
/*
* if (employeeLogic.existEmployee(data.id))
* {
* //petición correcta pero no pudo ser procesada porque ya existe el archivo code 202
* return StatusCode(HttpStatusCode.Accepted);
* }
*/
if (employeeLogic.addEmployee(data))
{
//petición correcta y se ha creado un nuevo recurso code 201
return(StatusCode(HttpStatusCode.Created));
}
else
{
//No se pudo crear el recurso por un error interno code 500
return(InternalServerError());
}
}
public Employee_Data GetEmployee(int ID)
{
Employee_Data employee = new Employee_Data();
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
if (!this.existEmployee(ID))
{
employee = null;
return(employee);
}
var emp = construyeEntities.Employees.Find(ID);
employee.id = emp.id;
employee.identification = emp.identification;
employee.name = emp.name;
employee.lastname1 = emp.lastname1;
employee.lastname2 = emp.lastname2;
employee.phone = emp.phone;
employee.hour_cost = emp.hour_cost;
return(employee);
}
catch (Exception E)
{
employee = null;
return(employee);
}
}
}
public Exception UpdateEmployee(int id, employees employee)
{
Employee_Data obj = new Employee_Data(_connection);
Exception ex = obj.UpdateEmployee(id, employee);
return(ex);
}
[Test] // #16
public void p()
{ //@ Add a deparment and check if he existing
Employee_Data ed = new Employee_Data();
ed.Remove("14");
Assert.IsTrue(!ed.Contains("14"));
}
public void DeleteEmployee(int id)
{
Employee_Data obj = new Employee_Data(_connection);
obj.DeleteEmployee(id);
return;
}
public Exception SaveEmployee(employees employee)
{
Employee_Data obj = new Employee_Data(_connection);
Exception ex = obj.SaveEmployee(employee);
return(ex);
}
[Test] // #15
public void o()
{ //@ Add a worker and check if he existing
Employee_Data ed = new Employee_Data();
Backend.Employee c = new Backend.Employee("14", "adam", "bon", "Man", "3434", 20000.0, "0", "Worker");
ed.Add(c);
Assert.IsTrue(ed.Contains("14"));
}
public Main()
{
InitializeComponent();
EmartDataContext emartDataContext = new EmartDataContext();
//data classes of the enities
List <DAL.User> userSqlDB = (from s in emartDataContext.Users select s).ToList();
List <Backend.User> userDB = Change.UserDalToBackendList(userSqlDB);
User_Data user_data = new User_Data(userDB);
List <DAL.Customer> clubMemberSqlDB = (from s in emartDataContext.Customers select s).ToList();
List <Club_Member> clubMemberDB = Change.CustomerDalToBackendList(clubMemberSqlDB);
ClubMember_Data clubMember_data = new ClubMember_Data(clubMemberDB);
List <DAL.Department> departmentSqlDB = (from s in emartDataContext.Departments select s).ToList();
List <Backend.Department> departmentDB = Change.DepartmentDalToBackendList(departmentSqlDB);
Department_Data department_data = new Department_Data(departmentDB);
List <DAL.Employee> EmployeeSqlDB = (from s in emartDataContext.Employees select s).ToList();
List <Backend.Employee> EmployeeDB = Change.EmployeeDalToBackendList(EmployeeSqlDB);
Employee_Data employee_data = new Employee_Data(EmployeeDB);
List <DAL.Product> productSqlDB = (from s in emartDataContext.Products select s).ToList();
List <Backend.Product> productDB = Change.ProductDalToBackendList(productSqlDB);
Product_Data product_data = new Product_Data(productDB);
List <DAL.Transaction> transactionSqlDB = (from s in emartDataContext.Transactions select s).ToList();
List <Backend.Transaction> transactionDB = Change.TransactionDalToBackendList(transactionSqlDB);
List <DAL.Recipt> reciptSqlDB = (from s in emartDataContext.Recipts select s).ToList();
List <Backend.Receipt> reciptDB = Change.ReciptDalToBackendList(reciptSqlDB);
Transaction_Data transaction_data = new Transaction_Data(transactionDB, reciptDB);
Location_Data location_data = new Location_Data();
// managers
DAL_Manager dal_manager = new DAL_Manager(user_data, clubMember_data, department_data, employee_data, product_data, transaction_data, location_data);
BL_Manager BL_manager = new BL_Manager(dal_manager);
Window mw = new MainWindow(BL_manager);
mw.Show();
this.Close();
}
static void Main(string[] args)
{
Console.WriteLine("Enter name: ");
string nameFirst = Console.ReadLine();
Console.WriteLine("Enter day of birth: ");
int dayFirst = int.Parse(Console.ReadLine());
Console.WriteLine("Enter month of birth: ");
int monthFirst = int.Parse(Console.ReadLine());
Console.WriteLine("Enter year of birth: ");
int yearFirst = int.Parse(Console.ReadLine());
string dateOfBirthFirst = dayFirst.ToString() + "-" + monthFirst.ToString() + "-" + yearFirst.ToString();
Console.WriteLine("Enter name: ");
string nameSecond = Console.ReadLine();
Console.WriteLine("Enter day of birth: ");
int daySecond = int.Parse(Console.ReadLine());
Console.WriteLine("Enter month of birth: ");
int monthSecond = int.Parse(Console.ReadLine());
Console.WriteLine("Enter year of birth: ");
int yearSecond = int.Parse(Console.ReadLine());
string dateOfBirthSecond = daySecond.ToString() + "-" + monthSecond.ToString() + "-" + yearSecond.ToString();
Employee_Data employeeFirst = new Employee_Data();
Employee_Data.Name employeeFirstName = new Employee_Data.Name(nameFirst);
Employee_Data.Name employeeDateOfBirthFirst = new Employee_Data.Name(dateOfBirthFirst);
Employee_Data employeeSecond = new Employee_Data();
Employee_Data.Name employeeSecondName = new Employee_Data.Name(nameSecond);
Employee_Data.Name employeeDateOfBirthSecond = new Employee_Data.Name(dateOfBirthSecond);
employeeFirst.show();
employeeSecond.show();
Console.ReadLine();
}
public IHttpActionResult GetEmployee(int id)
{
if (!employeeLogic.existEmployee(id))
{
//No se encontró el recurso code 404
return(NotFound());
}
Employee_Data employee = employeeLogic.GetEmployee(id);
if (employee != null)
{
// ok code 200
return(Ok(employee));
}
else
{
//No se pudo crear el recurso por un error interno code 500
return(InternalServerError());
}
}
public List <Object> GetListEmployee()
{
List <Object> dataList = new List <object>();
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var employeeList = construyeEntities.Employees.ToList();
int n = employeeList.Count;
if (n == 0)
{
dataList = null;
return(dataList);
}
else
{
for (int i = 0; i < employeeList.Count; ++i)
{
Employee_Data data = new Employee_Data();
data.id = employeeList.ElementAt(i).id;
data.identification = employeeList.ElementAt(i).identification;
data.name = employeeList.ElementAt(i).name;
data.lastname1 = employeeList.ElementAt(i).lastname1;
data.lastname2 = employeeList.ElementAt(i).lastname2;
data.phone = employeeList.ElementAt(i).phone;
data.hour_cost = employeeList.ElementAt(i).hour_cost;
dataList.Add(data);
}
return(dataList);
}
}
catch
{
dataList = null;
return(dataList);
}
}
}
public List <Object> GetAllProjectManagers()
{
List <Object> dataList = new List <object>();
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var employeeList = construyeEntities.usp_posible_manager().ToList();
int n = employeeList.Count;
if (n == 0)
{
dataList = null;
return(dataList);
}
else
{
for (int i = 0; i < employeeList.Count; ++i)
{
Employee_Data data = new Employee_Data();
data.id = employeeList.ElementAt(i).Id_Employee;
data.identification = employeeList.ElementAt(i).Identification;
data.name = employeeList.ElementAt(i).Name;
data.lastname1 = employeeList.ElementAt(i).Lastname1;
data.lastname2 = employeeList.ElementAt(i).Lastname2;
data.phone = employeeList.ElementAt(i).Phone;
data.hour_cost = employeeList.ElementAt(i).hour_cost;
dataList.Add(data);
}
return(dataList);
}
}
catch
{
dataList = null;
return(dataList);
}
}
}
public bool updateEmployee(Employee_Data data)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var employee = construyeEntities.Employees.Find(data.id);
employee.id = data.id;
employee.identification = data.identification;
employee.name = data.name;
employee.lastname1 = data.lastname1;
employee.lastname2 = data.lastname2;
employee.phone = data.phone;
employee.hour_cost = data.hour_cost;
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public IHttpActionResult updateEmployee([FromBody] Employee_Data data)
{
if (data == null)
{
//Bad request code 400
return(BadRequest());
}
if (!employeeLogic.existEmployee(data.id))
{
//petición correcta pero no pudo ser procesada porque no existe el archivo code 404
return(NotFound());
}
if (employeeLogic.updateEmployee(data))
{
//petición correcta y se ha creado un nuevo recurso code 200 ok
return(Ok());
}
else
{
//No se pudo crear el recurso por un error code 500
return(InternalServerError());
}
}
public bool addEmployee(Employee_Data data)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
Employee newEmployee = new Employee();
newEmployee.id = data.id;
newEmployee.identification = data.identification;
newEmployee.name = data.name;
newEmployee.lastname1 = data.lastname1;
newEmployee.lastname2 = data.lastname2;
newEmployee.phone = data.phone;
newEmployee.hour_cost = data.hour_cost;
try
{
construyeEntities.Employees.Add(newEmployee);
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public IEnumerable <employees> ListaEmployee()
{
Employee_Data obj = new Employee_Data(_connection);
return(obj.ListaEmployee());
}
public employees RetornaEmployee(int id)
{
Employee_Data obj = new Employee_Data(_connection);
return(obj.RetornaEmployee(id));
}
public Employee_BL(Employee_Data dl)
{
itsDAL = dl;
}