public Material_Data GetMaterial(int id)
{
Material_Data material = new Material_Data();
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
if (!this.existMaterial(id))
{
material = null;
return(material);
}
var mat = construyeEntities.Materials.Find(id);
material.id = mat.id;
material.name = mat.name;
material.price = mat.price;
material.description = mat.description;
return(material);
}
catch (Exception E)
{
material = null;
return(material);
}
}
}
public List <Object> getRolesXEmployee(int id)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
List <Object> client = new List <Object>();
try
{
if (!this.existEmployee(id))
{
client = null;
return(client);
}
var roles = construyeEntities.Roles.Where(e => e.id_employee == id).ToList();
for (int i = 0; i < roles.Count; ++i)
{
RoleSpecification_Data roleData = new RoleSpecification_Data();
roleData.id_role = roles.ElementAt(i).Role_specification.id;
roleData.specification = roles.ElementAt(i).Role_specification.specification;
client.Add(roleData);
}
return(client);
}
catch (Exception E)
{
client = null;
return(client);
}
}
}
public Anotations_Data GetAnotation(int ID)
{
Anotations_Data result = new Anotations_Data();
Anotation anotations;
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
if (!this.existAnotation(ID))
{
result = null;
return(result);
}
anotations = construyeEntities.Anotations.Find(ID);
result.id = anotations.id;
result.id_project = anotations.id_project;
result.date = anotations.date;
result.anotation = anotations.anotation1;
return(result);
}
catch (Exception E)
{
result = null;
return(result);
}
}
}
public bool addStage(Stage_Data data)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
Stage newStage = new Stage();
newStage.id = data.id;
newStage.id_project = data.id_project;
newStage.name = data.name;
newStage.start_date = data.start_date;
newStage.status = data.status;
newStage.end_date = data.end_date;
newStage.description = data.description;
newStage.Project = construyeEntities.Projects.Find(data.id_project);
try
{
construyeEntities.Stages.Add(newStage);
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public Bill_Data GetBill(int ID)
{
Bill_Data result = new Bill_Data();
Bill bill;
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
if (!this.existBill(ID))
{
result = null;
return(result);
}
bill = construyeEntities.Bills.Find(ID);
result.id = bill.id;
result.id_material = bill.id_material;
result.id_provider = bill.id_provider;
result.id_stage = bill.id_stage;
result.price = bill.price;
result.serial = bill.serial;
result.date = bill.date;
return(result);
}
catch (Exception E)
{
result = null;
return(result);
}
}
}
public List <Object> GetListProvider()
{
List <Object> dataList = new List <object>();
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var providerList = construyeEntities.Providers.ToList();
int n = providerList.Count;
if (n == 0)
{
dataList = null;
return(dataList);
}
else
{
for (int i = 0; i < providerList.Count; ++i)
{
Provider_Data data = new Provider_Data();
data.id = providerList.ElementAt(i).id;
data.name = providerList.ElementAt(i).name;
dataList.Add(data);
}
return(dataList);
}
}
catch
{
dataList = null;
return(dataList);
}
}
}
public MStage_Data GetMStage(int id_material, int id_stage)
{
MStage_Data result = new MStage_Data();
MaterialsxStage materialsxStage;
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
if (!this.existMStage(id_stage, id_material))
{
result = null;
return(result);
}
materialsxStage = construyeEntities.MaterialsxStages.Find(id_stage, id_material);
result.id_material = materialsxStage.id_material;
result.id_stage = materialsxStage.id_stage;
result.price = materialsxStage.price;
result.quantity = materialsxStage.quantity;
return(result);
}
catch (Exception E)
{
result = null;
return(result);
}
}
}
public bool addBill(Bill_Data data)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
Bill bill = new Bill();
bill.id = data.id;
bill.id_material = data.id_material;
bill.id_provider = data.id_provider;
bill.id_stage = data.id_stage;
bill.price = data.price;
bill.serial = data.serial;
bill.date = data.date;
bill.Material = construyeEntities.Materials.Find(data.id_material);
bill.Provider = construyeEntities.Providers.Find(data.id_provider);
bill.Stage = construyeEntities.Stages.Find(data.id_stage);
try
{
construyeEntities.Bills.Add(bill);
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public List <Object> GetListRole()
{
List <Object> dataList = new List <object>();
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var providerList = construyeEntities.Role_specification.ToList();
int n = providerList.Count;
if (n == 0)
{
dataList = null;
return(dataList);
}
else
{
for (int i = 0; i < providerList.Count; ++i)
{
RoleSpecification_Data data = new RoleSpecification_Data();
data.id_role = providerList.ElementAt(i).id;
data.specification = providerList.ElementAt(i).specification;
dataList.Add(data);
}
return(dataList);
}
}
catch
{
dataList = null;
return(dataList);
}
}
}
public Role_Data GetRoles(int ID)
{
Role_Data result = new Role_Data();
Role role;
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
if (!this.existRoles(ID))
{
result = null;
return(result);
}
role = construyeEntities.Roles.Find(ID);
result.id = role.id;
result.id_employee = role.id_employee;
result.id_role = role.id_role;
result.start_date = role.start_date;
return(result);
}
catch (Exception E)
{
result = null;
return(result);
}
}
}
public RoleSpecification_Data GetRole(int ID)
{
RoleSpecification_Data result = new RoleSpecification_Data();
Role_specification role_Specification;
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
if (!this.existRole(ID))
{
result = null;
return(result);
}
role_Specification = construyeEntities.Role_specification.Find(ID);
result.id_role = role_Specification.id;
result.specification = role_Specification.specification;
return(result);
}
catch (Exception E)
{
result = null;
return(result);
}
}
}
public Provider_Data GetProvider(int ID)
{
Provider_Data result = new Provider_Data();
Provider provider;
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
if (!this.existProvider(ID))
{
result = null;
return(result);
}
provider = construyeEntities.Providers.Find(ID);
result.id = provider.id;
result.name = provider.name;
return(result);
}
catch (Exception E)
{
result = null;
return(result);
}
}
}
public bool addWorkedHours(Worked_Hours_Data data)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
Worked_hours newwh = new Worked_hours();
newwh.id = data.id;
newwh.id_employee = data.id_employee;
newwh.id_project = data.id_project;
newwh.hours = data.hours;
newwh.date = data.date;
newwh.Project = construyeEntities.Projects.Find(data.id_project);
newwh.Employee = construyeEntities.Employees.Find(data.id_employee);
try
{
construyeEntities.Worked_hours.Add(newwh);
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public Worked_Hours_Data GetWorkedHours(int ID)
{
Worked_Hours_Data result = new Worked_Hours_Data();
Worked_hours wh;
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
if (!this.existWorkedHours(ID))
{
result = null;
return(result);
}
wh = construyeEntities.Worked_hours.Find(ID);
result.id = wh.id;
result.id_employee = wh.id_employee;
result.id_project = wh.id_project;
result.hours = wh.hours;
result.date = wh.date;
return(result);
}
catch (Exception E)
{
result = null;
return(result);
}
}
}
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 Report_Project_Data GetProject(int id)
{
Report_Project_Data project = new Report_Project_Data();
Project pr;
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
if (!this.existProject(id))
{
project = null;
return(project);
}
pr = construyeEntities.Projects.Where(e => e.id == id).ToList().First();
project.id = pr.id;
project.id_client = pr.id_client;
project.manager = pr.manager;
project.name = pr.name;
project.ubication = pr.ubication;
var costos = construyeEntities.usp_total_bills(id).First();
var etapasList = construyeEntities.Stages.Where(e => e.id_project == id).ToList();
List <int> idStageList = new List <int>();
for (int i = 0; i < etapasList.Count; ++i)
{
idStageList.Add(etapasList.ElementAt(i).id);
}
var anotationsList = construyeEntities.Anotations.Where(e => e.id_project == id).ToList();
List <int> idAnotationList = new List <int>();
for (int i = 0; i < anotationsList.Count; ++i)
{
idAnotationList.Add(anotationsList.ElementAt(i).id);
}
project.totalCost = (int)costos.TotalReal;
project.totalBudget = (int)costos.TotalPresupuesto;
project.idAnotations = idAnotationList;
project.idStages = idStageList;
return(project);
}
catch (Exception E)
{
project = null;
return(project);
}
}
}
public bool existProject(int id)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
var i = construyeEntities.Projects.Find(id);
if (i == null)
{
return(false);
}
else
{
return(true);
}
}
}
public bool existWorkedHours(int id)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
var i = construyeEntities.Worked_hours.Find(id);
if (i == null)
{
return(false);
}
else
{
return(true);
}
}
}
public bool existRole(int id)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
var i = construyeEntities.Role_specification.Find(id);
if (i == null)
{
return(false);
}
else
{
return(true);
}
}
}
public bool existClient(string id)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
var i = construyeEntities.Clients.Find(id);
if (i == null)
{
return(false);
}
else
{
return(true);
}
}
}
public bool existMStage(int id_stage, int id_material)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
var i = construyeEntities.MaterialsxStages.Find(id_stage, id_material);
if (i == null)
{
return(false);
}
else
{
return(true);
}
}
}
public bool eraseRole(int id)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var ms = construyeEntities.Role_specification.Find(id);
construyeEntities.Role_specification.Remove(ms);
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public bool eraseClient(string id)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var ms = construyeEntities.Clients.Find(id);
construyeEntities.Clients.Remove(ms);
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public bool eraseMStage(int id_stage, int id_material)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var ms = construyeEntities.MaterialsxStages.Find(id_stage, id_material);
construyeEntities.MaterialsxStages.Remove(ms);
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public bool eraseWorkedHours(int id)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var ms = construyeEntities.Worked_hours.Find(id);
construyeEntities.Worked_hours.Remove(ms);
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public List <Object> GetListClient()
{
List <Object> dataList = new List <object>();
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var clientList = construyeEntities.Clients.ToList();
int n = clientList.Count;
if (n == 0)
{
dataList = null;
return(dataList);
}
else
{
for (int i = 0; i < clientList.Count; ++i)
{
ProjectsxClient_Data data = new ProjectsxClient_Data();
data.identification = clientList.ElementAt(i).identification;
data.name = clientList.ElementAt(i).name;
data.lastname1 = clientList.ElementAt(i).lastname1;
data.lastname2 = clientList.ElementAt(i).lastname2;
data.phone = clientList.ElementAt(i).phone;
data.email = clientList.ElementAt(i).email;
var projects = construyeEntities.Projects.Where(e => e.id_client == data.identification).ToList();
List <Object> lis = new List <Object>();
for (int j = 0; j < projects.Count; ++j)
{
lis.Add(projects.ElementAt(j).id);
}
data.projects = lis;
dataList.Add(data);
}
return(dataList);
}
}
catch
{
dataList = null;
return(dataList);
}
}
}
public bool revokeRegister(string username)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var ms = construyeEntities.Passwords.Find(
construyeEntities.Employees.Where(e => e.identification == username).ToList().First().id);
construyeEntities.Passwords.Remove(ms);
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public bool updateRole(RoleSpecification_Data data)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var role = construyeEntities.Role_specification.Find(data.id_role);
role.id = data.id_role;
role.specification = data.specification;
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public bool updateProvider(Provider_Data data)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var provider = construyeEntities.Providers.Find(data.id);
provider.id = data.id;
provider.name = data.name;
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public bool addProvider(Provider_Data data)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
Provider newProvider = new Provider();
newProvider.id = data.id;
newProvider.name = data.name;
try
{
construyeEntities.Providers.Add(newProvider);
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
