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