public static bool UpdateUser(UpdateUser u) { string sql = @"UPDATE [dbo].[Users] SET [Username] = @p1, [Email] = @p2, " + "[Firstname] = @p3, [Lastname] = @p4, [Address] = @p5 WHERE Id = @p6"; return(DB.Action(sql, u.Username, u.Email, u.Firstname, u.Lastname, u.Address, u.Id)); }
public static bool CreateUser(InsertUser u) { string sql = @"INSERT INTO [dbo].[Users] ([Username], [Password], [Email], [Firstname], [Lastname], [Address])" + " VALUES (@p1, @p2, @p3, @p4, @p5, @p6)"; return(DB.Action(sql, u.Username, u.Password, u.Email, u.Firstname, u.Lastname, u.Address)); }
public static bool Update(UpdatePost p) { //string sql = @"UPDATE [dbo].[Articles] SET [Title] = @p1, [Content] = @p2, [Photo] = @p3, [Category] = @p4, [byUser] = @p5, [OnDate] = @p6 WHERE Id = @p7"; //return DB.Action(sql, p.Title, p.Content, p.Photo, p.Category, p.ByUser, p.OnDate, p.Id); string sql = @"UPDATE [dbo].[Articles] SET [Title] = @p1, [Content] = @p2, [byUser] = @p3, [OnDate] = @p4 WHERE Id = @p5"; return(DB.Action(sql, p.Title, p.Content, p.ByUser, p.OnDate, p.Id)); }
public static bool ChangePassword(ChangePassword p) { string sql = null; if (p.OldPassword == AccountDAO.Password) { sql = @"UPDATE [dbo].[Users] SET [Password] = @p1 WHERE Id = @p2"; } return(DB.Action(sql, p.NewPassword, AccountDAO.Id)); }
public static bool DeleteUser(int id) { string sql = @"DELETE [dbo].[Users] WHERE Id = @p1"; return(DB.Action(sql, id)); }
public static bool Create(SetPost p) { string sql = @"INSERT INTO [dbo].[Articles] ([Title], [Content], [Photo], [Category], [ByUser]) VALUES (@p1, @p2, @p3, @p4, @p5)"; return(DB.Action(sql, p.Title, p.Content, p.Photo, p.Category, AccountDAO.Id)); }
public static bool Update(SetCategory c) { string sql = @"UPDATE [dbo].[Categories] SET [Name] = @p1, [Description] = @p2, [ByUser] = @p3, [OnDate] = @p4 WHERE Id = @p5"; return(DB.Action(sql, c.Name, c.Description, c.ByUser, c.OnDate, c.Id)); }
public static bool Delete(int id) { string sql = @"DELETE [dbo].[Categories] WHERE Id = @p1"; return(DB.Action(sql, id)); }
public static bool Create(SetCategory c) { string sql = @"INSERT INTO [dbo].[Categories] ([Name], [Description], [ByUser]) VALUES (@p1, @p2, @p3)"; return(DB.Action(sql, c.Name, c.Description, AccountDAO.Id)); }