//参加の申請が来た時
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);
}
}
//戻り値は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);
}
