private DataTable GetFunctionalityImageData(int functionalityId) { var dt = FunctionalityXFunctionalityImageDataManager.GetByFunctionality(functionalityId, SessionVariables.RequestProfile); var FunctionalityImagedt = FunctionalityImageDataManager.GetList(SessionVariables.RequestProfile); var resultdt = FunctionalityImagedt.Clone(); foreach (DataRow row in dt.Rows) { var rows = FunctionalityImagedt.Select("FunctionalityImageId = " + row[FunctionalityImageDataModel.DataColumns.FunctionalityImageId]); resultdt.ImportRow(rows[0]); } return(resultdt); }
protected override DataTable GetData() { var dt1 = FunctionalityDataManager.Search(oSearchFilter.SearchParameters, SessionVariables.RequestProfile); dt1.Columns.Add("FunctionalityImageId"); string str = string.Empty; foreach (DataRow dr in dt1.Rows) { var functionalityId = Convert.ToInt32(dr["FunctionalityId"]); var functionalityImageId = string.Empty; var objFunctionalityXFunctionalityImage = new FunctionalityXFunctionalityImageDataModel(); objFunctionalityXFunctionalityImage.FunctionalityId = Convert.ToInt32(functionalityId); var dtFunctionalityXFunctionalityImage = FunctionalityXFunctionalityImageDataManager.GetByFunctionality(functionalityId, SessionVariables.RequestProfile); if (dtFunctionalityXFunctionalityImage != null && dtFunctionalityXFunctionalityImage.Rows.Count > 0) { foreach (DataRow drFunctionalityXFunctionalityImage in dtFunctionalityXFunctionalityImage.Rows) { if (string.IsNullOrEmpty(functionalityImageId)) { functionalityImageId = drFunctionalityXFunctionalityImage["FunctionalityImageId"].ToString(); } else { functionalityImageId += ", " + drFunctionalityXFunctionalityImage["FunctionalityImageId"].ToString(); } } } dr["FunctionalityImageId"] = functionalityImageId; } return(dt1); }
protected override DataTable GetData() { var dt = FunctionalityXFunctionalityImageDataManager.Search(oSearchFilter.SearchParameters, SessionVariables.RequestProfile); return(dt); }