public override MaxSerial CreateSerial(int ownerUserId, DateTime expriseDate, SerialType type, string data,out bool success)
{
using (SqlQuery query = new SqlQuery())
{
Guid serial = Guid.NewGuid();
DateTime createDate = DateTimeUtil.Now;
query.CommandText = "bx_CreateSerial";
query.CommandType = System.Data.CommandType.StoredProcedure;
query.CreateParameter<int>("@UserID", ownerUserId, SqlDbType.Int);
query.CreateParameter<DateTime>("@ExpiresDate", expriseDate, SqlDbType.DateTime);
query.CreateParameter<byte>("@Type", (byte)type, SqlDbType.TinyInt);
query.CreateParameter<string>("@Data", data, SqlDbType.NVarChar, 1000);
SqlParameter outputParam = query.CreateParameter<bool>("@Success", SqlDbType.Bit, ParameterDirection.Output);
MaxSerial newSerial = null;
using (XSqlDataReader reader = query.ExecuteReader())
{
while (reader.Next)
{
newSerial = new MaxSerial(reader);
}
}
success = (bool)outputParam.Value;
return newSerial;
}
}
public override MaxSerial GetSerial(Guid serial, SerialType serialType)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandType = System.Data.CommandType.StoredProcedure;
query.CommandText = "bx_GetSerial";
query.CreateParameter<Guid>("@Serial", serial, System.Data.SqlDbType.UniqueIdentifier);
query.CreateParameter<byte>("@Type", (byte)serialType, System.Data.SqlDbType.TinyInt);
using (XSqlDataReader reader = query.ExecuteReader())
{
MaxSerial resault = null;
while (reader.Next)
{
resault = new MaxSerial(reader);
}
return resault;
}
}
}