public static IdType Insert(SessionInformationData data)
{
// Create and execute the command
data = PrepareForInsert(data);
string sql = "Insert Into " + TABLE + "("
+ "SessionId,"
+ "DemoId,"
+ "UserId,"
+ "DateCreated,"
;
sql = sql.Substring(0, sql.Length - 1) + ") values("
+ "@SessionId,"
+ "@DemoId,"
+ "@UserId,"
+ "@DateCreated,"
;
sql = sql.Substring(0, sql.Length - 1) + ")";
SqlCommand cmd = GetSqlCommand(DatabaseEnum.ORDERDB, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
cmd.Parameters.Add(new SqlParameter("@SessionId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "SessionId", DataRowVersion.Proposed, data.SessionId.DBValue));
cmd.Parameters.Add(new SqlParameter("@DemoId", SqlDbType.Char, 7, ParameterDirection.Input, false, 0, 0, "DemoId", DataRowVersion.Proposed, data.DemoId.DBValue));
cmd.Parameters.Add(new SqlParameter("@UserId", SqlDbType.Char, 15, ParameterDirection.Input, false, 0, 0, "UserId", DataRowVersion.Proposed, data.UserId.DBValue));
cmd.Parameters.Add(new SqlParameter("@DateCreated", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateCreated", DataRowVersion.Proposed, data.DateCreated.DBValue));
// Execute the query
cmd.ExecuteNonQuery();
// Return field designated
return(data.SessionId);
}
public static void Update(SessionInformationData data)
{
// Create and execute the command
SessionInformationData oldData = Load(data.SessionId);
string sql = "Update " + TABLE + " set ";
if (!oldData.SessionId.Equals(data.SessionId))
{
sql = sql + "SessionId=@SessionId,";
}
if (!oldData.DemoId.Equals(data.DemoId))
{
sql = sql + "DemoId=@DemoId,";
}
if (!oldData.UserId.Equals(data.UserId))
{
sql = sql + "UserId=@UserId,";
}
if (!oldData.DateCreated.Equals(data.DateCreated))
{
sql = sql + "DateCreated=@DateCreated,";
}
WhereClause w = new WhereClause();
w.And("SessionId", data.SessionId.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.ORDERDB, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.SessionId.Equals(data.SessionId))
{
cmd.Parameters.Add(new SqlParameter("@SessionId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "SessionId", DataRowVersion.Proposed, data.SessionId.DBValue));
}
if (!oldData.DemoId.Equals(data.DemoId))
{
cmd.Parameters.Add(new SqlParameter("@DemoId", SqlDbType.Char, 7, ParameterDirection.Input, false, 0, 0, "DemoId", DataRowVersion.Proposed, data.DemoId.DBValue));
}
if (!oldData.UserId.Equals(data.UserId))
{
cmd.Parameters.Add(new SqlParameter("@UserId", SqlDbType.Char, 15, ParameterDirection.Input, false, 0, 0, "UserId", DataRowVersion.Proposed, data.UserId.DBValue));
}
if (!oldData.DateCreated.Equals(data.DateCreated))
{
cmd.Parameters.Add(new SqlParameter("@DateCreated", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateCreated", DataRowVersion.Proposed, data.DateCreated.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static SessionInformationData Load(IdType sessionId)
{
WhereClause w = new WhereClause();
w.And("SessionId", sessionId.DBValue);
SqlDataReader dataReader = GetListReader(DatabaseEnum.ORDERDB, TABLE, w, null, true);
if (!dataReader.Read())
{
dataReader.Close();
throw new FinderException("Load found no rows for SessionInformation.");
}
SessionInformationData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
private static SessionInformationData GetDataObjectFromReader(SqlDataReader dataReader)
{
SessionInformationData data = new SessionInformationData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("SessionId")))
{
data.SessionId = IdType.UNSET;
}
else
{
data.SessionId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("SessionId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DemoId")))
{
data.DemoId = DemoIdType.UNSET;
}
else
{
data.DemoId = DemoIdType.Parse(dataReader.GetString(dataReader.GetOrdinal("DemoId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("UserId")))
{
data.UserId = StringType.UNSET;
}
else
{
data.UserId = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("UserId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateCreated")))
{
data.DateCreated = DateType.UNSET;
}
else
{
data.DateCreated = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateCreated")));
}
return(data);
}
private static SessionInformationData PrepareForInsert(SessionInformationData data)
{
return(data);
}
