public User getUser(string code) { try { OpenConnection(); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(User.GetByExactCodeSQL(code)); cmd.Connection = m_connection; MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader(); User u = User.TransformReader(r); r.Close(); if (u == null) { return(null); } FormAccess p = new FormAccess(); MySql.Data.MySqlClient.MySqlCommand aCommand = new MySql.Data.MySqlClient.MySqlCommand(FormAccess.GetAllByUserSQL(u.ID), m_connection); MySql.Data.MySqlClient.MySqlDataReader aReader = aCommand.ExecuteReader(); IList a = p.GetAll(aReader); aReader.Close(); foreach (FormAccess fa in a) { u.FORM_ACCESS_LIST.Add(fa.CODE, fa); } return(u); } catch (Exception x) { throw new Exception(getErrorMessage(x)); } finally { m_connection.Close(); } }
public User GetFormAccessByUserID(User userID) { try { OpenConnection(); FormAccess p = new FormAccess(); MySql.Data.MySqlClient.MySqlCommand aCommand = new MySql.Data.MySqlClient.MySqlCommand(FormAccess.GetAllByUserSQL(userID.ID), m_connection); MySql.Data.MySqlClient.MySqlDataReader aReader = aCommand.ExecuteReader(); IList a = p.GetAll(aReader); foreach (FormAccess fa in a) { userID.FORM_ACCESS_LIST.Add(fa.CODE, fa); } return(userID); } catch (Exception x) { throw new Exception(getErrorMessage(x)); } finally { m_connection.Close(); } }