public static bool Create(T_Notification notification, T_User user, T_Event myevent) { using (ConcertFinderEntities bdd = new ConcertFinderEntities()) { try { T_Event a_event = bdd.T_Event.Where(x => x.Id == myevent.Id).FirstOrDefault(); T_User a_user = bdd.T_User.Where(x => x.Id == user.Id).FirstOrDefault(); bdd.Attach(a_event); bdd.Attach(a_user); notification.T_Event.Add(a_event); notification.T_User.Add(a_user); bdd.T_Notification.AddObject(notification); bdd.SaveChanges(); } catch (Exception) { throw; } } return true; }
public static bool Create(T_Tag tag) { using (ConcertFinderEntities bdd = new ConcertFinderEntities()) { try { bdd.AddToT_Tag(tag); bdd.SaveChanges(); } catch (Exception) { return false; } } return true; }
static public bool Delete(long id) { using (ConcertFinderEntities bdd = new ConcertFinderEntities()) { try { bdd.DeleteObject(bdd.T_Location.Where(x => x.Id == id).FirstOrDefault()); bdd.SaveChanges(); } catch (Exception) { return false; } } return true; }
static public bool Update(T_Tag tag) { using (ConcertFinderEntities bdd = new ConcertFinderEntities()) { try { var n_tag = new T_Tag { Id = tag.Id }; bdd.T_Tag.Attach(n_tag); bdd.ApplyCurrentValues("T_Tag", tag); bdd.SaveChanges(); } catch (Exception) { return false; } } return true; }
static public bool Update(T_Location location) { using (ConcertFinderEntities bdd = new ConcertFinderEntities()) { try { var n_location = new T_Location { Id = location.Id }; bdd.T_Location.Attach(n_location); bdd.ApplyCurrentValues("T_Location", location); bdd.SaveChanges(); } catch (Exception) { return false; } } return true; }
public static Boolean Update(T_User upUser) { using (ConcertFinderEntities bdd = new ConcertFinderEntities ()) { try { var user = new T_User { Id = upUser.Id }; bdd.T_User.Attach(user); bdd.ApplyCurrentValues("T_User", upUser); bdd.SaveChanges(); } catch (Exception) { throw; } return true; } }
public static List<DataAccess.T_Notification> Get(string pseudo) { List<DataAccess.T_Notification> notifs = new List<T_Notification>(); using (ConcertFinderEntities bdd = new ConcertFinderEntities()) { try { notifs = bdd.T_Notification.Include("T_User").Include("T_Event").ToList().Where(x => x.T_User.FirstOrDefault().Pseudo == pseudo).OrderByDescending(x => x.Date).Take(6).ToList(); foreach (T_Notification notif in bdd.T_Notification.Include("T_User").ToList().Where(x => x.T_User.FirstOrDefault().Pseudo == pseudo && x.Check == false).ToList()) { notif.Check = true; } bdd.SaveChanges(); } catch (Exception) { throw; } } return notifs; }
public static bool Create(T_Notification notification, long id) { using (ConcertFinderEntities bdd = new ConcertFinderEntities()) { try { T_User user = bdd.T_User.Where(x => x.Id == id).FirstOrDefault(); bdd.Attach(user); notification.T_User.Add(user); bdd.AddToT_Notification(notification); bdd.SaveChanges(); } catch (Exception) { throw; } } return true; }
public static Boolean Delete(long idUser) { using (ConcertFinderEntities bdd = new ConcertFinderEntities()) { try { T_User user = bdd.T_User.Where(u => u.Id == idUser).FirstOrDefault(); user.Role = "deactivated"; bdd.AddToT_User(user); bdd.SaveChanges(); } catch (Exception) { return false; } return true; } }
public static Boolean Create(T_User user, List<T_Tag> tags) { using (ConcertFinderEntities bdd = new ConcertFinderEntities()) { try { foreach (T_Tag tag in tags) { bdd.Attach(tag); user.T_Tag.Add(tag); } bdd.AddToT_User(user); bdd.SaveChanges(); } catch (Exception) { throw; } return (true); } }
public static bool Deny(T_Notification notif, long idEvent) { using (ConcertFinderEntities bdd = new ConcertFinderEntities()) { try { T_Event myevent = bdd.T_Event.Include("T_User").Where(x => x.Id == idEvent).FirstOrDefault(); notif.T_Event.Add(myevent); notif.T_User.Add(myevent.T_User); bdd.AddToT_Notification(notif); bdd.SaveChanges(); return true; } catch (Exception) { throw; return false; } } }
public static Boolean Update(string pseudo, Models.ParameterModel form) { using (ConcertFinderEntities bdd = new ConcertFinderEntities()) { try { SimpleAES encryptor = new SimpleAES(); T_User user = bdd.T_User.Include("T_Tag").Include("T_Event").Where(x => x.Pseudo == pseudo).FirstOrDefault(); if (user.Ville != form.MyCity && form.MyCity != null) { user.Ville = form.MyCity; } if ((form.NewPassword != null) && (form.OldPassword != null) && (form.ConfirmPassword != null)) { if (User.ValidateUser(pseudo, encryptor.EncryptToString(form.OldPassword)) && encryptor.EncryptToString(form.NewPassword) != user.Password) { user.Password = encryptor.EncryptToString(form.NewPassword); } } if (user.Mail != form.Email && (form.Email != null)) { user.Mail = form.Email; } List<DataAccess.T_Tag> listTag = new List<DataAccess.T_Tag>(); if (form.Tag != null) { string[] split = form.Tag.Split(new Char[] { ' ', ',', '.', ';' }); foreach (string str in split) { if (str.Length > 2) { Regex r = new Regex("[a-z1-9*]"); Match m = r.Match(str); if (m.Success) { str.ToLower(); DataAccess.T_Tag tag = new DataAccess.T_Tag() { Name = str }; if (bdd.T_Tag.Where(t => t.Name == tag.Name).FirstOrDefault() == null) { DataAccess.Tag.Create(tag); } tag = bdd.T_Tag.Where(t => t.Name == tag.Name).FirstOrDefault(); listTag.Add(tag); } } } } user.T_Tag.Clear(); foreach (T_Tag tag in listTag) { bdd.Attach(tag); user.T_Tag.Add(tag); } var uuser = new T_User { Id = user.Id }; bdd.ApplyCurrentValues("T_User", user); bdd.SaveChanges(); } catch (System.Data.UpdateException ex) { throw; } return true; } }