public DataResponse GetUserHeckTotal(int UserID) { DataResponse resp; connection.Open(); DataTable dt = new DataTable(); using (MySqlCommand cmd = new MySqlCommand("GetUserHeckTotals")) { cmd.Connection = connection; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserID", UserID); using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd)) { sda.Fill(dt); } } UserHeckTotal item = ColumnMapper(dt) as UserHeckTotal; if (item != null) { HeckUserModel mdl = new HeckUserModel(null); DataResponse usrResp = mdl.GetUserByID(UserID); if (usrResp.Result) { item.User = usrResp.Item as HeckUser; } mdl.Dispose(); resp = new DataResponse("User Heck Total Found", true); resp.Item = item; } else { resp = new DataResponse("User Heck Total could not be found.", true); } return(resp); }