public int Eliminar(BE.Turno beTurno) { try { string sp = "SpTbTurnoEliminar"; int rowsAffected = 0; using (SqlConnection cnn = new SqlConnection(ConnectionManager.ConexionLocal)) { cnn.Open(); SqlCommand cmd = new SqlCommand(sp, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@IDTURNO", beTurno.IdTurno)); rowsAffected = cmd.ExecuteNonQuery(); } return(rowsAffected); } catch (Exception ex) { throw ex; } }
public List <BE.Turno> Listar() { List <BE.Turno> lst = new List <BE.Turno>(); try { var daTurno = new DA.Turno(); DataTable dt = daTurno.Listar(); for (int i = 0; i < dt.Rows.Count; i++) { var beTurno = new BE.Turno(); DataRow dr = dt.Rows[i]; daTurno.Cargar(ref beTurno, ref dr); lst.Add(beTurno); } return(lst); } catch (Exception ex) { throw ex; } }
public int Actualizar(BE.Turno beTurno) { try { string sp = "SpTbTurnoActualizar"; int rowsAffected = 0; using (SqlConnection cnn = new SqlConnection(ConnectionManager.ConexionLocal)) { cnn.Open(); SqlCommand cmd = new SqlCommand(sp, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@IDTURNO", beTurno.IdTurno)); cmd.Parameters.Add(new SqlParameter("@NUMERO", beTurno.Numero)); cmd.Parameters.Add(new SqlParameter("@HORAINICIAL", beTurno.HoraInicial)); cmd.Parameters.Add(new SqlParameter("@HORAFINAL", beTurno.HoraFinal)); cmd.Parameters.Add(new SqlParameter("@ACTIVO", beTurno.Activo)); rowsAffected = cmd.ExecuteNonQuery(); } return(rowsAffected); } catch (Exception ex) { throw ex; } }
public void Cargar(ref BE.Turno beTurno, ref DataRow dr) { try { beTurno.IdTurno = dr["IdTurno"] == DBNull.Value ? 0 : int.Parse(dr["IdTurno"].ToString()); beTurno.Numero = dr["Numero"] == DBNull.Value ? 0 : int.Parse(dr["Numero"].ToString()); beTurno.HoraInicial = dr["HoraInicial"] == DBNull.Value ? "00:00:00" : dr["HoraInicial"].ToString(); beTurno.HoraFinal = dr["HoraFinal"] == DBNull.Value ? "00:00:00" : dr["HoraFinal"].ToString(); beTurno.Activo = dr["Activo"] == DBNull.Value ? false : bool.Parse(dr["Activo"].ToString()); } catch (Exception ex) { throw ex; } }
public bool Obtener(ref BE.Turno beTurno) { bool exists = false; try { var daTurno = new DA.Turno(); exists = daTurno.Obtener(ref beTurno); return(exists); } catch (Exception ex) { throw ex; } }
public int Eliminar(BE.Turno beTurno) { int rowsAffected = 0; try { var daTurno = new DA.Turno(); rowsAffected = daTurno.Eliminar(beTurno); return(rowsAffected); } catch (Exception ex) { throw ex; } }
public int Insertar(ref BE.Turno beTurno) { int rowsAffected = 0; try { var daTurno = new DA.Turno(); rowsAffected = daTurno.Insertar(ref beTurno); return(rowsAffected); } catch (Exception ex) { throw ex; } }
public bool Obtener(ref BE.Turno beTurno) { bool rpta = false; try { string sp = "SpTbTurnoObtener"; DataTable dt = new DataTable(); using (SqlConnection cnn = new SqlConnection(ConnectionManager.ConexionLocal)) { cnn.Open(); SqlCommand cmd = new SqlCommand(sp, cnn); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter dad = new SqlDataAdapter(cmd); dad.SelectCommand.Parameters.Add(new SqlParameter("@IDTURNO", beTurno.IdTurno)); dad.Fill(dt); if ((dt.Rows.Count == 1)) { DataRow dr = dt.Rows[0]; Cargar(ref beTurno, ref dr); rpta = true; } return(rpta); } } catch (Exception ex) { throw ex; } }