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