public Caj_TurnoBE ConsultarTurno(int in_idTurno) { try { objSqlConnection.Open(); Caj_TurnoBE objTurno; SqlCommand objSqlCommand = new SqlCommand("sp_sel_Caj_Turno_seleccionar", objSqlConnection); objSqlCommand.CommandType = CommandType.StoredProcedure; objSqlCommand.Parameters.Add(new SqlParameter("@i_idTurno", in_idTurno)); SqlDataReader objSqlDataReader = objSqlCommand.ExecuteReader(); if (objSqlDataReader.Read()) { objTurno = new Caj_TurnoBE(); objTurno.in_idTurno = (int)objSqlDataReader["i_idTurno"]; objTurno.bl_ver = (bool)objSqlDataReader["b_ver"]; objTurno.dt_fchRegistro = (DateTime)(objSqlDataReader["dt_fchRegistro"]); objTurno.st_dscpTurno = (string)objSqlDataReader["vc_dscpTurno"]; objTurno.st_hrInicio = (string)(objSqlDataReader["tm_hrInicio"]); objTurno.st_hrFin = (string)objSqlDataReader["tm_hrFin"]; return(objTurno); } objSqlConnection.Close(); return(null); } catch (Exception e) { objSqlConnection.Close(); return(null); } }
public List <Caj_TurnoBE> ListarTurno(int _case, string filtro) { try { SqlConnection objSqlConnection = Conexion.GetConexion(); objSqlConnection.Open(); List <Caj_TurnoBE> objListTurno = new List <Caj_TurnoBE>(); Caj_TurnoBE objTurno; //sp_list_Caj_Turno_listar SqlCommand objSqlCommand = new SqlCommand("sp_list_Caj_Turno_listar", objSqlConnection); objSqlCommand.CommandType = CommandType.StoredProcedure; objSqlCommand.Parameters.Add(new SqlParameter("@case", _case)); objSqlCommand.Parameters.Add(new SqlParameter("@filtro", filtro)); SqlDataReader objSqlDataReader = objSqlCommand.ExecuteReader(); while (objSqlDataReader.Read()) { objTurno = new Caj_TurnoBE(); objTurno.in_idTurno = (int)objSqlDataReader["i_idTurno"]; objTurno.bl_ver = (bool)objSqlDataReader["b_ver"]; objTurno.dt_fchRegistro = (DateTime)objSqlDataReader["dt_fchRegistro"]; objTurno.st_dscpTurno = (string)objSqlDataReader["vc_dscpTurno"]; objTurno.st_hrInicio = (string)(objSqlDataReader["tm_hrInicio"]); objTurno.st_hrFin = (string)objSqlDataReader["tm_hrFin"]; objListTurno.Add(objTurno); } objSqlDataReader.Close(); objSqlConnection.Close(); return(objListTurno); } catch (Exception e) { return(null); } }
public Boolean QuitarTurno(Caj_TurnoBE objTurno) { try { objSqlConnection.Open(); SqlCommand objSqlCommand = new SqlCommand("sp_del_Caj_Turno_eliminar", objSqlConnection); objSqlCommand.CommandType = CommandType.StoredProcedure; // objSqlCommand.Transaction = objSqlTransaction; objSqlCommand.Parameters.Add(new SqlParameter("@i_idTurno", objTurno.in_idTurno)); objSqlCommand.Parameters.Add(new SqlParameter("@b_ver", objTurno.bl_ver)); objSqlCommand.ExecuteNonQuery(); //objSqlTransaction.Commit(); objSqlConnection.Close(); return(true); } catch (Exception e) { objSqlConnection.Close(); return(false); } }
public Boolean ModificarTurno(Caj_TurnoBE objTurno) { try { objSqlConnection.Open(); SqlCommand objSqlCommand = new SqlCommand("sp_upd_Caj_Turno_actualizar", objSqlConnection); objSqlCommand.CommandType = CommandType.StoredProcedure; // objSqlCommand.Transaction = objSqlTransaction; objSqlCommand.Parameters.Add(new SqlParameter("@i_idTurno", objTurno.in_idTurno)); objSqlCommand.Parameters.Add(new SqlParameter("@vc_dscpTurno", objTurno.st_dscpTurno)); objSqlCommand.Parameters.Add(new SqlParameter("@tm_hrInicio", objTurno.st_hrInicio)); objSqlCommand.Parameters.Add(new SqlParameter("@tm_hrFin", objTurno.st_hrFin)); objSqlCommand.ExecuteNonQuery(); //objSqlTransaction.Commit(); objSqlConnection.Close(); return(true); } catch (Exception e) { objSqlConnection.Close(); return(false); } }
public Boolean InsertarRegistro(Caj_TurnoBE objTurno) { //SqlTransaction objSqlTransaction = objSqlConnection.BeginTransaction(); try { objSqlConnection.Open(); SqlCommand objSqlCommand = new SqlCommand("sp_ins_Caj_Turno_registrar", objSqlConnection); objSqlCommand.CommandType = CommandType.StoredProcedure; // objSqlCommand.Transaction = objSqlTransaction; objSqlCommand.Parameters.Add(new SqlParameter("@dt_fchRegistro", objTurno.dt_fchRegistro)); objSqlCommand.Parameters.Add(new SqlParameter("@vc_dscpTurno", objTurno.st_dscpTurno)); objSqlCommand.Parameters.Add(new SqlParameter("@tm_hrInicio", objTurno.st_hrInicio)); objSqlCommand.Parameters.Add(new SqlParameter("@tm_hrFin", objTurno.st_hrFin)); objSqlCommand.Parameters.Add(new SqlParameter("@b_ver", "true")); objSqlCommand.ExecuteNonQuery(); //objSqlTransaction.Commit(); objSqlConnection.Close(); return(true); } catch (Exception e) { objSqlConnection.Close(); return(false); } }