private static CalendarsItemsLocationsData GetDataObjectFromReader(SqlDataReader dataReader) { CalendarsItemsLocationsData data = new CalendarsItemsLocationsData(); if (dataReader.IsDBNull(dataReader.GetOrdinal("CalendarsItemsLocationsID"))) { data.CalendarsItemsLocationsID = IdType.UNSET; } else { data.CalendarsItemsLocationsID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("CalendarsItemsLocationsID"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("CalendarsItemsID"))) { data.CalendarsItemsID = IntegerType.UNSET; } else { data.CalendarsItemsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("CalendarsItemsID"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgLocationsID"))) { data.OrgLocationsID = IntegerType.UNSET; } else { data.OrgLocationsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgLocationsID"))); } return(data); }
public static IdType Insert(CalendarsItemsLocationsData data) { // Create and execute the command string sql = "Insert Into " + TABLE + "(" + "CalendarsItemsID," + "OrgLocationsID," ; sql = sql.Substring(0, sql.Length - 1) + ") values(" + "@CalendarsItemsID," + "@OrgLocationsID," ; sql = sql.Substring(0, sql.Length - 1) + ");select Scope_Identity() Id"; 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("@CalendarsItemsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "CalendarsItemsID", DataRowVersion.Proposed, data.CalendarsItemsID.DBValue)); cmd.Parameters.Add(new SqlParameter("@OrgLocationsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgLocationsID", DataRowVersion.Proposed, data.OrgLocationsID.DBValue)); // Execute the query SqlDataReader returnValue = cmd.ExecuteReader(); returnValue.Read(); int returnId = (int)(returnValue.GetDecimal(0)); returnValue.Close(); // Set the output paramter value(s) return(new IdType(returnId)); }
public static CalendarsItemsLocationsData Load(IdType calendarsItemsLocationsID) { WhereClause w = new WhereClause(); w.And("CalendarsItemsLocationsID", calendarsItemsLocationsID.DBValue); SqlDataReader dataReader = GetListReader(DatabaseEnum.INTRANET, TABLE, w, null, true); if (!dataReader.Read()) { dataReader.Close(); throw new FinderException("Load found no rows for CalendarsItemsLocations."); } CalendarsItemsLocationsData data = GetDataObjectFromReader(dataReader); dataReader.Close(); return(data); }
public static void Update(CalendarsItemsLocationsData data) { // Create and execute the command CalendarsItemsLocationsData oldData = Load(data.CalendarsItemsLocationsID); string sql = "Update " + TABLE + " set "; if (!oldData.CalendarsItemsID.Equals(data.CalendarsItemsID)) { sql = sql + "CalendarsItemsID=@CalendarsItemsID,"; } if (!oldData.OrgLocationsID.Equals(data.OrgLocationsID)) { sql = sql + "OrgLocationsID=@OrgLocationsID,"; } WhereClause w = new WhereClause(); w.And("CalendarsItemsLocationsID", data.CalendarsItemsLocationsID.DBValue); 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.CalendarsItemsLocationsID.Equals(data.CalendarsItemsLocationsID)) { cmd.Parameters.Add(new SqlParameter("@CalendarsItemsLocationsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "CalendarsItemsLocationsID", DataRowVersion.Proposed, data.CalendarsItemsLocationsID.DBValue)); } if (!oldData.CalendarsItemsID.Equals(data.CalendarsItemsID)) { cmd.Parameters.Add(new SqlParameter("@CalendarsItemsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "CalendarsItemsID", DataRowVersion.Proposed, data.CalendarsItemsID.DBValue)); } if (!oldData.OrgLocationsID.Equals(data.OrgLocationsID)) { cmd.Parameters.Add(new SqlParameter("@OrgLocationsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgLocationsID", DataRowVersion.Proposed, data.OrgLocationsID.DBValue)); } // Execute the query if (cmd.Parameters.Count > 0) { cmd.ExecuteNonQuery(); } }