public void Add(Post obj)
{
var procedure = new ProcedureSql("Add_Post");
procedure.AddParameter("@Id", SqlDbType.Int, ParameterDirection.Output);
procedure.AddParameter("@AuthorId", obj.Author.Id);
procedure.AddParameter("@Title", obj.Title);
procedure.AddParameter("@Body", obj.Body);
procedure.AddParameter("@IsPublished", obj.IsPublished);
procedure.AddParameter("@DateCreated", obj.DateCreated);
// Sql Server 2008 compatible
// http://www.mssqltips.com/sqlservertip/2112/table-value-parameters-in-sql-server-2008-and-net-c/
var categories = new DataTable();
categories.Columns.Add("Id", typeof(Int32));
if (obj.Categories != null)
{
foreach (Category category in obj.Categories)
{
categories.Rows.Add(category.Id);
}
}
procedure.AddParameter("@Categories", categories, SqlDbType.Structured);
obj.Id = procedure.Insert();
}
public void Add(Post obj)
{
var procedure = new ProcedureSql("Add_Post");
procedure.AddParameter("@Id", SqlDbType.Int, ParameterDirection.Output);
procedure.AddParameter("@AuthorId", obj.Author.Id);
procedure.AddParameter("@Title", obj.Title);
procedure.AddParameter("@Body", obj.Body);
procedure.AddParameter("@IsPublished", obj.IsPublished);
procedure.AddParameter("@DateCreated", obj.DateCreated);
// Sql Server 2008 compatible
// http://www.mssqltips.com/sqlservertip/2112/table-value-parameters-in-sql-server-2008-and-net-c/
var categories = new DataTable();
categories.Columns.Add("Id", typeof(Int32));
if (obj.Categories != null)
{
foreach (Category category in obj.Categories)
{
categories.Rows.Add(category.Id);
}
}
procedure.AddParameter("@Categories", categories, SqlDbType.Structured);
obj.Id = procedure.Insert();
}
public void Add(Category obj)
{
var procedure = new ProcedureSql("Add_Category");
procedure.AddParameter("@Id", SqlDbType.Int, ParameterDirection.Output);
procedure.AddParameter("@Name", obj.Name);
procedure.AddParameter("@DateCreated", obj.DateCreated);
obj.Id = procedure.Insert();
}
public void Add(Category obj)
{
var procedure = new ProcedureSql("Add_Category");
procedure.AddParameter("@Id", SqlDbType.Int, ParameterDirection.Output);
procedure.AddParameter("@Name", obj.Name);
procedure.AddParameter("@DateCreated", obj.DateCreated);
obj.Id = procedure.Insert();
}
public void Add(Author obj)
{
var procedure = new ProcedureSql("Add_Author");
procedure.AddParameter("@Id", SqlDbType.Int, ParameterDirection.Output);
procedure.AddParameter("@Name", obj.Name);
procedure.AddParameter("@Email", obj.Email);
procedure.AddParameter("@Password", obj.Password);
procedure.AddParameter("@IsActive", obj.IsActive);
procedure.AddParameter("@DateCreated", obj.DateCreated);
obj.Id = procedure.Insert();
}
public void Add(Author obj)
{
var procedure = new ProcedureSql("Add_Author");
procedure.AddParameter("@Id", SqlDbType.Int, ParameterDirection.Output);
procedure.AddParameter("@Name", obj.Name);
procedure.AddParameter("@Email", obj.Email);
procedure.AddParameter("@Password", obj.Password);
procedure.AddParameter("@IsActive", obj.IsActive);
procedure.AddParameter("@DateCreated", obj.DateCreated);
obj.Id = procedure.Insert();
}
public void Add(Comment obj)
{
var procedure = new ProcedureSql("Add_Comment");
procedure.AddParameter("@Id", SqlDbType.Int, ParameterDirection.Output);
procedure.AddParameter("@PostId", obj.PostId);
procedure.AddParameter("@Name", obj.Name);
procedure.AddParameter("@Email", obj.Email);
procedure.AddParameter("@Url", obj.Url);
procedure.AddParameter("@Body", obj.Body);
procedure.AddParameter("@Status", obj.Status);
procedure.AddParameter("@DateCreated", obj.DateCreated);
obj.Id = procedure.Insert();
}
public void Add(Comment obj)
{
var procedure = new ProcedureSql("Add_Comment");
procedure.AddParameter("@Id", SqlDbType.Int, ParameterDirection.Output);
procedure.AddParameter("@PostId", obj.PostId);
procedure.AddParameter("@Name", obj.Name);
procedure.AddParameter("@Email", obj.Email);
procedure.AddParameter("@Url", obj.Url);
procedure.AddParameter("@Body", obj.Body);
procedure.AddParameter("@Status", obj.Status);
procedure.AddParameter("@DateCreated", obj.DateCreated);
obj.Id = procedure.Insert();
}