public HttpResponseMessage Post([FromBody] JObject value)
{
int title = int.Parse(value["title"].ToString());
var items = value["items"].ToString();
var votememberchk = from q in db.voteMember
where q.memberNAME == member
select new
{
ID = q.memberID
};
var voteItems = (from p in db.voteitem
where p.titleID == title && p.items == items
select p).FirstOrDefault();
var voteItemsmemberchk = from r in db.memberVoteitem
select new
{
itemsID = r.itemsID,
itemsmember = r.memberID
};
foreach (var item in votememberchk)
{
foreach (var item2 in voteItemsmemberchk)
{
if (item.ID == item2.itemsmember && voteItems.itemsID == item2.itemsID)
{
var result = new
{
STATUS = true,
MSG = "重複投票囉",
};
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
}
}
{
voteMember votemember = new voteMember();
votemember.memberNAME = member;
db.voteMember.Add(votemember);
db.SaveChanges();
memberVoteitem membervoteitem = new memberVoteitem();
membervoteitem.memberID = votemember.memberID;
membervoteitem.itemsID = voteItems.itemsID;
db.memberVoteitem.Add(membervoteitem);
db.SaveChanges();
var result2 = new
{
STATUS = true,
MSG = "成功",
};
return(Request.CreateResponse(HttpStatusCode.OK, result2));
}
}
public HttpResponseMessage Post([FromBody] JObject value)
{
if (value["title"].ToString() != "delete")
{
voteTitle votetitle = new voteTitle();
voteMember votemember = new voteMember();
votemember.memberNAME = Convert.ToInt32(member.ToString());
db.voteMember.Add(votemember);
db.SaveChanges();
votetitle.title = value["title"].ToString();
votetitle.startTime = DateTime.Now.ToString("G");
votetitle.endTime = value["endtime"].ToString();
votetitle.memberID = votemember.memberID;
db.voteTitle.Add(votetitle);
db.SaveChanges();
for (var i = 1; i <= value.Count; i++)
{
voteitem voteitem = new voteitem();
if (i <= value.Count - 2)
{
voteitem.items = value["item" + i].ToString();
voteitem.titleID = votetitle.titleID;
db.voteitem.Add(voteitem);
db.SaveChanges();
}
else
{
break;
}
memberVoteitem membervoteitem = new memberVoteitem();
membervoteitem.memberID = 37;
membervoteitem.itemsID = voteitem.itemsID;
db.memberVoteitem.Add(membervoteitem);
db.SaveChanges();
}
var result = new
{
STATUS = true,
MSG = "成功",
};
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
else
{
var result2 = new
{
STATUS = true,
MSG = "不可取名為delete",
};
return(Request.CreateResponse(HttpStatusCode.OK, result2));
}
}
