public static ErrorLog_DTO Add(Exception exception, string additionalInfo = null) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { ErrorLog_DTO ErrorLog = new ErrorLog_DTO() { UserId = exception.UserId(), Message = exception.Message, TimeStamp = exception.TimeStamp(), Classname = exception.ClassName(), LineNumber = exception.LineNumber(), MethodName = exception.MethodName(), InnerException = (exception.InnerException != null) ? exception.InnerException.Message : "", AdditionalIfno = additionalInfo }; context.ErrorLogs.Add(ErrorLog); context.SaveChanges(); return context.ErrorLogs.FirstOrDefault(e=>e.UserId == ErrorLog.UserId && e.TimeStamp == ErrorLog.TimeStamp); } } catch (Exception ex) { throw ex; } }
public static UserTimeLog_DTO Add(int userId) { if (!User_DTO.Exists(userId)) return null; try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { var userLog = new UserTimeLog_DTO() { FirstLogDate = DateTime.Now, LastLogDate = DateTime.Now, Duration = 0, UserId = userId }; context.UserLogs.Add(userLog); context.SaveChanges(); return GetLast(userId); } } catch (Exception ex) { throw ex; } }
public static Setting_DTO UpdateSetting(string settingGroup, string settingKey, string settingValue) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { var setting = GetSetting(settingKey); if (setting == null) throw new Exception("Setting Does Not Exist."); setting.SettingGroup = (string.IsNullOrEmpty(settingGroup)) ? "" : settingGroup; setting.SettingValue = setting.SettingValue; context.Settings.Attach(setting); context.Entry(setting).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return GetSetting(settingKey); } } catch (Exception ex) { ex.Log(); return null; } }
public static bool AddUpdateExemption(Exemption exemption) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { var e = context.Exemptions.Find(exemption.ID); //Add Exemption if(e == null) return AddExemption(exemption); e.AssignedUsers.Clear(); context.SaveChanges(); } using (HomesteadViewerContext context = new HomesteadViewerContext()) { var e = context.Exemptions.Find(exemption.ID); e.AssignedUsers = exemption.AssignedUsers; context.SaveChanges(); return true; } } catch (Exception ex) { return false; } }
public static int Count() { using (var context = new HomesteadViewerContext()) { return context.UserLogs.Count(); } }
public static GridColumn_DTO Get(string propertyName) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { return context.GridColumns.FirstOrDefault(x => x.PropertyName.ToLower() == propertyName.ToLower()) ?? null; } } catch (Exception ex) { throw ex; } }
public static GridColumn_DTO Get(Func<GridColumn_DTO, bool> func) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { return context.GridColumns.FirstOrDefault(func) ?? null; } } catch (Exception ex) { throw ex; } }
public static Setting_DTO GetSetting(string settingKey) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { return context.Settings.FirstOrDefault(x => x.SettingKey == settingKey) ?? new Setting_DTO(); } } catch (Exception ex) { ex.Log(); return null; } }
public static List<Setting_DTO> GetAllSettings() { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { return context.Settings.ToList(); } } catch (Exception ex) { ex.Log(); return null; } }
public static bool AddExemption(Exemption exemption) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { foreach (var user in exemption.AssignedUsers) context.Users.Attach(user); context.Exemptions.Add(exemption); context.SaveChanges(); return true; } } catch (Exception ex) { return false; } }
/// <summary> /// Adds a new user /// </summary> /// <param name="name"></param> /// <param name="phone"></param> /// <param name="email"></param> /// <returns>bool</returns> public static bool AddUser(string userName, string phone, string email) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { User user = new User() { UserName = userName, Phone = phone, EmailAddress = email }; context.Users.Add(user); context.SaveChanges(); return true; } } catch (Exception ex) { return false; } }
public static AdministrativeProperties_DTO AddOrUpdate(AdministrativeProperties_DTO administrativeProperties) { try { if (administrativeProperties.AssignedUserID != null) administrativeProperties.AssignedUserID = (administrativeProperties.AssignedUserID <= 0) ? null : administrativeProperties.AssignedUserID; var ap = AdministrativeProperties_DTO.Get(administrativeProperties.OnlineExemptionID); //Creaet New if (ap == null) { using (var context = new HomesteadViewerContext()) { var newAp = new AdministrativeProperties_DTO() { OnlineExemptionID = administrativeProperties.OnlineExemptionID, Comment = administrativeProperties.Comment, FollowUpDate = administrativeProperties.FollowUpDate, Status = administrativeProperties.Status, QuickrefID = administrativeProperties.QuickrefID, AssignedUserID = administrativeProperties.AssignedUserID }; if (newAp.Status != ExemptionStatus.NotWorked) newAp.DateStatusChanged = DateTime.Now; if (administrativeProperties.AssignedUserID != null) newAp.DateAssigned = DateTime.Now; context.AdministrativeProperties_Collection.Add(newAp); context.SaveChanges(); return LogChange(administrativeProperties.OnlineExemptionID); } } //Update using (var context = new HomesteadViewerContext()) { ap.Comment = administrativeProperties.Comment; ap.FollowUpDate = administrativeProperties.FollowUpDate; ap.QuickrefID = administrativeProperties.QuickrefID; if (ap.Status != administrativeProperties.Status) ap.DateStatusChanged = DateTime.Now; ap.Status = administrativeProperties.Status; if (ap.AssignedUserID != administrativeProperties.AssignedUserID) ap.DateAssigned = DateTime.Now; ap.AssignedUserID = administrativeProperties.AssignedUserID; context.AdministrativeProperties_Collection.Attach(ap); context.Entry(ap).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return LogChange(administrativeProperties.OnlineExemptionID); } } catch (Exception ex) { throw ex; } }
public static AdministrativeProperties_DTO LogChange(int onlineExemptionID) { try { using (var context = new HomesteadViewerContext()) { var ap = AdministrativeProperties_DTO.Get(onlineExemptionID); if (ap == null) return null; ap.Modified = DateTime.Now; ap.ModifiedBy = UserSession.GetCurrentUser().FullName; context.AdministrativeProperties_Collection.Attach(ap); context.Entry(ap).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return AdministrativeProperties_DTO.Get(onlineExemptionID); } } catch (Exception ex) { throw ex; } }
public static List<AdministrativeProperties_DTO> GetOrphanedData() { try { using (var context = new HomesteadViewerContext()) { var ap_c = context.AdministrativeProperties_Collection.ToList(); //Check if object exists in Master Exemptions var orphans = ap_c.Where(ap => !MasterExemption_DTO.Exists(ap.OnlineExemptionID)).ToList(); //Check if Quick Ref ID's Work //orphans.AddRange(ap_c.Where(ap => MasterExemption_DTO.Exists(x => x.OnlineExemptionID == ap.OnlineExemptionID && x.QuickrefID != ap.QuickrefID)).ToList()); return orphans; } } catch (Exception ex) { throw ex; } }
public static List<AdministrativeProperties_DTO> GetAll(Func<AdministrativeProperties_DTO, bool> func = null) { try { using (var context = new HomesteadViewerContext()) { if (func != null) return context.AdministrativeProperties_Collection.Where(func).ToList(); return context.AdministrativeProperties_Collection.ToList(); } } catch (Exception ex) { return null; } }
public static AdministrativeProperties_DTO Get(Func<AdministrativeProperties_DTO, bool> func) { try { using (var context = new HomesteadViewerContext()) { return context.AdministrativeProperties_Collection .FirstOrDefault(func); } } catch (Exception ex) { return null; } }
public static AdministrativeProperties_DTO Get(int onlineExemptionId) { try { using (var context = new HomesteadViewerContext()) { return context.AdministrativeProperties_Collection .FirstOrDefault(x => x.OnlineExemptionID == onlineExemptionId); } } catch (Exception ex) { return null; } }
public static List<UserTimeLog_DTO> GetAll(Func<UserTimeLog_DTO, bool> func) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { return context.UserLogs.Where(func).ToList(); } } catch (Exception ex) { throw ex; } }
public static List<User_DTO> GetAll() { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { return context.Users.ToList(); } } catch (Exception ex) { throw ex; } }
public static bool UpdateUser(int id, string firstName, string lastName, string phone, string email) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { var user = Get(id); if (user == null) throw new Exception("User Could Not Be Found"); user.FirstName = firstName; user.LastName = lastName; user.Phone = phone; user.EmailAddress = email; context.Users.Attach(user); context.Entry(user).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return true; } } catch (Exception ex) { return false; } }
public static User_DTO UpdateUser(User_DTO user) { Mapper.CreateMap<Models.User_DTO, Models.User_DTO>() .ForMember(dest => dest.Id, opt => opt.Ignore()); using (HomesteadViewerContext context = new HomesteadViewerContext()) { try { var c = Get(user.Id); if (c == null) throw new Exception("User Could Not Be Found"); Mapper.Map<Models.User_DTO, Models.User_DTO>(user, c); context.Users.Attach(c); context.Entry(c).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return Get(user.Id); } catch (Exception ex) { return null; } } }
public static UserTimeLog_DTO Update(UserTimeLog_DTO userLog) { Mapper.CreateMap<Models.UserTimeLog_DTO, Models.UserTimeLog_DTO>() .ForMember(dest => dest.Id, opt => opt.Ignore()); using (HomesteadViewerContext context = new HomesteadViewerContext()) { try { var c = Get(userLog.Id); if (c == null) throw new Exception("User Could Not Be Found"); Mapper.Map<Models.UserTimeLog_DTO, Models.UserTimeLog_DTO>(userLog, c); TimeSpan span = c.LastLogDate - c.FirstLogDate; c.Duration = (int)span.TotalMilliseconds; context.UserLogs.Attach(c); context.Entry(c).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return Get(userLog.Id); } catch (Exception ex) { throw ex; } } }
public static void RemoveAll() { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { context.Database.ExecuteSqlCommand("TRUNCATE TABLE [UserLogs]"); context.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static UserTimeLog_DTO GetLast(Func<UserTimeLog_DTO, bool> func) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { return context.UserLogs.OrderByDescending(ul => ul.Id).FirstOrDefault(func); } } catch (Exception ex) { throw ex; } }
public static Setting_DTO UpdateSetting(Setting_DTO setting) { Mapper.CreateMap<Models.Setting_DTO, Models.Setting_DTO>(); using (HomesteadViewerContext context = new HomesteadViewerContext()) { try { var s = GetSetting(setting.SettingKey); if (s == null) throw new Exception("Setting Does Not Exist"); Mapper.Map(setting, s); s.SettingGroup = (string.IsNullOrEmpty(setting.SettingGroup)) ? "" : setting.SettingGroup; context.Settings.Attach(s); context.Entry(s).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return GetSetting(s.SettingKey); } catch (Exception ex) { ex.Log(); return null; } } }
public static int Count(Func<AdministrativeProperties_DTO, bool> func) { try { using (var context = new HomesteadViewerContext()) { return context.AdministrativeProperties_Collection.Count(func); } } catch (Exception ex) { throw ex; } }
public static int Count(Func<UserTimeLog_DTO, bool> func) { using (var context = new HomesteadViewerContext()) { return context.UserLogs.Count(func); } }
public static UserTimeLog_DTO Get(Func<UserTimeLog_DTO, bool> func) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { return context.UserLogs.Find(func); } } catch (Exception ex) { throw ex; } }
public static UserTimeLog_DTO Get(int id) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { return context.UserLogs.Find(id); } } catch (Exception ex) { throw ex; } }
public static User_DTO Get(Func<User_DTO, bool> func) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { return context.Users.Where(func).FirstOrDefault(); } } catch (Exception ex) { return null; } }