public PandoraMedalShadow(Guid managerId, int type, string itemIds, string itemCodes, int medalCount, Guid transactionId)
{
Shadow = new ShadowPandoraMedalEntity();
Shadow.ManagerId = managerId;
Shadow.Type = type;
Shadow.ItemIds = itemIds;
Shadow.ItemCodes = itemCodes;
Shadow.MedalCount = medalCount;
Shadow.TransactionId = transactionId;
}
public bool SavePandoraMedal(ShadowPandoraMedalEntity entity, DbTransaction trans = null)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_PandoraMedal_Insert");
database.AddInParameter(commandWrapper, "@TransactionId", DbType.Guid, entity.TransactionId);
database.AddInParameter(commandWrapper, "@ManagerId", DbType.Guid, entity.ManagerId);
database.AddInParameter(commandWrapper, "@Type", DbType.Int32, entity.Type);
database.AddInParameter(commandWrapper, "@ItemIds", DbType.String, entity.ItemIds);
database.AddInParameter(commandWrapper, "@ItemCodes", DbType.String, entity.ItemCodes);
database.AddInParameter(commandWrapper, "@MedalCount", DbType.Int32, entity.MedalCount);
int results = 0;
if (trans != null)
{
results = database.ExecuteNonQuery(commandWrapper, trans);
}
else
{
results = database.ExecuteNonQuery(commandWrapper);
}
return(Convert.ToBoolean(results));
}
