/// <summary>
/// Valida LoginUser
/// </summary>
/// <param name="Usuario">Usuario</param>
/// <param name="Pwd">Pwd</param>
/// <returns>return List<string> with data user</string></returns>
public static List <string> LoginUser(string Usuario, string Pwd)
{
List <string> rs = null;
try
{
using (SqlConnection connection = new SqlConnection(Connection.ConnectionString))
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter()
{
ParameterName = "@Usuario", SqlDbType = SqlDbType.VarChar, Value = Usuario
});
parameters.Add(new SqlParameter()
{
ParameterName = "@Pwd", SqlDbType = SqlDbType.VarChar, Value = Pwd
});
//
SqlDataReader reader = SqlHelper.ExecuteReader(connection, CommandType.StoredProcedure, "dbo.udfLogin_User", parameters.ToArray());
//
if (reader.HasRows)
{
rs = new List <string>();
while (reader.Read())
{
if (reader["IdUser"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["IdUser"]));
}
//
if (reader["Usuario"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["Usuario"]));
}
//
if (reader["Pwd"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["Pwd"]));
}
//
if (reader["Nombres"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["Nombres"]));
}
//
if (reader["Apellidos"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["Apellidos"]));
}
//
if (reader["Email"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["Email"]));
}
//
if (reader["IdRol"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["IdRol"]));
}
//
if (reader["IdStateRow"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["IdStateRow"]));
}
//
if (reader["FechaCreacion"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["FechaCreacion"]));
}
//
if (reader["HostName"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["HostName"]));
}
}
}
}
}
catch (Exception ex)
{
SealsLogService.AddLog("UserService", "LoginUser", ex.Message, ex.StackTrace, ex.TargetSite.ToString(), 1, 1, "LocalHost");
}
return(rs);
}
/// <summary>
/// insert token
/// </summary>
/// <param name="IdUser">IdUser</param>
/// <param name="IdStateRow">IdStateRow</param>
/// <param name="HostName">HostName</param>
/// <returns>return token insert</returns>
public static List <string> InsertToken(int IdUser, int IdStateRow, string HostName)
{
List <string> rs = null;
try
{
using (SqlConnection connection = new SqlConnection(Connection.ConnectionString))
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter()
{
ParameterName = "@IdUser", SqlDbType = SqlDbType.Int, Value = IdUser
});
parameters.Add(new SqlParameter()
{
ParameterName = "@IdStateRow", SqlDbType = SqlDbType.Int, Value = IdStateRow
});
parameters.Add(new SqlParameter()
{
ParameterName = "@HostName", SqlDbType = SqlDbType.VarChar, Value = HostName
});
//
SqlDataReader reader = SqlHelper.ExecuteReader(connection, CommandType.StoredProcedure, "dbo.udfToken_Insert", parameters.ToArray());
//
if (reader.HasRows)
{
rs = new List <string>();
while (reader.Read())
{
if (reader["IdToken"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["IdToken"]));
}
//
if (reader["IdUser"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["IdUser"]));
}
//
if (reader["KeyPass"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["KeyPass"]));
}
//
if (reader["CreateDate"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["CreateDate"]));
}
//
if (reader["ModifyDate"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["ModifyDate"]));
}
//
if (reader["IdStateRow"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["IdStateRow"]));
}
//
if (reader["FechaCreacion"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["FechaCreacion"]));
}
//
if (reader["HostName"] != DBNull.Value)
{
rs.Add(Convert.ToString(reader["HostName"]));
}
}
}
}
}
catch (Exception ex)
{
SealsLogService.AddLog("TokenService", "InsertToken", ex.Message, ex.StackTrace, ex.TargetSite.ToString(), 1, 1, "LocalHost");
}
return(rs);
}