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(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(); }