public virtual bool Update(object id, T updated)
{
Context.Update(updated);
Context.SaveChanges();
return(true);
}
public IActionResult save([FromBody] Models.Porciones porcion)
{
try
{
porcion.isLey = true;
if (!User.IsInRole("Admin"))
{
porcion.isLey = false;
porcion.Category = "Mis Porciones";
}
if (!porcion.Cantidad.HasValue)
{
porcion.Unidad = "";
}
porcion.OwnerId = this.User.FindFirstValue(ClaimTypes.NameIdentifier);
_context.Porciones.Add(porcion);
_context.SaveChanges();
return(Json(porcion.Id));
}
catch
{
return(Json(BadRequest()));
}
}
public IActionResult Post([FromBody] CategoriaTemp ctemp)
{
try
{
// validation
if (ctemp.Nome.Length <= 3)
{
Response.StatusCode = 400;
return(new ObjectResult(new { msg = "Nome precisa de mais de 3 caracteres." }));
}
if (ctemp.Descricao.Length <= 3)
{
Response.StatusCode = 400;
return(new ObjectResult(new { msg = "Descrição precisa de mais de 3 caracteres." }));
}
Categoria c = new Categoria();
c.Nome = ctemp.Nome;
c.Descricao = ctemp.Descricao;
database.Categorias.Add(c);
database.SaveChanges();
Response.StatusCode = 201;
return(new ObjectResult(""));
}
catch (Exception)
{
Response.StatusCode = 404;
return(new ObjectResult(""));
}
}
public Microsoft.AspNetCore.Mvc.IActionResult Create(string name)
{
_dataContext.Items.Add(new Data.Item {
Value = name
});
_dataContext.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// Asynchronous method that represents an HTTP POST method, which
/// allows data to be sent to the server in order to create and, in this case,
/// update a resource, in this case, the account type.
/// If the user is not authenticated, a page Not Found (404) is obtained.
/// If the user's account type is that of a customer and the model of the data
/// entered is valid, a new account change request is created and added to
/// the database. Finally, the user in question is notified, using the private
/// SendNotification method.
/// If the user's account type is that of a provider, the type of account is
/// changed to the type of customer account.
/// If the user's account type is none of the above, the user remains on the
/// form for changing the account type.
/// If the request to change the account is successful, the user is redirected
/// to the page where the updated information is reported.
/// </summary>
/// <returns>Returns a Task of an IActionResult</returns>
/// <seealso cref="Task"/>
/// <seealso cref="IActionResult"/>
public async Task <IActionResult> OnPostAsync()
{
var user = await _userManager.GetUserAsync(User);
if (user == null)
{
return(NotFound($"Unable to load user with ID '{_userManager.GetUserId(User)}'."));
}
if (User.IsInRole("Cliente") && ModelState.IsValid)
{
int idNew = 0;
try
{
idNew = _context.Request.OrderBy(r => r.RequestID).Select(r => r.RequestID).First() + 1;
}
catch (InvalidOperationException)
{
idNew = 1;
}
string descrip = Input.Description;
if (descrip == null || descrip.Equals(""))
{
descrip = "Não apresentou motivo.";
}
Request request = new()
{
RequisitionerID = user.Id,
RequestType = RequestType.ProvideServices,
Description = descrip,
CreationDateTime = DateTime.Now,
RequestStatus = RequestStatus.WaitingApproval, RejectionMotive = ""
};
_context.Request.Add(request);
_context.SaveChanges();
SendNotification(user);
}
else if (User.IsInRole("Prestador"))
{
await _userManager.RemoveFromRoleAsync(user, "Prestador");
await _userManager.AddToRoleAsync(user, "Cliente");
}
else
{
return(Page());
}
await _signInManager.RefreshSignInAsync(user);
_logger.LogInformation("O seu pedido foi enviado com sucesso.");
StatusMessage = "O seu pedido foi enviado com sucesso.";
return(RedirectToPage());
}
public IActionResult Create(ProductTypes productTypes)
{
if (ModelState.IsValid)
{
_db.Add(productTypes);
_db.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
return(View());
}
public ActionResult Create([Bind(Include = "Id,Descripcion,Estado")] UnidadMedida unidadMedida)
{
if (ModelState.IsValid)
{
db.UnidadMedidas.Add(unidadMedida);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(unidadMedida));
}
public bool AddUserDetails(ApplicationUser user)
{
try
{
_db.ApplicationUser.Add(user);
_db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
public Messages AddMessage(ApplicationUser fromUser, ApplicationUser toUser, string message)
{
var msg = new Messages
{
FromId = fromUser.Id,
ToId = toUser.Id,
Message = message,
TimeStamp = DateTime.Now
};
_db.Messages.Add(msg);
_db.SaveChanges();
return(msg);
}
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 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);
}
// Atualiza todas as informações da Entidade.
public void AlterarProdutoTodasPropriedades(Produto produto)
{
using var db = new Data.ApplicationDbContext();
db.Update(produto);
db.SaveChanges();
}
public void AdicionarProdutosMassa(List <Produto> produtos)
{
using var db = new Data.ApplicationDbContext();
db.AddRange(produtos);
db.SaveChanges();
}
public void AdicionarProduto(Produto produto)
{
using var db = new Data.ApplicationDbContext();
db.Add(produto);
db.SaveChanges();
}
public IActionResult Save([FromBody] Models.Proximales proximal)
{
try
{
proximal.OwnerId = this.User.FindFirstValue(ClaimTypes.NameIdentifier);
proximal.Porcion = _context.Porciones.Where(x => x.Id == proximal.PorcionId).First();
_context.Proximales.Add(proximal);
_context.SaveChanges();
return(Ok(proximal.Id));
}
catch
{
return(BadRequest());
}
}
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);
}
}
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 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();
}
}
/// <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 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 }));
}
}
public IActionResult Registro([FromBody] Usuario usuario)
{
//Verificar se as credenciais são válidas
//Verificar se o e-mail já está cadastrado no banco
//Encriptar a senha
database.Add(usuario);
database.SaveChanges();
return(Ok(new { msg = "Usuário cadastrado com sucesso!" }));
}
public void ExcluirProduto(Produto produto)
{
using var db = new Data.ApplicationDbContext();
var produtoExcluir = db.Produtos.Find(produto.Id);
db.Remove(produtoExcluir);
db.SaveChanges();
}
// Atualiza apenas a informação alterada.
public void AlterarProduto(Produto produto)
{
using var db = new Data.ApplicationDbContext();
var produtoAlterar = db.Produtos.Find(produto.Id);
produtoAlterar.Nome = produto.Nome;
db.SaveChanges();
}
public IActionResult Post([FromBody] GeneroTemp gtemp)
{
// validation
if (gtemp.Nome.Length <= 3)
{
Response.StatusCode = 400;
return(new ObjectResult(new { msg = "Nome precisa de mais de 3 caracteres." }));
}
Genero g = new Genero();
g.Nome = gtemp.Nome;
database.Genero.Add(g);
database.SaveChanges();
Response.StatusCode = 201;
return(new ObjectResult(""));
}
public async Task <IActionResult> DepositMoney(DepositMoneyViewModel model)
{
if (model.CreditCardNumber == "this is not valid")
{
return(BadRequest("Not enough money"));
}
if (model.CreditCardVerificationCode == "wrong code")
{
return(BadRequest("Please check verification code"));
}
var user = await _userManager.GetUserAsync(HttpContext.User);
user.Wallet += model.AmountToDeposit;
_context.Update(user);
_context.SaveChanges();
return(View());
}
public async Task <IActionResult> AddandRemoveSchedule(Schedule s)
{
try
{
var user = await GetCurrentUserAsync();
var userId = user?.Id;
var slots = _context.Student.Where(p => p.IdentityId.Equals(userId)).FirstOrDefault();
s.StudentId = slots.Id;
var schedule = _context.Slots.Where(p => p.Id == s.SlotId).FirstOrDefault();
var studentslotvalidation = _context.Schedule.Where(p => p.StudentId.Equals(s.StudentId) && p.Date == schedule.ScheduleDateTime && schedule.Id != p.SlotId).FirstOrDefault();
if (studentslotvalidation == null)
{
var slot = _context.Schedule.Where(p => p.StudentId.Equals(s.StudentId) && p.Date == s.Date).FirstOrDefault();
if (slot == null)
{
s.CreatedBy = "test";
s.CreatedDate = System.DateTime.Now;
s.UpdatedBy = "test1";
s.UpdatedDate = System.DateTime.Now;
_context.Add(s);
_context.SaveChanges();
return(Json(new { success = true }));
}
else
{
_context.Remove(slot);
_context.SaveChanges();
return(Json(new { success = false }));
}
}
else
{
return(Json(new { success = studentslotvalidation }));
}
}
catch (Exception ex)
{
throw ex;
}
}
public IActionResult Index()
{
MailSetting cms;
cms = context.MailSettings.FirstOrDefault();
if (cms == null)
{
cms = new MailSetting();
cms.FromAddress = "*****@*****.**";
cms.FromAddressPassword = "******";
cms.FromAddressTitle = "Cv Havuzu";
cms.Subject = "Ýletiþim";
cms.BodyContent = "Mesajýnýz Bize Ýletilmiþtir. Ýlginiz Ýçin Teþekkür Ederiz";
cms.SmptServer = "smtp.gmail.com";
cms.SmptPortNumber = 587;
cms.UseSSL = false;
context.Add(cms);
context.SaveChanges();
}
return(View(cms));
}
public IActionResult save([FromBody] Ingredientes ingrediente)
{
ingrediente.OwnerId = this.User.FindFirstValue(ClaimTypes.NameIdentifier);
ingrediente.Id = 0;
if (!User.IsInRole("Admin"))
{
ingrediente.Certificate = false;
}
try {
_context.Ingredientes.Add(ingrediente);
_context.SaveChanges();
return(Ok(ingrediente.Id));
}
catch
{
return(BadRequest());
}
}
public IActionResult SaveTarea()
{
//Tareas entity = new Tareas() {
// Nombre = tarea.Nombre,
// Detalle = tarea.Detalle,
// fecharegistro = tarea.fecharegistro,
// idPrioridad = 1
//};
ctx.Tareas.Add(tarea);
ctx.SaveChanges();
return(RedirectToAction("Index"));
}