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