public IEnumerable <string> GetAllFamilyProductsNamesByRealeaseId(int?releaseId) { if (releaseId != null) { List <string> rp; using (IReleaseFamilyProductRepository db = new ReleaseFamilyProductRepository()) { rp = db.Where(a => a.ReleaseID == releaseId && a.IsChecked == true && a.FamilyProduct.Products.Count() > 0).Select(z => z.FamilyProduct.Name).ToList(); } return(rp); } return(null); }
public string GetParameterTableName(string tableName, int ReleaseParameterID) { if (tableName == "Milestone") { using (IReleaseMilestoneRepository dbr = new ReleaseMilestoneRepository()) { var ReleaseMilestone = dbr.Where(a => a.ReleaseMilestoneID == ReleaseParameterID).Include(a => a.Milestone).FirstOrDefault(); return(ReleaseMilestone != null && ReleaseMilestone.Milestone != null ? ReleaseMilestone.Milestone.Name : ""); } } else if (tableName == "Product") { using (IReleaseProductRepository dbr = new ReleaseProductRepository()) { var ReleaseProduct = dbr.Where(a => a.ReleaseProductID == ReleaseParameterID).Include(a => a.Product).FirstOrDefault(); return(ReleaseProduct != null && ReleaseProduct.Product != null ? ReleaseProduct.Product.Name : ""); } } else if (tableName == "FamilyProduct") { using (IReleaseFamilyProductRepository dbr = new ReleaseFamilyProductRepository()) { var ReleaseFamilyProduct = dbr.Where(a => a.ReleaseFamilyProductID == ReleaseParameterID).Include(a => a.FamilyProduct).FirstOrDefault(); return(ReleaseFamilyProduct != null && ReleaseFamilyProduct.FamilyProduct != null ? ReleaseFamilyProduct.FamilyProduct.Name : ""); } } else if (tableName == "Stakeholder") { using (IReleaseStakeholderRepository dbr = new ReleaseStakeholderRepository()) { var ReleaseStakeholder = dbr.Where(a => a.ReleaseStakeholderID == ReleaseParameterID).Include(a => a.Stakeholder).FirstOrDefault(); return(ReleaseStakeholder != null && ReleaseStakeholder.Stakeholder != null ? ReleaseStakeholder.Stakeholder.Name : ""); } } else if (tableName == "Area") { using (IReleaseAreaOwnerRepository dbr = new ReleaseAreaOwnerRepository()) { var ReleaseAreaOwner = dbr.Where(a => a.ReleaseAreaOwnerID == ReleaseParameterID).Include(a => a.Area).FirstOrDefault(); return(ReleaseAreaOwner != null && ReleaseAreaOwner.Area != null ? ReleaseAreaOwner.Area.Name : ""); } } return(null); }