public static void UpdateUser(Users u, EntityState Modified) { DataLink.UpdateUser(u, Modified); }
public static void CreateUser(Users u) { DataLink.CreateUser(u); }
public static void DeleteUser(int?id) { DataLink.DeleteUser(id); }
public static Users GetUser(string email) { return(DataLink.GetUser(email)); }
public static bool CheckForUser(string email) { return(DataLink.CheckForUser(email)); }
public static List <Users> GetAllUsers() { return(DataLink.GetAllUsers()); }
public static Users GetUser(int?id) { return(DataLink.GetUser(id)); }
public static void CreateUserInputsDC(UserInputsDC ui) { DataLink.CreateUserInputsDC(ui); }
public static void DeleteUserInputsDC(int?id) { DataLink.DeleteUserInputsDC(id); }
public static List <UserInputsDC> GetAllUserInputsDC() { return(DataLink.GetAllUserInputsDC()); }
public static void CreateUserInputs60Hz(UserInputs60Hz ui) { DataLink.CreateUserInputs60Hz(ui); }
public static List <UserInputs60Hz> GetAllUserInputs60Hz() { return(DataLink.GetAllUserInputs60Hz()); }
public IEnumerable <UserIP> GetData(out int totalRecords, string globalSearch, int?limitOffset, int?limitRowCount, string orderBy, bool desc) { var inputs60Hz = DataLink.GetAllUserInputs60Hz(); var inputsDC = DataLink.GetAllUserInputsDC(); List <UserIP> userIPs = new List <UserIP>(); foreach (UserInputs60Hz myInput in inputs60Hz) { UserIP myIP = new UserIP(); myIP.IPAddress = myInput.IPAddress; myIP.DateAdded = myInput.date; userIPs.Add(myIP); } foreach (UserInputsDC myInput in inputsDC) { UserIP myIP = new UserIP(); myIP.IPAddress = myInput.IPAddress; myIP.DateAdded = myInput.date; userIPs.Add(myIP); } var query = userIPs.AsQueryable(); if (!String.IsNullOrWhiteSpace(globalSearch)) { query = query.Where(p => (p.IPAddress + " " + p.DateAdded.ToString()).Contains(globalSearch)); } totalRecords = query.Count(); if (!String.IsNullOrWhiteSpace(orderBy)) { switch (orderBy.ToLower()) { case "ipaddress": if (!desc) { query = query.OrderBy(p => p.IPAddress); } else { query = query.OrderByDescending(p => p.IPAddress); } break; case "dateadded": if (!desc) { query = query.OrderBy(p => p.DateAdded); } else { query = query.OrderByDescending(p => p.DateAdded); } break; } } if (limitOffset.HasValue) { query = query.Skip(limitOffset.Value).Take(limitRowCount.Value); } return(query.ToList()); }
public IEnumerable <UserInputsDC> GetData(out int totalRecords, string globalSearch, int?limitOffset, int?limitRowCount, string orderBy, bool desc) { var query = DataLink.GetAllUserInputsDC().AsQueryable(); if (!String.IsNullOrWhiteSpace(globalSearch)) { query = query.Where(p => (p.PotMaxExp.ToString() + " " + p.AvailSCC.ToString() + " " + p.Duration.ToString() + " " + p.IPAddress + " " + p.date.ToString()).Contains(globalSearch)); } totalRecords = query.Count(); if (!String.IsNullOrWhiteSpace(orderBy)) { switch (orderBy.ToLower()) { case "potmaxep": if (!desc) { query = query.OrderBy(p => p.PotMaxExp); } else { query = query.OrderByDescending(p => p.PotMaxExp); } break; case "availscc": if (!desc) { query = query.OrderBy(p => p.AvailSCC); } else { query = query.OrderByDescending(p => p.AvailSCC); } break; case "duration": if (!desc) { query = query.OrderBy(p => p.Duration); } else { query = query.OrderByDescending(p => p.Duration); } break; case "ipaddress": if (!desc) { query = query.OrderBy(p => p.IPAddress); } else { query = query.OrderByDescending(p => p.IPAddress); } break; case "date": if (!desc) { query = query.OrderBy(p => p.date); } else { query = query.OrderByDescending(p => p.date); } break; } } if (limitOffset.HasValue) { query = query.Skip(limitOffset.Value).Take(limitRowCount.Value); } return(query.ToList()); }