public static Object insert_lbxFriends(friend f) { using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Default"].ConnectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand("addFriend", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@firstname", f.firstname); command.Parameters.AddWithValue("@lastname", f.lastname); return command.ExecuteScalar(); } } }
/// <summary> /// Accepts a friend request between the specified /// id (the source) and the logged in user (the destination) /// </summary> /// <param name="id">The id of the source of the friend request</param> /// <returns>True if successful, false otherwise</returns> public Boolean AcceptFriendRequest(int id) { // Ssame user? if (id == WebSecurity.CurrentUserId) return false; // Find the pending request friend_pending pending = (from f in _dbContext.friend_pending where f.source_id == id && f.destination_id == WebSecurity.CurrentUserId select f).FirstOrDefault(); if (pending == null) return false; // Remove pending, then add friendships in both directions _dbContext.friend_pending.Remove(pending); friend f1 = new friend() { source_id = id, destination_id = WebSecurity.CurrentUserId, request_date = pending.request_date, friended_date = DateTime.Now }; friend f2 = new friend() { source_id = WebSecurity.CurrentUserId, destination_id = id, request_date = pending.request_date, friended_date = f1.friended_date }; _dbContext.friend.Add(f1); _dbContext.friend.Add(f2); _unitOfWork.AchievementRepository.CheckFriendSystemAchievements(WebSecurity.CurrentUserId); _unitOfWork.AchievementRepository.CheckFriendSystemAchievements(f1.source_id); LoggerModel logFriendRequest = new LoggerModel() { Action = Logger.PlayerFriendLogType.AcceptRequest.ToString(), UserID = WebSecurity.CurrentUserId, IPAddress = HttpContext.Current.Request.UserHostAddress, TimeStamp = DateTime.Now, ID1 = id, IDType1 = Logger.LogIDType.User.ToString() }; Logger.LogSingleEntry(logFriendRequest, _dbContext); _dbContext.SaveChanges(); return true; }
public IHttpActionResult Deletefriend(int id) { friend friend = db.friends.Find(id); if (friend == null) { return(NotFound()); } db.friends.Remove(friend); db.SaveChanges(); return(Ok(friend)); }
public static Object insert_lbxFriends(friend f) { using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Default"].ConnectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand("addFriend", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@firstname", f.firstname); command.Parameters.AddWithValue("@lastname", f.lastname); return(command.ExecuteScalar()); } } }
// GET: Friends/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } friend friend = db.friends.Find(id); if (friend == null) { return(HttpNotFound()); } return(View(friend)); }
public void AddFriend(long subdomainid, long friendsubdomainid) { //check if friend exists if (!IsFriend(subdomainid, friendsubdomainid)) { friend f = new friend { subdomainid = subdomainid, friendsubdomainid = friendsubdomainid }; db.friends.InsertOnSubmit(f); // update total contacts count for both ppl UpdateCounters(subdomainid, 1, CounterType.CONTACTS_PUBLIC); UpdateCounters(friendsubdomainid, 1, CounterType.CONTACTS_PUBLIC); } }
public void ConfimRequest() { string currid = Request.Params["id"].ToString(); int id = int.Parse(Request.Params["id1"].ToString()); int notifID = int.Parse(Request.Params["notifID"]); user us = Session["User" + currid] as user; //delete current notification notification not = db.notifications.Where(n => n.id == notifID).ToList().First(); db.notifications.Remove(not); db.SaveChanges(); //sent response notification notification notif = new notification(); notif.user_id = id; notif.sender_id = us.id; notif.text_id = 4; notif.state = 1; notif.datetime = DateTime.Now; db.notifications.Add(notif); db.SaveChanges(); //add to friend; friend friends = new friend(); friends.user_id = us.id; friends.friend_user_id = id; db.friends.Add(friends); //add to followers follower folow = new follower(); folow.user_id = us.id; folow.follower_id = id; db.followers.Add(folow); follower folow2 = new follower(); folow2.user_id = id; folow2.follower_id = us.id; db.followers.Add(folow2); try { db.SaveChanges(); Response.Write("ok"); } catch (Exception e) { Response.Write("Sorry something wen't wrong - " + e.InnerException.ToString() + "x=" + id); } }
public friend Get_Friend(int id_Friend) { friend Friend = new friend(); try { Friend = (from data in _db.friends where (data.Status == true && data.id == id_Friend) select data).FirstOrDefault(); } catch (Exception ex) { throw; } return(Friend); }
public ErrorMessage AddFriend(string userBid) { if (currentUser == null) return ErrorMessage.ERROR; if (userBid == currentUser.userId) return ErrorMessage.ERROR; UserHandler BHandler = new UserHandler(); if (BHandler.SetCurrentUserById(userBid) == ErrorMessage.NOT_EXIST) return ErrorMessage.NOT_EXIST; if (currentUser.friend.Any(ff => ff.userB == userBid) || currentUser.friend1.Any(ff => ff.userA == userBid)) return ErrorMessage.ALREADY_EXIST; friend newRecord=new friend { userA=currentUser.userId,userB=userBid}; currentUser.friend.Add(newRecord); return ErrorMessage.OK; }
private void Sql()//显示好友 { try { conn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ToString()); friendsW = new ArrayList(); friendsB = new ArrayList(); string str = string.Format(@"select Friends.UserID, Friends.FriendNick, Friends.FriendNotes, Friends.FriendState, Friends.FriendClassification, Headpic, signatures from Friends,[User] where Friends.FriUserID=[User].UserID and [User].UserID in (select Friends.FriUserID from Friends where UserID ='" + UserID + "')"); SqlCommand cmd = new SqlCommand(str, conn); if (conn != null && conn.State != ConnectionState.Open) { conn.Open(); } SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { friend a = new friend(); a.Friendnick = dr["FriendNick"].ToString(); a.Friendnotes = dr["FriendNotes"].ToString(); a.FriuserID = dr["UserID"].ToString(); a.FriendState = dr["FriendState"].ToString(); a.FriendUrl = dr["HeadPic"].ToString(); a.FriendClassification = dr["FriendClassification"].ToString(); a.Signatures = dr["Signatures"].ToString(); if (!a.FriendClassification.Contains("黑名单")) { friendsW.Add(a); } else { friendsB.Add(a); } } dr.Close(); } catch (Exception ex) { throw ex; } finally { if (conn.State != ConnectionState.Closed) { conn.Close(); } } }
public void UnFriend() { string currId = Request.Params["id"].ToString(); int id = int.Parse(Request.Params["id1"]); user us = Session["User" + currId] as user; friend friend = new friend(); friend = db.friends.Where(fr => (fr.friend_user_id == id && fr.user_id == us.id) || (fr.user_id == id && fr.friend_user_id == us.id)).ToList().First(); try { db.friends.Remove(friend); db.SaveChanges(); } catch (Exception e) { Response.Write("Sorry something wen't wrong - " + e.InnerException.ToString() + "x=" + id); } Redirect("/Chrono/index/" + id); }
public async Task <IHttpActionResult> SendRequest(friend friend) { if (!ModelState.IsValid || friend.friendId == friend.UserId) { return(BadRequest(ModelState)); } db.send_friend_request(friend.UserId, friend.friendId, friend.since); //db.friends.Add(friend); try { db.SaveChanges(); } catch (DbUpdateException) { if (friendExists(friend.UserId, friend.friendId)) { return(Conflict()); } else { throw; } } var new_notifi = new cls_notifi { source_name = "user", source_id = friend.friendId, image = db.AspNetUsers.FirstOrDefault(x => x.Id == friend.friendId).Photo,//"no image", body_English = db.AspNetUsers.FirstOrDefault(x => x.Id == friend.friendId).UserName + " send you a friend request", body_Arabic = "قام " + db.AspNetUsers.FirstOrDefault(x => x.Id == friend.friendId).UserName + " بارسال طلب صداقة اليك", timestamp = DateTime.Now, readed = false }; await Push(new_notifi, "notifications/" + friend.UserId.ToString() + "/" + DateTime.UtcNow.ToString("dd-MM-yyyy")); PushNotifi(db.AspNetUsers.FirstOrDefault(x => x.Id == friend.UserId).DeviceToken, "New Friend Request", new_notifi.body_English, "user", friend.friendId); //return RedirectToRoute("~/rpc/notifi/push", new { notifi= new_notifi, path = "notifications/" + friend.UserId.ToString() + "/friends" }); return(CreatedAtRoute("DefaultApi", new { id = friend.UserId }, friend)); }
/// <summary> /// Removes a friendship between the specified /// id and the logged in user /// </summary> /// <param name="id">The id of the friend to remove</param> /// <returns>True if successful, false otherwise</returns> public Boolean RemoveFriend(int id) { // Find the friendships friend f1 = (from f in _dbContext.friend where f.source_id == id && f.destination_id == WebSecurity.CurrentUserId select f).FirstOrDefault(); friend f2 = (from f in _dbContext.friend where f.source_id == WebSecurity.CurrentUserId && f.destination_id == id select f).FirstOrDefault(); // If neither exists, can't remove if (f1 == null && f2 == null) { return(false); } LoggerModel logFriendRequest = new LoggerModel() { Action = Logger.PlayerFriendLogType.RemoveFriend.ToString(), UserID = WebSecurity.CurrentUserId, IPAddress = HttpContext.Current.Request.UserHostAddress, TimeStamp = DateTime.Now, ID1 = id, IDType1 = Logger.LogIDType.User.ToString() }; Logger.LogSingleEntry(logFriendRequest, _dbContext); // Remove both - It should be either both or neither, but // during testing we may end up with just one way, so better // to remove the stragglers if (f1 != null) { _dbContext.friend.Remove(f1); } if (f2 != null) { _dbContext.friend.Remove(f2); } _dbContext.SaveChanges(); return(true); }
public void ParseICS() { string contents = File.ReadAllText(@"birthday_cal.ics"); var calendar = (VCalendar)CalendarObject.Parse(contents); this.myfriends = new ArrayList(); foreach (var item in calendar.Children) { string name = item.Properties[1].Value; string id = item.Properties[4].Value; string date = item.Properties[0].Value; friend x = new friend(name, id, date); myfriends.Add(x); //Console.WriteLine("Name : " + item.Properties[1].Value); //Console.WriteLine("ID : " + item.Properties[4].Value); //Console.WriteLine("Date : " + item.Properties[0].Value); } //MessageBox.Show("Parsing Done! See Console"); }
/// <summary> /// function insert and update and delete User /// </summary> /// <param name="ctgr"></param> model User /// <param name="action_status"></param> status: (add; edit; insert) /// <returns></returns> public bool Add_and_Edit_Friend(friend ctgr, int action_status) { bool check = false; try { if (Util.Cnv_Int(ctgr.id.ToString()) > 0) { friend data_edit = new friend(); data_edit = Get_Friend(ctgr.id); if (action_status == Variable.action_status.is_update) { // update data data_edit.FullName = ctgr.FullName; data_edit.PhoneNumber = ctgr.PhoneNumber; data_edit.Note = ctgr.Note; data_edit.UpdatedAt = DateTime.Now; data_edit.UpdatedBy = ctgr.UpdatedBy; data_edit.Relationship = ctgr.Relationship; } else if (action_status == Variable.action_status.is_delete) // delete data { data_edit.Status = ctgr.Status; } } else { _db.friends.Add(ctgr); // add data } _db.SaveChanges(); check = true; } catch (Exception) { return(check); } return(check); }
public IHttpActionResult Deletefriend(string User1, string User2) { friend friend1 = db.friends.Find(User1, User2); friend friend2 = db.friends.Find(User2, User1); if (friend1 == null && friend2 == null) { return(NotFound()); } // db.friends.Remove(friend); db.remove_friend_or_frequest(User1, User2); db.SaveChanges(); if (friend1 == null) { return(Ok(friend2)); } else { return(Ok(friend1)); } }
partial void Deletefriend(friend instance);
partial void Updatefriend(friend instance);
partial void Insertfriend(friend instance);
private void attach_friend1(friend entity) { this.SendPropertyChanging(); entity.user1 = this; }
.Select(friend => (friend.Name, CloseFriends: GetCloseFriends(friend, friends, numberOfCloserFriends))).ToList();
private void detach_friend1(friend entity) { this.SendPropertyChanging(); entity.user1 = null; }
private void addButton2_Click(object sender, EventArgs e) { var get_login = from u in database.users where u.login == frndtextBox.Text select new {u.u_id}; int frnd_id = 0; foreach (var u in get_login) { frnd_id = u.u_id; } if (frnd_id == 0) { MessageBox.Show("No such user!", "Error!"); return; } using (var trans = new TransactionScope()) { DateTime teraz = DateTime.Now; friend add_friend = new friend { u1_id = userid, u2_id = frnd_id, add_time = teraz }; database.friends.InsertOnSubmit(add_friend); action fradd_act = new action { u_id = userid, act_type = "AFR", action_time = teraz }; database.actions.InsertOnSubmit(fradd_act); database.SubmitChanges(); trans.Complete(); } UpdateHistory(); panel1.Visible = false; }