public string CrearOperador(Operador oOperador) { string Respuesta; var ConClass = new DaConnectSQL(); try { SqlCommand cmd = new SqlCommand(); cmd.Connection = ConClass.DASQLConnection(); cmd.CommandType = CommandType.Text; cmd.Transaction = ConClass.Tran; ConClass.Open(); cmd.Transaction = ConClass.Con.BeginTransaction(); cmd.CommandText = "Insert into Operadores (CodOperador, Nombre, Huella, Status) " + "Values ('" + oOperador.CodOperador + "','" + oOperador.Nombre + "','" + oOperador.Huella + "', '" + oOperador.Status + "')"; cmd.ExecuteNonQuery(); cmd.Transaction.Commit(); Respuesta = "Registro creado"; } catch (Exception ex) { ConClass.RollBackTransaction(); Respuesta = ex.Message; } finally { ConClass.Close(); } return(Respuesta); }
public bool ValidaConexionSQL() { bool Exitosa = false; var ConClass = new DaConnectSQL(); ConClass.Open(); if (ConClass.Con.State == ConnectionState.Open) { Exitosa = true; } return(Exitosa); }
public List <Operador> ListarHuellas() { List <Operador> ListaHuellas = new List <Operador>(); var ConClass = new DaConnectSQL(); SqlCommand cmd = new SqlCommand(); cmd.Connection = ConClass.DASQLConnection(); cmd.CommandType = CommandType.Text; try { ConClass.Open(); cmd.CommandType = CommandType.Text; cmd.Connection = cmd.Connection; cmd.CommandText = "SELECT * FROM Operadores "; SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { { Operador OperadoresBd = new Operador(); OperadoresBd.IdOperador = dr.GetInt32(0); OperadoresBd.CodOperador = dr.GetString(1); OperadoresBd.Nombre = dr.GetString(2); OperadoresBd.Huella = dr.GetString(3); OperadoresBd.Status = dr.GetString(4); ListaHuellas.Add(OperadoresBd); } } dr.Close(); } catch (Exception ex) { Console.WriteLine("Error en la transaccion " + ex.Message); } return(ListaHuellas); }
public void DACliente() { DaConnectSQL DASQLConnection = new DaConnectSQL(); }