/// <summary> /// Инициализирует новый экземпляр класса <see cref="VkApi"/>. /// </summary> public VkApi() { Browser = new Browser(); Users = new UsersCategory(this); Friends = new FriendsCategory(this); Status = new StatusCategory(this); Messages = new MessagesCategory(this); Groups = new GroupsCategory(this); Audio = new AudioCategory(this); Wall = new WallCategory(this); Database = new DatabaseCategory(this); Utils = new UtilsCategory(this); Fave = new FaveCategory(this); Video = new VideoCategory(this); Account = new AccountCategory(this); Photo = new PhotoCategory(this); Docs = new DocsCategory(this); Likes = new LikesCategory(this); Pages = new PagesCategory(this); Gifts = new GiftsCategory(this); Apps = new AppsCategory(this); NewsFeed = new NewsFeedCategory(this); Stats = new StatsCategory(this); Auth = new AuthCategory(this); RequestsPerSecond = 3; }
/// <summary> /// Инициализирует новый экземпляр класса <see cref="VkApi"/>. /// </summary> public VkApi() { Browser = new Browser(); Users = new UsersCategory(this); Friends = new FriendsCategory(this); Status = new StatusCategory(this); Messages = new MessagesCategory(this); Groups = new GroupsCategory(this); Audio = new AudioCategory(this); Wall = new WallCategory(this); Database = new DatabaseCategory(this); Utils = new UtilsCategory(this); Fave = new FaveCategory(this); Video = new VideoCategory(this); Account = new AccountCategory(this); Photo = new PhotoCategory(this); Docs = new DocsCategory(this); Likes = new LikesCategory(this); Pages = new PagesCategory(this); Gifts = new GiftsCategory(this); Apps = new AppsCategory(this); NewsFeed = new NewsFeedCategory(this); Stats = new StatsCategory(this); Auth = new AuthCategory(this); Markets = new MarketsCategory(this); Execute = new ExecuteCategory(this); RequestsPerSecond = 3; }
/// <summary> /// Инициализирует новый экземпляр класса <see cref="VkApi"/>. /// </summary> public VkApi(ICaptchaSolver captchaSolver = null) { Browser = new Browser(); Users = new UsersCategory(this); Friends = new FriendsCategory(this); Status = new StatusCategory(this); Messages = new MessagesCategory(this); Groups = new GroupsCategory(this); Audio = new AudioCategory(this); Wall = new WallCategory(this); Board = new BoardCategory(this); Database = new DatabaseCategory(this); Utils = new UtilsCategory(this); Fave = new FaveCategory(this); Video = new VideoCategory(this); Account = new AccountCategory(this); Photo = new PhotoCategory(this); Docs = new DocsCategory(this); Likes = new LikesCategory(this); Pages = new PagesCategory(this); Gifts = new GiftsCategory(this); Apps = new AppsCategory(this); NewsFeed = new NewsFeedCategory(this); Stats = new StatsCategory(this); Auth = new AuthCategory(this); Markets = new MarketsCategory(this); Execute = new ExecuteCategory(this); RequestsPerSecond = 3; MaxCaptchaRecognitionCount = 5; _captchaSolver = captchaSolver; }
/// <summary> /// 获取所有category 或者 根据父类获取category /// </summary> /// <param name="parentCategoryId"></param> /// <returns></returns> public List <WallCategory> GetWallCategory(int parentCategoryId = 0, bool isRoot = false) { List <WallCategory> wcList = new List <WallCategory>(); string sql = string.Empty; if (parentCategoryId != 0) { sql = string.Format("select * from WallCategory where ParentCategoryId = {0} order by id desc", parentCategoryId); } else { sql = string.Format("select * from WallCategory {0} order by id desc", isRoot ? "where ParentCategoryId is null" : ""); } using (SqlDataReader dr = SQLHelper.ExecuteReader(sql)) { while (dr.Read()) { WallCategory wcFile = new WallCategory(); wcFile.Id = int.Parse(dr["Id"].ToString()); wcFile.CategoryName = dr["CategoryName"].ToString(); wcFile.ParentCategoryId = dr["ParentCategoryId"] is DBNull ? 0 : int.Parse(dr["ParentCategoryId"].ToString()); wcFile.UpdateDate = DateTime.Parse(dr["UpdateDate"].ToString()); wcFile.Owner = dr["Owner"].ToString(); wcList.Add(wcFile); } dr.Close(); } return(wcList); }
/// <summary> /// 更新category /// </summary> /// <param name="wc"></param> /// <returns></returns> public int UpdateWallCategory(WallCategory wc) { string sql = string.Format("update WallCategory set CategoryName=@CategoryName,UpdateDate=getDate(),Owner=@Owner where Id=@Id"); SqlParameter[] cmdParams = new SqlParameter[3]; cmdParams[0] = new SqlParameter("@CategoryName", wc.CategoryName); cmdParams[1] = new SqlParameter("@Owner", wc.Owner); cmdParams[2] = new SqlParameter("@Id", wc.Id); return(SQLHelper.ExecuteNonQuery(sql, cmdParams)); }
/// <summary> /// Инициализирует новый экземпляр класса <see cref="VkApi"/>. /// </summary> public VkApi() { Browser = new Browser(); Users = new UsersCategory(this); Friends = new FriendsCategory(this); Status = new StatusCategory(this); Messages = new MessagesCategory(this); Groups = new GroupsCategory(this); Audio = new AudioCategory(this); Wall = new WallCategory(this); Database = new DatabaseCategory(this); Utils = new UtilsCategory(this); Fave = new FaveCategory(this); Video = new VideoCategory(this); Account = new AccountCategory(this); }
/// <summary> /// Инициализирует новый экземпляр класса <see cref="VkApi"/>. /// </summary> public VkApi() { ServicePointManager.ServerCertificateValidationCallback = new PositiveCertificatePolicy().ServerCertificateValidationCallback; Browser = new Browser(); Users = new UsersCategory(this); Friends = new FriendsCategory(this); Status = new StatusCategory(this); Messages = new MessagesCategory(this); Groups = new GroupsCategory(this); Audio = new AudioCategory(this); Wall = new WallCategory(this); Database = new DatabaseCategory(this); Utils = new UtilsCategory(this); Fave = new FaveCategory(this); Video = new VideoCategory(this); Account = new AccountCategory(this); Likes = new LikesCategory(this); Photo = new PhotoCategory(this); }
public WallCategory GetWallCategoryById(int categoryId) { string sql = string.Format("select * from WallCategory where Id = {0}", categoryId); WallCategory wcFile = null; using (SqlDataReader dr = SQLHelper.ExecuteReader(sql)) { if (dr.Read()) { wcFile = new WallCategory(); wcFile.Id = int.Parse(dr["Id"].ToString()); wcFile.CategoryName = dr["CategoryName"].ToString(); wcFile.ParentCategoryId = dr["ParentCategoryId"] is DBNull ? 0 : int.Parse(dr["ParentCategoryId"].ToString()); wcFile.UpdateDate = DateTime.Parse(dr["UpdateDate"].ToString()); wcFile.Owner = dr["Owner"].ToString(); } dr.Close(); } return(wcFile); }
/// <summary> /// 添加Wall Category /// </summary> /// <param name="wc"></param> /// <returns></returns> public int Save(WallCategory wc) { string sql = string.Format("insert WallCategory values(@CategoryName,@ParentCategoryId,getDate(),@Owner);select id = SCOPE_IDENTITY();"); SqlParameter[] cmdParams = new SqlParameter[3]; cmdParams[0] = new SqlParameter("@CategoryName", wc.CategoryName); object parentCategory; if (wc.ParentCategoryId == 0) { parentCategory = DBNull.Value; } else { parentCategory = wc.ParentCategoryId; } cmdParams[1] = new SqlParameter("@ParentCategoryId", parentCategory); cmdParams[2] = new SqlParameter("@Owner", wc.Owner); return(int.Parse(SQLHelper.ExecuteScalar(sql, cmdParams).ToString())); }
/// <summary> /// Инициализирует новый экземпляр класса <see cref="VkApi"/>. /// </summary> public VkApi() { Browser = new Browser(); Users = new UsersCategory(this); Friends = new FriendsCategory(this); Status = new StatusCategory(this); Messages = new MessagesCategory(this); Groups = new GroupsCategory(this); Audio = new AudioCategory(this); Wall = new WallCategory(this); Database = new DatabaseCategory(this); Utils = new UtilsCategory(this); Fave = new FaveCategory(this); Video = new VideoCategory(this); Account = new AccountCategory(this); Photo = new PhotoCategory(this); Docs = new DocsCategory(this); RequestsPerSecond = 3; AutoTokenRefresh = false; }
public void SetUp() { _defaultWall = new WallCategory(new VkApi()); }
/// <summary> /// Инициализирует новый экземпляр класса <see cref="VkApi"/>. /// </summary> public VkApi() { Browser = new Browser(); Users = new UsersCategory(this); Friends = new FriendsCategory(this); Status = new StatusCategory(this); Messages = new MessagesCategory(this); Groups = new GroupsCategory(this); Audio = new AudioCategory(this); Wall = new WallCategory(this); Database = new DatabaseCategory(this); Utils = new UtilsCategory(this); Fave = new FaveCategory(this); Video = new VideoCategory(this); Account = new AccountCategory(this); Photo = new PhotoCategory(this); Docs = new DocsCategory(this); Likes = new LikesCategory(this); RequestsPerSecond = 3; }
internal WallCategoryExtended(WallCategory wallCategory, VkApi vk) { _wall = wallCategory; _vk = vk; }
/// <summary> /// Инициализирует новый экземпляр класса <see cref="VkApi"/>. /// </summary> public VkApi() { Browser = new Browser(); Users = new UsersCategory(this); Friends = new FriendsCategory(this); Status = new StatusCategory(this); Messages = new MessagesCategory(this); Groups = new GroupsCategory(this); Audio = new AudioCategory(this); Wall = new WallCategory(this); Database = new DatabaseCategory(this); Utils = new UtilsCategory(this); Fave = new FaveCategory(this); Video = new VideoCategory(this); Account = new AccountCategory(this); ApiVersion = "5.9"; }