public static void Insert(SeeAlsoKnowledgebasesSectionsArtclesData data) { // Create and execute the command string sql = "Insert Into " + TABLE + "(" + "KnowledgebasesSectionsArticlesID," + "Title," + "Id," + "SeeAlsoID," ; sql = sql.Substring(0, sql.Length - 1) + ") values(" + "@KnowledgebasesSectionsArticlesID," + "@Title," + "@Id," + "@SeeAlsoID," ; sql = sql.Substring(0, sql.Length - 1) + ")"; SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT); //Create the parameters and append them to the command object cmd.Parameters.Add(new SqlParameter("@KnowledgebasesSectionsArticlesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "KnowledgebasesSectionsArticlesID", DataRowVersion.Proposed, data.KnowledgebasesSectionsArticlesID.DBValue)); cmd.Parameters.Add(new SqlParameter("@Title", SqlDbType.VarChar, 250, ParameterDirection.Input, false, 0, 0, "Title", DataRowVersion.Proposed, data.Title.DBValue)); cmd.Parameters.Add(new SqlParameter("@Id", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Id", DataRowVersion.Proposed, data.Id.DBValue)); cmd.Parameters.Add(new SqlParameter("@SeeAlsoID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "SeeAlsoID", DataRowVersion.Proposed, data.SeeAlsoID.DBValue)); // Execute the query cmd.ExecuteNonQuery(); }
public static void Update(SeeAlsoKnowledgebasesSectionsArtclesData data) { // Create and execute the command SeeAlsoKnowledgebasesSectionsArtclesData oldData = Load(); string sql = "Update " + TABLE + " set "; if (!oldData.KnowledgebasesSectionsArticlesID.Equals(data.KnowledgebasesSectionsArticlesID)) { sql = sql + "KnowledgebasesSectionsArticlesID=@KnowledgebasesSectionsArticlesID,"; } if (!oldData.Title.Equals(data.Title)) { sql = sql + "Title=@Title,"; } if (!oldData.Id.Equals(data.Id)) { sql = sql + "Id=@Id,"; } if (!oldData.SeeAlsoID.Equals(data.SeeAlsoID)) { sql = sql + "SeeAlsoID=@SeeAlsoID,"; } WhereClause w = new WhereClause(); sql = sql.Substring(0, sql.Length - 1) + w.FormatSql(); SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT); //Create the parameters and append them to the command object if (!oldData.KnowledgebasesSectionsArticlesID.Equals(data.KnowledgebasesSectionsArticlesID)) { cmd.Parameters.Add(new SqlParameter("@KnowledgebasesSectionsArticlesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "KnowledgebasesSectionsArticlesID", DataRowVersion.Proposed, data.KnowledgebasesSectionsArticlesID.DBValue)); } if (!oldData.Title.Equals(data.Title)) { cmd.Parameters.Add(new SqlParameter("@Title", SqlDbType.VarChar, 250, ParameterDirection.Input, false, 0, 0, "Title", DataRowVersion.Proposed, data.Title.DBValue)); } if (!oldData.Id.Equals(data.Id)) { cmd.Parameters.Add(new SqlParameter("@Id", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Id", DataRowVersion.Proposed, data.Id.DBValue)); } if (!oldData.SeeAlsoID.Equals(data.SeeAlsoID)) { cmd.Parameters.Add(new SqlParameter("@SeeAlsoID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "SeeAlsoID", DataRowVersion.Proposed, data.SeeAlsoID.DBValue)); } // Execute the query if (cmd.Parameters.Count > 0) { cmd.ExecuteNonQuery(); } }
public static SeeAlsoKnowledgebasesSectionsArtclesData Load() { WhereClause w = new WhereClause(); SqlDataReader dataReader = GetListReader(DatabaseEnum.INTRANET, TABLE, w, null, true); if (!dataReader.Read()) { dataReader.Close(); throw new FinderException("Load found no rows for SeeAlsoKnowledgebasesSectionsArtcles."); } SeeAlsoKnowledgebasesSectionsArtclesData data = GetDataObjectFromReader(dataReader); dataReader.Close(); return(data); }
private static SeeAlsoKnowledgebasesSectionsArtclesData GetDataObjectFromReader(SqlDataReader dataReader) { SeeAlsoKnowledgebasesSectionsArtclesData data = new SeeAlsoKnowledgebasesSectionsArtclesData(); if (dataReader.IsDBNull(dataReader.GetOrdinal("KnowledgebasesSectionsArticlesID"))) { data.KnowledgebasesSectionsArticlesID = IntegerType.UNSET; } else { data.KnowledgebasesSectionsArticlesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("KnowledgebasesSectionsArticlesID"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Title"))) { data.Title = StringType.UNSET; } else { data.Title = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Title"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Id"))) { data.Id = IntegerType.UNSET; } else { data.Id = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Id"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("SeeAlsoID"))) { data.SeeAlsoID = IntegerType.UNSET; } else { data.SeeAlsoID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("SeeAlsoID"))); } return(data); }