public static List<CreateEmpleado> getAllEmpeladoFromDB() { SqlDataReader reader = null; SqlConnection connection = new SqlConnection(); connection.ConnectionString = "Data Source=.;Initial Catalog=TECAirlines;Integrated Security=SSPI"; SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandType = CommandType.Text; var query = "SELECT * FROM Empleado"; sqlCmd.CommandText = query; sqlCmd.Connection = connection; connection.Open(); reader = sqlCmd.ExecuteReader(); List<CreateEmpleado> listaEmpleado = new List<CreateEmpleado>(); while (reader.Read()) { CreateEmpleado empleado = null; empleado.tced = reader.GetValue(0).ToString(); empleado.trol = Convert.ToInt32(reader.GetValue(1)); empleado.tnomb = reader.GetValue(2).ToString(); empleado.tape = reader.GetValue(3).ToString(); empleado.tuser = reader.GetValue(4).ToString(); empleado.tpass = reader.GetValue(5).ToString(); listaEmpleado.Add(empleado); } connection.Close(); return listaEmpleado; }
public static bool addClienteToDB(CreateEmpleado empleado) { var connectionString = "Data Source=.;Initial Catalog=TECAirlines;Integrated Security=SSPI"; var query = "INSERT INTO Empleado (Cedula, RolN, Pnombre, Apellidos, Usuario, Pass) VALUES ('@Cedula', @RolN, '@Pnombre', @Apellidos, '@Usuario', @Pass)"; query = query.Replace("@Cedula", empleado.tced) .Replace("@RolN", empleado.trol.ToString()) .Replace("@Pnombre", empleado.tnomb) .Replace("@Apellidos", empleado.tape) .Replace("@Usuario", empleado.tuser) .Replace("@Pass", empleado.tpass); SqlConnection connection = new SqlConnection(connectionString); try { connection.Open(); SqlCommand command = new SqlCommand(query, connection); command.ExecuteNonQuery(); command.Dispose(); connection.Close(); return true; } catch (Exception) { return false; } }
public static CreateEmpleado getEmpleadoFromDB(string user) { SqlDataReader reader = null; SqlConnection connection = new SqlConnection(); connection.ConnectionString = "Data Source=.;Initial Catalog=TECAirlines;Integrated Security=SSPI"; SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandType = CommandType.Text; var query = "SELECT * FROM Empleado WHERE Usuario='@user'"; query = query.Replace("@user", user); sqlCmd.CommandText = query; sqlCmd.Connection = connection; connection.Open(); reader = sqlCmd.ExecuteReader(); CreateEmpleado empleado = null; while (reader.Read()) { empleado = new CreateEmpleado(); empleado.tced = reader.GetValue(0).ToString(); empleado.trol = Convert.ToInt32(reader.GetValue(1)); empleado.tnomb= reader.GetValue(2).ToString(); empleado.tape = reader.GetValue(3).ToString(); empleado.tuser = reader.GetValue(4).ToString(); empleado.tpass = reader.GetValue(5).ToString(); } connection.Close(); return empleado; }
public bool Post(CreateEmpleado empleado) { if (empleado != null) { return(CreateEmpleadoRepository.addClienteToDB(empleado)); } else { return(false); } }