//insert public static int addPost(string title, string writername, string content, string image, int platformid, int categoryid) { string sql = "INSERT INTO [dbo].[Post] ([title] , [writtername] , [content] , [image] , [upvote] , " + " [platformid] , [categoryid] , [datecreated] , [isApprove]) " + " VALUES ( @title, @writername, @content, @image, 0, @platformid, @categoryid, GETDATE(), 0 )"; SqlParameter p1 = new SqlParameter("@title", SqlDbType.VarChar); p1.Value = title; SqlParameter p2 = new SqlParameter("@writername", SqlDbType.VarChar); p2.Value = writername; SqlParameter p3 = new SqlParameter("@content", SqlDbType.VarChar); p3.Value = content; SqlParameter p4 = new SqlParameter("@image", SqlDbType.VarChar); p4.Value = image; SqlParameter p5 = new SqlParameter("@platformid", SqlDbType.Int); p5.Value = platformid; SqlParameter p6 = new SqlParameter("@categoryid", SqlDbType.Int); p6.Value = categoryid; return(DAO.ExecuteSQLWithParameters(sql, p1, p2, p3, p4, p5, p6)); }
//update public static int approvePostbyID(int id) { string sql = "UPDATE [dbo].[Post] SET [isApprove] = 1 WHERE [Post].postid = @id"; SqlParameter p1 = new SqlParameter("@id", SqlDbType.Int); p1.Value = id; return(DAO.ExecuteSQLWithParameters(sql, p1)); }
//insert public static int addNewCategory(string name) { string sql = "INSERT INTO [dbo].Category (categoryname) VALUES (@name) "; SqlParameter p1 = new SqlParameter("@name", SqlDbType.VarChar); p1.Value = name; return(DAO.ExecuteSQLWithParameters(sql, p1)); }
public static int deletePostByID(int id) { string sql = "delete [Post] where [Post].postid = @id "; SqlParameter p1 = new SqlParameter("@id", SqlDbType.Int); p1.Value = id; return(DAO.ExecuteSQLWithParameters(sql, p1)); }
//insert public static int addNewPlatform(string name) { string sql = "INSERT INTO [dbo].[Platform] ([platformname]) VALUES (@name) "; SqlParameter p1 = new SqlParameter("@name", SqlDbType.VarChar); p1.Value = name; return(DAO.ExecuteSQLWithParameters(sql, p1)); }
//delete acc public static int deleteAccByUsername(string username) { string sql = " delete [Account] where Account.username = @name "; SqlParameter p1 = new SqlParameter("@name", SqlDbType.VarChar); p1.Value = username; return(DAO.ExecuteSQLWithParameters(sql, p1)); }
public static int updatePasswordAccount(string username, string password) { string sql = "update [Account] set [Account].password = @password where [Account].username = @username "; SqlParameter p1 = new SqlParameter("@password", SqlDbType.VarChar); p1.Value = password; SqlParameter p2 = new SqlParameter("@username", SqlDbType.VarChar); p2.Value = username; return(DAO.ExecuteSQLWithParameters(sql, p1, p2)); }
public static int updateImageOfavaterAccount(string imagename, string username) { string sql = "update [Account] set [Account].avatar = @image where [Account].username = @username "; SqlParameter p1 = new SqlParameter("@image", SqlDbType.VarChar); p1.Value = imagename; SqlParameter p2 = new SqlParameter("@username", SqlDbType.VarChar); p2.Value = username; return(DAO.ExecuteSQLWithParameters(sql, p1, p2)); }
//update public static int activeWriter(string username, int bit) { string sql = @"update [Account] set [Account].isWriter = @bit where [Account].username = @username "; SqlParameter p1 = new SqlParameter("@bit", SqlDbType.Int); p1.Value = bit; SqlParameter p2 = new SqlParameter("@username", SqlDbType.VarChar); p2.Value = username; return(DAO.ExecuteSQLWithParameters(sql, p1, p2)); }
public static int updatePostByID(int id, string title, string content, string imagepath) { string sql = "UPDATE [dbo].[Post] SET [title] = @title ,[content] = @content ," + "[image] = @image , [isApprove] = 0 WHERE [Post].postid = @id "; SqlParameter p1 = new SqlParameter("@title", SqlDbType.VarChar); p1.Value = title; SqlParameter p2 = new SqlParameter("@content", SqlDbType.VarChar); p2.Value = content; SqlParameter p3 = new SqlParameter("@image", SqlDbType.VarChar); p3.Value = imagepath; SqlParameter p4 = new SqlParameter("@id", SqlDbType.Int); p4.Value = id; return(DAO.ExecuteSQLWithParameters(sql, p1, p2, p3, p4)); }