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