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