public List <Detail> getAllDashboardByCompnayId(int companyId, string type = null)
{
DBHelper._Dashboard dbhelp = new DBHelper._Dashboard();
if (string.IsNullOrEmpty(type))
{
return(dbhelp.GetAllByCompanyId(companyId).Select(s => new Detail()
{
Id = s.Id,
CompanyId = s.CompanyID,
FactoryId = s.FactoryID,
FactoryName = (s.Factory == null ? "" : s.Factory.Name),
EquipmentId = s.EquipmentID,
EquipmentName = (s.Equipment == null ? "" : s.Equipment.Name),
EquipmentClassId = s.EquipmentClassID,
EquipmentClassName = (s.EquipmentClass == null ? "" : s.EquipmentClass.Name),
DashboardType = s.DashboardType
}).ToList <Detail>());
}
else
{
return(dbhelp.GetAllByCompanyId(companyId, type).Select(s => new Detail()
{
Id = s.Id,
CompanyId = s.CompanyID,
FactoryId = s.FactoryID,
FactoryName = (s.Factory == null ? "" : s.Factory.Name),
EquipmentId = s.EquipmentID,
EquipmentName = (s.Equipment == null ? "" : s.Equipment.Name),
EquipmentClassId = s.EquipmentClassID,
EquipmentClassName = (s.EquipmentClass == null ? "" : s.EquipmentClass.Name),
DashboardType = s.DashboardType
}).ToList <Detail>());
}
}
public void deleteDashboard(int id)
{
DBHelper._Dashboard dbhelp = new DBHelper._Dashboard();
Dashboard existingDashboard = dbhelp.GetByid(id);
dbhelp.Delete(existingDashboard);
}
public int addDashboard(Add dashboard)
{
DBHelper._Dashboard dbhelp = new DBHelper._Dashboard();
var newDashboard = new Dashboard()
{
CompanyID = dashboard.CompanyId,
DashboardType = dashboard.DashboardType,
FactoryID = dashboard.FactoryId,
EquipmentClassID = dashboard.EquipmentClassId,
EquipmentID = dashboard.EquipmentId
};
return(dbhelp.Add(newDashboard));
}
public List <Detail> getAllElementClassDashboardByCompnayId(int companyId)
{
DBHelper._Dashboard dbhelp = new DBHelper._Dashboard();
return(dbhelp.GetAllByCompanyId(companyId).Select(s => new Detail()
{
Id = s.Id,
CompanyId = s.CompanyID,
FactoryId = s.FactoryID,
FactoryName = (s.Factory == null ? "" : s.Factory.Name),
EquipmentId = s.EquipmentID,
EquipmentName = (s.Equipment == null ? "" : s.Equipment.Name),
EquipmentClassId = s.EquipmentClassID,
EquipmentClassName = (s.EquipmentClass == null ? "" : s.EquipmentClass.Name),
DashboardType = s.DashboardType
}).ToList <Detail>());
}
public Detail getDashboardById(int id)
{
DBHelper._Dashboard dbhelp = new DBHelper._Dashboard();
Dashboard dashboard = dbhelp.GetByid(id);
return(new Detail()
{
Id = dashboard.Id,
CompanyId = dashboard.CompanyID,
FactoryId = dashboard.FactoryID,
FactoryName = (dashboard.Factory == null ? "" : dashboard.Factory.Name),
EquipmentId = dashboard.EquipmentID,
EquipmentName = (dashboard.Equipment == null ? "" : dashboard.Equipment.Name),
EquipmentClassId = dashboard.EquipmentClassID,
EquipmentClassName = (dashboard.EquipmentClass == null ? "" : dashboard.EquipmentClass.Name),
DashboardType = dashboard.DashboardType
});
}
