public bool Nuevo(BECama objBE)
{
try
{
return new DACama().Nuevo(objBE);
}
catch (Exception)
{
throw;
}
}
public bool Modificar(BECama objBE)
{
try
{
return new DACama().Modificar(objBE);
}
catch (Exception)
{
throw;
}
}
public bool Eliminar(BECama objBE)
{
try
{
return new DACama().Eliminar(objBE);
}
catch (Exception)
{
throw;
}
}
public bool Eliminar(BECama objBE)
{
bool isOK = false;
try
{
DbConnection dbCn = this.db.CreateConnection();
dbCn.Open();
DbTransaction dbTr = dbCn.BeginTransaction();
try
{
isOK = this.Eliminar(dbTr, objBE);
if (isOK)
dbTr.Commit();
else
dbTr.Rollback();
}
catch (Exception)
{
dbTr.Rollback();
throw;
}
finally
{
if (dbCn.State == ConnectionState.Open)
dbCn.Close();
}
return isOK;
}
catch (Exception)
{
throw;
}
}
public ActionResult Nuevo(BECama cama)
{
try
{
if (ModelState.IsValid)
{
cama.Estado = BECama.ESTADO_Abierta;
if (new BLCama().Nuevo(cama))
{
TempData["Mensaje"] = "Se creo correctamente la cama";
return RedirectToAction("Index");
}
else
ViewBag.Mensaje = "No se puede crear";
}
}
catch (Exception ex)
{
ViewBag.Mensaje = ex.Message;
}
return View(cama);
}
public ActionResult Nuevo()
{
var cama = new BECama();
try
{
ViewBag.ListaMarca = new SelectList(new BLParametro().ObtenerParametros(BEParametro.DOMINIO_Marca), "IdParametro", "Nombre");
ViewBag.ListaTipoCama = new SelectList(new BLParametro().ObtenerParametros(BEParametro.DOMINIO_TipoCama), "IdParametro", "Nombre");
ViewBag.ListaModoOperacion = new SelectList(new BLParametro().ObtenerParametros(BEParametro.DOMINIO_ModoOperacion), "IdParametro", "Nombre");
ViewBag.ListaTipoColchon = new SelectList(new BLParametro().ObtenerParametros(BEParametro.DOMINIO_TipoColchon), "IdParametro", "Nombre");
cama.Accesorios = new BLAccesorioCama().ObtenerAccesorioCamas();
ViewBag.Mensaje = "";
}
catch (Exception ex)
{
ViewBag.Mensaje = ex.Message;
}
return View(cama);
}
public ActionResult Editar(BECama cama)
{
try
{
if (ModelState.IsValid)
{
if (new BLCama().Modificar(cama))
{
TempData["Mensaje"] = "Se actualizo correctamente la cama";
return RedirectToAction("Index");
}
else
ViewBag.Mensaje = "No se puede modificar";
}
}
catch (Exception ex)
{
ViewBag.Mensaje = ex.Message;
}
return View(cama);
}
private bool Modificar(DbTransaction dbTr, BECama objBE)
{
try
{
using (DbCommand dbCmd = this.db.GetSqlStringCommand("update Cama set Marca = @v_marca, Modelo = @v_modelo, TipoCama = @v_tipocama, ModoOperacion = @v_modooperacion, TipoColchon = @v_tipocolchon, Estado = @v_estado where IdCama = @n_id"))
{
this.db.AddInParameter(dbCmd, "@v_marca", DbType.String, objBE.Marca);
this.db.AddInParameter(dbCmd, "@v_modelo", DbType.String, objBE.Modelo);
this.db.AddInParameter(dbCmd, "@v_tipocama", DbType.String, objBE.TipoCama);
this.db.AddInParameter(dbCmd, "@v_modooperacion", DbType.String, objBE.ModoOperacion);
this.db.AddInParameter(dbCmd, "@v_tipocolchon", DbType.String, objBE.TipoColchon);
this.db.AddInParameter(dbCmd, "@v_estado", DbType.String, objBE.Estado);
this.db.AddInParameter(dbCmd, "@n_id", DbType.Int32, objBE.IdCama);
if (this.db.ExecuteNonQuery(dbCmd, dbTr) > 0)
return true;
}
return false;
}
catch (Exception)
{
throw;
}
}
private bool Insertar(DbTransaction dbTr, BECama objBE)
{
try
{
using (DbCommand dbCmd = this.db.GetStoredProcCommand("pa_cama_set_insert"))
{
this.db.AddOutParameter(dbCmd, "@n_id", DbType.Int32, objBE.IdCama);
this.db.AddInParameter(dbCmd, "@v_marca", DbType.String, objBE.Marca);
this.db.AddInParameter(dbCmd, "@v_modelo", DbType.String, objBE.Modelo);
this.db.AddInParameter(dbCmd, "@v_tipocama", DbType.String, objBE.TipoCama);
this.db.AddInParameter(dbCmd, "@v_modooperacion", DbType.String, objBE.ModoOperacion);
this.db.AddInParameter(dbCmd, "@v_tipocolchon", DbType.String, objBE.TipoColchon);
this.db.AddInParameter(dbCmd, "@v_estado", DbType.String, objBE.Estado);
if (this.db.ExecuteNonQuery(dbCmd, dbTr) > 0)
{
objBE.IdCama = (int) this.db.GetParameterValue(dbCmd, "@n_id");
return true;
}
}
return false;
}
catch (Exception)
{
throw;
}
}
private bool Eliminar(DbTransaction dbTr, BECama objBE)
{
try
{
using (DbCommand dbCmd = this.db.GetSqlStringCommand("update Cama set Estado = @v_estado where IdCama = @n_id"))
{
this.db.AddInParameter(dbCmd, "@v_estado", DbType.String, objBE.Estado);
this.db.AddInParameter(dbCmd, "@n_id", DbType.Int32, objBE.IdCama);
if (this.db.ExecuteNonQuery(dbCmd, dbTr) > 0)
return true;
}
return false;
}
catch (Exception)
{
throw;
}
}
public BECama Obtener(int intIdCama)
{
try
{
BECama objBE = null;
using (DbCommand dbCmd = this.db.GetSqlStringCommand("select IdCama, Marca, Modelo, TipoCama, ModoOperacion, TipoColchon, Estado from Cama where IdCama = @n_idcama"))
{
this.db.AddInParameter(dbCmd, "@n_idcama", DbType.Int32, intIdCama);
using (IDataReader reader = this.db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
objBE = new BECama(reader, 0);
break;
}
}
}
if (objBE == null)
objBE = new BECama();
objBE.Accesorios = new DAAccesorioCama().ObtenerAccesorioCamas();
using (DbCommand dbCmd = this.db.GetSqlStringCommand("select IdAccesorioCama from Cama_AccesorioCama where IdCama = @n_idcama"))
{
this.db.AddInParameter(dbCmd, "@n_idcama", DbType.Int32, intIdCama);
using (IDataReader reader = this.db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
var accesoriocama = (from row in objBE.Accesorios
where row.IdAccesorioCama == Convert.ToInt32(reader["IdAccesorioCama"])
select row).First();
accesoriocama.Marcado = true;
}
}
}
return objBE;
}
catch (Exception)
{
throw;
}
}
public bool Nuevo(BECama objBE)
{
bool isOK = false;
try
{
DbConnection dbCn = this.db.CreateConnection();
dbCn.Open();
DbTransaction dbTr = dbCn.BeginTransaction();
try
{
isOK = this.Insertar(dbTr, objBE);
if (isOK)
{
int intFilas = (from row in objBE.Accesorios
where row.Marcado == true
select row).Count();
if (intFilas > 0)
isOK = this.InsertarAccesorios(dbTr, objBE.Accesorios, objBE.IdCama);
}
if (isOK)
dbTr.Commit();
else
dbTr.Rollback();
}
catch (Exception)
{
dbTr.Rollback();
throw;
}
finally
{
if (dbCn.State == ConnectionState.Open)
dbCn.Close();
}
return isOK;
}
catch (Exception)
{
throw;
}
}
public bool Modificar(BECama objBE)
{
bool isOK = false;
try
{
DbConnection dbCn = this.db.CreateConnection();
dbCn.Open();
DbTransaction dbTr = dbCn.BeginTransaction();
try
{
isOK = this.Modificar(dbTr, objBE);
if (isOK)
isOK = this.ActualizarAccesorios(dbTr, objBE.Accesorios, objBE.IdCama);
if (isOK)
dbTr.Commit();
else
dbTr.Rollback();
}
catch (Exception)
{
dbTr.Rollback();
throw;
}
finally
{
if (dbCn.State == ConnectionState.Open)
dbCn.Close();
}
return isOK;
}
catch (Exception)
{
throw;
}
}
