public static int CreateCategory(string categoryName)
{
ProductCategoryModel data = new ProductCategoryModel
{
CategoryName = categoryName
};
string sql = @"insert into dbo.Category(CategoryName) values (@CategoryName); SELECT CAST(SCOPE_IDENTITY() as int)";
return(SqlDataAccess.SaveDataGiveID(sql, data));
}
public static int CreateProduct(string productName, int categoryId, string description, int price, DateTime date, string urlLink)
{
ProductModel data = new ProductModel
{
ProductName = productName,
CategoryId = categoryId,
Description = description,
ProductPrice = price,
Date = date,
UrlLink = urlLink
};
string sql = @"insert into dbo.Products(ProductName, CategoryId, Description, ProductPrice, Published, UrlLink)
values (@ProductName, @CategoryId, @Description, @ProductPrice, @Date, @UrlLink); SELECT CAST(SCOPE_IDENTITY() as int)";
return(SqlDataAccess.SaveDataGiveID(sql, data));
}