public bool Add(Data.ApplicationDbContext context)
{
try
{
var survey = new Data.Survey {
Title = this.Title
};
context.Surveys.Add(survey);
context.SaveChanges();
if (this.Childs != null)
{
foreach (var child in this.Childs)
{
child.Add(context);
}
}
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// Generates a report of a specific site's information
/// </summary>
/// <param name="siteId">The site to generate a report of</param>
/// <returns>Json value containing all information pertaining to specific site</returns>
private JsonResult SiteInfo(int siteId)
{
using (var context = new Data.ApplicationDbContext()) {
Models.Site dbSite = context.Sites.AsNoTracking().FirstOrDefault(s => s.SiteId == siteId);
if (dbSite == null)
{
return(Json(new { status_code = 1, status = "Site '" + siteId + "' does not exist." }));
}
//#if LOCAL
// using (MySqlConnection conn = new MySqlConnection(Startup.Configuration.GetConnectionString("LocalDatabase"))) {
//#else
// using (MySqlConnection conn = new MySqlConnection(Startup.Configuration.GetConnectionString("Database"))) {
//#endif
// conn.Open();
// MySqlCommand cmd = new MySqlCommand("");
// using (var reader = cmd.ExecuteReader()) {
// while (reader.Read()) {
// }
// }
// }
Models.Activation activation = context.Activations.AsNoTracking().FirstOrDefault(a => a.SiteId == siteId);;
Models.System system = context.Systems.AsNoTracking().FirstOrDefault(sys => sys.Id == dbSite.SystemId);
return(Json(new { status_code = 0, site = dbSite, activation, system }));
}
}
/// <summary>Sets a user's permission to view a site</summary>
/// <param name="userId">The user to give/take permission from</param>
/// <param name="siteId">The site to give/take permission from</param>
/// <param name="hasAccess">Sets whether user has access to site or not</param>
/// <returns>Json object with <code>status_code</code> of event (0 = success)</returns>
private JsonResult SetPermission(int userId, int siteId, int?access)
{
using (var context = new Data.ApplicationDbContext()) {
Models.User user = context.Users.AsNoTracking().FirstOrDefault(u => u.Id == userId);
if (user == null)
{
return(Json(new { status_code = 2, status = "Cannot create permission for user '" + userId + "'; user doesn't exist" }));
}
Models.Permission permission = context.Permissions.FirstOrDefault(p => p.UserId == userId && p.SiteId == siteId);
if (permission != null && (access.HasValue && access.Value == 0))
{
context.Permissions.Remove(permission);
}
else if (permission == null && (access.HasValue && access.Value == 1))
{
permission = new Models.Permission {
UserId = userId,
SiteId = siteId,
Access = 1,
};
context.Permissions.Add(permission);
}
context.SaveChanges();
return(Json(new { status_code = 0, permission }));
}
}
public ProjectController(Data.ApplicationDbContext context)
{
_context = context;
_tasks = from t in _context.Tasks
where t.UserId == User.FindFirst(ClaimTypes.NameIdentifier).Value
select t;
}
public IndexModel(Models.CoreTaskManagerContext context, Data.ApplicationDbContext userContext)
{
_context = context;
_userContext = userContext;
// 一ページに表示する項目の量
_pageSize = 6;
}
public JsonResult DeleteAdjustment(int adjustmentId)
{
using (var context = new Data.ApplicationDbContext()) {
String authUserId = User.GetClaim(OpenIdConnectConstants.Claims.Subject);
User authUser = context.Users.AsNoTracking().FirstOrDefault(u => u.Id.ToString().Equals(authUserId));
if (authUser == null)
{
return(Json(new { status_code = 2, status = "User '" + authUserId + "' does not exist" }));
}
if (!Helpers.PermissionChecker.CanDoAdjustments(authUser))
{
return(Json(new { status_code = 1, status = "User '" + authUser.UserName + "' cannot do adjustments" }));
}
Adjustment adjustment = context.Adjustments.FirstOrDefault(a => a.Id == adjustmentId);
if (adjustment == null)
{
return(Json(new { status_code = 2, status = "Adjustment '" + adjustmentId + "' does not exist" }));
}
if (adjustment.Completed && authUser.Level != 10)
{
return(Json(new { status_code = 1, status = "Only administrators can delete completed adjustments" }));
}
context.Adjustments.Remove(adjustment);
context.SaveChanges();
Helpers.LogHelper.LogAction(Log.ActionType.DeleteAdjustment, authUser.Id, adjustmentId,
String.Format("{0} (id: {1}) deleted adjustment {2}", authUser.UserName, authUser.Id, adjustmentId));
return(Json(new { status_code = 0 }));
}
}
// Atualiza todas as informações da Entidade.
public void AlterarProdutoTodasPropriedades(Produto produto)
{
using var db = new Data.ApplicationDbContext();
db.Update(produto);
db.SaveChanges();
}
public UserAdminController(Data.ApplicationDbContext context, IServiceProvider serviceProvider, UserManager <ChatUserModel> userManager, RoleManager <IdentityRole> roleManager)
{
_context = context;
_serviceProvider = serviceProvider;
_userManager = userManager;
_roleManager = roleManager;
}
public void AdicionarProduto(Produto produto)
{
using var db = new Data.ApplicationDbContext();
db.Add(produto);
db.SaveChanges();
}
public void AdicionarProdutosMassa(List <Produto> produtos)
{
using var db = new Data.ApplicationDbContext();
db.AddRange(produtos);
db.SaveChanges();
}
public List <Produto> ConsultarProdutosPorNomeUsandoProcedure(string nome, decimal valor)
{
#region Declarar Parâmetros
SqlParameter pNome = new SqlParameter("@nome", SqlDbType.VarChar, 50);
SqlParameter pValor = new SqlParameter("@valor", SqlDbType.Decimal);
pValor.Precision = 18;
pValor.Scale = 2;
#endregion
#region Atribuir valor aos parâmetros
pNome.Value = nome;
pValor.Value = valor;
#endregion
using var db = new Data.ApplicationDbContext();
return(db.Produtos
.FromSqlRaw($"consultarprodutopornome @nome,@valor", pNome, pValor)
.ToList());
//return db.Produtos
// .FromSqlRaw($"ConsultarProdutoPorNome '{nome}',{valor}")
// .ToList();
}
/// <summary>Gets a specific activation</summary>
/// <param name="formId"></param>
/// <returns></returns>
private JsonResult GetActivation(int formId)
{
using (var context = new Data.ApplicationDbContext()) {
// Verify user exists & has permission
String authUserId = User.GetClaim(OpenIdConnectConstants.Claims.Subject);
Models.User authUser = context.Users.AsNoTracking().FirstOrDefault(u => u.Id.ToString().Equals(authUserId));
if (authUser == null)
{
return(Json(new { status_code = 2, status = "User '" + authUserId + "' does not exist" }));
}
if (!Helpers.PermissionChecker.IsTechOrAdmin(authUser) && !Helpers.PermissionChecker.IsBillingDepartment(authUser))
{
return(Json(new { status_code = 1, status = "User '" + authUser.UserName + "' does not have permission to view activations" }));
}
// Verify activation form exists, and if so, return form
Models.Activation activation = context.Activations.AsNoTracking().FirstOrDefault(a => a.ActivationId == formId);
if (activation == null)
{
return(Json(new { status_code = 2, status = "Activation '" + formId + "' does not exist" }));
}
return(Json(new { status_code = 0, activation }));
}
}
public ContactsViewComponent(SignInManager <IdentityUser> signInManager, UserManager <IdentityUser> userManager, Data.ApplicationDbContext db)
{
_signInManager = signInManager;
_userManager = userManager;
_db = db;
_dbUserManager = new Core.UserManager(_db);
}
protected override void Seed(Data.ApplicationDbContext context)
{
var cursus1 = new Cursus {
Id = 1, Duur = "5 dagen", Code = "ABC", Titel = "cursus 1"
};
var cursus2 = new Cursus {
Id = 2, Duur = "3 dagen", Code = "KLM", Titel = "cursus 2"
};
var cursus3 = new Cursus {
Id = 3, Duur = "2 dagen", Code = "XYZ", Titel = "cursus 3"
};
context.Cursussen.AddOrUpdate(x => x.Id,
cursus1, cursus2, cursus3
);
context.CursusInstanties.AddOrUpdate(x => x.Id,
new CursusInstantie {
Id = 1, StartDatum = new DateTime(2010, 10, 10), Cursus = cursus1
},
new CursusInstantie {
Id = 2, StartDatum = new DateTime(2011, 11, 11), Cursus = cursus1
},
new CursusInstantie {
Id = 3, StartDatum = new DateTime(2010, 05, 05), Cursus = cursus2
},
new CursusInstantie {
Id = 4, StartDatum = new DateTime(2010, 08, 08), Cursus = cursus3
},
new CursusInstantie {
Id = 5, StartDatum = new DateTime(2012, 12, 12), Cursus = cursus2
}
);
}
public static bool LogAction(Models.Log log)
{
if (log.Description.Length == 0)
{
log.Description = "[NO DESCRIPTION GIVEN]";
}
if (log.UserId <= 0)
{
log.Description = "[INVALID USER] " + log.Description;
}
if (log.ModifiedId <= 0)
{
log.Description = "[INVALID MODIFIED ID] " + log.Description;
}
if (log.Changes.Length == 0 && (log.Action == Models.Log.ActionType.ModifyInstaller || log.Action == Models.Log.ActionType.ModifyManager ||
log.Action == Models.Log.ActionType.ModifySite || log.Action == Models.Log.ActionType.ModifyUser))
{
log.Description = "[NO CHANGES GIVEN] " + log.Description;
log.Changes = "[NO CHANGES GIVEN]";
}
using (var context = new Data.ApplicationDbContext()) {
context.Add(log);
context.SaveChanges();
}
return(true);
}
public bool Add(Data.ApplicationDbContext context)
{
try
{
var question = new Data.Question {
Title = this.Title, SurveyId = this.ParentId
};
context.Questions.Add(question);
context.SaveChanges();
if (this.Childs != null)
{
foreach (var child in this.Childs)
{
child.Add(context);
}
}
return(true);
}
catch
{
return(false);
}
}
public void BinanceUpdate(IServiceProvider serviceProvider)
{
using (var context = new Data.ApplicationDbContext(
serviceProvider.GetRequiredService <
DbContextOptions <Data.ApplicationDbContext> >()))
{
var BinanceCoins = CoinsGet();
foreach (var Coin in BinanceCoins.Data.OrderBy(o => o.Symbol))
{
var coinExists = context.Coin.Where(o => o.Exchange == "Binance" && o.Pair == Coin.Symbol).FirstOrDefault();
if (coinExists == null)
{
Coin coin = new Coin()
{
Exchange = "Binance", Pair = Coin.Symbol, CurrentPrice = Coin.LastPrice, PriceChange = Coin.PriceChangePercent, Volume = Coin.Volume, LastUpdated = DateTime.Now
};
context.Coin.Add(coin);
}
else
{
coinExists.CurrentPrice = Coin.LastPrice;
coinExists.PriceChange = Coin.PriceChangePercent;
coinExists.Volume = Coin.Volume;
coinExists.LastUpdated = DateTime.Now;
}
context.SaveChanges();
}
}
}
public Register(Data.ApplicationDbContext db)
{
_db = db;
userExistInDatabase = false;
ChangeLogin = false;
changeEmail = false;
}
public JsonResult GetAdjustments([RequiredFromQuery] int status)
{
using (var context = new Data.ApplicationDbContext()) {
String authUserId = User.GetClaim(OpenIdConnectConstants.Claims.Subject);
Models.User authUser = context.Users.AsNoTracking().FirstOrDefault(u => u.Id.ToString().Equals(authUserId));
if (authUser == null)
{
return(Json(new { status_code = 2, status = "Unknown user '" + authUserId + "'" }));
}
if (!Helpers.PermissionChecker.CanDoAdjustments(authUser))
{
return(Json(new { status_code = 1, status = "User '" + authUser.UserName + "' cannot do adjustments" }));
}
if (status == 0)
{
return(Json(new { status_code = 0, report = context.PlayerAdjustments.AsNoTracking().Where(pa => !pa.CompletedTime.HasValue).ToList() }));
}
else if (status == 1)
{
return(Json(new { status_code = 0, report = context.PlayerAdjustments.AsNoTracking().ToList() }));
}
else
{
return(Json(new { status_code = 5, status = "Unknown status code '" + status + "'" }));
}
}
}
public JsonResult GetPlayer(int id, [RequiredFromQuery] int status)
{
using (var context = new Data.ApplicationDbContext()) {
String authUserId = User.GetClaim(OpenIdConnectConstants.Claims.Subject);
Models.User authUser = context.Users.AsNoTracking().FirstOrDefault(u => u.Id.ToString().Equals(authUserId));
if (authUser == null)
{
return(Json(new { status_code = 2, status = "User '" + authUserId + "' does not exist" }));
}
if (status == 0)
{
Models.Player player = context.Players.AsNoTracking().FirstOrDefault(p => p.CardId == id);
if (player == null)
{
return(Json(new { status_code = 2, status = "Player '" + id + "' does not exist" }));
}
return(Json(new { status_code = 0, player }));
}
else if (status == 1)
{
return(Json(new { status_code = 0, report = context.Players.AsNoTracking().Where(p => p.SiteId == id && !String.IsNullOrWhiteSpace(p.PersonalId)).ToList() }));
}
else
{
return(Json(new { status_code = -1 }));
}
}
}
public LoginModel(IHttpContextAccessor accessor, SignInManager <UsuarioApp> signInManager, ILogger <LoginModel> logger, Data.ApplicationDbContext context)
{
_accessor = accessor;
_signInManager = signInManager;
_logger = logger;
_context = context;
}
public AdminController(Data.ApplicationDbContext context, IServiceProvider serviceProvider, IConfiguration configuration)
{
_context = context;
_serviceProvider = serviceProvider;
_configuration = configuration;
random = new Random(DateTime.Now.Second * DateTime.Now.Millisecond / DateTime.Now.Hour);
}
public JsonResult GetSite(int siteId)
{
using (var context = new Data.ApplicationDbContext()) {
String authUserId = User.GetClaim(OpenIdConnectConstants.Claims.Subject);
Models.User authUser = context.Users.AsNoTracking().FirstOrDefault(u => u.Id.ToString().Equals(authUserId));
if (authUser == null)
{
return(Json(new { status_code = 2, status = "User '" + authUserId + "' does not exist" }));
}
if (Helpers.PermissionChecker.IsTechOrAdmin(authUser) || Helpers.PermissionChecker.IsBillingDepartment(authUser))
{
return(SiteInfo(siteId));
}
else
{
Models.Permission permission = context.Permissions.AsNoTracking().FirstOrDefault(p => p.UserId == authUser.Id && p.SiteId == siteId);
if (permission != null)
{
return(SiteInfo(siteId));
}
return(Json(new { status_code = 1, status = "User does not have permission to view site '" + siteId + "'" }));
}
}
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new Data.ApplicationDbContext(
serviceProvider.GetRequiredService <
DbContextOptions <Data.ApplicationDbContext> >()))
{
if (context.Kwiat.Any())
{
return; // DB has been seeded
}
context.Kwiat.AddRange(
new Kwiat
{
Nazwa = "Roza",
Price = 7.99M
},
new Kwiat
{
Nazwa = "Stokrotka",
Price = 7.99M
}
);
context.SaveChanges();
}
}
public LoginModel(Data.ApplicationDbContext context, SignInManager <ApplicationUser> signInManager, ILogger <LoginModel> logger, RoleManager <ApplicationRole> roleManager)
{
_signInManager = signInManager;
_logger = logger;
_context = context;
_roleManager = roleManager;
}
public JsonResult Get([RequiredFromQuery] int status)
{
using (var context = new Data.ApplicationDbContext()) {
String authUserId = User.GetClaim(OpenIdConnectConstants.Claims.Subject);
Models.User authUser = context.Users.AsNoTracking().FirstOrDefault(u => u.Id.ToString() == authUserId);
if (authUser == null)
{
return(Json(new { status_code = 2, status = "User '" + authUserId + "' does not exist" }));
}
switch (status)
{
case 0: // distrib list
return(GetDistributors());
case 1: // user list
return(GetUsers());
case 2: // authorized user info
return(GetUserInfo());
case 3: // owner list
return(GetOwners());
case 4: // users with permission level > 4
return(GetHighLevelUsers());
default:
return(Json(new { status_code = 6, status = "Unknown status code '" + status + "' for GET /api/users" }));
}
}
}
public JsonResult GetTicket(int id)
{
using (var context = new Data.ApplicationDbContext()) {
String authUserId = User.GetClaim(OpenIdConnectConstants.Claims.Subject);
Models.User authUser = context.Users.AsNoTracking().FirstOrDefault(u => u.Id.ToString().Equals(authUserId));
if (authUser == null)
{
return(Json(new { status_code = 2, status = "User '" + authUserId + "' does not exist" }));
}
Models.Ticket ticket = context.Tickets.AsNoTracking().FirstOrDefault(t => t.Id == id);
if (ticket == null)
{
return(Json(new { status_code = 2, status = "Ticket '" + id + "' does not exist" }));
}
if (authUser.Level >= 4)
{
return(Json(new { status_code = 0, ticket }));
}
else
{
Models.Permission permission = context.Permissions.AsNoTracking().FirstOrDefault(p => p.UserId == authUser.Id && p.SiteId == id);
if (permission == null || permission.Access == 0)
{
return(Json(new { status_code = 1, status = "User does not have permission to view this ticket" }));
}
return(Json(new { status_code = 0, ticket }));
}
}
}
public JsonResult CreateInstaller([FromBody] Models.Installer installer)
{
using (var context = new Data.ApplicationDbContext()) {
String authUserId = User.GetClaim(OpenIdConnectConstants.Claims.Subject);
Models.User authUser = context.Users.AsNoTracking().FirstOrDefault(u => u.Id.ToString().Equals(authUserId));
if (authUser == null)
{
return(Json(new { status_code = 2, status = "User '" + authUserId + "' does not exist" }));
}
if (!Helpers.PermissionChecker.CanAddSite(authUser))
{
return(Json(new { status_code = 1, status = "User '" + authUser.UserName + "' does not have permission to create installers" }));
}
if (installer.FName.Length == 0 && installer.LName.Length == 0)
{
return(Json(new { status_code = 4, status = "Installer must have at least a first or last name" }));
}
else if (installer.Phone.Length == 0)
{
return(Json(new { status_code = 4, status = "Installer must have a phone number" }));
}
context.Installers.Add(installer);
context.SaveChanges();
Helpers.LogHelper.LogAction(Models.Log.ActionType.CreateInstaller, authUser.Id, installer.Id,
String.Format("{0} (id: {1}) created installer '{2}' (id: {3})", authUser.UserName, authUser.Id, installer.FName + " " + installer.LName, installer.Id));
return(Json(new { status_code = 0, installer }));
}
}
public JsonResult GetInstallers()
{
using (var context = new Data.ApplicationDbContext()) {
String authUserId = User.GetClaim(OpenIdConnectConstants.Claims.Subject);
Models.User authUser = context.Users.AsNoTracking().FirstOrDefault(u => u.Id.ToString().Equals(authUserId));
if (authUser == null)
{
return(Json(new { status_code = 2, status = "User '" + authUserId + "' does not exist" }));
}
if (!Helpers.PermissionChecker.CanAddSite(authUser))
{
return(Json(new { status_code = 1, status = "User '" + authUser.UserName + "' does not have permission to view installers" }));
}
List <Models.Installer> installers = context.Installers.AsNoTracking().Where(i => i.Id > 0).ToList();
List <Object> report = new List <object>();
foreach (var installer in installers)
{
report.Add(new { installer.Email, installer.FName, installer.Id, installer.LName, installer.Phone, name = installer.FName + " " + installer.LName });
}
return(Json(new { status_code = 0, report }));
}
}
public TweetsController()
{
var context = new Data.ApplicationDbContext();
this.tweetsRepo = new EfGenericRepository <Tweet>(context);
this.tagsRepo = new EfGenericRepository <Tag>(context);
}
private IHttpActionResult ValidatePicture(FileModel file)
{
var dbContext = new Data.ApplicationDbContext();
if (file.ApplicationUserId == null ||
!dbContext.Users
.Any(x => x.Id == file.ApplicationUserId.ToString()))
{
return BadRequest("ApplicationUserId NOT FOUND");
}
if (file.Link == null || !file.Link.StartsWith("https://"))
{
return BadRequest("Invalid Url");
}
return Ok();
}