public static OtherGroupsKnowledgebasesData 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 OtherGroupsKnowledgebases.");
}
OtherGroupsKnowledgebasesData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
public static void Insert(OtherGroupsKnowledgebasesData data)
{
// Create and execute the command
string sql = "Insert Into " + TABLE + "("
+ "KnowledgebasesID,"
+ "SubscriptionID,"
+ "Description,"
+ "IsPublic,"
+ "GroupDescription,"
+ "ArticlesCount,"
+ "OrgGroupID,"
;
sql = sql.Substring(0, sql.Length - 1) + ") values("
+ "@KnowledgebasesID,"
+ "@SubscriptionID,"
+ "@Description,"
+ "@IsPublic,"
+ "@GroupDescription,"
+ "@ArticlesCount,"
+ "@OrgGroupID,"
;
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("@KnowledgebasesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "KnowledgebasesID", DataRowVersion.Proposed, data.KnowledgebasesID.DBValue));
cmd.Parameters.Add(new SqlParameter("@SubscriptionID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "SubscriptionID", DataRowVersion.Proposed, data.SubscriptionID.DBValue));
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 150, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
cmd.Parameters.Add(new SqlParameter("@IsPublic", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsPublic", DataRowVersion.Proposed, !data.IsPublic.IsValid ? data.IsPublic.DBValue : data.IsPublic.DBValue.Equals("Y") ? 1 : 0));
cmd.Parameters.Add(new SqlParameter("@GroupDescription", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "GroupDescription", DataRowVersion.Proposed, data.GroupDescription.DBValue));
cmd.Parameters.Add(new SqlParameter("@ArticlesCount", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ArticlesCount", DataRowVersion.Proposed, data.ArticlesCount.DBValue));
cmd.Parameters.Add(new SqlParameter("@OrgGroupID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupID", DataRowVersion.Proposed, data.OrgGroupID.DBValue));
// Execute the query
cmd.ExecuteNonQuery();
}
public static void Update(OtherGroupsKnowledgebasesData data)
{
// Create and execute the command
OtherGroupsKnowledgebasesData oldData = Load();
string sql = "Update " + TABLE + " set ";
if (!oldData.KnowledgebasesID.Equals(data.KnowledgebasesID))
{
sql = sql + "KnowledgebasesID=@KnowledgebasesID,";
}
if (!oldData.SubscriptionID.Equals(data.SubscriptionID))
{
sql = sql + "SubscriptionID=@SubscriptionID,";
}
if (!oldData.Description.Equals(data.Description))
{
sql = sql + "Description=@Description,";
}
if (!oldData.IsPublic.Equals(data.IsPublic))
{
sql = sql + "IsPublic=@IsPublic,";
}
if (!oldData.GroupDescription.Equals(data.GroupDescription))
{
sql = sql + "GroupDescription=@GroupDescription,";
}
if (!oldData.ArticlesCount.Equals(data.ArticlesCount))
{
sql = sql + "ArticlesCount=@ArticlesCount,";
}
if (!oldData.OrgGroupID.Equals(data.OrgGroupID))
{
sql = sql + "OrgGroupID=@OrgGroupID,";
}
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.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.SubscriptionID.Equals(data.SubscriptionID))
{
cmd.Parameters.Add(new SqlParameter("@SubscriptionID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "SubscriptionID", DataRowVersion.Proposed, data.SubscriptionID.DBValue));
}
if (!oldData.Description.Equals(data.Description))
{
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 150, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
}
if (!oldData.IsPublic.Equals(data.IsPublic))
{
cmd.Parameters.Add(new SqlParameter("@IsPublic", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsPublic", DataRowVersion.Proposed, !data.IsPublic.IsValid ? data.IsPublic.DBValue : data.IsPublic.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.GroupDescription.Equals(data.GroupDescription))
{
cmd.Parameters.Add(new SqlParameter("@GroupDescription", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "GroupDescription", DataRowVersion.Proposed, data.GroupDescription.DBValue));
}
if (!oldData.ArticlesCount.Equals(data.ArticlesCount))
{
cmd.Parameters.Add(new SqlParameter("@ArticlesCount", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ArticlesCount", DataRowVersion.Proposed, data.ArticlesCount.DBValue));
}
if (!oldData.OrgGroupID.Equals(data.OrgGroupID))
{
cmd.Parameters.Add(new SqlParameter("@OrgGroupID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupID", DataRowVersion.Proposed, data.OrgGroupID.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
private static OtherGroupsKnowledgebasesData GetDataObjectFromReader(SqlDataReader dataReader)
{
OtherGroupsKnowledgebasesData data = new OtherGroupsKnowledgebasesData();
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("SubscriptionID")))
{
data.SubscriptionID = IntegerType.UNSET;
}
else
{
data.SubscriptionID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("SubscriptionID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Description")))
{
data.Description = StringType.UNSET;
}
else
{
data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsPublic")))
{
data.IsPublic = BooleanType.UNSET;
}
else
{
data.IsPublic = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsPublic")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("GroupDescription")))
{
data.GroupDescription = StringType.UNSET;
}
else
{
data.GroupDescription = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("GroupDescription")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ArticlesCount")))
{
data.ArticlesCount = IntegerType.UNSET;
}
else
{
data.ArticlesCount = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ArticlesCount")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupID")))
{
data.OrgGroupID = IntegerType.UNSET;
}
else
{
data.OrgGroupID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupID")));
}
return(data);
}
