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