public static KnowledgebasesArticleTextData Load(IdType knowledgebasesArticlesTextID)
{
WhereClause w = new WhereClause();
w.And("KnowledgebasesArticlesTextID", knowledgebasesArticlesTextID.DBValue);
SqlDataReader dataReader = GetListReader(DatabaseEnum.INTRANET, TABLE, w, null, true);
if (!dataReader.Read())
{
dataReader.Close();
throw new FinderException("Load found no rows for KnowledgebasesArticleText.");
}
KnowledgebasesArticleTextData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
public static IdType Insert(KnowledgebasesArticleTextData data)
{
// Create and execute the command
string sql = "Insert Into " + TABLE + "("
+ "KnowledgebasesSectionsArticlesID,"
+ "KnowledgebasesID,"
+ "Text,"
+ "StartDate,"
+ "EndDate,"
+ "Keywords,"
;
sql = sql.Substring(0, sql.Length - 1) + ") values("
+ "@KnowledgebasesSectionsArticlesID,"
+ "@KnowledgebasesID,"
+ "@Text,"
+ "@StartDate,"
+ "@EndDate,"
+ "@Keywords,"
;
sql = sql.Substring(0, sql.Length - 1) + ");select Scope_Identity() Id";
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("@KnowledgebasesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "KnowledgebasesID", DataRowVersion.Proposed, data.KnowledgebasesID.DBValue));
cmd.Parameters.Add(new SqlParameter("@Text", SqlDbType.Text, 0, ParameterDirection.Input, false, 0, 0, "Text", DataRowVersion.Proposed, data.Text.DBValue));
cmd.Parameters.Add(new SqlParameter("@StartDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "StartDate", DataRowVersion.Proposed, data.StartDate.DBValue));
cmd.Parameters.Add(new SqlParameter("@EndDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "EndDate", DataRowVersion.Proposed, data.EndDate.DBValue));
cmd.Parameters.Add(new SqlParameter("@Keywords", SqlDbType.VarChar, 300, ParameterDirection.Input, false, 0, 0, "Keywords", DataRowVersion.Proposed, data.Keywords.DBValue));
// Execute the query
SqlDataReader returnValue = cmd.ExecuteReader();
returnValue.Read();
int returnId = (int)(returnValue.GetDecimal(0));
returnValue.Close();
// Set the output paramter value(s)
return(new IdType(returnId));
}
public static void Update(KnowledgebasesArticleTextData data)
{
// Create and execute the command
KnowledgebasesArticleTextData oldData = Load(data.KnowledgebasesArticlesTextID);
string sql = "Update " + TABLE + " set ";
if (!oldData.KnowledgebasesSectionsArticlesID.Equals(data.KnowledgebasesSectionsArticlesID))
{
sql = sql + "KnowledgebasesSectionsArticlesID=@KnowledgebasesSectionsArticlesID,";
}
if (!oldData.KnowledgebasesID.Equals(data.KnowledgebasesID))
{
sql = sql + "KnowledgebasesID=@KnowledgebasesID,";
}
if (!oldData.Text.Equals(data.Text))
{
sql = sql + "Text=@Text,";
}
if (!oldData.StartDate.Equals(data.StartDate))
{
sql = sql + "StartDate=@StartDate,";
}
if (!oldData.EndDate.Equals(data.EndDate))
{
sql = sql + "EndDate=@EndDate,";
}
if (!oldData.Keywords.Equals(data.Keywords))
{
sql = sql + "Keywords=@Keywords,";
}
WhereClause w = new WhereClause();
w.And("KnowledgebasesArticlesTextID", data.KnowledgebasesArticlesTextID.DBValue);
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.KnowledgebasesArticlesTextID.Equals(data.KnowledgebasesArticlesTextID))
{
cmd.Parameters.Add(new SqlParameter("@KnowledgebasesArticlesTextID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "KnowledgebasesArticlesTextID", DataRowVersion.Proposed, data.KnowledgebasesArticlesTextID.DBValue));
}
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.KnowledgebasesID.Equals(data.KnowledgebasesID))
{
cmd.Parameters.Add(new SqlParameter("@KnowledgebasesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "KnowledgebasesID", DataRowVersion.Proposed, data.KnowledgebasesID.DBValue));
}
if (!oldData.Text.Equals(data.Text))
{
cmd.Parameters.Add(new SqlParameter("@Text", SqlDbType.Text, 0, ParameterDirection.Input, false, 0, 0, "Text", DataRowVersion.Proposed, data.Text.DBValue));
}
if (!oldData.StartDate.Equals(data.StartDate))
{
cmd.Parameters.Add(new SqlParameter("@StartDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "StartDate", DataRowVersion.Proposed, data.StartDate.DBValue));
}
if (!oldData.EndDate.Equals(data.EndDate))
{
cmd.Parameters.Add(new SqlParameter("@EndDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "EndDate", DataRowVersion.Proposed, data.EndDate.DBValue));
}
if (!oldData.Keywords.Equals(data.Keywords))
{
cmd.Parameters.Add(new SqlParameter("@Keywords", SqlDbType.VarChar, 300, ParameterDirection.Input, false, 0, 0, "Keywords", DataRowVersion.Proposed, data.Keywords.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
private static KnowledgebasesArticleTextData GetDataObjectFromReader(SqlDataReader dataReader)
{
KnowledgebasesArticleTextData data = new KnowledgebasesArticleTextData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("KnowledgebasesArticlesTextID")))
{
data.KnowledgebasesArticlesTextID = IdType.UNSET;
}
else
{
data.KnowledgebasesArticlesTextID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("KnowledgebasesArticlesTextID")));
}
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("KnowledgebasesID")))
{
data.KnowledgebasesID = IntegerType.UNSET;
}
else
{
data.KnowledgebasesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("KnowledgebasesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Text")))
{
data.Text = StringType.UNSET;
}
else
{
data.Text = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Text")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("StartDate")))
{
data.StartDate = DateType.UNSET;
}
else
{
data.StartDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("StartDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EndDate")))
{
data.EndDate = DateType.UNSET;
}
else
{
data.EndDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("EndDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Keywords")))
{
data.Keywords = StringType.UNSET;
}
else
{
data.Keywords = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Keywords")));
}
return(data);
}
