public bool InsertarAddress(address nuevoAddress)
{
sakilaEntities contexto = new sakilaEntities();
nuevoAddress.last_update = DateTime.Now;
contexto.address.Add(nuevoAddress);
contexto.SaveChanges();
return(true);
}
public bool InsertarCity(city nuevoCity)
{
sakilaEntities contexto = new sakilaEntities();
nuevoCity.last_update = DateTime.Now;
contexto.city.Add(nuevoCity);
contexto.SaveChanges();
return(true);
}
public bool BorrarCustomer(customer delCustomer)
{
sakilaEntities contexto = new sakilaEntities();
var customer_ = (from T0 in contexto.customer
where T0.customer_id == delCustomer.customer_id
select T0).FirstOrDefault();
contexto.customer.Remove(customer_);
contexto.SaveChanges();
return(true);
}
public bool InsertarCustomer(customer nuevoCustomer)
{
sakilaEntities contexto = new sakilaEntities();
nuevoCustomer.create_date = DateTime.Now;
nuevoCustomer.last_update = DateTime.Now;
contexto.customer.Add(nuevoCustomer);
contexto.SaveChanges();
return(true);
}
public bool BorrarAddress(address delAddress)
{
sakilaEntities contexto = new sakilaEntities();
var address_ = (from T0 in contexto.address
where T0.address_id == delAddress.address_id
select T0).FirstOrDefault();
contexto.address.Remove(address_);
contexto.SaveChanges();
return(true);
}
public bool BorrarCity(int idCity)
{
sakilaEntities contexto = new sakilaEntities();
var city_ = (from T0 in contexto.city
where T0.city_id == idCity
select T0).FirstOrDefault();
contexto.city.Remove(city_);
contexto.SaveChanges();
return(true);
}
public bool ActualizarCity(city cityActualizado)
{
sakilaEntities contexto = new sakilaEntities();
var city_ = (from T0 in contexto.city
where T0.city_id == cityActualizado.city_id
select T0).FirstOrDefault();
city_.city1 = cityActualizado.city1;
city_.last_update = DateTime.Now;
contexto.SaveChanges();
return(true);
}
public bool ActualizarCustomer(customer customerActualizado)
{
sakilaEntities contexto = new sakilaEntities();
var customer_ = (from T0 in contexto.customer
where T0.customer_id == customerActualizado.customer_id
select T0).FirstOrDefault();
customer_.first_name = customerActualizado.first_name;
customer_.last_name = customerActualizado.last_name;
customer_.email = customerActualizado.email;
customer_.address_id = customerActualizado.address_id;
customer_.active = customerActualizado.active;
customer_.last_update = DateTime.Now;
contexto.SaveChanges();
return(true);
}
public bool ActualizarAddress(address addressActualizado)
{
sakilaEntities contexto = new sakilaEntities();
var address_ = (from T0 in contexto.address
where T0.address_id == addressActualizado.address_id
select T0).FirstOrDefault();
address_.address1 = addressActualizado.address1;
address_.address2 = addressActualizado.address2;
address_.district = addressActualizado.district;
address_.city_id = addressActualizado.city_id;
address_.postal_code = addressActualizado.postal_code;
address_.phone = addressActualizado.phone;
address_.last_update = DateTime.Now;
contexto.SaveChanges();
return(true);
}