public static int SP_10_GetUtilityID(string zip, int categoryTdxID) { int utilityID = 0; sp_010_select_IDs_terms_productTableAdapter taSP10 = new sp_010_select_IDs_terms_productTableAdapter(); Search.sp_010_select_IDs_terms_productDataTable dtSP10 = taSP10.GetData(zip, categoryTdxID); for (int i = 0; i < dtSP10.Rows.Count; i++) { utilityID = Convert.ToInt32(dtSP10.Rows[i]["UtilityID"]); } return(utilityID); }
public static int SP_10_GetTdxTermsID(string zip, int categoryTdxID) { int tdxTermsID = 0; sp_010_select_IDs_terms_productTableAdapter taSP10 = new sp_010_select_IDs_terms_productTableAdapter(); Search.sp_010_select_IDs_terms_productDataTable dtSP10 = taSP10.GetData(zip, categoryTdxID); for (int i = 0; i < dtSP10.Rows.Count; i++) { //ratingModelTdxIDList.Add(dtSP10.Rows[i]["RatingModelTdxID"].ToString()); tdxTermsID = Convert.ToInt32(dtSP10.Rows[i]["TdxTermsID"]); } return(tdxTermsID); }