private static GroupNewsArticlesInfoData GetDataObjectFromReader(SqlDataReader dataReader)
{
GroupNewsArticlesInfoData data = new GroupNewsArticlesInfoData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupsID")))
{
data.OrgGroupsID = IntegerType.UNSET;
}
else
{
data.OrgGroupsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ArticleCount")))
{
data.ArticleCount = IntegerType.UNSET;
}
else
{
data.ArticleCount = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ArticleCount")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LastModified")))
{
data.LastModified = DateType.UNSET;
}
else
{
data.LastModified = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("LastModified")));
}
return(data);
}
public static void Insert(GroupNewsArticlesInfoData data)
{
// Create and execute the command
string sql = "Insert Into " + TABLE + "("
+ "OrgGroupsID,"
+ "ArticleCount,"
+ "LastModified,"
;
sql = sql.Substring(0, sql.Length - 1) + ") values("
+ "@OrgGroupsID,"
+ "@ArticleCount,"
+ "@LastModified,"
;
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("@OrgGroupsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupsID", DataRowVersion.Proposed, data.OrgGroupsID.DBValue));
cmd.Parameters.Add(new SqlParameter("@ArticleCount", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ArticleCount", DataRowVersion.Proposed, data.ArticleCount.DBValue));
cmd.Parameters.Add(new SqlParameter("@LastModified", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "LastModified", DataRowVersion.Proposed, data.LastModified.DBValue));
// Execute the query
cmd.ExecuteNonQuery();
}
public static GroupNewsArticlesInfoData 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 GroupNewsArticlesInfo.");
}
GroupNewsArticlesInfoData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
public static void Update(GroupNewsArticlesInfoData data)
{
// Create and execute the command
GroupNewsArticlesInfoData oldData = Load();
string sql = "Update " + TABLE + " set ";
if (!oldData.OrgGroupsID.Equals(data.OrgGroupsID))
{
sql = sql + "OrgGroupsID=@OrgGroupsID,";
}
if (!oldData.ArticleCount.Equals(data.ArticleCount))
{
sql = sql + "ArticleCount=@ArticleCount,";
}
if (!oldData.LastModified.Equals(data.LastModified))
{
sql = sql + "LastModified=@LastModified,";
}
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.OrgGroupsID.Equals(data.OrgGroupsID))
{
cmd.Parameters.Add(new SqlParameter("@OrgGroupsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupsID", DataRowVersion.Proposed, data.OrgGroupsID.DBValue));
}
if (!oldData.ArticleCount.Equals(data.ArticleCount))
{
cmd.Parameters.Add(new SqlParameter("@ArticleCount", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ArticleCount", DataRowVersion.Proposed, data.ArticleCount.DBValue));
}
if (!oldData.LastModified.Equals(data.LastModified))
{
cmd.Parameters.Add(new SqlParameter("@LastModified", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "LastModified", DataRowVersion.Proposed, data.LastModified.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
