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