public Reply Search([FromBody] EmployeeViewModel model)
{
Reply oR = new Reply
{
Result = 0
};
try
{
using (TriarioEntities1 db = new TriarioEntities1())
{
List <Search_Employee_Result> SearchEmployee = db.Search_Employee(model.CC).ToList();
if (SearchEmployee.Count() > 0)
{
oR.Data = SearchEmployee;
oR.Result = 1;
}
else
{
oR.Message = "Usuario Inexistente";
}
}
}
catch (Exception)
{
oR.Message = "Error del servidor";
}
return(oR);
}
public Reply DeleteEmployee([FromUri] int id)
{
Reply oR = new Reply
{
Result = 0
};
try
{
using (TriarioEntities1 db = new TriarioEntities1())
{
int CC = id;
List <Search_Employee_Result> SearchEmployee = db.Search_Employee(CC).ToList();
if (SearchEmployee.Count() > 0)
{
int DeleteEmployee = db.Delete_Employee(CC);
oR.Data = DeleteEmployee;
oR.Result = 1;
oR.Message = "Borrado correctamente";
}
else
{
oR.Message = "Usuario no encontrado";
}
}
}
catch (Exception)
{
oR.Message = "Error De Borrado";
}
return(oR);
}
public Reply AlterEmployee([FromBody] EmployeeViewModel model)
{
Reply oR = new Reply
{
Result = 0
};
try
{
using (TriarioEntities1 db = new TriarioEntities1())
{
List <Search_Employee_Result> SearchEmployee = db.Search_Employee(model.CC).ToList();
if (SearchEmployee.Count() > 0)
{
int AlterEmployee = db.Actualizate_Employee(model.CC, model.FName, model.LName, model.EUser, model.Email, model.Salary, model.Fk_Department);
oR.Data = AlterEmployee;
oR.Result = 1;
}
else
{
oR.Message = "Usuario no encontrado";
}
}
}
catch (Exception)
{
oR.Message = "Error De Actualizacion";
}
return(oR);
}
public Reply Search([FromBody] DepartmentViewModel model)
{
Reply oR = new Reply
{
Result = 0
};
try
{
using (TriarioEntities1 db = new TriarioEntities1())
{
List <Search_Department_Result> SearchDeparment = db.Search_Department(model.Id_Department).ToList();
if (SearchDeparment.Count() > 0)
{
oR.Data = SearchDeparment;
oR.Result = 1;
}
else
{
oR.Message = "Departamento Inexistente";
}
}
}
catch (Exception)
{
oR.Message = "Error del servidor";
}
return(oR);
}
public Reply All()
{
Reply oR = new Reply
{
Result = 0
};
try
{
using (TriarioEntities1 db = new TriarioEntities1())
{
List <DepartmentViewModel> lst = (from d in db.Department
select new DepartmentViewModel
{
Id_Department = d.Id_Department,
Name = d.Name
}).ToList();
oR.Data = lst;
oR.Result = 1;
}
}
catch (Exception)
{
oR.Message = "Error del servidor";
}
return(oR);
}
public Reply AlterDepartment([FromBody] DepartmentViewModel model)
{
Reply oR = new Reply
{
Result = 0
};
try
{
using (TriarioEntities1 db = new TriarioEntities1())
{
List <Search_Department_Result> SearchDepartment = db.Search_Department(model.Id_Department).ToList();
if (SearchDepartment.Count() > 0)
{
int AlterDepartment = db.Actualizate_Department(model.Id_Department, model.Name);
oR.Data = AlterDepartment;
oR.Result = 1;
}
else
{
oR.Message = "Usuario no encontrado";
}
}
}
catch (Exception)
{
oR.Message = "Error De Actualizacion";
}
return(oR);
}
public Reply DeleteDepartment([FromUri] string id)
{
Reply oR = new Reply
{
Result = 0
};
try
{
using (TriarioEntities1 db = new TriarioEntities1())
{
string FkDepartment = id;
List <Search_Department_Result> SearchDepartment = db.Search_Department(id).ToList();
if (SearchDepartment.Count() > 0)
{
foreach (Employee em in db.Employee)
{
if (em.Fk_Department == id)
{
oR.Message = "No s puede borrar por la existencia de usuarios relacionados con el";
return(oR);
}
}
int DeleteDepartment = db.Delete_Department(id);
oR.Data = DeleteDepartment;
oR.Result = 1;
oR.Message = "Borrado correctamente";
}
else
{
oR.Message = "Usuario no encontrado";
}
}
}
catch (Exception)
{
oR.Message = "Error De Borrado";
}
return(oR);
}
public Reply GeneralInformation()
{
Reply oR = new Reply
{
Result = 0
};
try
{
using (TriarioEntities1 db = new TriarioEntities1())
{
List <JoinViewModel> listJ = new List <JoinViewModel>();
foreach (var em in db.Employee)
{
listJ.Add(new JoinViewModel
{
CC = em.CC,
FullName = em.FullName,
DName = em.Department.Name,
Salary = (decimal)em.Salary,
PSalary = (decimal)em.Salary * 100 / (decimal)(((Sum_Salary_Department_Result)
(db.Sum_Salary_Department(em.Department.Id_Department).ToList().FirstOrDefault())).Sum_Salary)
});
}
oR.Data = listJ;
oR.Result = 1;
}
}
catch (Exception ex)
{
oR.Message = ex.Message;
}
return(oR);
}
public Reply NewEmployee([FromBody] EmployeeViewModel model)
{
Reply oR = new Reply
{
Result = 0
};
try
{
using (TriarioEntities1 db = new TriarioEntities1())
{
int NewEmployee = db.Create_Employee(model.CC, model.FName, model.LName, model.EUser, model.Email, model.Salary, model.Fk_Department);
oR.Data = NewEmployee;
oR.Result = 1;
}
}
catch (Exception)
{
oR.Message = "Error De Creacion";
}
return(oR);
}
public Reply All()
{
Reply oR = new Reply
{
Result = 0
};
try
{
using (TriarioEntities1 db = new TriarioEntities1())
{
List <EmployeeViewModel> lst = (from d in db.Employee
select new EmployeeViewModel
{
Id_Num = d.id_num,
CC = d.CC,
FName = d.FName,
LName = d.LName,
EUser = d.EUser,
Email = d.Email,
Salary = (decimal)d.Salary,
Fk_Department = d.Fk_Department
}).ToList();
oR.Data = lst;
oR.Result = 1;
}
}
catch (Exception)
{
oR.Message = "Error del servidor";
}
return(oR);
}
public Reply NewDepartment([FromBody] DepartmentViewModel model)
{
Reply oR = new Reply
{
Result = 0
};
try
{
using (TriarioEntities1 db = new TriarioEntities1())
{
int NewDepartment = db.Create_Department(model.Id_Department, model.Name);
oR.Data = NewDepartment;
oR.Result = 1;
}
}
catch (Exception)
{
oR.Message = "Error De Creacion";
}
return(oR);
}
