/// <summary>
/// Saves a record to the ticket_registration table.
/// </summary>
public virtual void Insert(TicketregistrationInfo ticketregistrationInfo)
{
try
{
new TicketregistrationTFM().Insert(ticketregistrationInfo);
}
catch (Exception ex)
{
//Provider.Log.Error(ex, "TFM.Biz.Implements.Ticketregistration - Insert" + ex.Message);
throw;
}
}
/// <summary>
/// Saves a record to the ticket_registration table.
/// </summary>
public virtual void Insert(TicketregistrationInfo ticketregistrationInfo)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ticketid", ticketregistrationInfo.Ticketid),
new SqlParameter("@number_plate", ticketregistrationInfo.Number_plate),
new SqlParameter("@ticket_type", ticketregistrationInfo.Ticket_type),
new SqlParameter("@start_date", ticketregistrationInfo.Start_date),
new SqlParameter("@end_date", ticketregistrationInfo.End_date),
new SqlParameter("@station", ticketregistrationInfo.Station)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "ticket_registration_Insert", parameters);
}
/// <summary>
/// Creates a new instance of the ticket_registration class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual TicketregistrationInfo MakeTicketregistrationInfo(SqlDataReader dataReader)
{
TicketregistrationInfo ticketregistrationInfo = new TicketregistrationInfo();
ticketregistrationInfo.Ticketid = SqlClientUtility.GetInt32(dataReader,DbConstants.TICKET_REGISTRATION.TICKETID, 0);
ticketregistrationInfo.Number_plate = SqlClientUtility.GetString(dataReader,DbConstants.TICKET_REGISTRATION.NUMBER_PLATE, String.Empty);
ticketregistrationInfo.Ticket_type = SqlClientUtility.GetInt32(dataReader,DbConstants.TICKET_REGISTRATION.TICKET_TYPE, 0);
ticketregistrationInfo.Start_date = SqlClientUtility.GetInt32(dataReader,DbConstants.TICKET_REGISTRATION.START_DATE, 0);
ticketregistrationInfo.End_date = SqlClientUtility.GetInt32(dataReader,DbConstants.TICKET_REGISTRATION.END_DATE, 0);
ticketregistrationInfo.Station = SqlClientUtility.GetInt32(dataReader,DbConstants.TICKET_REGISTRATION.STATION, 0);
ticketregistrationInfo.Customer = SqlClientUtility.GetString(dataReader,DbConstants.TICKET_REGISTRATION.CUSTOMER, String.Empty);
ticketregistrationInfo.Staff = SqlClientUtility.GetString(dataReader,DbConstants.TICKET_REGISTRATION.STAFF, String.Empty);
return ticketregistrationInfo;
}