private static DataRow SP_20_FillModelInfo(int ratingModelTdxID, int retailerID_min, DataRow resultRow) { // BrandName, BrandModel, ProdImgURL,ProdDesc = SP_20(RatingModelTdxID,@retailerID_min) sp_020_select_model_info_for_selectedRetailerTableAdapter taModelInfo = new sp_020_select_model_info_for_selectedRetailerTableAdapter(); Search.sp_020_select_model_info_for_selectedRetailerDataTable dtModelInfo = taModelInfo.GetModelInfo(ratingModelTdxID, retailerID_min); //Get Above info into that partially filled result row which comes as input if (dtModelInfo.Rows.Count > 0) { resultRow["BrandName"] = dtModelInfo.Rows[0]["BrandName"]; resultRow["BrandModel"] = dtModelInfo.Rows[0]["BrandModel"]; resultRow["ProdImgURL"] = dtModelInfo.Rows[0]["ProdImgURL"]; resultRow["ProdDesc"] = dtModelInfo.Rows[0]["ProdDesc"]; } else { return(null); } //return result row after filling in model info into this return(resultRow); }
private static DataRow SP_20_FillModelInfo(int ratingModelTdxID, int retailerID_min, DataRow resultRow) { // BrandName, BrandModel, ProdImgURL,ProdDesc = SP_20(RatingModelTdxID,@retailerID_min) sp_020_select_model_info_for_selectedRetailerTableAdapter taModelInfo = new sp_020_select_model_info_for_selectedRetailerTableAdapter(); Search.sp_020_select_model_info_for_selectedRetailerDataTable dtModelInfo = taModelInfo.GetModelInfo(ratingModelTdxID, retailerID_min); //Get Above info into that partially filled result row which comes as input if (dtModelInfo.Rows.Count > 0) { resultRow["BrandName"] = dtModelInfo.Rows[0]["BrandName"]; resultRow["BrandModel"] = dtModelInfo.Rows[0]["BrandModel"]; resultRow["ProdImgURL"] = dtModelInfo.Rows[0]["ProdImgURL"]; resultRow["ProdDesc"] = dtModelInfo.Rows[0]["ProdDesc"]; } else return null; //return result row after filling in model info into this return resultRow; }