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