public HttpResponseMessage AddAsFriend(EncryptionForFriends listofFriends) { try { int flagint = -1; flagint = listofFriends.friendId; using (TransactionScope scope = new TransactionScope()) { using (var ctx = new MlaDatabaseEntities1()) { int fIdint = Convert.ToInt32(listofFriends.friendId); var groupIdfromVar = ctx.groups.Where(x => x.userId == listofFriends.userId && x.groupType == 1).Select(x => x.groupNo).ToList(); int grpfromint = groupIdfromVar[0]; friendsTable fobj = new friendsTable(); fobj.user_id = listofFriends.userId; fobj.friend_id = fIdint; fobj.Isaccepted = false; fobj.groupNo = grpfromint; ctx.friendsTables.Add(fobj); group_key grk1 = new group_key(); grk1.groupNo = grpfromint; grk1.groupKey = listofFriends.groupKey; grk1.userId = fIdint; ctx.group_key.Add(grk1); ctx.SaveChanges(); } scope.Complete(); } var response = Request.CreateResponse <int>(System.Net.HttpStatusCode.Created, flagint); return(response); } catch (Exception e) { var response = Request.CreateResponse <string>(System.Net.HttpStatusCode.BadRequest, "Error"); return(response); } }
public HttpResponseMessage AcceptFriendRequest(int userId, int friendId, string groupkey, string groupId) { try { using (TransactionScope scope = new TransactionScope()) { using (var ctx = new MlaDatabaseEntities1()) { int groupIDint = Convert.ToInt32(groupId); friendsTable fobj = new friendsTable(); fobj.user_id = userId; fobj.friend_id = friendId; fobj.Isaccepted = false; fobj.groupNo = groupIDint; ctx.friendsTables.Add(fobj); ctx.SaveChanges(); var lstfrndVar = (from ft in ctx.friendsTables where ft.user_id == friendId && ft.friend_id == userId select ft).Union(from std in ctx.friendsTables where std.friend_id == friendId && std.user_id == userId select std).ToList(); lstfrndVar.ForEach(c => c.Isaccepted = true); group_key gkobj = new group_key(); gkobj.userId = friendId; gkobj.groupNo = Convert.ToInt32(groupId); gkobj.groupKey = groupkey; var query = ctx.group_key.Add(gkobj); ctx.SaveChanges(); } scope.Complete(); } var response = Request.CreateResponse <string>(System.Net.HttpStatusCode.Created, "Success"); return(response); } catch (Exception e) { var response = Request.CreateResponse <string>(System.Net.HttpStatusCode.BadRequest, "Error"); return(response); } }