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