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