public List <Usuario> ConsultarUsuariosProcesar(string conexion) { SqlConnection Sqlcon = null; SqlCommand cmd = null; List <Usuario> list = new List <Usuario>(); Usuario item = null; try { Parametros Parameter = new Parametros(); Sqlcon = new SqlConnection(conexion); Sqlcon.Open(); cmd = Sqlcon.CreateCommand(); cmd.CommandText = Parametros.fc_SPS_USUARIOS_PROCESAR; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandTimeout = 0; cmd.ExecuteScalar(); SqlDataAdapter da = new SqlDataAdapter(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { item = new Usuario(); if (!dr.IsDBNull(dr.GetOrdinal("Usu_Id"))) { item.Id = long.Parse(dr.GetValue(dr.GetOrdinal("Usu_Id")).ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("Usu_Identificacion"))) { item.Identificacion = dr.GetString(dr.GetOrdinal("Usu_Identificacion")); } if (!dr.IsDBNull(dr.GetOrdinal("Usu_Nombre"))) { item.NombreCompleto = dr.GetString(dr.GetOrdinal("Usu_Nombre")); } list.Add(item); } dr.Close(); dr.Dispose(); } catch (SqlException ex) { string name = this.GetType().FullName.ToString(); System.Reflection.MethodBase currentMethod = System.Reflection.MethodBase.GetCurrentMethod(); throw ex; } catch (Exception ex) { string name = this.GetType().FullName.ToString(); System.Reflection.MethodBase currentMethod = System.Reflection.MethodBase.GetCurrentMethod(); throw ex; } finally { if (Sqlcon != null) { Sqlcon.Close(); Sqlcon.Dispose(); } if (cmd != null) { cmd.Dispose(); } } return(list); }
public void ActualizarUsuario(Usuario usuario, string conexion) { this.Estado = false; object retval = null; SqlConnection Sqlcon = null; SqlCommand cmd = null; SqlTransaction tran = null; SqlParameter param; try { Parametros Parameter = new Parametros(); Sqlcon = new SqlConnection(conexion); Sqlcon.Open(); tran = Sqlcon.BeginTransaction(); cmd = Sqlcon.CreateCommand(); cmd.Transaction = tran; cmd.CommandText = Parametros.fu_SPU_ACTUALIZAR_USUARIO; cmd.CommandType = System.Data.CommandType.StoredProcedure; param = cmd.CreateParameter(); param.ParameterName = "@usu_identificacion"; param.Value = usuario.Identificacion; cmd.Parameters.Add(param); param = cmd.CreateParameter(); param.ParameterName = "@usu_dispositivo"; param.Value = usuario.Dispositivo; cmd.Parameters.Add(param); param = cmd.CreateParameter(); param.ParameterName = "@usu_perfil"; param.Value = usuario.Perfil; cmd.Parameters.Add(param); param = cmd.CreateParameter(); param.ParameterName = "@usu_password"; param.Value = usuario.Password; cmd.Parameters.Add(param); param = cmd.CreateParameter(); param.ParameterName = "@usu_nombre"; param.Value = usuario.NombreCompleto; cmd.Parameters.Add(param); param = cmd.CreateParameter(); param.ParameterName = "@usu_fechacierre"; param.Value = usuario.FechaCierre; cmd.Parameters.Add(param); retval = cmd.ExecuteScalar(); tran.Commit(); this.Estado = true; } catch (SqlException ex) { string name = this.GetType().FullName.ToString(); System.Reflection.MethodBase currentMethod = System.Reflection.MethodBase.GetCurrentMethod(); throw ex; } catch (Exception ex) { string name = this.GetType().FullName.ToString(); System.Reflection.MethodBase currentMethod = System.Reflection.MethodBase.GetCurrentMethod(); throw ex; } finally { if (Sqlcon != null) { Sqlcon.Close(); Sqlcon.Dispose(); tran.Dispose(); } if (cmd != null) { cmd.Dispose(); } } }
public void RegistraDispositivo(string usu_identificacion, string dispositivo, string conexion) { this.Estado = false; object retval = null; SqlConnection Sqlcon = null; SqlCommand cmd = null; SqlTransaction tran = null; SqlParameter param; try { Parametros Parameter = new Parametros(); Sqlcon = new SqlConnection(conexion); Sqlcon.Open(); tran = Sqlcon.BeginTransaction(); cmd = Sqlcon.CreateCommand(); cmd.Transaction = tran; cmd.CommandText = Parametros.fu_SPU_REGISTRA_DISPOSITIVO; cmd.CommandType = System.Data.CommandType.StoredProcedure; param = cmd.CreateParameter(); param.ParameterName = "@usu_identificacion"; param.Value = usu_identificacion; cmd.Parameters.Add(param); param = cmd.CreateParameter(); param.ParameterName = "@usu_dispositivo"; param.Value = dispositivo; cmd.Parameters.Add(param); retval = cmd.ExecuteScalar(); tran.Commit(); this.Estado = true; } catch (SqlException ex) { string name = this.GetType().FullName.ToString(); System.Reflection.MethodBase currentMethod = System.Reflection.MethodBase.GetCurrentMethod(); throw ex; } catch (Exception ex) { string name = this.GetType().FullName.ToString(); System.Reflection.MethodBase currentMethod = System.Reflection.MethodBase.GetCurrentMethod(); throw ex; } finally { if (Sqlcon != null) { Sqlcon.Close(); Sqlcon.Dispose(); tran.Dispose(); } if (cmd != null) { cmd.Dispose(); } } }
public Usuario ConsultarLogin(string usu_identificacion, string usu_password, string conexion) { SqlConnection Sqlcon = null; SqlCommand cmd = null; SqlParameter param; Usuario item = null; try { Parametros Parameter = new Parametros(); Sqlcon = new SqlConnection(conexion); Sqlcon.Open(); cmd = Sqlcon.CreateCommand(); cmd.CommandText = Parametros.fc_SPS_LOGIN; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandTimeout = 0; param = cmd.CreateParameter(); param.ParameterName = "@usu_identificacion"; param.Value = usu_identificacion; cmd.Parameters.Add(param); param = cmd.CreateParameter(); param.ParameterName = "@usu_password"; param.Value = usu_password; cmd.Parameters.Add(param); cmd.ExecuteScalar(); SqlDataAdapter da = new SqlDataAdapter(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { item = new Usuario(); if (!dr.IsDBNull(dr.GetOrdinal("Usu_Id"))) { item.Id = long.Parse(dr.GetValue(dr.GetOrdinal("Usu_Id")).ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("Usu_Identificacion"))) { item.Identificacion = dr.GetString(dr.GetOrdinal("Usu_Identificacion")); } if (!dr.IsDBNull(dr.GetOrdinal("Usu_Dispositivo"))) { item.Dispositivo = dr.GetString(dr.GetOrdinal("Usu_Dispositivo")); } if (!dr.IsDBNull(dr.GetOrdinal("Usu_Perfil"))) { item.Perfil = dr.GetString(dr.GetOrdinal("Usu_Perfil")); } if (!dr.IsDBNull(dr.GetOrdinal("Usu_Password"))) { item.Password = dr.GetString(dr.GetOrdinal("Usu_Password")); } } dr.Close(); dr.Dispose(); } catch (SqlException ex) { string name = this.GetType().FullName.ToString(); System.Reflection.MethodBase currentMethod = System.Reflection.MethodBase.GetCurrentMethod(); throw ex; } catch (Exception ex) { string name = this.GetType().FullName.ToString(); System.Reflection.MethodBase currentMethod = System.Reflection.MethodBase.GetCurrentMethod(); throw ex; } finally { if (Sqlcon != null) { Sqlcon.Close(); Sqlcon.Dispose(); } if (cmd != null) { cmd.Dispose(); } } return(item); }