public int Insert(Category entity)
{
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("Name", entity.Name),
new SqlParameter("MetaTitle", FormatValue.ConvertToLink(entity.Name)),
new SqlParameter("Image", entity.Image)
};
return(db.Database.SqlQuery <int>("uspInsertCategory @Name, @MetaTitle, @Image", sqlParameters).SingleOrDefault());
}
public int Insert(Publisher entity)
{
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("Name", entity.Name),
new SqlParameter("MetaTitle", FormatValue.ConvertToLink(entity.Name)),
new SqlParameter("Address", entity.Address != null ? entity.Address : DBNull.Value.ToString()),
new SqlParameter("Phone", entity.Phone != null ? entity.Phone : DBNull.Value.ToString()),
new SqlParameter("Email", entity.Email != null ? entity.Email : DBNull.Value.ToString())
};
return(db.Database.ExecuteSqlCommand("uspInsertPublisher @Name, @MetaTitle, @Address, @Phone, @Email", sqlParameters));
}
public int Insert(Book model)
{
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("Title", model.Title),
new SqlParameter("MetaTitle", FormatValue.ConvertToLink(model.Title)),
new SqlParameter("Image", model.Image),
new SqlParameter("Authors", model.Authors),
new SqlParameter("CategoryId", model.CategoryId),
new SqlParameter("PublisherId", model.PublisherId),
new SqlParameter("Quantity", model.Quantity),
new SqlParameter("PageNumber", model.PageNumber),
new SqlParameter("Size", model.Size),
new SqlParameter("Weight", model.Weight),
new SqlParameter("PublishYear", model.PublishYear),
new SqlParameter("Description", model.Description == null ? DBNull.Value.ToString() : model.Description),
new SqlParameter("Status", model.Status),
};
return(db.Database.SqlQuery <int>("uspInsertBook @Title, @MetaTitle, @Image, @Authors, @CategoryId, @PublisherId, @Quantity, @PageNumber, @Size, @Weight, @PublishYear, @Description, @Status", sqlParameters).SingleOrDefault());
}
