private ReferenceCodeItem GetReferenceCodeItemModelFromReader(SqlDataReader reader) { ReferenceCodeItem result = new ReferenceCodeItem(); int index = reader.GetOrdinal("admin"); result.Admin = reader.GetString(index); index = reader.GetOrdinal("status"); result.Status = reader.GetInt16(index); index = reader.GetOrdinal("type"); result.Type = reader.GetInt16(index); index = reader.GetOrdinal("code"); result.Code = reader.IsDBNull(index) ? string.Empty : reader.GetString(index); index = reader.GetOrdinal("attempts"); result.Attempts = reader.GetInt16(index); index = reader.GetOrdinal("allowed"); result.Allowed = reader.GetInt16(index); index = reader.GetOrdinal("created"); result.Created = reader.IsDBNull(index) ? DateTime.MinValue : reader.GetDateTime(index); index = reader.GetOrdinal("modified"); result.Modified = reader.IsDBNull(index) ? DateTime.MinValue : reader.GetDateTime(index); return(result); }
public ReferenceCodeItem GetActivationCodeItem(string accountNo) { ReferenceCodeItem result = null; SqlConnection conn = null; SqlDataReader reader = null; try { conn = Connect(); SqlCommand cmd = new SqlCommand("knsp_activation_codes_get", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@admin", System.Data.SqlDbType.VarChar, 64); cmd.Parameters["@admin"].Value = accountNo; reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { result = GetReferenceCodeItemModelFromReader(reader); } } else { } } catch (Exception ex) { // Logger.Instance.Error(this, "GetActivationCodeItem", ex); } finally { Disconnect(conn); } return(result);; }