public List <Banned> GetLimit(Expression <Func <Banned, bool> > whereClause, int limit)
{
try
{
using (UBContext ubc = new UBContext())
{
if (whereClause == null)
{
return(ubc.Users_Banned
.AsNoTracking()
.OrderByDescending(x => x.UtcDate).Skip(0).Take(limit)
.ToList());
}
return(ubc.Users_Banned
.AsNoTracking()
.Where(whereClause)
.OrderByDescending(x => x.UtcDate).Skip(0).Take(limit)
.ToList());
}
}
catch
{
return(new List <Banned>());
}
}
public TelegramGroup Update(TelegramGroup telegramGroup, int callerId)
{
using (UBContext ubc = new UBContext())
{
TelegramGroup exists = ubc.Group_TelegramGroups
.Where(x => x.GroupId == telegramGroup.GroupId)
.FirstOrDefault();
if (exists == null)
{
return(null);
}
try
{
exists.TelegramChatId = telegramGroup.TelegramChatId;
exists.Title = telegramGroup.Title;
exists.State = telegramGroup.State;
exists.Configuration = telegramGroup.Configuration;
exists.WelcomeText = telegramGroup.WelcomeText;
exists.ChatLanguage = telegramGroup.ChatLanguage;
exists.SettingsLanguage = telegramGroup.SettingsLanguage;
exists.ReportChatId = telegramGroup.ReportChatId;
exists.RulesText = telegramGroup.RulesText;
ubc.SaveChanges();
return(telegramGroup);
}
catch (Exception ex)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban",
Date = DateTime.Now,
Function = "Unifiedban.Data.TelegramGroupService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.Message,
UserId = callerId
});
if (ex.InnerException != null)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban.Data",
Date = DateTime.Now,
Function = "Unifiedban.Data.TelegramGroupService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.InnerException.Message,
UserId = callerId
});
}
}
return(null);
}
}
public BadImage Update(BadImage badImage, int callerId)
{
using (UBContext ubc = new UBContext())
{
BadImage exists = ubc.BadImages
.Where(x => x.BadImageId == badImage.BadImageId)
.FirstOrDefault();
if (exists == null)
{
return(null);
}
try
{
exists.GroupId = badImage.GroupId;
exists.HashData = badImage.HashData;
exists.ParentImageId = badImage.ParentImageId;
exists.FlipType = badImage.FlipType;
exists.Status = badImage.Status;
exists.Match = badImage.Match;
ubc.SaveChanges();
return(badImage);
}
catch (Exception ex)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban",
Date = DateTime.Now,
Function = "Unifiedban.Data.BadImageService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.Message,
UserId = callerId
});
if (ex.InnerException != null)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban.Data",
Date = DateTime.Now,
Function = "Unifiedban.Data.BadImageService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.InnerException.Message,
UserId = callerId
});
}
}
return(null);
}
}
public BadWord Update(BadWord badWord, int callerId)
{
using (UBContext ubc = new UBContext())
{
BadWord exists = ubc.BadWords
.Where(x => x.BadWordId == badWord.BadWordId)
.FirstOrDefault();
if (exists == null)
{
return(null);
}
try
{
exists.Name = badWord.Name;
exists.GroupId = badWord.GroupId;
exists.Regex = badWord.Regex;
exists.Status = badWord.Status;
exists.Match = badWord.Match;
ubc.SaveChanges();
return(badWord);
}
catch (Exception ex)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban",
Date = DateTime.Now,
Function = "Unifiedban.Data.BadWordService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.Message,
UserId = callerId
});
if (ex.InnerException != null)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban.Data",
Date = DateTime.Now,
Function = "Unifiedban.Data.BadWordService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.InnerException.Message,
UserId = callerId
});
}
}
return(null);
}
}
public SafeTName Update(SafeTName safeTName,
SafeTName newSafeTName, int callerId)
{
using (UBContext ubc = new UBContext())
{
SafeTName exists = ubc.SafeTNames
.Where(x => x.Username == safeTName.Username &&
x.TelegramChatId == safeTName.TelegramChatId)
.FirstOrDefault();
if (exists == null)
{
return(null);
}
try
{
exists.Username = newSafeTName.Username;
exists.TelegramChatId = newSafeTName.TelegramChatId;
ubc.SaveChanges();
return(safeTName);
}
catch (Exception ex)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban",
Date = DateTime.Now,
Function = "Unifiedban.Data.SafeTNameService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.Message,
UserId = callerId
});
if (ex.InnerException != null)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban.Data",
Date = DateTime.Now,
Function = "Unifiedban.Data.SafeTNameService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.InnerException.Message,
UserId = callerId
});
}
}
return(null);
}
}
public NightSchedule Update(NightSchedule nightSchedule, int callerId)
{
using (UBContext ubc = new UBContext())
{
NightSchedule exists = ubc.Group_NightSchedules
.Where(x => x.GroupId == nightSchedule.GroupId)
.FirstOrDefault();
if (exists == null)
{
return(null);
}
try
{
exists.State = nightSchedule.State;
exists.UtcStartDate = nightSchedule.UtcStartDate;
exists.UtcEndDate = nightSchedule.UtcEndDate;
ubc.SaveChanges();
return(nightSchedule);
}
catch (Exception ex)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban",
Date = DateTime.Now,
Function = "Unifiedban.Data.NightScheduleService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.Message,
UserId = callerId
});
if (ex.InnerException != null)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban.Data",
Date = DateTime.Now,
Function = "Unifiedban.Data.NightScheduleService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.InnerException.Message,
UserId = callerId
});
}
}
return(null);
}
}
public Flood Update(Flood flood, int callerId)
{
using (UBContext ubc = new UBContext())
{
Flood exists = ubc.Users_Flood
.Where(x => x.GroupId == flood.GroupId &&
x.TelegramUserId == flood.TelegramUserId)
.FirstOrDefault();
if (exists == null)
{
return(null);
}
try
{
exists.MessageCount = flood.MessageCount;
exists.UtcDate = flood.UtcDate;
ubc.SaveChanges();
return(flood);
}
catch (Exception ex)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban",
Date = DateTime.Now,
Function = "Unifiedban.Data.FloodService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.Message,
UserId = callerId
});
if (ex.InnerException != null)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban.Data",
Date = DateTime.Now,
Function = "Unifiedban.Data.FloodService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.InnerException.Message,
UserId = callerId
});
}
}
return(null);
}
}
public DashboardUser Update(DashboardUser dashboardUser, int callerId)
{
using (UBContext ubc = new UBContext())
{
DashboardUser exists = ubc.Group_DashboardUsers
.Where(x => x.DashboardUserId == dashboardUser.DashboardUserId)
.FirstOrDefault();
if (exists == null)
{
return(null);
}
try
{
exists.Name = dashboardUser.Name;
exists.ProfilePicture = dashboardUser.ProfilePicture;
exists.LastActionUtc = dashboardUser.LastActionUtc;
ubc.SaveChanges();
return(dashboardUser);
}
catch (Exception ex)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban",
Date = DateTime.Now,
Function = "Unifiedban.Data.DashboardUserService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.Message,
UserId = callerId
});
if (ex.InnerException != null)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban.Data",
Date = DateTime.Now,
Function = "Unifiedban.Data.DashboardUserService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.InnerException.Message,
UserId = callerId
});
}
}
return(null);
}
}
public ConfigurationParameter Update(ConfigurationParameter configurationParameter, int callerId)
{
using (UBContext ubc = new UBContext())
{
ConfigurationParameter exists = ubc.Group_ConfigurationParameters
.Where(x => x.ConfigurationParameterId == configurationParameter.ConfigurationParameterId)
.FirstOrDefault();
if (exists == null)
{
return(null);
}
try
{
exists.Value = configurationParameter.Value;
exists.Type = configurationParameter.Type;
exists.Values = configurationParameter.Values;
ubc.SaveChanges();
return(configurationParameter);
}
catch (Exception ex)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban",
Date = DateTime.Now,
Function = "Unifiedban.Data.ConfigurationParameterService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.Message,
UserId = callerId
});
if (ex.InnerException != null)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban.Data",
Date = DateTime.Now,
Function = "Unifiedban.Data.ConfigurationParameterService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.InnerException.Message,
UserId = callerId
});
}
}
return(null);
}
}
public Note Update(Note note, int callerId)
{
using (UBContext ubc = new UBContext())
{
Note exists = ubc.Group_Notes
.Where(x => x.NoteId == note.NoteId)
.FirstOrDefault();
if (exists == null)
{
return(null);
}
try
{
exists.GroupId = note.GroupId;
exists.Message = note.Message;
exists.Tag = note.Tag;
ubc.SaveChanges();
return(note);
}
catch (Exception ex)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban",
Date = DateTime.Now,
Function = "Unifiedban.Data.NoteService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.Message,
UserId = callerId
});
if (ex.InnerException != null)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban.Data",
Date = DateTime.Now,
Function = "Unifiedban.Data.NoteService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.InnerException.Message,
UserId = callerId
});
}
}
return(null);
}
}
public TrustFactor Update(TrustFactor trustFactor, int callerId)
{
using (UBContext ubc = new UBContext())
{
TrustFactor exists = ubc.Users_TrustFactor
.Where(x => x.TrustFactorId == trustFactor.TrustFactorId)
.FirstOrDefault();
if (exists == null)
{
return(null);
}
try
{
exists.Points = trustFactor.Points;
ubc.SaveChanges();
return(trustFactor);
}
catch (Exception ex)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban",
Date = DateTime.Now,
Function = "Unifiedban.Data.TrustFactorService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.Message,
UserId = callerId
});
if (ex.InnerException != null)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban.Data",
Date = DateTime.Now,
Function = "Unifiedban.Data.TrustFactorService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.InnerException.Message,
UserId = callerId
});
}
}
return(null);
}
}
public SystemLog.ErrorCodes Remove(SafeGroup safeGroup, int callerId)
{
using (UBContext ubc = new UBContext())
{
SafeGroup exists = ubc.Group_SafeGroups
.Where(x => x.GroupId == safeGroup.GroupId)
.FirstOrDefault();
if (exists == null)
{
return(SystemLog.ErrorCodes.Error);
}
try
{
ubc.Remove(exists);
ubc.SaveChanges();
return(SystemLog.ErrorCodes.OK);
}
catch (Exception ex)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban",
Date = DateTime.Now,
Function = "Unifiedban.Data.SafeGroupService.Remove",
Level = SystemLog.Levels.Warn,
Message = ex.Message,
UserId = callerId
});
if (ex.InnerException != null)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban.Data",
Date = DateTime.Now,
Function = "Unifiedban.Data.SafeGroupService.Remove",
Level = SystemLog.Levels.Warn,
Message = ex.InnerException.Message,
UserId = callerId
});
}
}
return(SystemLog.ErrorCodes.Error);
}
}
public SafeGroup Add(SafeGroup safeGroup, int callerId)
{
using (UBContext ubc = new UBContext())
{
try
{
ubc.Add(safeGroup);
ubc.SaveChanges();
return(safeGroup);
}
catch (Exception ex)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban",
Date = DateTime.Now,
Function = "Unifiedban.Data.SafeGroupService.Add",
Level = SystemLog.Levels.Warn,
Message = ex.Message,
UserId = callerId
});
if (ex.InnerException != null)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban.Data",
Date = DateTime.Now,
Function = "Unifiedban.Data.SafeGroupService.Add",
Level = SystemLog.Levels.Warn,
Message = ex.InnerException.Message,
UserId = callerId
});
}
}
return(null);
}
}
public List <SafeGroup> Get(Expression <Func <SafeGroup, bool> > whereClause)
{
try
{
using (UBContext ubc = new UBContext())
{
if (whereClause == null)
{
return(ubc.Group_SafeGroups
.AsNoTracking()
.ToList());
}
return(ubc.Group_SafeGroups
.AsNoTracking()
.Where(whereClause)
.ToList());
}
}
catch
{
return(new List <SafeGroup>());
}
}
public List <NightSchedule> Get(Expression <Func <NightSchedule, bool> > whereClause)
{
try
{
using (UBContext ubc = new UBContext())
{
if (whereClause == null)
{
return(ubc.Group_NightSchedules
.AsNoTracking()
.ToList());
}
return(ubc.Group_NightSchedules
.AsNoTracking()
.Where(whereClause)
.ToList());
}
}
catch
{
return(new List <NightSchedule>());
}
}
public List <ConfigurationParameter> Get(Expression <Func <ConfigurationParameter, bool> > whereClause)
{
try
{
using (UBContext ubc = new UBContext())
{
if (whereClause == null)
{
return(ubc.Group_ConfigurationParameters
.AsNoTracking()
.ToList());
}
return(ubc.Group_ConfigurationParameters
.AsNoTracking()
.Where(whereClause)
.ToList());
}
}
catch
{
return(new List <ConfigurationParameter>());
}
}
public List <DashboardUser> Get(Expression <Func <DashboardUser, bool> > whereClause)
{
try
{
using (UBContext ubc = new UBContext())
{
if (whereClause == null)
{
return(ubc.Group_DashboardUsers
.AsNoTracking()
.ToList());
}
return(ubc.Group_DashboardUsers
.AsNoTracking()
.Where(whereClause)
.ToList());
}
}
catch
{
return(new List <DashboardUser>());
}
}
public List <TrustFactor> Get(Expression <Func <TrustFactor, bool> > whereClause)
{
try
{
using (UBContext ubc = new UBContext())
{
if (whereClause == null)
{
return(ubc.Users_TrustFactor
.AsNoTracking()
.ToList());
}
return(ubc.Users_TrustFactor
.AsNoTracking()
.Where(whereClause)
.ToList());
}
}
catch
{
return(new List <TrustFactor>());
}
}
public List <BadImage> Get(Expression <Func <BadImage, bool> > whereClause)
{
try
{
using (UBContext ubc = new UBContext())
{
if (whereClause == null)
{
return(ubc.BadImages
.AsNoTracking()
.ToList());
}
return(ubc.BadImages
.AsNoTracking()
.Where(whereClause)
.ToList());
}
}
catch
{
return(new List <BadImage>());
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, UBContext db)
{
app.UseExceptionScheme(env)
.UseSwaggerService();
loggerFactory.AddNLog();
//AutoMapperHandler.UseAutoMapper();
app.UseHttpsRedirection();
app.UseMvc();
db.InitSeed();
}
public UserRepository(UBContext ubContext)
{
db = ubContext;
}
public Banned Add(Banned banned, int callerId)
{
using (UBContext ubc = new UBContext())
{
try
{
using (var transaction = ubc.Database.BeginTransaction())
{
try
{
ubc.Add(banned);
ubc.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.User_Banned ON;");
ubc.SaveChanges();
ubc.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.User_Banned OFF");
transaction.Commit();
return(banned);
}
catch (Exception ex)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban",
Date = DateTime.Now,
Function = "Unifiedban.Data.BannedService.Add",
Level = SystemLog.Levels.Warn,
Message = ex.Message,
UserId = callerId
});
if (ex.InnerException != null)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban.Data",
Date = DateTime.Now,
Function = "Unifiedban.Data.BannedService.Add",
Level = SystemLog.Levels.Warn,
Message = ex.InnerException.Message,
UserId = callerId
});
}
return(null);
}
}
}
catch (Exception ex)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban",
Date = DateTime.Now,
Function = "Unifiedban.Data.BannedService.Add",
Level = SystemLog.Levels.Warn,
Message = ex.Message,
UserId = callerId
});
if (ex.InnerException != null)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban.Data",
Date = DateTime.Now,
Function = "Unifiedban.Data.BannedService.Add",
Level = SystemLog.Levels.Warn,
Message = ex.InnerException.Message,
UserId = callerId
});
}
}
return(null);
}
}
