public IHttpActionResult Put([FromBody] Detalle datos)
{
IHttpActionResult _result = null;
Detalle _datos;
try
{
using (DatosContext ctx = new DatosContext())
{
_datos = ctx.Detalles.Where(d => d.id == datos.id).FirstOrDefault();
if (datos != null)
{
_datos.corta = datos.corta;
_datos.larga = datos.larga;
_datos.largo = datos.largo;
_datos.ancho = datos.ancho;
_datos.ventanas = datos.ventanas;
}
_result = Ok(ctx.SaveChanges());
}
}
catch (Exception ex)
{
}
return(_result);
}
public IHttpActionResult del(Guid token, int userid, int pidFoto, int pidDetalle, string pfoto)
{
IHttpActionResult _result = null;
Foto foto;
_result = Ok();
if (validate(token.ToString(), userid))
{
using (DatosContext ctx = new DatosContext())
{
foto = ctx.Fotos.Where(f => f.id == pidFoto).FirstOrDefault();
if (foto != null)
{
var filePath = System.Web.HttpContext.Current.Server.MapPath($"~/Uploads/{userid}/{pidDetalle}");
if (System.IO.File.Exists(System.IO.Path.Combine(filePath, pfoto)))
{
System.IO.File.Delete(System.IO.Path.Combine(filePath, pfoto));
}
ctx.Fotos.Remove(foto);
_result = Ok(ctx.SaveChanges());
}
}
}
return(_result);
}
public Negocio(IMiLogger log, List <RateEnt> rates, List <Transaction> transactions)
{
this.logger = log;
this.contexto = new DatosContext();
this.ratesList = rates;
this.transactionsList = transactions;
}
/// <summary>
/// Inicializa el objeto de aplicación Singleton. Esta es la primera línea de código creado
/// ejecutado y, como tal, es el equivalente lógico de main() o WinMain().
/// </summary>
public App()
{
this.InitializeComponent();
this.Suspending += OnSuspending;
using (var db = new DatosContext())
{
db.Database.Migrate();
}
}
public string Post()
{
//IHttpActionResult _result = null;
string _result = string.Empty;
Foto _dataResult = new Foto();
var req = Request;
var headers = req.Headers;
int userid = int.Parse(headers.GetValues("userid").FirstOrDefault());
int iddetalle = int.Parse(headers.GetValues("iddetalle").FirstOrDefault());
if (validate(headers.GetValues("token").FirstOrDefault(), userid))
{
try
{
var httpRequest = System.Web.HttpContext.Current.Request;
if (httpRequest.Files.Count > 0)
{
var docfiles = new List <string>();
foreach (string file in httpRequest.Files)
{
var postedFile = httpRequest.Files[file];
var filePath = System.Web.HttpContext.Current.Server.MapPath($"~/Uploads/{userid}/{iddetalle}");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
postedFile.SaveAs(System.IO.Path.Combine(filePath, postedFile.FileName));
docfiles.Add(System.IO.Path.Combine(filePath, postedFile.FileName));
using (DatosContext ctx = new DatosContext())
{
_dataResult = new Foto();
_dataResult.iddetalle = iddetalle;
_dataResult.foto = headers.GetValues("filename").FirstOrDefault();
_dataResult = ctx.Fotos.Add(_dataResult);
ctx.SaveChanges();
_result = Ok(_dataResult).ToString();
}
}
_result = Ok(Request.CreateResponse(HttpStatusCode.Created, docfiles)).ToString();
}
else
{
_result = Ok(Request.CreateResponse(HttpStatusCode.BadRequest)).ToString();
}
}
catch (Exception ex)
{
tracklogging(userid.ToString(), ex.Message);
_result = Ok(Request.CreateResponse(ex.Message)).ToString();
}
}
return(_result);
}
public IHttpActionResult get(Guid token, int userid)
{
IHttpActionResult _result = null;
_result = Ok();
try
{
DatosContext ctx = new DatosContext();
_result = Ok(ctx.Users.Where(u => u.id == userid && u.Token == token.ToString()).FirstOrDefault());
}
catch (Exception ex)
{
}
return(_result);
}
public IHttpActionResult getById(int id)
{
IHttpActionResult _result = null;
_result = Ok();
try
{
DatosContext ctx = new DatosContext();
var _userResult = ctx.Detalles.Where(d => d.id == id).FirstOrDefault();
_result = Ok(_userResult);
}
catch (Exception ex)
{
}
return(_result);
}
public IHttpActionResult getByUserName(string username)
{
IHttpActionResult _result = null;
_result = Ok();
try
{
DatosContext ctx = new DatosContext();
SqlParameter pusername = new SqlParameter("@username", username);
_result = Ok(ctx.Database.SqlQuery <object>("usuariogetbyusername @username", pusername).ToList());
}
catch (Exception ex)
{
}
return(_result);
}
public IHttpActionResult getByIdModel(int id)
{
IHttpActionResult _result = null;
_result = Ok();
try
{
DatosContext ctx = new DatosContext();
var _userResult = ctx.Detalles.Where(d => d.idmodelo == id).ToList();
_result = Ok(_userResult);
}
catch (Exception ex)
{
}
return(_result);
}
public IHttpActionResult getByMOdel(int idmodelo)
{
IHttpActionResult _result = null;
ViewModel.Fotodetalle _fotoDetalle = new ViewModel.Fotodetalle();
List <Foto> _fotos = new List <Foto>();
List <Detalle> _detalles = new List <Detalle>();
_result = Ok();
int _userId = validateHost(System.Web.HttpContext.Current.Request.UrlReferrer);
if (_userId > 0)
{
try
{
DatosContext ctx = new DatosContext();
var _modeloResult = ctx.Modelos.Where(m => m.iduser == _userId && m.id == idmodelo).FirstOrDefault();
if (_modeloResult != null)
{
_detalles = ctx.Detalles.Where(d => _modeloResult.id == d.idmodelo).
OrderBy(d => d.piso).ThenBy(d => d.posicion).ThenBy(d => d.location).
ToList();
if (_detalles != null)
{
_fotoDetalle.detalle = _detalles;
_fotoDetalle.fotos = new List <Foto>();
foreach (Detalle detail in _detalles)
{
var _fotosResul = ctx.Fotos.Where(f => detail.id == f.iddetalle).
OrderBy(f => f.nivel).ThenBy(f => f.posicion).ThenBy(f => f.location).
ToList();
if (_fotosResul != null)
{
_fotoDetalle.fotos.AddRange(_fotosResul);
}
}
}
}
_result = Ok(_fotoDetalle);
}
catch (Exception ex)
{
}
}
return(_result);
}
public void tracklogging(string userid, string message)
{
try
{
using (DatosContext ctx = new DatosContext())
{
Models.Logtrack _log = new Models.Logtrack();
_log.Message = message;
_log.Moment = DateTime.Now;
ctx.Logtracks.Add(_log);
ctx.SaveChanges();
}
}
catch (Exception ex)
{
}
}
public bool validate(string token, int userid)
{
bool result = false;
try
{
using (DatosContext ctx = new DatosContext())
{
var _userResult = ctx.Users.Where(u => u.id == userid && u.Token == token).FirstOrDefault();
result = _userResult != null;
}
}
catch (Exception ex)
{
}
return(result);
}
public IHttpActionResult Post([FromBody] Detalle datos)
{
IHttpActionResult _result = null;
try
{
using (DatosContext ctx = new DatosContext())
{
var _dataResult = ctx.Detalles.Add(datos);
ctx.SaveChanges();
_result = Ok(_dataResult);
}
}
catch (Exception ex)
{
}
return(_result);
}
public IHttpActionResult Post([FromBody] User datos)
{
IHttpActionResult _result = null;
User _userResult = new User();
try
{
using (DatosContext ctx = new DatosContext())
{
_userResult = ctx.Users.Add(datos);
ctx.SaveChanges();
_result = Ok(_userResult);
}
}
catch (Exception ex)
{
}
return(_result);
}
public IHttpActionResult getByIdUser(string token, int userid)
{
IHttpActionResult _result = null;
_result = Ok();
if (validate(token, userid))
{
try
{
DatosContext ctx = new DatosContext();
var _userResult = ctx.Modelos.Where(m => m.iduser == userid).ToList();
_result = Ok(_userResult);
}
catch (Exception ex)
{
}
}
return(_result);
}
public IHttpActionResult put([FromBody] Foto datos, string token, int userid)
{
IHttpActionResult _result = null;
Foto foto;
_result = Ok();
if (validate(token, userid))
{
using (DatosContext ctx = new DatosContext())
{
foto = ctx.Fotos.Where(f => f.id == datos.id).FirstOrDefault();
if (foto != null)
{
foto.posicion = datos.posicion;
_result = Ok(ctx.SaveChanges());
}
}
}
return(_result);
}
public IHttpActionResult Post([FromBody] User datos)
{
IHttpActionResult _result = null;
User _userResult = new User();
try
{
using (DatosContext ctx = new DatosContext())
{
_userResult = ctx.Users.Where(u => u.username == datos.username).FirstOrDefault();
_userResult.Token = Guid.NewGuid().ToString();
ctx.SaveChanges();
_result = Ok(_userResult);
}
}
catch (Exception ex)
{
}
return(_result);
}
public IHttpActionResult Put([FromBody] Modelo datos, Guid token, int userid)
{
IHttpActionResult _result = null;
Modelo _dataResult = new Modelo();
if (validate(token.ToString(), userid))
{
try
{
using (DatosContext ctx = new DatosContext())
{
_dataResult = ctx.Modelos.Where(m => m.id == datos.id).FirstOrDefault();
if (_dataResult != null)
{
_dataResult.banos = datos.banos;
_dataResult.construido = datos.construido;
_dataResult.corta = datos.corta;
_dataResult.cservicio = datos.cservicio;
_dataResult.dias = datos.dias;
_dataResult.horas = datos.horas;
_dataResult.larga = datos.larga;
_dataResult.lavado = datos.lavado;
_dataResult.medios = datos.medios;
_dataResult.metros = datos.metros;
_dataResult.pisos = datos.pisos;
_dataResult.posicion = datos.posicion;
_dataResult.precio = datos.precio;
_dataResult.recamaras = datos.recamaras;
_dataResult.terreno = datos.terreno;
_dataResult.vecindario = datos.vecindario;
ctx.SaveChanges();
_result = Ok(_dataResult);
}
}
}
catch (Exception ex)
{
}
}
return(_result);
}
public IHttpActionResult Post([FromBody] Subdominio datos, Guid token, int userid)
{
IHttpActionResult _result = null;
User _userResult = new User();
try
{
using (DatosContext ctx = new DatosContext())
{
_userResult = ctx.Users.Where(u => u.id == userid && u.Token == token.ToString()).FirstOrDefault();
_userResult.subdominioa = datos.subdominioa;
_userResult.subdominiov = datos.subdominiov;
ctx.SaveChanges();
_result = Ok(_userResult);
}
}
catch (Exception ex)
{
}
return(_result);
}
public int validateHost(Uri host)
{
int _idUser = -1;
try
{
using (DatosContext ctx = new DatosContext())
{
var _userResult = ctx.Users.Where(u => u.hostName == host.AbsoluteUri).FirstOrDefault();
if (_userResult != null)
{
_idUser = _userResult.id;
}
;
}
}
catch (Exception ex)
{
}
return(_idUser);
}
//[Route("subdominio")]
public IHttpActionResult get(Guid token, int userid)
{
IHttpActionResult _result = null;
_result = Ok();
try
{
DatosContext ctx = new DatosContext();
//SqlParameter pusername = new SqlParameter("@username", username);
//_result = Ok(ctx.Database.SqlQuery<object>("usuariogetbyusername @username", pusername).ToList());
var subdominio = from u in ctx.Users
where u.id == userid && u.Token == token.ToString()
select new { u.id, u.subdominiov, u.subdominioa };
_result = Ok(subdominio.FirstOrDefault());
}
catch (Exception ex)
{
}
return(_result);
}
public LoginController(DatosContext context, IOptions <AppSetting> appSettings)
{
_context = context;
var admin = _context.Users.Find("admin");
if (admin == null)
{
_context.Users.Add(new User()
{
UserName = "******",
Password = "******",
Estado = "AC",
NombreCompleto = "Adminitrador",
Telefono = "318000",
Email = "*****@*****.**"
});
var registrosGuardados = _context.SaveChanges();
}
_userService = new UserService(context);
_jwtService = new JwtService(appSettings);
}
public IHttpActionResult Post([FromBody] Modelo datos, Guid token, int userid)
{
IHttpActionResult _result = null;
Modelo _dataResult = new Modelo();
if (validate(token.ToString(), userid))
{
try
{
using (DatosContext ctx = new DatosContext())
{
_dataResult = ctx.Modelos.Add(datos);
ctx.SaveChanges();
_result = Ok(_dataResult);
}
}
catch (Exception ex)
{
}
}
return(_result);
}
public IHttpActionResult get(string token, int userid, int id)
{
IHttpActionResult _result = null;
_result = Ok();
if (validate(token, userid))
{
try
{
DatosContext ctx = new DatosContext();
var foto = from f in ctx.Fotos
where f.id == id
select f;
_result = Ok(foto.FirstOrDefault());
}
catch (Exception ex)
{
}
}
return(_result);
}
public IHttpActionResult getByIdDetalle(string token, int userid, int id)
{
IHttpActionResult _result = null;
_result = Ok();
if (validate(token, userid))
{
try
{
DatosContext ctx = new DatosContext();
var foto = from f in ctx.Fotos
where f.iddetalle == id
orderby f.nivel, f.posicion, f.location
select f;
_result = Ok(foto);
}
catch (Exception ex)
{
}
}
return(_result);
}
public Negocio(IMiLogger log)
{
this.logger = log;
this.contexto = new DatosContext();
this.DescargaDatosAPI().Wait();
}
public pessoController(DatosContext _db)
{
db = _db;
}
public ProductorService(DatosContext context)
{
_context = context;
}
public UserService(DatosContext context)
{
_context = context;
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, DatosContext context)
{
context.Database.Migrate();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
if (!env.IsDevelopment())
{
app.UseSpaStaticFiles();
}
app.UseRouting();
// global cors policy
app.UseCors(x => x
.AllowAnyOrigin()
.AllowAnyMethod()
.AllowAnyHeader());
app.UseAuthentication();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller}/{action=Index}/{id?}");
});
//start swagger
app.UseSwagger();
app.UseSwaggerUI(c =>
{
c.SwaggerEndpoint("/swagger/v1/swagger.json", "My API V1");
});
//end swagger
app.UseSpa(spa =>
{
// To learn more about options for serving an Angular SPA from ASP.NET Core,
// see https://go.microsoft.com/fwlink/?linkid=864501
spa.Options.SourcePath = "ClientApp";
if (env.IsDevelopment())
{
spa.UseAngularCliServer(npmScript: "start");
}
});
}
