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 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)); }