public void Update(Post obj)
{
var procedure = new ProcedureSql("Update_Post");
procedure.AddParameter("@Id", obj.Id);
procedure.AddParameter("@AuthorId", obj.Author.Id);
procedure.AddParameter("@Title", obj.Title);
procedure.AddParameter("@Body", obj.Body);
procedure.AddParameter("@IsPublished", obj.IsPublished);
// 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);
procedure.Execute();
}
public void Delete(int id)
{
var procedure = new ProcedureSql("Update_Post");
procedure.AddParameter("@Id", id);
procedure.Execute();
}
public void Delete(int id)
{
var procedure = new ProcedureSql("Delete_Category");
procedure.AddParameter("@Id", id);
procedure.Execute();
}
public void Update(Post obj)
{
var procedure = new ProcedureSql("Update_Post");
procedure.AddParameter("@Id", obj.Id);
procedure.AddParameter("@AuthorId", obj.Author.Id);
procedure.AddParameter("@Title", obj.Title);
procedure.AddParameter("@Body", obj.Body);
procedure.AddParameter("@IsPublished", obj.IsPublished);
// 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);
procedure.Execute();
}
public IEnumerable <Category> GetByPostId(int postId)
{
var procedure = new ProcedureSql("List_Category_By_PostId");
procedure.AddParameter("@PostId", postId);
return(procedure.GetList <Category>(FillCategory));
}
public Author GetByName(string name)
{
var procedure = new ProcedureSql("Get_Author_By_Name");
procedure.AddParameter("@Name", name);
return procedure.Get<Author>(this.FillAuthor);
}
public Author GetById(int id)
{
var procedure = new ProcedureSql("Get_Author_By_Id");
procedure.AddParameter("@Id", id);
return procedure.Get<Author>(this.FillAuthor);
}
public PagedList<Comment> GetByPostId(int postId, int pageNumber = 1, int pageSize = 50)
{
var procedure = new ProcedureSql("List_Comment_By_PostId");
procedure.AddParameter("@PostId", postId);
return procedure.GetPagedList<Comment>(this.FillComment, pageNumber, pageSize);
}
public Author GetById(int id)
{
var procedure = new ProcedureSql("Get_Author_By_Id");
procedure.AddParameter("@Id", id);
return(procedure.Get <Author>(this.FillAuthor));
}
public Comment GetById(int id)
{
var procedure = new ProcedureSql("Get_Comment_By_Id");
procedure.AddParameter("@Id", id);
return(procedure.Get <Comment>(FillComment));
}
public Post GetById(int id)
{
var procedure = new ProcedureSql("Get_Post_By_Id");
procedure.AddParameter("@Id", id);
return procedure.Get<Post>(this.FillPost);
}
public PagedList <Comment> GetByPostId(int postId, int pageNumber = 1, int pageSize = 50)
{
var procedure = new ProcedureSql("List_Comment_By_PostId");
procedure.AddParameter("@PostId", postId);
return(procedure.GetPagedList <Comment>(this.FillComment, pageNumber, pageSize));
}
public Post GetById(int id)
{
var procedure = new ProcedureSql("Get_Post_By_Id");
procedure.AddParameter("@Id", id);
return(procedure.Get <Post>(this.FillPost));
}
public Category GetById(int id)
{
var procedure = new ProcedureSql("Get_Category_By_Id");
procedure.AddParameter("@Id", id);
return(procedure.Get <Category>(this.FillCategory));
}
public Comment GetById(int id)
{
var procedure = new ProcedureSql("Get_Comment_By_Id");
procedure.AddParameter("@Id", id);
return procedure.Get<Comment>(FillComment);
}
public Category GetById(int id)
{
var procedure = new ProcedureSql("Get_Category_By_Id");
procedure.AddParameter("@Id", id);
return procedure.Get<Category>(this.FillCategory);
}
public void Delete(int id)
{
var procedure = new ProcedureSql("Delete_Comment");
procedure.AddParameter("@Id", id);
procedure.Execute();
}
public Author GetByName(string name)
{
var procedure = new ProcedureSql("Get_Author_By_Name");
procedure.AddParameter("@Name", name);
return(procedure.Get <Author>(this.FillAuthor));
}
public void Update(Category obj)
{
var procedure = new ProcedureSql("Update_Category");
procedure.AddParameter("@Id", obj.Id);
procedure.AddParameter("@Name", obj.Name);
procedure.Execute();
}
public void Update(Category obj)
{
var procedure = new ProcedureSql("Update_Category");
procedure.AddParameter("@Id", obj.Id);
procedure.AddParameter("@Name", obj.Name);
procedure.Execute();
}
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 Update(Author obj)
{
var procedure = new ProcedureSql("Update_Author");
procedure.AddParameter("@Id", obj.Id);
procedure.AddParameter("@Name", obj.Name);
procedure.AddParameter("@Email", obj.Email);
procedure.AddParameter("@Password", obj.Password);
procedure.AddParameter("@IsActive", obj.IsActive);
procedure.Execute();
}
public void Update(Author obj)
{
var procedure = new ProcedureSql("Update_Author");
procedure.AddParameter("@Id", obj.Id);
procedure.AddParameter("@Name", obj.Name);
procedure.AddParameter("@Email", obj.Email);
procedure.AddParameter("@Password", obj.Password);
procedure.AddParameter("@IsActive", obj.IsActive);
procedure.Execute();
}
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 Update(Comment obj)
{
var procedure = new ProcedureSql("Update_Comment");
procedure.AddParameter("@Id", obj.Id);
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);
procedure.Execute();
}
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 Update(Comment obj)
{
var procedure = new ProcedureSql("Update_Comment");
procedure.AddParameter("@Id", obj.Id);
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);
procedure.Execute();
}
public PagedList<Post> GetAll(int pageNumber = 1, int pageSize = 50)
{
var procedure = new ProcedureSql("List_Post");
return procedure.GetPagedList<Post>(this.FillPost, pageNumber, pageSize);
}
public void Delete(int id)
{
var procedure = new ProcedureSql("Update_Post");
procedure.AddParameter("@Id", id);
procedure.Execute();
}
public IEnumerable<Category> GetAll()
{
var procedure = new ProcedureSql("List_Category");
return procedure.GetList<Category>(FillCategory);
}
public IEnumerable <Category> GetAll()
{
var procedure = new ProcedureSql("List_Category");
return(procedure.GetList <Category>(FillCategory));
}
public IEnumerable<Category> GetByPostId(int postId)
{
var procedure = new ProcedureSql("List_Category_By_PostId");
procedure.AddParameter("@PostId", postId);
return procedure.GetList<Category>(FillCategory);
}
public PagedList <Post> GetAll(int pageNumber = 1, int pageSize = 50)
{
var procedure = new ProcedureSql("List_Post");
return(procedure.GetPagedList <Post>(this.FillPost, pageNumber, pageSize));
}
public IEnumerable<Author> GetAll()
{
var procedure = new ProcedureSql("List_Author");
return procedure.GetList<Author>(this.FillAuthor);
}
public IEnumerable <Author> GetAll()
{
var procedure = new ProcedureSql("List_Author");
return(procedure.GetList <Author>(this.FillAuthor));
}
