Beispiel #1
0
        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);
        }
Beispiel #2
0
        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;
        }