public void createConductor(ConductorModel conductorModel)
{
using (TransporteSACDBEntities db = new TransporteSACDBEntities())
{
db.Conductor.Add(Converter.model2enity(conductorModel));
db.SaveChanges();
}
}
public void deleteConductor(int id)
{
using (TransporteSACDBEntities db = new TransporteSACDBEntities())
{
var conductor = db.Conductor.Find(id);
db.Entry(conductor).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
public void updateConductor(ConductorModel conductorModel)
{
Conductor conductorE = Converter.model2enity(conductorModel);
using (TransporteSACDBEntities db = new TransporteSACDBEntities())
{
db.Entry(conductorE).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public Conductor findByID(int id)
{
Conductor conductorE;
using (TransporteSACDBEntities db = new TransporteSACDBEntities())
{
conductorE = db.Conductor.Find(id);
}
return(conductorE);
}
public List <ConductorModel> getAllConductor()
{
List <Conductor> conductors;
List <ConductorModel> conductorModels = new List <ConductorModel>();
using (TransporteSACDBEntities db = new TransporteSACDBEntities())
{
conductors = db.Conductor.ToList();
}
foreach (Conductor conductorE in conductors)
{
ConductorModel conductorM = Converter.entity2model(conductorE);
conductorModels.Add(conductorM);
}
return(conductorModels);
}
public ActionResult updateConductor(int id)
{
try
{
Conductor conductorE;
using (TransporteSACDBEntities db = new TransporteSACDBEntities())
{
conductorE = db.Conductor.Find(id);
}
ConductorModel conductorM = Converter.entity2model(conductorE);
return(View(conductorM));
}
catch (Exception e)
{
throw new Exception(e.ToString());
}
}
public ActionResult deleteConductor(int id)
{
try
{
using (TransporteSACDBEntities db = new TransporteSACDBEntities())
{
var conductor = db.Conductor.Find(id);
db.Entry(conductor).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch (Exception e)
{
throw new Exception(e.ToString());
}
}
public ActionResult createConductor(ConductorModel conductor)
{
try
{
if (ModelState.IsValid)
{
using (TransporteSACDBEntities db = new TransporteSACDBEntities())
{
db.Conductor.Add(Converter.model2enity(conductor));
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(conductor));
}
catch (Exception e)
{
throw new Exception(e.ToString());
}
}
public ActionResult updateConductor(ConductorModel conductorModel)
{
try
{
if (ModelState.IsValid)
{
Conductor conductorE = Converter.model2enity(conductorModel);
using (TransporteSACDBEntities db = new TransporteSACDBEntities())
{
db.Entry(conductorE).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(conductorModel));
}
catch (Exception e)
{
throw new Exception(e.ToString());
}
}
public IEnumerable <ConductorModel> getAllConductor()
{
List <Conductor> conductors;
List <ConductorModel> conductorModels = new List <ConductorModel>();
using (TransporteSACDBEntities db = new TransporteSACDBEntities())
{
conductors = db.Conductor.ToList();
/*conductors = (from c in db.Conductor select new ConductorModel{
* Id = c.id,
* Nombre = c.nombre,
* ape_pat = c.ape_pat,
* ape_mat = c.ape_mat,
* Telefono = c.telefono
* }).ToList();*/
}
foreach (Conductor conductorE in conductors)
{
ConductorModel conductorM = Converter.entity2model(conductorE);
conductorModels.Add(conductorM);
}
return(conductorModels);
}
