public LearningCharacterMapping(HanDatabase db, int userID, string culture) { SqlParameter[] parameters = { new SqlParameter("UserID", userID), new SqlParameter("Culture", culture) }; DataSet result = db.ExecuteStoredProcedure("spLearningCharacterData", parameters); CharacterData = new CharacterLookupMapping(result.Tables[0], result.Tables[1], result.Tables[2], result.Tables[3]); }
public CharacterLookupMapping(HanDatabase db, IEnumerable <int> utfCodes, string culture, int userID, VariantType variantType) { DataTable utfCodeTable = new DataTable(); utfCodeTable.Columns.Add("UTFCode"); foreach (int utf in utfCodes) { DataRow row = utfCodeTable.NewRow(); row["UTFCode"] = utf; utfCodeTable.Rows.Add(row); } SqlParameter variantParam; if (variantType == VariantType.None) { variantParam = new SqlParameter("VariantLookup", null); } else { variantParam = new SqlParameter("VariantLookup", (int)variantType); } SqlParameter[] parameters = { new SqlParameter("UTFCodes", utfCodeTable) { TypeName = "tvpUTFCodes" }, new SqlParameter("Culture", culture), new SqlParameter("UserID", userID), variantParam }; DataSet result = db.ExecuteStoredProcedure("spCharacterLookup", parameters); ParseData(result.Tables[0], result.Tables[1], result.Tables[2], result.Tables[3]); }