public int AcceptRejectRequest(int relationshipID, string status)
{
var friend = new FRIEND();
GenericDataAccess <FRIEND> dataAccessFriend = new GenericDataAccess <FRIEND>();
GenericDataAccess <NOTIFICATION> dataAccessNotification = new GenericDataAccess <NOTIFICATION>();
int result;
friend = friendDataAccess.GetFriendRelationship(relationshipID);
if (status == "Confirm")
{
friend.REQUEST = "N";
var friend1 = new FRIEND()
{
USER_ID = friend.FRIEND_ID,
FRIEND_ID = friend.USER_ID,
REQUEST = "N",
CREATED_DATE = DateTime.Now,
BLOCKED = "N"
};
result = dataAccessFriend.Update(friend);
dataAccessFriend.Create(friend1);
}
else
{
result = dataAccessFriend.Delete(friend);
dataAccessNotification.Delete(notificationDataAccess.GetNotificationForFriendRequest(friend));
}
return(result);
}
public IHttpActionResult AddUserFriend(int id)
{
int userid = UserInf.GetUser();
using (MynoteDBEntities db = new MynoteDBEntities())
{
try
{
FRIEND friend = new FRIEND
{
FromUserId = userid,
ToUserId = id,
StatusCode = 0
};
db.FRIENDS.Add(friend);
int save = db.SaveChanges();
if (save != 0)
{
return(Ok());
}
else
{
return(BadRequest());
}
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
}
public ActionResult DeleteConfirmed(string id)
{
FRIEND fRIEND = db.FRIEND.Find(id);
db.FRIEND.Remove(fRIEND);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public FRIEND GetFriend(int userID, int friendID)
{
FRIEND getFriend = new FRIEND();
getFriend = friendRepo.Get(friend =>
(friend.USER_ID == userID && friend.FRIEND_ID == friendID) ||
(friend.USER_ID == friendID && friend.FRIEND_ID == userID));
return(getFriend);
}
public ActionResult Edit([Bind(Include = "READERIDA,READERIDB")] FRIEND fRIEND)
{
if (ModelState.IsValid)
{
db.Entry(fRIEND).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(fRIEND));
}
public FRIEND GetFriendRelationship(int id)
{
FRIEND getSpecificFriend = new FRIEND();
using (var context = new PastebookEntities())
{
getSpecificFriend = context.FRIENDs.FirstOrDefault(f => f.ID == id);
}
return(getSpecificFriend);
}
public FRIEND GetPendingAndApprovedFriends(int userID, int friendID)
{
var friend = new FRIEND();
using (var context = new PastebookEntities())
{
friend = context.FRIENDs.Include("USER1").Include("USER").FirstOrDefault(f => (f.USER_ID == userID && f.FRIEND_ID == friendID) || (f.USER_ID == friendID && f.FRIEND_ID == userID));
}
return(friend);
}
public ActionResult Create([Bind(Include = "READERIDA,READERIDB")] FRIEND fRIEND)
{
if (ModelState.IsValid)
{
db.FRIEND.Add(fRIEND);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(fRIEND));
}
public NOTIFICATION GetNotificationForFriendRequest(FRIEND friend)
{
NOTIFICATION notification = new NOTIFICATION();
using (var context = new PastebookEntities())
{
notification = context.NOTIFICATIONs.FirstOrDefault(n => n.SENDER_ID == friend.USER_ID && n.RECEIVER_ID == friend.FRIEND_ID && n.NOTIF_TYPE == "F");
}
return(notification);
}
public bool AcceptFriend(FRIEND friend)
{
bool returnValue = false;
friend.REQUEST = "Y";
returnValue = friendRepo.Update(friend);
//if (returnValue == true)
//{
// notifManager.RemoveFriendNotification(friend.USER_ID, friend.FRIEND_ID);
//}
return(returnValue);
}
public ActionResult AddFriend(FRIEND friend)
{
string userName = string.Empty;
if (friend != null)
{
friend.USER_ID = (int)Session["CurrentUserID"];
friendManager.AddFriend(friend);
userName = userManager.GetUserNameByID(friend.FRIEND_ID);
}
return(RedirectToAction("ViewProfile", "Pastebook", new { userName = userName }));
}
// GET: FRIENDs/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FRIEND fRIEND = db.FRIEND.Find(id);
if (fRIEND == null)
{
return(HttpNotFound());
}
return(View(fRIEND));
}
public ActionResult AddFriendPartial(string username)
{
USER user = new USER();
FRIEND friend = new FRIEND();
user = userDataAccess.GetUser(null, username);
if (user.ID == (int)Session["user_id"])
{
friend.USER1 = user;
return(PartialView("AddFriendPartialView", friend));
}
return(PartialView("AddFriendPartialView", friendDataAccess.GetPendingAndApprovedFriends((int)Session["user_id"], user.ID)));
}
public ActionResult AcceptFriendRequest(FRIEND friend)
{
if (Session["CurrentUserName"] == null)
{
return(RedirectToAction("Login", "Pastebook"));
}
var userName = string.Empty;
if (friend != null)
{
friend.USER_ID = (int)Session["CurrentUserID"];
friend = friendManager.GetFriend(friend.USER_ID, friend.FRIEND_ID);
var getValue = friendManager.AcceptFriend(friend);
userName = userManager.GetUserNameByID(friend.FRIEND_ID);
}
return(RedirectToAction("ViewProfile", "Pastebook", new { userName = userName }));
}
public bool AddFriend(FRIEND friend)
{
bool returnValue = false;
friend.REQUEST = "N";
friend.BLOCKED = "N";
friend.CREATED_DATE = DateTime.Now;
returnValue = friendRepo.Add(friend);
if (returnValue == true)
{
var getReturn = notifManager.AddNotification(new NOTIFICATION()
{
RECEIVER_ID = friend.FRIEND_ID,
SEEN = "N",
SENDER_ID = friend.USER_ID,
NOTIF_TYPE = "F"
});
}
return(returnValue);
}
public int AddFriend(string username, int userID)
{
var user = new USER();
GenericDataAccess <FRIEND> dataAccessFriend = new GenericDataAccess <FRIEND>();
GenericDataAccess <NOTIFICATION> dataAccessNotification = new GenericDataAccess <NOTIFICATION>();
int result;
user = userDataAccess.GetUser(null, username);
var friend = new FRIEND()
{
USER_ID = userID,
FRIEND_ID = user.ID,
REQUEST = "Y",
CREATED_DATE = DateTime.Now,
BLOCKED = "N"
};
result = dataAccessFriend.Create(friend);
if (result == 1)
{
var notification = new NOTIFICATION()
{
NOTIF_TYPE = "F",
RECEIVER_ID = user.ID,
SENDER_ID = userID,
CREATED_DATE = DateTime.Now,
SEEN = "N"
};
dataAccessNotification.Create(notification);
}
return(result);
}
public static DataTable Loadds_FRIEND(string _userNameTemp)
{
return(FRIEND.Loadds(_userNameTemp));
}
public static void Add_Friend(string userPrimary, string userReference)
{
FRIEND.Add_Friend(userPrimary, userReference);
}
public static DataTable FindFriend(string _userNameTemp)
{
return(FRIEND.FindFriend(_userNameTemp));
}
