public List<RouteData> AddRoutDatas(List<RouteData> routeDatas) { if (routeDatas == null || routeDatas.Count == 0) { return routeDatas; } using (var dbContext = new DataEntities()) { foreach (var item in routeDatas) { if (item == null) { continue; } item.CreatedDate = DateTime.Now; item.LastUpdatedDate = DateTime.Now; dbContext.RouteDatas.AddObject(item); } dbContext.SaveChanges(); } return routeDatas; }
public CIDRSettingModel Add(CIDRSettingModel model) { if (model == null) { throw new MobileException("非法的CIDRSettingModel参数,model 不能为空."); } model.ID = Guid.NewGuid().ToString(); cidrsetting item = new cidrsetting { ID = model.ID, CreatedBy = model.CreatedBy, CreatedDate = DateTime.Now, LastUpdatedBy = model.CreatedBy, LastUpdatedDate = DateTime.Now, IPStart = model.IPStart, IPStartNum = IPHelper.IPToNumber(model.IPStart), IPEnd = model.IPEnd, IPEndNum = IPHelper.IPToNumber(model.IPEnd), TCPPort = model.TCPPort, TTLThreshold = model.TTLFaZhi, TCPThreshold = model.TCPFaZhi, TTLExceptionKeys = model.TTLExceptionKeys }; using (var dbContext = new DataEntities()) { dbContext.cidrsettings.AddObject(item); dbContext.SaveChanges(); } return model; }
public List<IPScanResult> QueryIPScanResults(DateTime start, DateTime end, string ip, string tcpStatus, string ttlStatus, int pageIndex = 0, int pageSize = 20) { List<IPScanResult> result = new List<IPScanResult>(); List<ipscanresults> dbResult = null; using (var dbContext = new DataEntities()) { dbResult = dbContext.ipscanresults.Where(t => (String.IsNullOrEmpty(tcpStatus) ? true : t.TCPValidation.Equals(tcpStatus, StringComparison.OrdinalIgnoreCase)) && (String.IsNullOrEmpty(ttlStatus) ? true : t.TTLValidation.Equals(ttlStatus, StringComparison.OrdinalIgnoreCase)) && (String.IsNullOrEmpty(ip) ? true : t.IP == ip) && (t.CreatedDate >= start && t.CreatedDate <= end)) .OrderByDescending(t => t.CreatedDate).ThenBy(t=>t.IP) .Skip(pageIndex * pageSize).Take(pageSize).ToList(); } int index = pageIndex * pageSize; foreach (var r in dbResult) { IPScanResult item = new IPScanResult { Seq = ++index, IP = r.IP, CreatedDate = r.CreatedDate, TCPResponseTime = r.TCPTime, TCPValidationResult = r.TCPValidation, TTLValidationResult = r.TTLValidation }; result.Add(item); } return result; }
public void AddIPScanResults(List<IPScanResult> results) { if (results == null || results.Count == 0) { throw new MobileException("非法的results参数,results 不能为空."); } using (var dbContext = new DataEntities()) { foreach (var item in results) { var dbItem = new ipscanresults { CreatedBy = item.CreatedBy, CreatedDate = DateTime.Now, LastUpdatedBy = item.LastUpdatedBy, LastUpdatedDate = DateTime.Now, IP = item.IP, TCPTime = item.TCPResponseTime, TCPValidation = item.TCPValidationResult, TTLValidation = item.TTLValidationResult }; dbContext.ipscanresults.AddObject(dbItem); } dbContext.SaveChanges(); } }
public List<CIDRSettingModel> GetSettings(int pageIndex, int pageSize) { List<CIDRSettingModel> result = new List<CIDRSettingModel>(); List<cidrsetting> dbSettings = new List<cidrsetting>(); using (var dbContext = new DataEntities()) { dbSettings = dbContext.cidrsettings .OrderBy(c => c.IPStartNum) .Skip(pageIndex * pageSize) .Take(pageSize) .ToList(); } foreach (var c in dbSettings) { var b = new CIDRSettingModel(); b.CreatedBy = c.CreatedBy; b.CreatedDate = c.CreatedDate; b.ID = c.ID; b.IPEnd = c.IPEnd; b.IPStart = c.IPStart; b.LastUpdatedBy = c.LastUpdatedBy; b.LastUpdatedDate = c.LastUpdatedDate; b.TCPFaZhi = c.TCPThreshold; b.TCPPort = c.TCPPort; b.TTLFaZhi = c.TTLThreshold; b.TTLExceptionKeys = c.TTLExceptionKeys; b.IPStartNum = c.IPStartNum; b.IPEndNum = c.IPEndNum; result.Add(b); } return result; }
public int GetRowTotal() { int count = 0; using (var dbContext = new DataEntities()) { count = dbContext.cidrsettings.Count(); } return count; }
public User GetUser(string loginName) { User user = null; using (var dbContext = new DataEntities()) { user = dbContext.Users.Where(u => u.UserName.Equals(loginName, StringComparison.OrdinalIgnoreCase)).FirstOrDefault(); } return user; }
public token GetTokenModel(string token) { token tokenModel = null; using (var dbContext = new DataEntities()) { tokenModel = dbContext.Tokens.Where(t => t.Token == token).FirstOrDefault(); } return tokenModel; }
public void DeleteTokens(string userName) { using (var dbContext = new DataEntities()) { foreach (var item in dbContext.Tokens.Where(t => t.UserName == userName)) { dbContext.DeleteObject(item); } dbContext.SaveChanges(); } }
public void DeleteUser(string userId) { using (var dbContext = new DataEntities()) { var dbUser = dbContext.Users.Where(u => u.UserName.Equals(userId, StringComparison.OrdinalIgnoreCase)).FirstOrDefault(); if (dbUser != null) { dbContext.DeleteObject(dbUser); dbContext.SaveChanges(); } } }
public List<LoginRecord> Query(string userName, DateTime loginDateStart, DateTime loginDateEnd) { List<LoginRecord> result = null; using (var dbContext = new DataEntities()) { result = dbContext.LoginRecords.Where(t => t.UserName.Contains(userName) && t.LoginDate >= loginDateStart && t.LoginDate <= loginDateEnd).ToList(); } return result; }
public ClientIP Add(ClientIP clientIP) { clientIP.CreatedDate = DateTime.Now; clientIP.LastUpdatedDate = DateTime.Now; using (var dbContext = new DataEntities()) { dbContext.ClientIPs.AddObject(clientIP); dbContext.SaveChanges(); } return clientIP; }
public void DeleteSetting(string id) { using (var dbContext = new DataEntities()) { var dbSetting = dbContext.cidrsettings.Where(c => c.ID.Equals(id, StringComparison.OrdinalIgnoreCase)).FirstOrDefault(); if (dbSetting != null) { dbContext.DeleteObject(dbSetting); dbContext.SaveChanges(); } } }
public LoginRecord GetLatestLoginRecord(string userName) { LoginRecord result = null; using (var dbContext = new DataEntities()) { result = dbContext.LoginRecords .Where(t =>t.UserName.Equals(userName,StringComparison.OrdinalIgnoreCase)) .OrderByDescending(t=>t.LoginDate) .FirstOrDefault(); } return result; }
public string NewToken(token tokenModel) { tokenModel.Token = Guid.NewGuid().ToString("N"); tokenModel.CreatedDate = DateTime.Now; tokenModel.ExpiredDate = DateTime.Now.AddYears(1); using (var dbContext = new DataEntities()) { dbContext.Tokens.AddObject(tokenModel); dbContext.SaveChanges(); } return tokenModel.Token; }
public IList<User> GetUsers(int pageIndex,int pageSize) { IList<User> result = null; using (var dbContext = new DataEntities()) { result = dbContext.Users .OrderBy(u=>u.UserName) .Skip(pageIndex * pageSize) .Take(pageSize) .ToList(); } return result; }
public void Add(LoginRecord loginRecord) { if (loginRecord == null) { return; } loginRecord.LoginDate = DateTime.Now; using (var dbContext = new DataEntities()) { dbContext.LoginRecords.AddObject(loginRecord); dbContext.SaveChanges(); } }
public int GetRowCount(string selectedRegion, string userName, DateTime start, DateTime end, int status) { int count = 0; using (var dbContext = new DataEntities()) { count = dbContext.ClientIPs.Where(t => (String.IsNullOrEmpty(userName) ? true : t.UserName.Equals(userName, StringComparison.OrdinalIgnoreCase)) && (String.IsNullOrEmpty(selectedRegion) ? true : t.ClientCity.Equals(selectedRegion, StringComparison.OrdinalIgnoreCase)) && (t.CreatedDate >= start && t.CreatedDate <= end) && (status == -1 ? true : t.Status == status)) .Count(); } return count; }
public int GetRowTotal(DateTime start, DateTime end, string IP, string tcpStatus, string ttlStatus) { int count = 0; using (var dbContext = new DataEntities()) { count = dbContext.ipscanresults.Where(t => (String.IsNullOrEmpty(tcpStatus) ? true : t.TCPValidation.Equals(tcpStatus, StringComparison.OrdinalIgnoreCase)) && (String.IsNullOrEmpty(ttlStatus) ? true : t.TTLValidation.Equals(ttlStatus, StringComparison.OrdinalIgnoreCase)) && (String.IsNullOrEmpty(IP) ? true : t.IP == IP) && (t.CreatedDate >= start && t.CreatedDate <= end)) .Count(); } return count; }
public IList<ClientIP> GetMonitorDatas(string selectedRegion, string userName, DateTime start,DateTime end,int pageIndex = 0, int pageSize = 20, int status = -1) { IList<ClientIP> result = null; using (var dbContext = new DataEntities()) { result = dbContext.ClientIPs.Where(t=> (String.IsNullOrEmpty(userName)? true : t.UserName.Equals(userName,StringComparison.OrdinalIgnoreCase)) && (String.IsNullOrEmpty(selectedRegion) ? true : t.ClientCity.Equals(selectedRegion,StringComparison.OrdinalIgnoreCase)) && (t.CreatedDate >= start && t.CreatedDate <= end) && (status == -1 ? true : t.Status == status )) .OrderByDescending(t=>t.CreatedDate) .Skip(pageIndex*pageSize).Take(pageSize).ToList(); } return result; }
public IPEntity RetriveIP(string ip) { if(!IsIPAddress(ip)) { return null; } long ipNum = ConvertIPToNumber(ip); ; IPEntity result = null; using (var dbContext = new DataEntities()) { result = dbContext.IPEntities.Where(t => ipNum >= t.IPStartNum && ipNum <= t.IPEndNum).FirstOrDefault(); } return result; }
public User AddUser(User user) { if (user == null) { throw new MobileException("非法的user参数,user 不能为空."); } using (var dbContext = new DataEntities()) { user.CreatedDate = DateTime.Now; user.LastUpdatedDate = DateTime.Now; dbContext.Users.AddObject(user); dbContext.SaveChanges(); } return user; }
public List<GroupByAccountAndStatusModel> GroupByAccount(string userName, DateTime start, DateTime end) { List<GroupByAccountAndStatusModel> result = null; using (var dbContext = new DataEntities()) { result = dbContext.ClientIPs. Where(t => (String.IsNullOrEmpty(userName) ? true : t.UserName.Equals(userName,StringComparison.OrdinalIgnoreCase)) && (t.CreatedDate >= start && t.CreatedDate <= end)) .GroupBy(g=>new {g.UserName,g.Status}) .OrderBy(g=>g.Key.UserName) .Select(g => new GroupByAccountAndStatusModel { UserName = g.Key.UserName, Status = g.Key.Status.HasValue ? g.Key.Status.Value : -1, Count = g.Count() }) .ToList(); } return result; }
public void ChangePassword(string userName, string newPassword) { if (String.IsNullOrWhiteSpace(userName)) { throw new Exception("参数userName不能为空。"); } using (var dbContext = new DataEntities()) { var dbUser = dbContext.Users.Where(u => u.UserName.Equals(userName, StringComparison.OrdinalIgnoreCase)).FirstOrDefault(); if (dbUser == null) { throw new Exception("该用户不存在!"); } else { dbUser.Password = newPassword; dbContext.SaveChanges(); } } }
public User Login(string userName, string md5Password) { User user = null; using (var dbContext = new DataEntities()) { user = (from u in dbContext.Users where u.UserName.Equals(userName) && u.Password.Equals(md5Password) select u).FirstOrDefault(); } return user; }
public void UpdateSetting(CIDRSettingModel model) { if (model == null || String.IsNullOrWhiteSpace(model.ID)) { throw new Exception("参数CIDRSettingModel不能为空。"); } using (var dbContext = new DataEntities()) { var dbSetting = dbContext.cidrsettings.Where(m => m.ID.Equals(model.ID, StringComparison.OrdinalIgnoreCase)).FirstOrDefault(); if (dbSetting == null) { throw new Exception("该CIDR设置不存在!"); } else { dbSetting.LastUpdatedBy = model.LastUpdatedBy; dbSetting.LastUpdatedDate = DateTime.Now; dbSetting.IPStart = model.IPStart; dbSetting.IPEnd = model.IPEnd; dbSetting.TCPPort = model.TCPPort; dbSetting.IPStartNum = IPHelper.IPToNumber(model.IPStart); dbSetting.IPEndNum = IPHelper.IPToNumber(model.IPEnd); dbSetting.TTLThreshold = model.TTLFaZhi; dbSetting.TCPThreshold = model.TCPFaZhi; dbSetting.TTLExceptionKeys = model.TTLExceptionKeys; dbContext.SaveChanges(); } } }
public void UpdateUser(User user) { if (user == null || String.IsNullOrWhiteSpace(user.UserName)) { throw new Exception("参数userName不能为空。"); } using (var dbContext = new DataEntities()) { var dbUser = dbContext.Users.Where(u => u.UserName.Equals(user.UserName, StringComparison.OrdinalIgnoreCase)).FirstOrDefault(); if (dbUser == null) { throw new Exception("该用户不存在!"); } else { dbUser.FullName = user.FullName; dbUser.Phone = user.Phone; dbUser.Description = user.Description; dbUser.City = user.City; dbContext.SaveChanges(); } } }