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; } }