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 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 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 Category GetById(int id) { var procedure = new ProcedureSql("Get_Category_By_Id"); procedure.AddParameter("@Id", id); return procedure.Get<Category>(this.FillCategory); }
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 Comment GetById(int id) { var procedure = new ProcedureSql("Get_Comment_By_Id"); procedure.AddParameter("@Id", id); return procedure.Get<Comment>(FillComment); }
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 void Delete(int id) { var procedure = new ProcedureSql("Delete_Comment"); procedure.AddParameter("@Id", id); procedure.Execute(); }
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 Comment GetById(int id) { var procedure = new ProcedureSql("Get_Comment_By_Id"); procedure.AddParameter("@Id", id); return(procedure.Get <Comment>(FillComment)); }
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(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(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 Delete(int id) { var procedure = new ProcedureSql("Update_Post"); procedure.AddParameter("@Id", id); 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); }