public static KnowledgebasesSectionsArticlesData Load(IdType knowledgebasesSectionsArticlesID)
{
WhereClause w = new WhereClause();
w.And("KnowledgebasesSectionsArticlesID", knowledgebasesSectionsArticlesID.DBValue);
SqlDataReader dataReader = GetListReader(DatabaseEnum.INTRANET, TABLE, w, null, true);
if (!dataReader.Read())
{
dataReader.Close();
throw new FinderException("Load found no rows for KnowledgebasesSectionsArticles.");
}
KnowledgebasesSectionsArticlesData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
public static void Update(KnowledgebasesSectionsArticlesData data)
{
// Create and execute the command
KnowledgebasesSectionsArticlesData oldData = Load(data.KnowledgebasesSectionsArticlesID);
string sql = "Update " + TABLE + " set ";
if (!oldData.Title.Equals(data.Title))
{
sql = sql + "Title=@Title,";
}
if (!oldData.DateStart.Equals(data.DateStart))
{
sql = sql + "DateStart=@DateStart,";
}
if (!oldData.DateEnd.Equals(data.DateEnd))
{
sql = sql + "DateEnd=@DateEnd,";
}
if (!oldData.ParentID.Equals(data.ParentID))
{
sql = sql + "ParentID=@ParentID,";
}
if (!oldData.KnowledgebasesID.Equals(data.KnowledgebasesID))
{
sql = sql + "KnowledgebasesID=@KnowledgebasesID,";
}
if (!oldData.HasChild.Equals(data.HasChild))
{
sql = sql + "HasChild=@HasChild,";
}
if (!oldData.PrevKnowledgebasesSectionsID.Equals(data.PrevKnowledgebasesSectionsID))
{
sql = sql + "PrevKnowledgebasesSectionsID=@PrevKnowledgebasesSectionsID,";
}
if (!oldData.NextKnowledgebasesSectionsID.Equals(data.NextKnowledgebasesSectionsID))
{
sql = sql + "NextKnowledgebasesSectionsID=@NextKnowledgebasesSectionsID,";
}
if (!oldData.ListInParentArticle.Equals(data.ListInParentArticle))
{
sql = sql + "ListInParentArticle=@ListInParentArticle,";
}
if (!oldData.IncludeSummaryinParent.Equals(data.IncludeSummaryinParent))
{
sql = sql + "IncludeSummaryinParent=@IncludeSummaryinParent,";
}
if (!oldData.Sort.Equals(data.Sort))
{
sql = sql + "Sort=@Sort,";
}
if (!oldData.IsSection.Equals(data.IsSection))
{
sql = sql + "IsSection=@IsSection,";
}
if (!oldData.IsTemp.Equals(data.IsTemp))
{
sql = sql + "IsTemp=@IsTemp,";
}
WhereClause w = new WhereClause();
w.And("KnowledgebasesSectionsArticlesID", data.KnowledgebasesSectionsArticlesID.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.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.DateStart.Equals(data.DateStart))
{
cmd.Parameters.Add(new SqlParameter("@DateStart", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateStart", DataRowVersion.Proposed, data.DateStart.DBValue));
}
if (!oldData.DateEnd.Equals(data.DateEnd))
{
cmd.Parameters.Add(new SqlParameter("@DateEnd", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateEnd", DataRowVersion.Proposed, data.DateEnd.DBValue));
}
if (!oldData.ParentID.Equals(data.ParentID))
{
cmd.Parameters.Add(new SqlParameter("@ParentID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ParentID", DataRowVersion.Proposed, data.ParentID.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.HasChild.Equals(data.HasChild))
{
cmd.Parameters.Add(new SqlParameter("@HasChild", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "HasChild", DataRowVersion.Proposed, !data.HasChild.IsValid ? data.HasChild.DBValue : data.HasChild.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.PrevKnowledgebasesSectionsID.Equals(data.PrevKnowledgebasesSectionsID))
{
cmd.Parameters.Add(new SqlParameter("@PrevKnowledgebasesSectionsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "PrevKnowledgebasesSectionsID", DataRowVersion.Proposed, data.PrevKnowledgebasesSectionsID.DBValue));
}
if (!oldData.NextKnowledgebasesSectionsID.Equals(data.NextKnowledgebasesSectionsID))
{
cmd.Parameters.Add(new SqlParameter("@NextKnowledgebasesSectionsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "NextKnowledgebasesSectionsID", DataRowVersion.Proposed, data.NextKnowledgebasesSectionsID.DBValue));
}
if (!oldData.ListInParentArticle.Equals(data.ListInParentArticle))
{
cmd.Parameters.Add(new SqlParameter("@ListInParentArticle", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "ListInParentArticle", DataRowVersion.Proposed, !data.ListInParentArticle.IsValid ? data.ListInParentArticle.DBValue : data.ListInParentArticle.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.IncludeSummaryinParent.Equals(data.IncludeSummaryinParent))
{
cmd.Parameters.Add(new SqlParameter("@IncludeSummaryinParent", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IncludeSummaryinParent", DataRowVersion.Proposed, !data.IncludeSummaryinParent.IsValid ? data.IncludeSummaryinParent.DBValue : data.IncludeSummaryinParent.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.Sort.Equals(data.Sort))
{
cmd.Parameters.Add(new SqlParameter("@Sort", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Sort", DataRowVersion.Proposed, data.Sort.DBValue));
}
if (!oldData.IsSection.Equals(data.IsSection))
{
cmd.Parameters.Add(new SqlParameter("@IsSection", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsSection", DataRowVersion.Proposed, !data.IsSection.IsValid ? data.IsSection.DBValue : data.IsSection.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.IsTemp.Equals(data.IsTemp))
{
cmd.Parameters.Add(new SqlParameter("@IsTemp", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsTemp", DataRowVersion.Proposed, !data.IsTemp.IsValid ? data.IsTemp.DBValue : data.IsTemp.DBValue.Equals("Y") ? 1 : 0));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static IdType Insert(KnowledgebasesSectionsArticlesData data)
{
// Create and execute the command
string sql = "Insert Into " + TABLE + "("
+ "Title,"
+ "DateStart,"
+ "DateEnd,"
+ "ParentID,"
+ "KnowledgebasesID,"
+ "HasChild,"
+ "PrevKnowledgebasesSectionsID,"
+ "NextKnowledgebasesSectionsID,"
+ "ListInParentArticle,"
+ "IncludeSummaryinParent,"
+ "Sort,"
+ "IsSection,"
+ "IsTemp,"
;
sql = sql.Substring(0, sql.Length - 1) + ") values("
+ "@Title,"
+ "@DateStart,"
+ "@DateEnd,"
+ "@ParentID,"
+ "@KnowledgebasesID,"
+ "@HasChild,"
+ "@PrevKnowledgebasesSectionsID,"
+ "@NextKnowledgebasesSectionsID,"
+ "@ListInParentArticle,"
+ "@IncludeSummaryinParent,"
+ "@Sort,"
+ "@IsSection,"
+ "@IsTemp,"
;
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("@Title", SqlDbType.VarChar, 250, ParameterDirection.Input, false, 0, 0, "Title", DataRowVersion.Proposed, data.Title.DBValue));
cmd.Parameters.Add(new SqlParameter("@DateStart", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateStart", DataRowVersion.Proposed, data.DateStart.DBValue));
cmd.Parameters.Add(new SqlParameter("@DateEnd", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateEnd", DataRowVersion.Proposed, data.DateEnd.DBValue));
cmd.Parameters.Add(new SqlParameter("@ParentID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ParentID", DataRowVersion.Proposed, data.ParentID.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("@HasChild", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "HasChild", DataRowVersion.Proposed, !data.HasChild.IsValid ? data.HasChild.DBValue : data.HasChild.DBValue.Equals("Y") ? 1 : 0));
cmd.Parameters.Add(new SqlParameter("@PrevKnowledgebasesSectionsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "PrevKnowledgebasesSectionsID", DataRowVersion.Proposed, data.PrevKnowledgebasesSectionsID.DBValue));
cmd.Parameters.Add(new SqlParameter("@NextKnowledgebasesSectionsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "NextKnowledgebasesSectionsID", DataRowVersion.Proposed, data.NextKnowledgebasesSectionsID.DBValue));
cmd.Parameters.Add(new SqlParameter("@ListInParentArticle", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "ListInParentArticle", DataRowVersion.Proposed, !data.ListInParentArticle.IsValid ? data.ListInParentArticle.DBValue : data.ListInParentArticle.DBValue.Equals("Y") ? 1 : 0));
cmd.Parameters.Add(new SqlParameter("@IncludeSummaryinParent", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IncludeSummaryinParent", DataRowVersion.Proposed, !data.IncludeSummaryinParent.IsValid ? data.IncludeSummaryinParent.DBValue : data.IncludeSummaryinParent.DBValue.Equals("Y") ? 1 : 0));
cmd.Parameters.Add(new SqlParameter("@Sort", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Sort", DataRowVersion.Proposed, data.Sort.DBValue));
cmd.Parameters.Add(new SqlParameter("@IsSection", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsSection", DataRowVersion.Proposed, !data.IsSection.IsValid ? data.IsSection.DBValue : data.IsSection.DBValue.Equals("Y") ? 1 : 0));
cmd.Parameters.Add(new SqlParameter("@IsTemp", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsTemp", DataRowVersion.Proposed, !data.IsTemp.IsValid ? data.IsTemp.DBValue : data.IsTemp.DBValue.Equals("Y") ? 1 : 0));
// 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));
}
private static KnowledgebasesSectionsArticlesData GetDataObjectFromReader(SqlDataReader dataReader)
{
KnowledgebasesSectionsArticlesData data = new KnowledgebasesSectionsArticlesData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("KnowledgebasesSectionsArticlesID")))
{
data.KnowledgebasesSectionsArticlesID = IdType.UNSET;
}
else
{
data.KnowledgebasesSectionsArticlesID = new IdType(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("DateStart")))
{
data.DateStart = DateType.UNSET;
}
else
{
data.DateStart = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateStart")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateEnd")))
{
data.DateEnd = DateType.UNSET;
}
else
{
data.DateEnd = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateEnd")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ParentID")))
{
data.ParentID = IntegerType.UNSET;
}
else
{
data.ParentID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ParentID")));
}
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("HasChild")))
{
data.HasChild = BooleanType.UNSET;
}
else
{
data.HasChild = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("HasChild")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("PrevKnowledgebasesSectionsID")))
{
data.PrevKnowledgebasesSectionsID = IntegerType.UNSET;
}
else
{
data.PrevKnowledgebasesSectionsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("PrevKnowledgebasesSectionsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("NextKnowledgebasesSectionsID")))
{
data.NextKnowledgebasesSectionsID = IntegerType.UNSET;
}
else
{
data.NextKnowledgebasesSectionsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("NextKnowledgebasesSectionsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ListInParentArticle")))
{
data.ListInParentArticle = BooleanType.UNSET;
}
else
{
data.ListInParentArticle = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("ListInParentArticle")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IncludeSummaryinParent")))
{
data.IncludeSummaryinParent = BooleanType.UNSET;
}
else
{
data.IncludeSummaryinParent = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IncludeSummaryinParent")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Sort")))
{
data.Sort = IntegerType.UNSET;
}
else
{
data.Sort = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Sort")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsSection")))
{
data.IsSection = BooleanType.UNSET;
}
else
{
data.IsSection = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsSection")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsTemp")))
{
data.IsTemp = BooleanType.UNSET;
}
else
{
data.IsTemp = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsTemp")));
}
return(data);
}
