/// <summary>
/// Saves a record to the ticket_type table.
/// </summary>
public virtual void Insert(TickettypeInfo tickettypeInfo)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@name", tickettypeInfo.Name),
new SqlParameter("@created_date", tickettypeInfo.Created_date)
};
tickettypeInfo.Ticket_type_id = (int) SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "ticket_type_Insert", parameters);
}
/// <summary>
/// Saves a record to the ticket_type table.
/// </summary>
public virtual void Update(TickettypeInfo tickettypeInfo)
{
try
{
new TickettypeTFM().Update(tickettypeInfo);
}
catch (Exception ex)
{
//Provider.Log.Error(ex, "TFM.Biz.Implements.Tickettype - Update" + ex.Message);
throw;
}
}
/// <summary>
/// Saves a record to the ticket_type table.
/// </summary>
public virtual void Insert(TickettypeInfo tickettypeInfo)
{
try
{
new TickettypeTFM().Insert(tickettypeInfo);
}
catch (Exception ex)
{
//Log error by TFM framwork here
//Provider.Log.Error(ex, "TFM.Biz.Implements.Tickettype - Insert" + ex.Message);
throw;
}
}
/// <summary>
/// Creates a new instance of the ticket_type class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual TickettypeInfo MakeTickettypeInfo(SqlDataReader dataReader)
{
TickettypeInfo tickettypeInfo = new TickettypeInfo();
tickettypeInfo.Ticket_type_id = SqlClientUtility.GetInt32(dataReader,DbConstants.TICKET_TYPE.TICKET_TYPE_ID, 0);
tickettypeInfo.Name = SqlClientUtility.GetString(dataReader,DbConstants.TICKET_TYPE.NAME, String.Empty);
tickettypeInfo.Created_date = SqlClientUtility.GetInt32(dataReader,DbConstants.TICKET_TYPE.CREATED_DATE, 0);
return tickettypeInfo;
}
/// <summary>
/// Updates a record in the ticket_type table.
/// </summary>
public virtual void Update(TickettypeInfo tickettypeInfo)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ticket_type_id", tickettypeInfo.Ticket_type_id),
new SqlParameter("@name", tickettypeInfo.Name),
new SqlParameter("@created_date", tickettypeInfo.Created_date)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "ticket_type_Update", parameters);
}
