public List <MemberStore> GetMemberStoreListByMemberId(string memberId)
{
List <MemberStore> list = new List <MemberStore>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(MemberSqls.SELECT_STORE_BY_MEMBER_ID, memberId);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
MemberStore memberStore = new MemberStore
{
bindDate = dr["BIND_DATE"].ToString(),
cardCode = dr["CARD_CODE"].ToString(),
memberId = dr["MEMBER_ID"].ToString(),
isDefault = dr["IS_DEFAULT"].ToString() == "1",
memberStoreId = dr["MEMBER_STORE_ID"].ToString(),
regPhone = dr["REG_PHONE"].ToString(),
storeAddr = dr["STORE_ADDR"].ToString(),
storeCardImg = dr["STORE_CARD_IMG"].ToString(),
storeId = dr["STORE_ID"].ToString(),
storeName = dr["STORE_NAME"].ToString(),
};
list.Add(memberStore);
}
}
return(list);
}
public DataFileService(SystemStore systems, MemberStore members, SwitchStore switches, ILogger logger)
{
_systems = systems;
_members = members;
_switches = switches;
_logger = logger.ForContext <DataFileService>();
}
async Task ExecuteLoadItemsCommand()
{
if (IsBusy)
{
return;
}
IsBusy = true;
try
{
Members.Clear();
var members = await MemberStore.GetDatasAsync(true);
foreach (var item in members)
{
Members.Add(item);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
}
finally
{
IsBusy = false;
}
}
public MemberCommands(SystemStore systems, MemberStore members, EmbedService embeds, ProxyCacheService proxyCache)
{
_systems = systems;
_members = members;
_embeds = embeds;
_proxyCache = proxyCache;
}
public EmbedService(SystemStore systems, MemberStore members, IDiscordClient client, SwitchStore switches, MessageStore messages)
{
_systems = systems;
_members = members;
_client = client;
_switches = switches;
_messages = messages;
}
public SystemController(SystemStore systems, MemberStore members, SwitchStore switches, DbConnectionFactory conn, TokenAuthService auth)
{
_systems = systems;
_members = members;
_switches = switches;
_conn = conn;
_auth = auth;
}
public SystemCommands(SystemStore systems, MemberStore members, SwitchStore switches, EmbedService embeds, ProxyCacheService proxyCache)
{
_systems = systems;
_members = members;
_switches = switches;
_embeds = embeds;
_proxyCache = proxyCache;
}
public Context(IServiceProvider provider, SocketUserMessage message, int commandParseOffset,
PKSystem senderSystem)
{
_client = provider.GetRequiredService <IDiscordClient>() as DiscordShardedClient;
_message = message;
_systems = provider.GetRequiredService <SystemStore>();
_members = provider.GetRequiredService <MemberStore>();
_senderSystem = senderSystem;
_provider = provider;
_parameters = new Parameters(message.Content.Substring(commandParseOffset));
}
public PeriodicStatCollector(IDiscordClient client, IMetrics metrics, SystemStore systems, MemberStore members, SwitchStore switches, MessageStore messages, ILogger logger, WebhookCacheService webhookCache, DbConnectionCountHolder countHolder)
{
_client = (DiscordShardedClient)client;
_metrics = metrics;
_systems = systems;
_members = members;
_switches = switches;
_messages = messages;
_webhookCache = webhookCache;
_countHolder = countHolder;
_logger = logger.ForContext <PeriodicStatCollector>();
}
public CacheClient(string prefix)
{
Prefix = prefix;
Channels = new ChannelStore(this);
EditableMessages = new EditableMessagesStore(this);
Emojis = new EmojiStore(this);
Guilds = new GuildStore(this);
Members = new MemberStore(this);
Messages = new MessageStore(this);
Roles = new RoleStore(this);
Users = new UserStore(this);
VoiceStates = new VoiceStateStore(this);
}
public MemberViewModel()
{
Title = "Member";
Members = new ObservableCollection <Member>();
LoadMembersCommand = new Command(async() => await ExecuteLoadItemsCommand());
/*TODO: MessagingCenter to register when implemented AddMember*/
MessagingCenter.Subscribe <NewMemberPage, Member>(this, "AddMember", async(obj, item) =>
{
var newItem = item as Member;
Members.Add(newItem);
await MemberStore.AddDataAsync(newItem);
});
}
/// <summary>Initializes a new instance of the <see cref="JsonObject"/> class.</summary>
public JwtHeader()
: base(MemberStore.CreateSlowGrowingStore())
{
}
public MemberController(MemberStore members, DbConnectionFactory conn, TokenAuthService auth)
{
_members = members;
_conn = conn;
_auth = auth;
}
/// <summary>Initializes a new instance of the <see cref="JwtPayload"/> class.</summary>
public JwtPayload()
: base(MemberStore.CreateFastGrowingStore())
{
}
public ViewSystem(SystemStore systems, MemberStore members)
{
_systems = systems;
_members = members;
}