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 T_Tag Get(string tagName)
{
using (ConcertFinderEntities bdd = new ConcertFinderEntities())
{
try
{
T_Tag tag = bdd.T_Tag.Where(t => t.Name == tagName).FirstOrDefault();
return tag;
}
catch (Exception)
{
return null;
}
}
}
public static T_Tag GetTagbycontent(String content)
{
using (ConcertFinderEntities bdd = new ConcertFinderEntities())
{
try
{
T_Tag tag = bdd.T_Tag.Where(x => x.Name == content).FirstOrDefault();
return tag;
}
catch (Exception)
{
return null;
}
}
}
public static T_Tag Get(long id)
{
using (ConcertFinderEntities bdd = new ConcertFinderEntities())
{
try
{
T_Tag tag = bdd.T_Tag.Where(x => x.Id == id).FirstOrDefault();
return tag;
}
catch (Exception)
{
return null;
}
}
}
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;
}
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;
}
public static List<DataAccess.T_Notification> GetNext(string pseudo, int last_id)
{
List<DataAccess.T_Notification> notifs;
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 && x.Id < last_id).OrderByDescending(x => x.Date).Take(6).ToList();
}
catch (Exception)
{
throw;
}
}
return notifs;
}
static public T_Location Get(long id)
{
using (ConcertFinderEntities bdd = new ConcertFinderEntities())
{
T_Location location;
try
{
location = bdd.T_Location.Include("T_Event").
Where(x => x.Id == id).FirstOrDefault();
}
catch (Exception)
{
return null;
}
return location;
}
}
public static T_Location GetLocationByCoord(double latitude, double longitude)
{
using (ConcertFinderEntities bdd = new ConcertFinderEntities())
{
T_Location location;
try
{
location = bdd.T_Location.
Where(x => x.Latitude == latitude && x.Longitude == longitude).FirstOrDefault();
}
catch (Exception)
{
return null;
}
return location;
}
}
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;
}
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;
}
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 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 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 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 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 List<T_Tag> GetTagListFromUser(long idUser)
{
using (ConcertFinderEntities bdd = new ConcertFinderEntities())
{
try
{
T_User user = bdd.T_User.Where(x => x.Id == idUser).FirstOrDefault();
List<T_Tag> tags = user.T_Tag.ToList();
return tags;
}
catch (Exception)
{
return null;
}
}
}
public static T_User GetUserByEmail(String email)
{
using (ConcertFinderEntities bdd = new ConcertFinderEntities())
{
try
{
return (bdd.T_User.Where(u => u.Mail == email).FirstOrDefault());
}
catch (Exception)
{
return null;
}
}
}
public static int Checks(String user)
{
using (ConcertFinderEntities bdd = new ConcertFinderEntities())
{
try
{
return bdd.T_User.Include("T_Notification").Where(x => x.Pseudo.Equals(user)).FirstOrDefault().T_Notification.Where(x => x.Check.Value == false).Count();
}
catch (Exception)
{
return 0;
}
}
}
public static Boolean ValidateUser(string pseudo, string password)
{
using (ConcertFinderEntities bdd = new ConcertFinderEntities())
{
try
{
T_User user = bdd.T_User.Where(x => x.Pseudo == pseudo && x.Password == password && x.Deleted == false) .FirstOrDefault();
if (user != null)
{
return true;
}
return false;
}
catch (Exception)
{
return false;
}
}
}
public static List<T_User> GetNextUsers(long last_id)
{
using (ConcertFinderEntities bdd = new ConcertFinderEntities())
{
try
{
return bdd.T_User.OrderByDescending(x => x.Id).Where(x => x.Deleted == false && x.Id < last_id).Take(16).ToList();
}
catch (Exception)
{
return null;
}
}
}
public static T_User GetUserByPseudo(String pseudo)
{
using (ConcertFinderEntities bdd = new ConcertFinderEntities())
{
try
{
T_User user = bdd.T_User.Include("T_Tag").Include("T_Event").Where(x => x.Pseudo == pseudo).FirstOrDefault();
if (user != null)
{
return user;
}
return null;
}
catch (Exception)
{
throw;
}
}
}
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;
}
}
public static T_Location GetLocationById(long id)
{
using (ConcertFinderEntities bdd = new ConcertFinderEntities())
{
T_Location location;
try
{
location = bdd.T_Location.Where(loc => loc.Id == id).FirstOrDefault();
}
catch (Exception)
{
return null;
}
return location;
}
}
public static T_User Get(long idUser)
{
using (ConcertFinderEntities bdd = new ConcertFinderEntities())
{
try
{
return (bdd.T_User.Where(u => u.Id == idUser).FirstOrDefault());
}
catch (Exception)
{
return null;
}
}
}
public static List<T_Event> getEventlistfromTag(long idTag)
{
using (ConcertFinderEntities bdd = new ConcertFinderEntities())
{
try
{
T_Tag tag = bdd.T_Tag.Where(x => x.Id == idTag).FirstOrDefault();
List<T_Event> events = tag.T_Event.ToList();
return events;
}
catch (Exception)
{
return null;
}
}
}
// Contains (Titre(mot), Salle) Start (Ville, Tag)
public static List<T_Event> Search(String q)
{
using (ConcertFinderEntities bdd = new ConcertFinderEntities())
{
try
{
List<T_Event> events = bdd.T_Event.Include("T_Tag").Include("T_Location")
.Where(x => x.Valide == true && x.DateDebut > DateTime.Now).ToList()
.Where(x => x.Titre.Split(new char[] { ' ', '+' }).Intersect(q.Split(new char[] { ' ', '+' })).Count() > 0 ||
x.T_Location.Name.Split(' ').Select(z => z.ToLowerInvariant()).Intersect(q.Split(' ').Select(z => z.ToLowerInvariant())).Count() > 0 ||
x.T_Location.Ville.Split(new char[] { ' ', '-' }).Intersect(q.Split(new char[] { ' ', '-' })).Count() > 0 ||
x.T_Tag.FirstOrDefault(y => y.Name.Equals(q, StringComparison.InvariantCultureIgnoreCase)) != null)
.OrderBy(x => x.DateDebut).ToList();
return events;
}
catch (Exception)
{
return null;
}
}
}