/// <summary>
/// Actualiza Administrador
/// </summary>
/// <param name="theEmpresaDTO"></param>
/// <returns></returns>
public static int UpdateAdministrador(UsuarioDTO theUsuarioDTO)
{
SqlConnection myConnection = IMDB.GetConnection();
SqlCommand myCommand = new SqlCommand("UDP_administrador", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
//myCommand.Parameters.Add("@paterno", SqlDbType.VarChar).Value = theUsuarioDTO.Paterno;
//myCommand.Parameters.Add("@materno", SqlDbType.VarChar).Value = theUsuarioDTO.Materno;
//myCommand.Parameters.Add("@nombres", SqlDbType.VarChar).Value = theUsuarioDTO.Nombres;
//myCommand.Parameters.Add("@rut", SqlDbType.Int).Value = theUsuarioDTO.Rut;
//myCommand.Parameters.Add("@mail", SqlDbType.VarChar).Value = theUsuarioDTO.Mail;
//myCommand.Parameters.Add("@empresa", SqlDbType.Int).Value = theUsuarioDTO.Empresa;
//myCommand.Parameters.Add("@usuarioIngreso", SqlDbType.Int).Value = theUsuarioDTO.UsuarioIngreso;
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
return(0);
}
/// <summary>
/// Actualiza Intentos Fallidos
/// </summary>
/// <param name="mvarUsuarioCod"></param>
/// <param name="pvarIntentoFallidoCant"></param>
private static void ActIntentoFallidos(string mvarUsuarioCod, short pvarIntentoFallidoCant)
{
SqlConnection myConnection = IMDB.GetConnection();
SqlCommand myCommand = new SqlCommand("UPD_Operador1", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
SqlDataReader datos;
string idEmpleado = string.Empty;
myCommand.Parameters.Add("@pUsu_Rut", SqlDbType.VarChar).Value = mvarUsuarioCod;
myCommand.Parameters.Add("@pIntentoFallidoFecha", SqlDbType.VarChar).Value = "";
myCommand.Parameters.Add("@pIntentoFallidoCant", SqlDbType.VarChar).Value = pvarIntentoFallidoCant;
try
{
myConnection.Open();
datos = myCommand.ExecuteReader();
while (datos.Read())
{
idEmpleado = datos.GetString(0);
}
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
myConnection.Close();
}
}
/// <summary>
/// Agregar un usuario
/// </summary>
/// <param name="UsuarioDTO"></param>
/// <returns></returns>
public static int InsertarUsuario(UsuarioDTO UsuarioDTO)
{
SqlConnection myConnection = IMDB.GetConnection();
SqlCommand myCommand = new SqlCommand("ins_usuario", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@rut", SqlDbType.VarChar).Value = UsuarioDTO.Usuario;
myCommand.Parameters.Add("@password", SqlDbType.VarChar).Value = UsuarioDTO.Password;
myCommand.Parameters.Add("@pNombreUsuario", SqlDbType.VarChar).Value = UsuarioDTO.Nombres;
myCommand.Parameters.Add("@pPaternoUsuario", SqlDbType.VarChar).Value = UsuarioDTO.Paterno;
myCommand.Parameters.Add("@pMaternoUsuario", SqlDbType.VarChar).Value = UsuarioDTO.Materno;
myCommand.Parameters.Add("@pFechaNacimiento", SqlDbType.DateTime).Value = UsuarioDTO.FechaNacimiento;
myCommand.Parameters.Add("@pMailUsuario", SqlDbType.VarChar).Value = UsuarioDTO.Mail;
myCommand.Parameters.Add("@pIdCondominio", SqlDbType.Decimal).Value = UsuarioDTO.IdCondominio;
myCommand.Parameters.Add("@usuarioIngreso", SqlDbType.VarChar).Value = UsuarioDTO.UsuarioIngreso;
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
return(0);
}
/// <summary>
/// Actualiza datos de empresa existente
/// </summary>
/// <param name="theEmpresaDTO"></param>
/// <returns></returns>
public static int UpdateCondominio(CondominioDTO theCondominioDTO)
{
SqlConnection myConnection = IMDB.GetConnection();
SqlCommand myCommand = new SqlCommand("UPD_CONDOMINIO", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@idCondominio", SqlDbType.Decimal).Value = theCondominioDTO.IdCondominio;
myCommand.Parameters.Add("@idPorteria", SqlDbType.Decimal).Value = theCondominioDTO.IdPorteria;
myCommand.Parameters.Add("@idAdministracion", SqlDbType.Decimal).Value = theCondominioDTO.IdAdministracion;
myCommand.Parameters.Add("@nombreCondominio", SqlDbType.VarChar).Value = theCondominioDTO.NombreCondominio;
myCommand.Parameters.Add("@telefonoCondominio", SqlDbType.VarChar).Value = theCondominioDTO.TelefonoCondominio;
myCommand.Parameters.Add("@correoCondominio", SqlDbType.VarChar).Value = theCondominioDTO.EmailCondominio;
myCommand.Parameters.Add("@direccionCondominio", SqlDbType.VarChar).Value = theCondominioDTO.DireccionCondominio;
myCommand.Parameters.Add("@usuarioIngreso", SqlDbType.VarChar).Value = theCondominioDTO.UsuarioIngreso;
myCommand.Parameters.Add("@fechaIngreso", SqlDbType.DateTime).Value = theCondominioDTO.FechaIngreso;
myCommand.Parameters.Add("@usuarioModificacion", SqlDbType.VarChar).Value = theCondominioDTO.UsuarioModificacion;
myCommand.Parameters.Add("@fechaModificacion", SqlDbType.DateTime).Value = theCondominioDTO.FechaModificacion;
myCommand.Parameters.Add("@estado", SqlDbType.Int).Value = theCondominioDTO.Estado;
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
return(0);
}
public void AddMovie(IMDB movie)
{
try
{
//progressLabel.Content = string.Format("Adding movie [ {0} ]...", Movie.Title);
bool inserted = movie.AddMovieToCollection();
if (inserted)
{
_moviesInsertedSuccessfully++;
}
movie.Inserted = inserted;
//processedMovies.Add( movie );
//Film moviePulledFromDB = movieToRetrieve.ReadMovieFromCollection();
Dispatcher.Invoke(_updatePbDelegate,
System.Windows.Threading.DispatcherPriority.Background, new object[]
{
RangeBase.ValueProperty, (double)_movieCount
});
}
catch (Exception ex)
{
Log.Trace("Could not complete movie insert", movie.Title);
Log.Error(ex);
ex.ThrowFormattedException();
}
}
/// <summary>
/// Inserta una nueva Empresa
/// </summary>
/// <param name="theEmpresaDTO"></param>
/// <returns></returns>
public static int InsertarCondominio(CondominioDTO theCondominioDTO)
{
SqlConnection myConnection = IMDB.GetConnection();
SqlCommand myCommand = new SqlCommand("INS_Condominio", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@pRutCondominio", SqlDbType.VarChar).Value = theCondominioDTO.RutCondominio;
myCommand.Parameters.Add("@pNombreCondominio", SqlDbType.VarChar).Value = theCondominioDTO.NombreCondominio;
myCommand.Parameters.Add("@pTelefonoCondominio", SqlDbType.VarChar).Value = theCondominioDTO.TelefonoCondominio;
myCommand.Parameters.Add("@pCorreoCondominio", SqlDbType.VarChar).Value = theCondominioDTO.EmailCondominio;
myCommand.Parameters.Add("@pDireccionCondominio", SqlDbType.VarChar).Value = theCondominioDTO.DireccionCondominio;
myCommand.Parameters.Add("@pUsuarioIngreso", SqlDbType.VarChar).Value = theCondominioDTO.UsuarioIngreso;
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
return(0);
}
/// <summary>
/// Lista usuarios
/// </summary>
/// <returns></returns>
public static List <UsuarioDTO> ListaUsuarios()
{
SqlConnection myConnection = IMDB.GetConnection();
SqlCommand myCommand = new SqlCommand("QRY_listaUsuarios", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
SqlDataReader datos;
UsuarioDTO theUsuarioDTO;
List <UsuarioDTO> usuario = new List <UsuarioDTO>();
try
{
myConnection.Open();
datos = myCommand.ExecuteReader();
while (datos.Read())
{
theUsuarioDTO = new UsuarioDTO();
if (!datos.IsDBNull(0))
{
theUsuarioDTO.Rut = datos.GetString(0);
}
if (!datos.IsDBNull(1))
{
theUsuarioDTO.Nombres = datos.GetString(1);
}
if (!datos.IsDBNull(2))
{
theUsuarioDTO.Paterno = datos.GetString(2);
}
if (!datos.IsDBNull(3))
{
theUsuarioDTO.Materno = datos.GetString(3);
}
if (!datos.IsDBNull(4))
{
theUsuarioDTO.Mail = datos.GetString(4);
}
if (!datos.IsDBNull(13))
{
theUsuarioDTO.Estado = datos.GetInt32(13).ToString();
}
usuario.Add(theUsuarioDTO);
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
finally
{
myConnection.Close();
}
return(usuario);
}
public ActionResult AddMovie(IMDB movie)
{
if (ModelState.IsValid)
{
DbRepository.AddMovie(movie);
DbRepository.Save();
}
return(RedirectToAction("MovieIndex"));
}
public static List <FuncionDTO> ListaFuncionGrupoSistema()
{
SqlConnection myConnection = IMDB.GetConnection();
SqlCommand myCommand = new SqlCommand("GetFuncionalidadesSistema", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
SqlDataReader datos;
FuncionDTO theFuncionDTO;
List <FuncionDTO> funciones = new List <FuncionDTO>();
string idEmpleado = string.Empty;
try
{
myConnection.Open();
datos = myCommand.ExecuteReader();
while (datos.Read())
{
theFuncionDTO = new FuncionDTO();
try
{
if (!datos.IsDBNull(0))
{
theFuncionDTO.FuncionCod = datos.GetInt32(0).ToString();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
try
{
if (!datos.IsDBNull(1))
{
theFuncionDTO.FuncionNombre = datos.GetString(1);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
funciones.Add(theFuncionDTO);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
myConnection.Close();
}
return(funciones);
}
public static YouCom.DTO.Seguridad.UsuarioDTO GetGrupos(string pvarUsuarioCod)
{
SqlConnection myConnection = IMDB.GetConnection();
SqlCommand myCommand = new SqlCommand("QRY_Permiso3", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
SqlDataReader datos;
List <FuncionGrupoDTO> ListfuncionGrupo = new List <FuncionGrupoDTO>();
FuncionGrupoDTO theFuncionGrupo;
FuncionDTO theFuncionDTO;
YouCom.DTO.Seguridad.UsuarioDTO theOperador = new YouCom.DTO.Seguridad.UsuarioDTO();
theOperador.Grupo = new List <FuncionGrupoDTO>();
myCommand.Parameters.Add("@pUSU_RUT", SqlDbType.VarChar).Value = pvarUsuarioCod;
try
{
myConnection.Open();
datos = myCommand.ExecuteReader();
while (datos.Read())
{
theFuncionDTO = new FuncionDTO();
theFuncionGrupo = new FuncionGrupoDTO();
theFuncionGrupo.Funciones = new List <FuncionDTO>();
ListfuncionGrupo = new List <FuncionGrupoDTO>();
///Carga Grupo
theFuncionGrupo.FuncionGrupoCod = datos.GetInt32(0).ToString();
theFuncionGrupo.FuncionGrupoNombre = datos.GetString(1);
theFuncionGrupo.FuncionGrupoTipo = datos.GetString(5);
///Carga Funcionalidades de Grupo y Funcionalidades Internas del Negocio
theFuncionDTO.FuncionCod = datos.GetInt32(2).ToString();
theFuncionDTO.FuncionNombre = datos.GetString(3);
theFuncionDTO.Url = datos.GetString(4);
theFuncionDTO.FuncionalidadNegocio = datos.GetString(5);
theFuncionGrupo.Funciones.Add(theFuncionDTO);
// ListfuncionGrupo.Add(theFuncionGrupo);
theOperador.Grupo.Add(theFuncionGrupo);
}
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
myConnection.Close();
}
return(theOperador);
}
private void SaveTransaction()
{
foreach (var transaction in this.CurrentTransaction.FullChain)
{
if (!IMDB.Add(transaction))
{
throw new ApplicationException(String.Format("Commit ({0}) - SaveTransaction", this.CurrentTransaction.Id));
}
}
}
//Invokes DisplayTrailers View.
public ActionResult DisplayTrailers()
{
IMDB imdb = null;
string movie = Convert.ToString(Request.Form["movieName"]);
if (!string.IsNullOrEmpty(movie))
{
imdb = new IMDB(movie);
}
return(View(imdb));
}
public IEnumerable <string> Handle(string input, Match match, IListener listener)
{
var query = match.Groups[1].Value.Trim();
var imdb = IMDB.FromQuery(query);
yield return("{0} received a rating of {1}.".Template(imdb.Title, imdb.ImdbRating));
if (double.Parse(imdb.ImdbRating) > 6)
{
yield return("You should probably watch it.");
}
}
public static List <FuncionDTO> ListaPermisos(string Usuario)
{
SqlConnection myConnection = IMDB.GetConnection();
SqlCommand myCommand = new SqlCommand("PermisosUsuario", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@usuario", SqlDbType.VarChar).Value = Usuario;
SqlDataReader datos;
FuncionDTO theFuncionDTO;
List <FuncionDTO> funciones = new List <FuncionDTO>();
try
{
myConnection.Open();
datos = myCommand.ExecuteReader();
while (datos.Read())
{
theFuncionDTO = new FuncionDTO();
if (!datos.IsDBNull(0))
{
theFuncionDTO.FuncionNombre = datos.GetString(0);
}
if (!datos.IsDBNull(1))
{
theFuncionDTO.FuncionCod = datos.GetInt32(1).ToString();
}
if (!datos.IsDBNull(2))
{
theFuncionDTO.EnviaCorreo = datos.GetString(2);
}
//if (!datos.IsDBNull(2))
//{
// theFuncionDTO.Estado = datos.GetString(3);
//}
funciones.Add(theFuncionDTO);
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
finally
{
myConnection.Close();
}
return(funciones);
}
public static void Run()
{
//Load IMDb dataset
var((x_train, y_train), (x_test, y_test)) = IMDB.LoadData();
var X = np.concatenate(new NDarray[] { x_train, x_test }, axis: 0);
var Y = np.concatenate(new NDarray[] { y_train, y_test }, axis: 0);
Console.WriteLine("Shape of X: " + X.shape);
Console.WriteLine("Shape of Y: " + Y.shape);
//We can get an idea of the total number of unique words in the dataset.
Console.WriteLine("Number of words: ");
var hstack = np.hstack(new NDarray[] { X });
//var unique = hstack.unique();
//Console.WriteLine(np.unique(np.hstack(new NDarray[] { X })).Item1);
// Load the dataset but only keep the top n words, zero the rest
int top_words = 1000;// 5000;
((x_train, y_train), (x_test, y_test)) = IMDB.LoadData(num_words: top_words);
int max_words = 500;
x_train = SequenceUtil.PadSequences(x_train, maxlen: max_words);
x_test = SequenceUtil.PadSequences(x_test, maxlen: max_words);
//Create model
Sequential model = new Sequential();
model.Add(new Embedding(top_words, 32, input_length: max_words));
model.Add(new Conv1D(filters: 32, kernel_size: 3, padding: "same", activation: "relu"));
model.Add(new MaxPooling1D(pool_size: 2));
model.Add(new Flatten());
model.Add(new Dense(250, activation: "relu"));
model.Add(new Dense(1, activation: "sigmoid"));
model.Compile(loss: "binary_crossentropy", optimizer: "adam", metrics: new string[] { "accuracy" });
model.Summary();
// Fit the model
model.Fit(x_train, y_train, validation_data: new NDarray[] { x_test, y_test },
epochs: 1 /*10*/, batch_size: 128, verbose: 2);
// Final evaluation of the model
var scores = model.Evaluate(x_test, y_test, verbose: 0);
Console.WriteLine("Accuracy: " + (scores[1] * 100));
model.Save("model.h5");
File.WriteAllText("model.json", model.ToJson()); //save model
//model.SaveTensorflowJSFormat("./"); //error - Cannot perform runtime binding on a null reference
}
public MetaCollector(IMDB imdb)
{
SeriesName = imdb.SeriesName;
int SeasonNumber = Int32.Parse(imdb.Season);
SeasonNumberString = iToString(SeasonNumber);
int EpisodeNumber = Int32.Parse(imdb.EpisodeNumber);
EpisodeNumberString = iToString(EpisodeNumber);
EpisodeName = imdb.EpisodeName;
}
private void CreateFilmList()
{
Thread th = new Thread(new ThreadStart(() => {
IMDB imdb = new IMDB();
string[] dirs = new Settings().GetSetting("movieDirs").Split('|');
for (int i = 0; i < dirs.Length; i++)
{
imdb.GetInfo(new Files().SearchDir(dirs[i]));
}
new Speech().Speak("Finished updating the film list!");
}));
th.Start();
}
public static void Register(Pipe pipe)
{
//Actors
pipe.Listen((input, match, listener) =>
{
var query = match.Groups[1].Value;
var imdb = IMDB.FromQuery(query);
listener.Output("{0} were in {1}".Template(imdb.Actors, imdb.Title));
}, "who.+in (.+)");
//Alarm
pipe.Listen((input, match, listener) =>
{
ClockTicker.Instance.StopAlarm();
Brain.Awake = true;
}, "alarm");
//Close
pipe.Listen((input, match, listener) =>
{
var process = match.Groups[1].Value.ToLower();
var list = Process.GetProcesses().Where(o => o.ProcessName.ToLower().Contains(process)).ToList();
if (list.Count < 0)
{
return;
}
foreach (var p in list)
{
try
{
p.Kill();
}
catch (Exception)
{
}
}
listener.Output("I've closed " + list.FirstOrDefault());
}, "close (.+)");
//Restart
pipe.Listen((input, match, listener) =>
{
listener.Output("Restarting...");
var path = Assembly.GetAssembly(typeof(Brain)).Location;
Process.Start(path);
Environment.Exit(0);
}, "restart");
}
private void ButtonClick1(object sender, RoutedEventArgs e)
{
//Find Movie Clicked
string movieToRetrieve = TitleToSearch.Text;
if (!string.IsNullOrWhiteSpace(movieToRetrieve))
{
Movie = GetIMDBMovie(movieToRetrieve);
retrievedTitle.Content = Movie.Title;
retreievedLeadActor.Content = Movie.Cast.ToArray().ToList().First();
retrievedYear.Content = Movie.Year;
}
else
{
"You have to enter a title to search for".ShowMessage();
}
}
/// <summary>
/// lista Funciones Asociadas a Grupo para el perfilamiento de usuario
/// </summary>
/// <returns></returns>
public static List <FuncionDTO> ListaFunciones(int FuncionGrupo)
{
SqlConnection myConnection = IMDB.GetConnection();
SqlCommand myCommand = new SqlCommand("QRY_listaFuncionesGrupo", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@FuncionGrupoCod", SqlDbType.Int).Value = FuncionGrupo;
SqlDataReader datos;
FuncionDTO theFuncionDTO;
List <FuncionDTO> funciones = new List <FuncionDTO>();
try
{
myConnection.Open();
datos = myCommand.ExecuteReader();
while (datos.Read())
{
theFuncionDTO = new FuncionDTO();
if (!datos.IsDBNull(0))
{
theFuncionDTO.FuncionCod = datos.GetInt32(0).ToString();
}
if (!datos.IsDBNull(1))
{
theFuncionDTO.FuncionNombre = datos.GetString(1);
}
funciones.Add(theFuncionDTO);
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
finally
{
myConnection.Close();
}
return(funciones);
}
public static void DeletePermisos(PermisoDTO thePermisoDTO)
{
SqlConnection myConnection = IMDB.GetConnection();
SqlCommand myCommand = new SqlCommand("DEL_Permisos", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@usuario", SqlDbType.Int).Value = thePermisoDTO.Usuario;
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
}
public static void Predict(string text)
{
var model = Sequential.LoadModel("model.h5");
string result = "";
var indexes = IMDB.GetWordIndex();
string[] words = TextUtil.TextToWordSequence(text);
float[] tokens = words.Select(i => ((float)indexes[i])).ToArray();
NDarray x = np.array(tokens);
x = x.reshape(1, x.shape[0]);
x = SequenceUtil.PadSequences(x, maxlen: 500);
var y = model.Predict(x);
var binary = Math.Round(y[0].asscalar <float>());
result = binary == 0 ? "Negative" : "Positive";
Console.WriteLine("Sentiment for \"{0}\": {1}", text, result);
}
/// <summary>
/// Desactiva una empresa y todos los usuario asociados
/// </summary>
/// <param name="theEmpresaDTO"></param>
/// <returns></returns>
public static int DeleteCondominio(CondominioDTO theCondominioDTO)
{
SqlConnection myConnection = IMDB.GetConnection();
SqlCommand myCommand = new SqlCommand("ACT_CONDOMINIO", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@idCondominio", SqlDbType.Int).Value = theCondominioDTO.IdCondominio;
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
return(0);
}
/// <summary>
/// Inserta los permisos para las funcionalidades al Usuario asignado
/// </summary>
public static void InsertaPermisos(PermisoDTO thePermisoDTO)
{
SqlConnection myConnection = IMDB.GetConnection();
SqlCommand myCommand = new SqlCommand("INS_Permiso", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@pGrupoCod", SqlDbType.VarChar).Value = thePermisoDTO.Empresa;
myCommand.Parameters.Add("@pRolCod", SqlDbType.VarChar).Value = thePermisoDTO.Usuario;
myCommand.Parameters.Add("@pFuncionCod", SqlDbType.VarChar).Value = thePermisoDTO.Funcion;
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// Activa o Desactiva Usuarios
/// </summary>
/// <param name="UsuarioDTO"></param>
/// <returns></returns>
public static int ActivaDesactivaUsuario(UsuarioDTO UsuarioDTO)
{
SqlConnection myConnection = IMDB.GetConnection();
SqlCommand myCommand = new SqlCommand("activaDesactivaUsuario", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
//myCommand.Parameters.Add("@rut", SqlDbType.Int).Value = UsuarioDTO.Rut;
//myCommand.Parameters.Add("@usuarioModificacion", SqlDbType.VarChar).Value = UsuarioDTO.UsuarioModificacion;
//myCommand.Parameters.Add("@estado", SqlDbType.Int).Value = UsuarioDTO.Estado;
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
return(0);
}
public HTMLExtractor(string passedURL)
{
URL = passedURL;
SiteName = SiteDetector(URL);
using (WebClient client = new WebClient()) // WebClient class inherits IDisposable
{
HTML = client.DownloadString(URL);
}
if (SiteName.ToLower() == "imdb")
{
IMDB imdb = new IMDB(HTML);
MetaCollector = new MetaCollector(imdb);
}
else
{
TV tv = new TV(HTML);
MetaCollector = new MetaCollector(tv);
}
}
/// <summary>
/// Override the function from the BackgroundWorker Class
/// </summary>
/// <param name="e">The object that we want to be processed.</param>
protected override void OnDoWork(DoWorkEventArgs e)
{
WorkerReportsProgress = true;
String url = ((Params)e.Argument).url;
bool[] fields = ((Params)e.Argument).fields;
int media = ((Params)e.Argument).media;
int actorN = ((Params)e.Argument).actorN;
int sSeas = ((Params)e.Argument).sSeas;
int eSeas = ((Params)e.Argument).eSeas;
XmlDocument xmlDoc = ((Params)e.Argument).xmlDoc;
IMDB imdb = new IMDB();
imdb.parentProgressCaller = progressCaller;
imdb.parentErrorCaller = errorCaller;
bool success = imdb.getPage(url);
if (success)
{
this.ReportProgress(40);
imdb.parseTitlePage(xmlDoc, fields, media, actorN, sSeas, eSeas);
}
}
private void ButtonClick1(object sender, RoutedEventArgs e)
{
_moviesInsertedSuccessfully = 0;
MoviesToAdd = listOfMovies.Text.Split(new[] { "\r\n", "\n", Environment.NewLine }, StringSplitOptions.None).ToList();
progressBar.Minimum = 0;
progressBar.Maximum = MoviesToAdd.Count;
progressBar.Value = 0;
progressBar.Visibility = Visibility.Visible;
Stopwatch timer = new Stopwatch();
timer.Start();
foreach (string movieToRetrieve in MoviesToAdd)
{
_movieCount++;
if (!string.IsNullOrWhiteSpace(movieToRetrieve))
{
if (movieToRetrieve.Contains(@"http://www.imdb.com/title"))
{
try
{
IMDB Movie = new IMDB(movieToRetrieve, true);
AddMovie(Movie);
}
catch (Exception ex)
{
Log.Error("Could not add movie to collection: [ {0} ]", new object[] { movieToRetrieve });
}
}
}
}
//Switcher.Switch(new AddResults( processedMovies));
timer.Stop();
"Inserted {0} of {1} movies successfully, Total run time: {2}, (see log for any failures)".ShowMessage(new object[] { _moviesInsertedSuccessfully, MoviesToAdd.Count, timer.Elapsed.ToReadableString() });
}
public static YouCom.DTO.Seguridad.UsuarioDTO AuntetificaUsuario(string usuario, string password)
{
SqlConnection myConnection = IMDB.GetConnection();
SqlCommand myCommand = new SqlCommand("QRY_Operador", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
SqlDataReader datos;
YouCom.DTO.Seguridad.UsuarioDTO theOperadorDTO = new YouCom.DTO.Seguridad.UsuarioDTO();
string idEmpleado = string.Empty;
myCommand.Parameters.Add("@pUsuario", SqlDbType.VarChar).Value = usuario;
try
{
myConnection.Open();
datos = myCommand.ExecuteReader();
while (datos.Read())
{
if (!datos.IsDBNull(0))
{
theOperadorDTO.OperadorNro = int.Parse(datos.GetString(0).ToString().Substring(0, datos.GetString(0).ToString().Length - 1));
theOperadorDTO.Usuario = datos.GetString(0).ToString();
}
if (!datos.IsDBNull(1))
{
theOperadorDTO.Password = datos.GetString(1);
}
if (!datos.IsDBNull(2))
{
theOperadorDTO.Fechapass = datos.GetDateTime(2);
}
if (!datos.IsDBNull(3))
{
theOperadorDTO.IntentoFallidoFecha = datos.GetDateTime(3);
}
if (!datos.IsDBNull(4))
{
theOperadorDTO.IntentoFallidoCant = datos.GetInt32(4);
}
if (!datos.IsDBNull(5))
{
theOperadorDTO.Nombres = datos.GetString(5).ToString();
}
if (!datos.IsDBNull(6))
{
theOperadorDTO.Paterno = datos.GetString(6).ToString();
}
if (!datos.IsDBNull(7))
{
theOperadorDTO.Materno = datos.GetString(7).ToString();
}
}
if (theOperadorDTO.Password == password)
{
if (theOperadorDTO.IntentoFallidoCant >= 3)
{
throw new Exception("4|Estimado Cliente, Supero reintentos permitidos Usuario Bloqueado");
}
else
{
ActIntentoFallidos(usuario, 0);
}
}
else
{
theOperadorDTO.IntentoFallidoCant = theOperadorDTO.IntentoFallidoCant + 1;
ActIntentoFallidos(usuario, Convert.ToInt16(theOperadorDTO.IntentoFallidoCant));
throw new Exception("2|El usuario o la contraseña son incorrectos.");
///usuario pass erroneas
//return false
}
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
myConnection.Close();
}
return(theOperadorDTO);
}
/// <summary>
/// Default constructor
/// </summary>
public Utilities()
{
_context = new IMDB();
}
/// <summary>
/// Override the function from the BackgroundWorker Class
/// </summary>
/// <param name="e">The object that we want to be processed.</param>
protected override void OnDoWork(DoWorkEventArgs e)
{
WorkerReportsProgress = true;
String url = ((Params)e.Argument).url;
bool[] fields = ((Params)e.Argument).fields;
int media = ((Params)e.Argument).media;
int actorN = ((Params)e.Argument).actorN;
int sSeas = ((Params)e.Argument).sSeas;
int eSeas = ((Params)e.Argument).eSeas;
XmlDocument xmlDoc = ((Params)e.Argument).xmlDoc;
IMDB imdb = new IMDB();
imdb.parentProgressCaller = progressCaller;
imdb.parentErrorCaller = errorCaller;
bool success = imdb.getPage(url);
if (success)
{
this.ReportProgress(40);
imdb.parseTitlePage(xmlDoc, fields, media, actorN, sSeas, eSeas);
}
}
