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