public response validar_credenciales(string user_name, string password)
{
string query = "select contrasena from Usuarios where correo_electronico = '" + user_name + "'";
MySqlCommand comando = conn.conex.CreateCommand();
comando.CommandText = query;
MySqlDataReader reader = comando.ExecuteReader();
Login_model model = null;
while (reader.Read())
{
model = new Login_model(user_name, reader["contrasena"].ToString());
break;
}
if (model != null)
{
return(model.validate(password));
}
return(new response(false, "No existe usuario"));
}
public Get_Post_List LoginService(Login_model user)
{
string status = "failed";
Get_Post_List list = new Get_Post_List();
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["PortalConnectionString"].ToString()))
{
DataSet ds = new DataSet();
con.Open();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@username", user.username);
param[1] = new SqlParameter("@password", user.password);
param[2] = new SqlParameter("@IsValid", SqlDbType.Int);
param[2].Direction = ParameterDirection.Output;
ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "tmpprclogin", param);
int OutParam = 0;
if (!String.IsNullOrEmpty(Convert.ToString(param[2].Value)))
{
OutParam = Convert.ToInt32(param[2].Value);
}
if (OutParam == 1)
{
list.message = "valid";
}
else if (OutParam == 0)
{
list.message = "invalid";
}
}
}
catch (Exception ex)
{
list.message = ex.Message;
}
return(list);
}
