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