public void agregarDomicilio(long id, byte[] foto)
{
using (var bd = new Conexion())
{
domicilio domicilio = new domicilio
{
dom_asociado = id,
dom_foto = foto
};
long consulta = bd.domicilio.LongCount();
if (consulta == 0)
{
bd.Database.ExecuteSqlCommand("ALTER TABLE domicilio AUTO_INCREMENT=1");
}
else
{
long maxVal = bd.domicilio.Max(d => d.dom_id) + 1;
bd.Database.ExecuteSqlCommand("ALTER TABLE domicilio AUTO_INCREMENT={0}", maxVal);
}
bd.domicilio.Add(domicilio);
bd.SaveChanges();
}
}
public Address NormalizeAddressAfip(domicilio d)
{
var address = new Address
{
AddressType = d.tipoDomicilio,
LocalityDescription = d.localidad,
PostalCode = d.codPostal,
Province = new Province {
Name = d.descripcionProvincia
},
AditionalData = d.datoAdicional,
AditionalDataType = d.tipoDatoAdicional,
Default = d.tipoDomicilio == RealAddress
};
var fullAddress = Regex.Match(d.direccion, @"(([a-z0-9 °]+) (\d+))", RegexOptions.IgnoreCase);
var floor = Regex.Match(d.direccion, @"(p|piso):([a-z0-9]+)", RegexOptions.IgnoreCase);
var flat = Regex.Match(d.direccion, @"(d|dpto|departamento):([a-z0-9]+)", RegexOptions.IgnoreCase);
if (fullAddress.Success)
{
address.Street = fullAddress.Groups[2].Value;
address.Number = fullAddress.Groups[3].Value;
}
if (floor.Success)
{
address.Floor = floor.Groups[2].Value;
}
if (flat.Success)
{
address.FlatNumber = flat.Groups[2].Value;
}
return(address);
}
public async Task <IHttpActionResult> Putdomicilio(int id, domicilio domicilio)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != domicilio.Persona_id)
{
return(BadRequest());
}
db.Entry(domicilio).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!domicilioExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(int id)
{
domicilio domicilio = db.domicilios.Find(id);
db.domicilios.Remove(domicilio);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <IHttpActionResult> Getdomicilio(int id)
{
domicilio domicilio = await db.domicilios.FindAsync(id);
if (domicilio == null)
{
return(NotFound());
}
return(Ok(domicilio));
}
public ActionResult Edit([Bind(Include = "id,idventa,idcliente,direccion")] domicilio domicilio)
{
if (ModelState.IsValid)
{
db.Entry(domicilio).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.idventa = new SelectList(db.ventas, "idventa", "tipo_comprobante", domicilio.idventa);
return(View(domicilio));
}
public ActionResult <domicilio> Index([FromBody] domicilio Domicilio, [FromHeader] string token)
{
if (UsuarioConexion <usuario> .Instance.getUserToken(token))
{
return(Json(DomicilioConexion <domicilio> .Instance.Insert(Domicilio)));
}
else
{
return(null);
}
}
public async Task <IHttpActionResult> Postdomicilio(domicilio domicilio)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.domicilios.Add(domicilio);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = domicilio.Persona_id }, domicilio));
}
public ActionResult <domicilio> Put([FromBody] domicilio Domicilio, [FromHeader] string token)
{
if (UsuarioConexion <usuario> .Instance.getUserToken(token))
{
DomicilioConexion <domicilio> .Instance.Update(Domicilio);
return(Json("El proceso de almacenado se realizó con éxito."));
}
else
{
return(null);
}
}
public async Task <IHttpActionResult> Deletedomicilio(int id)
{
domicilio domicilio = await db.domicilios.FindAsync(id);
if (domicilio == null)
{
return(NotFound());
}
db.domicilios.Remove(domicilio);
await db.SaveChangesAsync();
return(Ok(domicilio));
}
// GET: /Domicilio/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
domicilio domicilio = db.domicilios.Find(id);
if (domicilio == null)
{
return(HttpNotFound());
}
return(View(domicilio));
}
// GET: /Domicilio/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
domicilio domicilio = db.domicilios.Find(id);
if (domicilio == null)
{
return(HttpNotFound());
}
ViewBag.idventa = new SelectList(db.ventas, "idventa", "tipo_comprobante", domicilio.idventa);
return(View(domicilio));
}
private DomicilioConexion(domicilio aux) : base(aux)
{
}
