public List <HelpClassLogs> GetAllByAdminInstitution(USER user) { DataClasses1DataContext pom = new DataClasses1DataContext(); INSTITUTION queryInst = ( from i in pom.INSTITUTIONs from u in pom.USERs from p in pom.PERMISSIONs where i.ID == p.ID_INST && p.ID_USER == u.ID && p.Usage == 1 && u.ID == user.ID select i).First <INSTITUTION>(); IQueryable <LOG> queryable = from l in pom.LOGs join u in pom.USERs on l.Id_User equals user.ID join p in pom.PERMISSIONs on u.ID equals p.ID_USER join i in pom.INSTITUTIONs on p.ID_INST equals i.ID where p.Usage == 1 && i.ID == queryInst.ID select l; List <HelpClassLogs> list = new List <HelpClassLogs>(); foreach (LOG current in queryable) { HelpClassLogs helpClassLogs = new HelpClassLogs(); helpClassLogs.ID = current.ID; helpClassLogs.idTable = (long)current.Id_Table; helpClassLogs.TittleTable = InteropDAL.TablesDictionary[current.Id_Table]; helpClassLogs.idUser = current.Id_User.ToString(); helpClassLogs.objUser = new UsersDAL().GetByID(current.Id_User); helpClassLogs.NameSurnameUser = helpClassLogs.objUser.Name + " " + helpClassLogs.objUser.Surname; helpClassLogs.idItem = current.Id_Item; helpClassLogs.Date = current.DateTime; helpClassLogs.ActiveType = current.ActiveType; helpClassLogs.Old = current.Old; helpClassLogs.New = current.New; switch (helpClassLogs.ActiveType) { case 1: helpClassLogs.ActiveTypeName = "insert"; break; case 2: helpClassLogs.ActiveTypeName = "update"; break; case 3: helpClassLogs.ActiveTypeName = "delete"; break; default: helpClassLogs.ActiveTypeName = "unknown"; break; } list.Add(helpClassLogs); } return(list); }
public List <HelpClassLogs> GetByUserForToday(USER user) { try { DataClasses1DataContext classes1DataContext = new DataClasses1DataContext(); DateTime DateFrom = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day); DateTime DateTo = DateFrom.AddHours(24.0); IQueryable <LOG> queryable = Queryable.Where <LOG>((IQueryable <LOG>)classes1DataContext.LOGs, (Expression <Func <LOG, bool> >)(p => p.Id_User == user.ID && p.DateTime >= DateFrom && p.DateTime <= DateTo)); List <HelpClassLogs> list = new List <HelpClassLogs>(); foreach (LOG log in (IEnumerable <LOG>)queryable) { HelpClassLogs helpClassLogs = new HelpClassLogs(); helpClassLogs.ID = log.ID; helpClassLogs.idTable = (long)log.Id_Table; helpClassLogs.TittleTable = InteropDAL.TablesDictionary[log.Id_Table]; helpClassLogs.idUser = log.Id_User.ToString(); helpClassLogs.objUser = new UsersDAL().GetByID(log.Id_User); helpClassLogs.NameSurnameUser = helpClassLogs.objUser.Name + " " + helpClassLogs.objUser.Surname; helpClassLogs.idItem = log.Id_Item; helpClassLogs.Date = log.DateTime; helpClassLogs.ActiveType = log.ActiveType; helpClassLogs.Old = log.Old; helpClassLogs.New = log.New; switch (helpClassLogs.ActiveType) { case 1: helpClassLogs.ActiveTypeName = "insert"; break; case 2: helpClassLogs.ActiveTypeName = "update"; break; case 3: helpClassLogs.ActiveTypeName = "delete"; break; default: helpClassLogs.ActiveTypeName = "unknown"; break; } list.Add(helpClassLogs); } return(list); } catch (Exception ex) { return((List <HelpClassLogs>)null); } }
public List <HelpClassLogs> GetTop50() { IQueryable <LOG> queryable = Queryable.Take <LOG>(Queryable.Select <LOG, LOG>((IQueryable <LOG>) new DataClasses1DataContext().LOGs, (Expression <Func <LOG, LOG> >)(p => p)), 50); List <HelpClassLogs> list = new List <HelpClassLogs>(); foreach (LOG log in (IEnumerable <LOG>)queryable) { HelpClassLogs helpClassLogs = new HelpClassLogs(); helpClassLogs.ID = log.ID; helpClassLogs.idTable = (long)log.Id_Table; helpClassLogs.TittleTable = InteropDAL.TablesDictionary[log.Id_Table]; helpClassLogs.idUser = log.Id_User.ToString(); helpClassLogs.objUser = new UsersDAL().GetByID(log.Id_User); helpClassLogs.NameSurnameUser = helpClassLogs.objUser.Name + " " + helpClassLogs.objUser.Surname; helpClassLogs.idItem = log.Id_Item; helpClassLogs.Date = log.DateTime; helpClassLogs.ActiveType = log.ActiveType; helpClassLogs.Old = log.Old; helpClassLogs.New = log.New; switch (helpClassLogs.ActiveType) { case 1: helpClassLogs.ActiveTypeName = "insert"; break; case 2: helpClassLogs.ActiveTypeName = "update"; break; case 3: helpClassLogs.ActiveTypeName = "delete"; break; default: helpClassLogs.ActiveTypeName = "unknown"; break; } list.Add(helpClassLogs); } return(list); }
public List <HelpClassLogs> GetAllByAdminInstitutionForDate(USER user, DateTime DateFrom, DateTime DateTo) { List <HelpClassLogs> result; try { DataClasses1DataContext pom = new DataClasses1DataContext(); // USER u; INSTITUTION queryInst = ( from i in pom.INSTITUTIONs from u in pom.USERs from p in pom.PERMISSIONs where i.ID == p.ID_INST && p.ID_USER == u.ID && p.Usage == 1 && u.ID == user.ID select i).First <INSTITUTION>(); IQueryable <USER> queryable = ( from u in pom.USERs join p in pom.PERMISSIONs on u.ID equals p.ID_USER join i in pom.INSTITUTIONs on p.ID_INST equals i.ID where i.ID == queryInst.ID && u.Active == true && p.Active == true select u).Distinct <USER>(); List <HelpClassLogs> list = new List <HelpClassLogs>(); foreach (USER u in queryable) { IQueryable <LOG> queryable2 = from l in pom.LOGs where l.Id_User == u.ID && l.DateTime >= DateFrom && l.DateTime <= DateTo && u.Type != 1 select l; foreach (LOG current in queryable2) { HelpClassLogs helpClassLogs = new HelpClassLogs(); HelpClassLogs helpClassLogs2 = new HelpClassLogs(); helpClassLogs2.ID = current.ID; helpClassLogs2.idTable = (long)current.Id_Table; helpClassLogs2.TittleTable = InteropDAL.TablesDictionary[current.Id_Table]; helpClassLogs2.idUser = current.Id_User.ToString(); helpClassLogs2.objUser = new UsersDAL().GetByID(current.Id_User); helpClassLogs2.NameSurnameUser = helpClassLogs2.objUser.Name + " " + helpClassLogs2.objUser.Surname; helpClassLogs2.idItem = current.Id_Item; helpClassLogs2.Date = current.DateTime; helpClassLogs2.ActiveType = current.ActiveType; helpClassLogs2.Old = current.Old; helpClassLogs2.New = current.New; switch (helpClassLogs2.ActiveType) { case 1: helpClassLogs2.ActiveTypeName = "insert"; break; case 2: helpClassLogs2.ActiveTypeName = "update"; break; case 3: helpClassLogs2.ActiveTypeName = "delete"; break; default: helpClassLogs2.ActiveTypeName = "unknown"; break; } list.Add(helpClassLogs2); } } result = list; } catch (Exception var_8_CB1) { result = null; } return(result); }