//добавить орагинизвцию
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));
}
