public static UserTypeData getType(int user_id)
{
//p_get_type_user_by_id
UserTypeData type = null;
try
{
using (MySqlConnection conn = new MySqlConnection(App.setting.connectString))
{
conn.Open();
string query = "fc_get_type_user_by_id";
using (MySqlCommand cmd = new MySqlCommand(query, conn))
{
cmd.Parameters.Add(new MySqlParameter("@_user_id", MySqlDbType.Int32)
{
Direction = System.Data.ParameterDirection.Input, Value = user_id
});
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.ExecuteScalar();
using (MySqlDataReader reader = cmd.ExecuteReader())
{
type = reader.toTypeUser();
}
};
conn.Close();
};
}
catch (Exception ex)
{
Console.WriteLine(ex.GetBaseException().ToString());
}
return(type);
}
public static List<UserTypeData> toTypeUsers(this MySqlDataReader reader)
{
if (reader.HasRows)
{
List<UserTypeData> results = new List<UserTypeData>();
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
UserTypeData type = new UserTypeData();
type.Id = reader.GetInt32(Define.type_id);
type.Name = reader.GetString(Define.type_name);
type.Status = reader.GetBoolean(Define.type_status);
type.DefaultPermision = Permision.Read(reader.GetString(Define.default_permision));
type.Icon = reader.GetString(Define.type_icon);
results.Add(type);
}
}
return results;
}
return null;
}