public void RegisterUser(User user)
{
_db.ExecuteProcedure("usp_RegisterUser",
new SqlParameter("@username", user.Username),
new SqlParameter("@email", user.Email),
new SqlParameter("@password", user.Password),
new SqlParameter("@type", user.Type));
}
public void AddPublisher(Publication publisher)
{
_db.ExecuteProcedure("usp_Publish_InsUpd",
new SqlParameter("@name", publisher.Name),
new SqlParameter("@country", publisher.SelectedCountry),
new SqlParameter("@state", publisher.SelectedState),
new SqlParameter("@city", publisher.SelectedCity),
new SqlParameter("@category", publisher.SelectedCategory),
new SqlParameter("@statusId", publisher.StatusId),
new SqlParameter("@userId", publisher.UserId));
}
public void AddNews(News news)
{
_db.ExecuteProcedure("usp_News_InsUpd",
new SqlParameter("@title", news.Title),
new SqlParameter("@body", news.Body),
new SqlParameter("@publication", news.Publication),
new SqlParameter("@category", news.Category),
new SqlParameter("@bannerUrl", news.BannerUrl));
}
public void AddCategory(Category category)
{
_db.ExecuteProcedure("usp_Category_InsUpd",
new SqlParameter("@name", category.Name),
new SqlParameter("@statusId", category.StatusId));
}
