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