/* UsersBlocked*/ //public bool Block(UsersBlocked ub)//חסימת משתמש //{ // try // { // using (TakeABowDBEntities db = new TakeABowDBEntities()) // { // if (db.UsersBlockeds.First(u => u.UserId == ub.UserId && u.BlockedUserId == ub.BlockedUserId)==null)//בדיקה אם המשתמש נחסם בעבר ע"י החוסם // { // db.UsersBlockeds.Add(ub);//אם לא קיים אז תוסיף // db.SaveChanges(); // return true; // } // else // {//אם קיים אז תשנה אותו לחסום // UsersBlocked ub2 = db.UsersBlockeds.FirstOrDefault(u => u.UserId == ub.UserId && u.BlockedUserId == u.BlockedUserId); // ub2.IsBlocked = true; // db.SaveChanges(); // return true; // } // return false; // } // } // catch (Exception ex) // { // throw; // } //} public bool Block(UsersBlocked ub)//חסימת משתמש { try { using (TakeABowDBEntities db = new TakeABowDBEntities()) { var user = db.UsersBlockeds.FirstOrDefault(u => u.UserId == ub.UserId && u.BlockedUserId == ub.BlockedUserId); if (user != null) { user.IsBlocked = !user.IsBlocked; db.SaveChanges(); return(true); } else { db.UsersBlockeds.Add(ub); db.SaveChanges(); return(true); } } } catch (Exception ex) { // return false; throw; } }
public User GetUserById(int userId) { using (TakeABowDBEntities db = new TakeABowDBEntities()) { return(db.Users.FirstOrDefault(u => u.Id == userId)); } }
public bool updateUser(User u) { try { using (TakeABowDBEntities db = new TakeABowDBEntities()) { var userDb = db.Users.First(x => x.Id == u.Id); if (u.Is_Deleted == true) { userDb.Is_Deleted = true; } else { userDb.FirstName = u.FirstName; userDb.LastName = u.LastName; userDb.Phone = u.Phone; userDb.Job = u.Job; userDb.Is_Deleted = u.Is_Deleted; userDb.Password = u.Password; } db.SaveChanges(); return(true); } } catch (Exception ex) { //return false; throw; } }
/*Feedbacks*/ public bool saveNewFeedback(int sendTo, Feedback f) { try { using (TakeABowDBEntities db = new TakeABowDBEntities()) { var user = db.Users.FirstOrDefault(f1 => f1.Id == sendTo); // var feedback = db.Feedbacks.Where(f1 => f1.UserBlocked.IsBlocked==false );//לעשות 2 תנאים ליצירת פידבק if (user == null)//בדיקה אם המייל קיים משהו עם כזה מייל או ידי { return(false); } else//אם קיים { f.ToUserId = user.Id; //מוסיף באוביקט פידבק למי שלח db.Feedbacks.Add(f); db.SaveChanges(); return(true); } } } catch (Exception ex) { throw; return(false); } }
public int getAmountViewRequests(int userId) { using (TakeABowDBEntities db = new TakeABowDBEntities()) { var count = db.Permissions.Where(p => p.UserId == userId).Count(p => p.IsAllow == null); return(count); } }
public int getAmountFeedbacks(int userId) { using (TakeABowDBEntities db = new TakeABowDBEntities()) { var count = db.Feedbacks.Where(f => f.ToUserId == userId).Count(f => f.IsSeen == false); return(count); } }
public List <Feedback> GetListfeedbackByUser(int id) { using (TakeABowDBEntities db = new TakeABowDBEntities()) { List <Feedback> allFeedbacks = new List <Feedback>(); allFeedbacks = db.Feedbacks.Include(f => f.User).Include(f => f.User1).Where(f => f.FromUserId == id).OrderByDescending(f => f.CreateDate).ToList(); return(allFeedbacks); } }
public List <Feedback> ViewAllFeedbacks(int id) { using (TakeABowDBEntities db = new TakeABowDBEntities()) { List <Feedback> allFeedbacks = new List <Feedback>(); allFeedbacks = db.Feedbacks.Include(f => f.User).Include(f => f.User1).Where(f => f.ToUserId == id && f.IsDeleted == false).ToList(); return(allFeedbacks); } }
public List <Permission> getlistInvitation(int WatchUserId) { using (TakeABowDBEntities db = new TakeABowDBEntities()) { List <Permission> allPermission = new List <Permission>(); allPermission = db.Permissions.Include(f => f.User).Where(p1 => p1.WatchUserId == WatchUserId && p1.ExpireDate > (DateTime.Now)).ToList(); return(allPermission); } }
public List <Feedback> getFeedbackTop(int userId) { using (TakeABowDBEntities db = new TakeABowDBEntities()) { List <Feedback> allFeedbacks = new List <Feedback>(); allFeedbacks = db.Feedbacks.Include(f => f.User).Include(f => f.User1).Where((f => f.ToUserId == userId && f.IsSeen == true && f.IsDeleted == false)).ToList(); return(allFeedbacks); } }
public List <Permission> getAllPermissions(int toPermission) { using (TakeABowDBEntities db = new TakeABowDBEntities()) { List <Permission> allPermission = new List <Permission>(); allPermission = db.Permissions.Include(f => f.User).Where(p1 => p1.UserId == toPermission && p1.IsAllow != true).OrderByDescending(p1 => p1.CreateDate).ToList(); return(allPermission); } }
public bool checkUserBlock(int myId, int userId) { using (TakeABowDBEntities db = new TakeABowDBEntities()) { var ub = db.UsersBlockeds.FirstOrDefault(u => u.UserId == myId && u.BlockedUserId == userId);//בודק לפי היד של הבקשה אם הוא חסום, אם חסום מחזיר אמת if (ub != null && ub.IsBlocked == true) { return(true); } return(false); } }
internal bool?checkUserAllow(int myId, int userId) { using (TakeABowDBEntities db = new TakeABowDBEntities()) { var ub = db.Permissions.FirstOrDefault(u => u.UserId == userId && u.WatchUserId == myId);//בודק לפי היד של הבקשה אם הוא חסום, אם חסום מחזיר אמת if (ub == null) { return(null); } else { return(false); } } }
public List <User> GetListUsers(int userId) { try { using (TakeABowDBEntities db = new TakeABowDBEntities()) { List <User> users = new List <User>(); users = db.Users.Include(f => f.Feedbacks).Where(u => u.Is_Deleted == false && u.Id != userId).OrderBy(u => u.Id).ToList(); return(users); } } catch (Exception ex) { throw; } }
public bool OpenUser(UsersBlocked ub) { try { using (TakeABowDBEntities db = new TakeABowDBEntities()) { UsersBlocked ub2 = db.UsersBlockeds.FirstOrDefault(u => u.UserId == ub.UserId && u.BlockedUserId == u.BlockedUserId); ub2.IsBlocked = false; db.SaveChanges(); return(true); } } catch (Exception ex) { throw; } }
public bool readFeedback(int idFeedback, int FromUserId) { try { using (TakeABowDBEntities db = new TakeABowDBEntities()) { var feedbackDb = db.Feedbacks.First(f => f.Id == idFeedback); feedbackDb.IsSeen = true; db.SaveChanges(); return(true); } } catch (Exception ex) { //return false; throw; } }
public bool IsAllowPermission(int time, Permissions p) { try { using (TakeABowDBEntities db = new TakeABowDBEntities()) { var p1 = db.Permissions.First(per => per.ID == p.Id); p1.IsAllow = p.IsAllow; p1.ExpireDate = DateTime.Today.AddDays(time); db.SaveChanges(); return(true); } } catch (Exception ex) { //return false; throw; } }
/*Permission*/ public bool AddPermission(Common.Permissions p) { using (TakeABowDBEntities db = new TakeABowDBEntities()) { try { if (db.Permissions.FirstOrDefault(per => per.UserId == p.UserId && per.WatchUserId == p.WatchUserId) == null)//בדיקה אם שלח בקשת צפיה למשתמש הזה { data.Permissions.Add(Converters.ConvertToDal.Permissions(p)); data.SaveChanges(); return(true); } else { return(false); } } catch (Exception ex) { throw; //return false; } } }