//добавить орагинизвцию public int OpenOrganization(OpenOrganizationRequestVm model) { if (model == null) { throw new ArgumentNullException($"{typeof(OpenOrganizationRequestVm).Name} is null"); } var checkOrganization = _aplicationDbContext.Organizations .SingleOrDefault(p => p.IdentificationNumber == model.IdentificationNumber || p.FullName == model.FullName); var checkOrganizationType = _aplicationDbContext.OrganizationTypes .SingleOrDefault(p => p.Name == model.OrganizationType); if (checkOrganization != null || checkOrganizationType == null) { throw new Exception("Model validation error!"); } Organization organization = new Organization() { FullName = model.FullName, IdentificationNumber = model.IdentificationNumber, OrganizationType = checkOrganizationType, RegistrationDate = DateTime.Now, Email = model.Email, PhoneNumber = model.PhoneNumber, Adress = model.Adress, LinkToSite = model.LinkToSite }; _aplicationDbContext.Organizations.Add(organization); _aplicationDbContext.SaveChanges(); return(organization.Id); }
public async Task <IActionResult> SalvaVagasEmpresa(entitymodel model) { _db.ParceiroEmpregos.Add(new ParceiroEmpregos { CreateDate = DateTime.Now, UpdateDate = DateTime.Now, AreaAtuacao = model.AreaAtuacao, Cargo = model.Cargo, Descricao = model.Descricao, FaixaSalarial = model.FaixaSalarial, HorarioTrabalho = model.HorarioTrabalho, NomeVaga = model.NomeVaga, IdEmpresa = int.Parse(model.Id) }); _db.Vagas.Add(new Vagas { CreateDate = DateTime.Now, UpdateDate = DateTime.Now, AvisosDaEmpresa = "", Descricao = model.Descricao, IdEmpresa = int.Parse(model.Id.ToString()), InformacoeAdicionais = "", NomeVaga = model.NomeVaga, Restricoes = "", ValorSalario = model.FaixaSalarial, EmailDeContato = model.EmailContato }); var parceiroUpdate = _db.Parceiro.Where(d => d.Id == int.Parse(model.Id)).SingleOrDefault(); parceiroUpdate.TOTAL_VAGAS_CADASTRADAS = (parceiroUpdate.TOTAL_VAGAS_CADASTRADAS == null ? (1).ToString() : (int.Parse(parceiroUpdate.TOTAL_VAGAS_CADASTRADAS) + 1).ToString()); _db.Parceiro.Update(parceiroUpdate); _db.SaveChanges(); return(Ok(true)); }
public async Task <IActionResult> PerfilVinculo(VinculoSistemaUsuario entityPerfil) { var retorno = _db.VinculoSistemaUsuario.Where(d => d.IdUsuario == entityPerfil.IdPerfil).SingleOrDefault(); if (retorno == null) { _db.VinculoSistemaUsuario.Add(new VinculoSistemaUsuario { CreateDate = DateTime.Now, UpdateDate = DateTime.Now, IdPerfil = entityPerfil.IdUsuario, IdSistema = entityPerfil.IdSistema, IdUsuario = entityPerfil.IdPerfil }); } else { var entityUpdate = new VinculoSistemaUsuario { CreateDate = DateTime.Now, UpdateDate = DateTime.Now, IdPerfil = entityPerfil.IdUsuario, IdSistema = entityPerfil.IdSistema, IdUsuario = entityPerfil.IdPerfil }; _db.VinculoSistemaUsuario.Update(entityUpdate); } _db.SaveChanges(); return(Ok("OK")); }
public ActionResult Post(long accion, [FromBody] Cliente usuario) { Encriptar encriptar = new Encriptar(); if (accion == 0) { try { String consena = encriptar.SHA256_Certificado(usuario.Pass); usuario.Pass = consena; usuario.Usuario = usuario.Usuario.ToUpper(); _context.Add(usuario); _context.SaveChanges(); return(Ok(usuario.Id)); } catch (Exception ex) { return(BadRequest(ex.Message)); } } else { Put(accion, usuario); return(Ok()); } }
public ActionResult Post(long accion, [FromBody] Cuenta cuenta) { if (accion == 0) { try { _context.Add(cuenta); _context.SaveChanges(); return(Ok()); } catch (Exception ex) { return(BadRequest(ex.Message)); } } else if (accion == 1) { AplicationDbContext db = new AplicationDbContext(); var consulta = from c in db.Cuentas where cuenta.Id == c.Id select c; foreach (var c in consulta) { cuenta.Monto = cuenta.Monto + c.Monto; } Put(cuenta.Id, cuenta); return(Ok()); } else { AplicationDbContext db = new AplicationDbContext(); var consulta = from c in db.Cuentas where cuenta.Id == c.Id select c; long antescuent = 0; long nueva = 0; foreach (var c in consulta) { antescuent = c.Monto; nueva = c.Monto - cuenta.Monto; if (nueva < 0) { return(BadRequest("Valor insuficiente")); } else { cuenta.Monto = nueva; } } Put(cuenta.Id, cuenta); return(Ok()); } }
public IActionResult Novo(Comercio comercio) { if (ModelState.IsValid) { _context.SaveChanges(); return(RedirectToAction("Index")); } return(View()); }
public IActionResult Novo(Gastronomia gastronomia) { if (ModelState.IsValid) { _context.SaveChanges(); return(RedirectToAction("Index")); } return(View()); }
public IActionResult Novo(Hospedagem hospedagem) { if (ModelState.IsValid) { _context.Add(hospedagem); _context.SaveChanges(); return(RedirectToAction("Index")); } return(View()); }
public IActionResult Novo(Atracoes atracoes) { if (ModelState.IsValid) { _context.Add(atracoes); _context.SaveChanges(); return(RedirectToAction("Index")); } return(View()); }
public IActionResult Post([FromBody] Pais pais) { if (ModelState.IsValid) { context.Paises.Add(pais); context.SaveChanges(); return(new CreatedAtRouteResult("paisCreado", new { id = pais.Id }, pais)); } return(BadRequest(ModelState)); }
public void Delete(int id) { var juguete = _context.Juguete.Find(id); if (juguete == null) { throw new KeyNotFoundException("El juguete no existe"); } _context.Juguete.Remove(juguete); _context.SaveChanges(); }
public IActionResult Create([FromBody] Provincia provincia, int idPais) { provincia.PaisId = idPais; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } context.Provincias.Add(provincia); context.SaveChanges(); return(new CreatedAtRouteResult("provinciaById", new { id = provincia.Id }, provincia)); }
public ActionResult Post([FromBody] Comentario comentario) { try { _context.Add(comentario); _context.SaveChanges(); return(Ok()); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public ActionResult Post([FromBody] Reserva reserva) { try { _context.Add(reserva); _context.SaveChanges(); return(Ok()); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public ActionResult Usuario([FromForm] Models.User user) { try { _context.Add(user); _context.SaveChanges(); return(Ok(user)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public ActionResult Car([FromForm] Models.Car car) { try { _context.Add(car); _context.SaveChanges(); return(Ok(car)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public void OpenAuction(OpenAuctionRequestVm model, int organizationId) { if (model == null) { throw new ArgumentNullException($"{typeof(OpenAuctionRequestVm).Name} is null"); } int maximumAllowedActiveAuctions = 3; var auctionsCheck = _aplicationDbContext .Organizations .Find(organizationId) .Auctions .Where(p => p.AuctionStatus == AuctionStatus.Active) .Count() < maximumAllowedActiveAuctions; var categoryCheck = _aplicationDbContext.AuctionCategories .SingleOrDefault(p => p.Name == model.AuctionCategory); if (categoryCheck == null) { throw new Exception("Ошибка валидации модели!"); } int categoryChecked = categoryCheck.Id; if (!auctionsCheck) { throw new OpenAuctionProcessException(model, "Превышено максимальное количество активных аукционов!"); } Auction auction = new Auction() { Description = model.Description, ShippingAddress = model.ShippingAddress, ShippingConditions = model.ShippingConditions, PriceAtStart = model.PriceAtStart, PriceChangeStep = model.PriceChangeStep, PriceAtMinimum = model.PriceAtMinimum, StartDate = model.StartDate, FinishDateExpected = model.FinishDateExpected, AuctionStatus = AuctionStatus.Active, AuctionCategoryId = categoryChecked, OrganizationId = organizationId }; _aplicationDbContext.Auctions.Add(auction); _aplicationDbContext.SaveChanges(); }
public void OpenOrganization(OpenOrganizationRequestVm model) { if (model == null) { throw new ArgumentNullException($"{typeof(OpenOrganizationRequestVm).Name} is null"); } var checkOrganization = /*(from o in _aplicationDbContext.Organizations * where o.IdentificationNumber == model.IdentificationNumber || * o.FullName == model.FullName * select o).ToList(); */ _aplicationDbContext.Organizations .SingleOrDefault(p => p.IdentificationNumber == model.IdentificationNumber || p.FullName == model.FullName); var checkOrganizationType = _aplicationDbContext.OrganizationTypes .SingleOrDefault(p => p.Name == model.OrganizationType); if (checkOrganization != null || checkOrganizationType == null) { throw new Exception("Model validation error!"); } var organization = Mapper.Map <Organization>(model); organization.OrganizationType = checkOrganizationType; organization.RegistrationDate = DateTime.Now; _aplicationDbContext.Organizations.Add(organization); _aplicationDbContext.SaveChanges(); }
public async Task <IActionResult> AddComplementar(request model) { var retorno = _db.CadastroComplementar.Where(d => d.IdCadastroBasico == model.IdCadastroBasico).SingleOrDefault(); if (retorno != null) { return(BadRequest("Cadastro Complementar ja existente.")); } else { _db.CadastroComplementar.Add(new CadastroComplementar { CreateDate = DateTime.Now, UpdateDate = DateTime.Now, IdCadastroBasico = model.IdCadastroBasico, DrogasilicitasNAO = model.drogaslicitasSIM != "" ? "1" : "0", QualdrogaDescri1 = model.QualdrogaDescri1, DrogasilicitasSIM = model.drogaslicitasNAO != "" ? "1" : "0", QualdrogaDescri2 = model.QualdrogaDescri2, IdosoNAO = model.Idoso == "1" ? "0" : "1", IdosoSIM = model.Idoso == "1" ? "1" : "0", Qtdo = model.Qtdo, PossuifilhosSIM = model.Possuifilhos == "1" ? "1" : "0", PossuiFilhosNAO = model.Possuifilhos == "1" ? "0" : "1", Quantidade = model.Quantidade, Profissao = model.Profissao, RendaFamiliar = model.RendaFamiliar, RendaPessoal = model.RendaPessoal, drogaslicitasNAO = model.drogaslicitasSIM != "" ? "1" : "0", drogaslicitasSIM = model.drogaslicitasSIM != "" ? "1" : "0" }); _db.SaveChanges(); var entity = _db.CadastroComplementar.Where(d => d.IdCadastroBasico == model.IdCadastroBasico).SingleOrDefault(); var vinculos = _db.CadastroDeVitimasCompleto.Where(d => d.IdCadastroBasico == model.IdCadastroBasico).SingleOrDefault(); vinculos.UpdateDate = DateTime.Now; vinculos.IdCadastroComplementar = entity.Id; _db.CadastroDeVitimasCompleto.Update(vinculos); await _db.SaveChangesAsync(); } return(Ok(true)); }
public void Create(T obj) { using (var context = new AplicationDbContext()) { context.Set <T>().Add(obj); context.SaveChanges(); } }
public void Delete(T obj) { using (var context = new AplicationDbContext()) { context.Set <T>().Remove(obj); context.SaveChanges(); } }
public ActionResult Post([FromBody] employees empleados) { try { _context.Add(empleados); _context.SaveChanges(); return(Ok()); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
//регистрация public int RegistrationUser(RegistrationNewUserVm model) { if (model == null) { throw new ArgumentNullException($"{typeof(RegistrationNewUserVm).Name} is null"); } var checkUser = _aplicationDbContext.Users .SingleOrDefault(p => p.Email == model.Email); if (checkUser != null) { throw new Exception("Model validation error!"); } var checkUserPosition = _aplicationDbContext.UserPositions .SingleOrDefault(p => p.Id == model.PositionId); var checOrganization = _aplicationDbContext.Organizations .SingleOrDefault(p => p.Id == model.OrganizationId); User user = new User() { Email = model.Email, FirstName = model.FirstName, LastName = model.LastName, Password = model.Password, Address = model.Address, OrganizationId = model.OrganizationId, PositionId = model.PositionId }; _aplicationDbContext.Users.Add(user); _aplicationDbContext.SaveChanges(); return(user.Id); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, AplicationDbContext context) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } //midleware authentication app.UseAuthentication(); app.UseMvc(); if (!context.Paises.Any()) { context.Paises.AddRange(new List <Pais> { new Pais() { Nombre = "Republica Dominicana", Provincias = new List <Provincia>() { new Provincia() { Nombre = "Azua" } } }, new Pais() { Nombre = "Mexico", Provincias = new List <Provincia>() { new Provincia() { Nombre = "Puebla" }, new Provincia() { Nombre = "Queretaro" } } }, new Pais() { Nombre = "Argentina" } }); context.SaveChanges(); } }
public async Task <IActionResult> OnPost() { if (ModelState.IsValid) { UserAccounts.UsuarioAccesso.CreateDate = DateTime.Now; UserAccounts.UsuarioAccesso.UpdateDate = DateTime.Now; Random randNum = new Random(); string senhaRandom = randNum.Next(1, 9999999).ToString(); string destinatario = UserAccounts.UsuarioAccesso.Password; UserAccounts.UsuarioAccesso.Password = senhaRandom; await _db.Login.AddAsync(UserAccounts.UsuarioAccesso); await _db.SaveChangesAsync(); Notificacoes.SendEmail envio = new Notificacoes.SendEmail(); envio.EnvioDeEmails("*****@*****.**", destinatario, senhaRandom, UserAccounts.UsuarioAccesso.EmailUser); var loginnew = _db.Login.Where(d => d.EmailUser == UserAccounts.UsuarioAccesso.EmailUser && d.Password == UserAccounts.UsuarioAccesso.Password).SingleOrDefault(); UserAccounts.IdLogin = loginnew.Id; await _db.UserAccounts.AddAsync(UserAccounts); await _db.SaveChangesAsync(); _db.VinculoSistemaUsuario.Add(new VinculoSistemaUsuario { CreateDate = DateTime.Now, UpdateDate = DateTime.Now, IdPerfil = "", IdSistema = "1", IdUsuario = UserAccounts.Id.ToString() }); _db.SaveChanges(); return(RedirectToPage("Index")); } else { return(Page()); } }
public IActionResult Edit(Doctor doctor) { if (doctor.Upload != null) { if (doctor.Upload.ContentType != "image/jpeg" && doctor.Upload.ContentType != "image/png" && doctor.Upload.ContentType != "image/gif") { ModelState.AddModelError("Upload", "Siz yalnız png,jpg və ya gif faylı yükləyə bilərsiniz"); } if (doctor.Upload.Length > 1048576) { ModelState.AddModelError("Upload", "Fayl ölcüsu maximum 1MB ola bilər"); } } if (ModelState.IsValid) { if (doctor.Upload != null) { var oldFile = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "uploads", doctor.Photo); System.IO.File.Delete(oldFile); var fileName = DateTime.Now.ToString("yyyyMMddHHmmssff") + Path.GetExtension(doctor.Upload.FileName); var path = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "uploads", fileName); using (var stream = new FileStream(path, FileMode.Create)) { doctor.Upload.CopyTo(stream); } doctor.Photo = fileName; } _context.Entry(doctor).State = EntityState.Modified; _context.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Departments = _context.Departments.ToList(); return(View(doctor)); }
public IActionResult Send(ContactSendViewModel model) { if (string.IsNullOrEmpty(model.Name) || string.IsNullOrEmpty(model.Email) || string.IsNullOrEmpty(model.Message)) { return(BadRequest()); } if (ModelState.IsValid) { Contact contact = new Contact { Name = model.Name, Email = model.Email, Message = model.Message }; _context.Contacts.Add(contact); _context.SaveChanges(); return(NoContent()); } return(View()); }
public IActionResult Send(AppointmentSendViewModel model) { if (!ModelState.IsValid) { return(BadRequest()); } Appointment appointment = new Appointment { DoctorId = model.DoctorId, PatientName = model.PatientName, Phone = model.Phone, Email = model.Email, Date = model.Date, Text = model.Text }; _context.Appointments.Add(appointment); _context.SaveChanges(); return(NoContent()); }
public void OpenAuction(OpenAuctionRequestVm model, int organizationId) { if (model == null) { throw new ArgumentNullException($"{typeof(OpenAuctionRequestVm).Name} is null"); } int maximumAllowedActiveAuctions = 3; var auctionsCheck = _aplicationDbContext .Organizations .Find(organizationId) .Auctions .Where(p => p.AuctionStatus == AuctionStatus.Active) .Count() < maximumAllowedActiveAuctions; var categoryCheck = _aplicationDbContext.AuctionCategories .SingleOrDefault(p => p.Name == model.AuctionCategory); if (categoryCheck == null) { throw new Exception("Ошибка валидации модели!"); } if (!auctionsCheck) { throw new OpenAuctionProcessException(model, "Превышено максимальное количество активных аукционов!"); } var auctionModel = Mapper.Map <Auction>(model); auctionModel.AuctionStatus = AuctionStatus.Active; auctionModel.Category = categoryCheck; auctionModel.OrganizationId = organizationId; _aplicationDbContext.Auctions.Add(auctionModel); _aplicationDbContext.SaveChanges(); }
public ActionResult Post([FromBody] Libro Libro) { context.Libros.Add(Libro); context.SaveChanges(); return(new CreatedAtRouteResult("ObtenerLibro", new { Id = Libro.Id }, Libro)); }