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<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 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 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 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 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 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 void Add(LoginRecord loginRecord)
{
if (loginRecord == null)
{
return;
}
loginRecord.LoginDate = DateTime.Now;
using (var dbContext = new DataEntities())
{
dbContext.LoginRecords.AddObject(loginRecord);
dbContext.SaveChanges();
}
}
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 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 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();
}
}
}