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 }); }