//参加の申請が来た時
private async void joinEventFromService(object sender, EventArgs e)
{
if (e is IjoinArg)
{
IjoinArg join = e as IjoinArg;
int result = joinDatabase.addMember(join);
string postStr = "";
if (result == 0 || result == 1)
{
string jobStr = myFunction.ConvertJob(join.getMainclass(), join.getSubclass());
if (jobStr == "")
{
jobStr += "クラス未定";
}
if (result == 0)
{
postStr = string.Format("{0}が{1}でエントリーしました。", join.getName(), jobStr);
}
if (result == 1)
{
postStr = string.Format("{0}のエントリーを更新しました。", join.getName());
}
}
else
{
postStr = "現在エントリー期間外です。";
}
await postService.AsyncPostService(postStr);
}
}
private (int key, bool membered) isMemberd(IjoinArg member)
{
string QueStr = string.Format("SELECT ID,name FROM {0} WHERE name = :name;", tablename);
List <object> para = new List <object>();
//para.Add(new NpgsqlParameter("name", DbType.String) { Value = member.Author });
NpgsqlParameter p = new NpgsqlParameter("name", NpgsqlDbType.Text);
p.Value = member.getName();
para.Add(p);
List <List <object> > table = selectParamQue(QueStr, para);
bool isMember = false;
int id = 0;
foreach (List <object> o in table)
{
int tmpID = 0;
if (o[0] is int)
{
tmpID = (int)o[0];
}
string name = o[1] as string;
if (name == member.getName())
{
id = tmpID;
isMember = true;
}
/*
* foreach(object obj in o)
* {
* int tempID = 0;
* string tempMember = "";
*
* if(obj is string)
* {
* tempMember = obj as string;
* }
*
* if(obj is int)
* {
* tempID = (int)obj;
* }
*
* if(tempMember == member.getName())
* {
* id = tempID;
* isMember = true;
* }
* }
*/
}
return(id, isMember);
}
//戻り値はUPDATEかどうか
public bool addMember(IjoinArg member)
{
(int key, bool memberd) = isMemberd(member);
List <NpgsqlParameter> parm = new List <NpgsqlParameter>();
string que = "";
if (!memberd) //初めて追加
{
que = string.Format("INSERT INTO {0} (ID,name,tag,mainclass,subclass,note,jointime) VALUES (:id,:author,:tag,:main,:sub,:note,'{1}');", tablename, DateTime.Now.ToString());
parm.Add(new NpgsqlParameter("id", NpgsqlDbType.Integer));
parm.Add(new NpgsqlParameter("author", NpgsqlDbType.Text));
parm.Add(new NpgsqlParameter("main", NpgsqlDbType.Integer));
parm.Add(new NpgsqlParameter("sub", NpgsqlDbType.Integer));
parm.Add(new NpgsqlParameter("note", NpgsqlDbType.Text));
parm.Add(new NpgsqlParameter("tag", NpgsqlDbType.Text));
parm[0].Value = id;
parm[1].Value = member.getName();
parm[2].Value = (int)member.getMainclass();
parm[3].Value = (int)member.getSubclass();
parm[4].Value = member.getNote();
if (member is DiscordJoinArg)
{
DiscordJoinArg disc = member as DiscordJoinArg;
parm[5].Value = disc.getID();
}
else
{
parm[5].Value = "";
}
id++;
logOutput.writeLog("{0}が参加しました。", member.getName());
}
else
{
if (member.getNote() == "") //備考の更新がないとき
{
/*
* que = string.Format("UPDATE {0} SET mainclass = {1},subclass = {2} WHERE id = {3};",
* tablename,
* member.mainClass,
* member.subClass,
* id);
*/
que = string.Format("UPDATE {0} SET mainclass = :main ,subclass = :sub WHERE id = :id;", tablename);
/*
* parm.Add(new NpgsqlParameter("id", DbType.Int32) { Value = key });
* parm.Add(new NpgsqlParameter("main", DbType.Int32) { Value = member.mainClass });
* parm.Add(new NpgsqlParameter("sub", DbType.Int32) { Value = member.subClass });
*/
parm.Add(new NpgsqlParameter("id", NpgsqlDbType.Integer));
parm.Add(new NpgsqlParameter("main", NpgsqlDbType.Integer));
parm.Add(new NpgsqlParameter("sub", NpgsqlDbType.Integer));
parm[0].Value = key;
parm[1].Value = (int)member.getMainclass();
parm[2].Value = (int)member.getSubclass();
}
else
{
/*
* que = string.Format("UPDATE {0} SET mainclass = {1},subclass = {2} ,note = {3} WHERE id = {4};",
* tablename,
* member.mainClass,
* member.subClass,
* member.content,
* id);
*/
que = string.Format("UPDATE {0} SET mainclass = :main ,subclass = :sub,note = :note WHERE id = :id;", tablename);
/*
* parm.Add(new NpgsqlParameter("id", DbType.Int32) { Value = key });
* parm.Add(new NpgsqlParameter("main", DbType.Int32) { Value = member.mainClass });
* parm.Add(new NpgsqlParameter("sub", DbType.Int32) { Value = member.subClass });
* parm.Add(new NpgsqlParameter("note", DbType.String) { Value = member.content });
*/
parm.Add(new NpgsqlParameter("id", NpgsqlDbType.Integer));
parm.Add(new NpgsqlParameter("main", NpgsqlDbType.Integer));
parm.Add(new NpgsqlParameter("sub", NpgsqlDbType.Integer));
parm.Add(new NpgsqlParameter("note", NpgsqlDbType.Text));
parm[0].Value = key;
parm[1].Value = (int)member.getMainclass();
parm[2].Value = (int)member.getSubclass();
parm[3].Value = member.getNote();
}
logOutput.writeLog("{0}を変更しました。", member.getName());
}
//command(que);
List <object> outputobj = new List <object>();
foreach (NpgsqlParameter p in parm)
{
outputobj.Add(p);
}
ListParamCommand(que, outputobj);
return(memberd);
}