public IHttpActionResult PutMecanicoPorBusinessUnit(int id, Mecanicos mecanicoPorBusinessUnit)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != mecanicoPorBusinessUnit.Id)
{
return(BadRequest());
}
db.Entry(mecanicoPorBusinessUnit).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!MecanicoPorBusinessUnitExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IActionResult> GuardarMecanicoAsync([FromBody] Mecanicos mecanico)
{
var result = new Mecanicos();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var mecanicoObj = await this.repository.ObtenerMecanicoByDocTipoDoc(mecanico.Documento, mecanico.TipoDocumento);
if (mecanicoObj == null)
{
result = await this.repository.CrearMecanicoByModelAsync(mecanico);
if (result == null)
{
return(BadRequest());
}
}
else
{
result = await this.repository.ActualizarMecanicoByModel(mecanico);
if (result == null)
{
return(BadRequest());
}
}
return(Ok(result));
}
public async Task <Mecanicos> CrearMecanicoByModelAsync(Mecanicos mecanico)
{
try
{
var parameters = new SqlParameter[] {
new SqlParameter("@tipo_documento", mecanico.TipoDocumento),
new SqlParameter("@documento", mecanico.Documento),
new SqlParameter("@primer_nombre", mecanico.PrimerNombre),
new SqlParameter("@segundo_nombre", (object)mecanico.SegundoNombre ?? DBNull.Value),
new SqlParameter("@primer_apellido", mecanico.PrimerApellido),
new SqlParameter("@segundo_apellido", (object)mecanico.SegundoApellido ?? DBNull.Value),
new SqlParameter("@celular", (object)mecanico.Celular ?? DBNull.Value),
new SqlParameter("@direccion", (object)mecanico.Direccion ?? DBNull.Value),
new SqlParameter("@email", (object)mecanico.Email ?? DBNull.Value),
new SqlParameter("@estado", mecanico.Estado)
};
var dato = await this.context.Database.ExecuteSqlCommandAsync(@"CrearMecanico
@tipo_documento,@documento,@primer_nombre,@segundo_nombre,@primer_apellido,@segundo_apellido,@celular,
@direccion,@email,@estado", parameters);
return(mecanico);
}
catch (System.Exception ex)
{
return(null);
}
}
private void agregarEmpleadoToolStripMenuItem_Click(object sender, EventArgs e)
{
Mecanicos frm = new Mecanicos();
frm.MdiParent = this;
frm.Show();
}
public ActionResult DeleteConfirmed(int id)
{
Mecanicos mecanicoPorBusinessUnit = db.Mecanicos.Find(id);
db.Mecanicos.Remove(mecanicoPorBusinessUnit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IActionResult Put([FromBody] Mecanicos model)
{
return(Ok(
_MecanicoService.Update(model)
));
}
public IActionResult Post([FromBody] Mecanicos model)
{
return(Ok(
_MecanicoService.Add(model)
));
}
public IActionResult Update([FromBody] Mecanicos model)
{
if (!ModelState.IsValid)
{
return(BadRequest("no se actualizo"));
}
MecanicosService.Add(model);
return(Ok());
}
public IActionResult Create([FromBody] Mecanicos model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
MecanicosService.Add(model);
return(Ok());
}
public IHttpActionResult GetMecanicoPorBusinessUnit(int id)
{
Mecanicos mecanicoPorBusinessUnit = db.Mecanicos.Find(id);
if (mecanicoPorBusinessUnit == null)
{
return(NotFound());
}
return(Ok(mecanicoPorBusinessUnit));
}
public IHttpActionResult PostMecanicoPorBusinessUnit(Mecanicos mecanicoPorBusinessUnit)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Mecanicos.Add(mecanicoPorBusinessUnit);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = mecanicoPorBusinessUnit.Id }, mecanicoPorBusinessUnit));
}
public ActionResult Create([Bind(Include = "Id,IdMecanico,IdBusinessUnit,Activo")] Mecanicos mecanicoPorBusinessUnit)
{
if (ModelState.IsValid)
{
db.Mecanicos.Add(mecanicoPorBusinessUnit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IdBusinessUnit = new SelectList(db.BussinesUnits, "Id", "Nombre", mecanicoPorBusinessUnit.IdBusinessUnit);
ViewBag.IdMecanico = new SelectList(db.Personas.Select(x => new { Id = x.Id, Nombre = x.Nombre + " " + x.Apellido1 + " " + x.Apellido2 }).OrderBy(x => x.Nombre), "Id", "Nombre");
return(View(mecanicoPorBusinessUnit));
}
public IHttpActionResult DeleteMecanicoPorBusinessUnit(int id)
{
Mecanicos mecanicoPorBusinessUnit = db.Mecanicos.Find(id);
if (mecanicoPorBusinessUnit == null)
{
return(NotFound());
}
db.Mecanicos.Remove(mecanicoPorBusinessUnit);
db.SaveChanges();
return(Ok(mecanicoPorBusinessUnit));
}
// GET: Seguridad/Mecanicos/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Mecanicos mecanicoPorBusinessUnit = db.Mecanicos.Find(id);
if (mecanicoPorBusinessUnit == null)
{
return(HttpNotFound());
}
return(View(mecanicoPorBusinessUnit));
}
public bool Add(Mecanicos model)
{
try
{
_VehiculoDbContext.Add(model);
_VehiculoDbContext.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine("Error: " + e);
}
return(true);
}
public Mecanicos Get(int id)
{
var result = new Mecanicos();
try
{
result = _VehiculoDbContext.Mecanicos.Single(x => x.Id == id);
}
catch (System.Exception)
{
}
return(result);
}
// GET: Seguridad/Mecanicos/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Mecanicos mecanicoPorBusinessUnit = db.Mecanicos.Find(id);
if (mecanicoPorBusinessUnit == null)
{
return(HttpNotFound());
}
ViewBag.IdBusinessUnit = new SelectList(db.BussinesUnits, "Id", "Nombre", mecanicoPorBusinessUnit.IdBusinessUnit);
ViewBag.IdMecanico = new SelectList(db.Personas.Select(x => new { Id = x.Id, Nombre = x.Nombre + " " + x.Apellido1 + " " + x.Apellido2 }).OrderBy(x => x.Nombre), "Id", "Nombre");
return(View(mecanicoPorBusinessUnit));
}
public bool Update(Mecanicos model)
{
try
{
var original = _VehiculoDbContext.Mecanicos.Single(x =>
x.Id == model.Id
);
original.Nombre = model.Nombre;
_VehiculoDbContext.Update(original);
_VehiculoDbContext.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine("Error " + e);
}
return(true);
}
public MecanicoDTO Read(int id)
{
Mecanicos mecanico = new Mecanicos();
return(_mapper.Map <MecanicoDTO>(mecanico));
}
