Esempio n. 1
0
 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();
     }
 }
Esempio n. 2
0
        public override void Update(IEntity en)
        {
            OpenConnection();
            MySql.Data.MySqlClient.MySqlTransaction trans    = m_connection.BeginTransaction();
            MySql.Data.MySqlClient.MySqlCommand     aCommand = new MySql.Data.MySqlClient.MySqlCommand();
            aCommand.Connection  = m_connection;
            aCommand.Transaction = trans;
            try
            {
                User e = (User)en;
                aCommand.CommandText = e.GetUpdateSQL();
                aCommand.ExecuteNonQuery();

                foreach (string kys in e.FORM_ACCESS_LIST.Keys)
                {
                    if (e.FORM_ACCESS_LIST[kys].ID > 0)
                    {
                        aCommand.CommandText = e.FORM_ACCESS_LIST[kys].GetUpdateSQL();
                        aCommand.ExecuteNonQuery();
                    }
                    else
                    {
                        aCommand.CommandText = e.FORM_ACCESS_LIST[kys].GetInsertSQL();
                        aCommand.ExecuteNonQuery();
                        aCommand.CommandText       = e.FORM_ACCESS_LIST[kys].GetMaximumIDSQL();
                        e.FORM_ACCESS_LIST[kys].ID = Convert.ToInt32(aCommand.ExecuteScalar());
                    }
                }
                aCommand.CommandText = FormAccess.GetAllByUserSQL(e.ID);
                MySql.Data.MySqlClient.MySqlDataReader r = aCommand.ExecuteReader();
                IList luc = FormAccess.GetAllStatic(r);
                r.Close();
                foreach (FormAccess chk in luc)
                {
                    chk.UPDATED = e.FORM_ACCESS_LIST.Contains(new KeyValuePair <string, FormAccess>(chk.CODE, chk));
                }
                foreach (FormAccess chk in luc)
                {
                    if (!chk.UPDATED)
                    {
                        aCommand.CommandText = chk.GetDeleteSQL();
                        aCommand.ExecuteNonQuery();
                    }
                }
                trans.Commit();
            }
            catch (Exception x)
            {
                trans.Rollback();
                throw new Exception(getErrorMessage(x));
            }
            finally
            {
                m_connection.Close();
            }
        }
Esempio n. 3
0
        public override bool Equals(object obj)
        {
            FormAccess o = (FormAccess)obj;

            if (o == null)
            {
                return(false);
            }
            return(o.ID == this.ID);
        }
Esempio n. 4
0
        public IEntity Get(MySql.Data.MySqlClient.MySqlDataReader aReader)
        {
            FormAccess formaccess = null;

            while (aReader.Read())
            {
                formaccess                        = new FormAccess();
                formaccess.ID                     = Convert.ToInt32(aReader[0]);
                formaccess.CODE                   = aReader[1].ToString();
                formaccess.NAME                   = aReader[2].ToString();
                formaccess.SAVE                   = Convert.ToBoolean(aReader[3]);
                formaccess.DELETE                 = Convert.ToBoolean(aReader[4]);
                formaccess.VIEW                   = Convert.ToBoolean(aReader[5]);
                formaccess.POST                   = Convert.ToBoolean(aReader[6]);
                formaccess.PRINT                  = Convert.ToBoolean(aReader[7]);
                formaccess.USER                   = new User(Convert.ToInt32(aReader[8]));
                formaccess.MODIFIED_BY            = aReader["modified_by"].ToString();
                formaccess.MODIFIED_DATE          = Convert.ToDateTime(aReader["modified_date"].ToString());
                formaccess.MODIFIED_COMPUTER_NAME = aReader["modified_computer"].ToString();
                formaccess.FORM_TYPE              = (FormType)Enum.Parse(typeof(FormType), aReader["form_type"].ToString());
            }
            return(formaccess);
        }
Esempio n. 5
0
        public static IList GetAllStatic(MySql.Data.MySqlClient.MySqlDataReader aReader)
        {
            IList result = new ArrayList();

            while (aReader.Read())
            {
                FormAccess formaccess = new FormAccess();
                formaccess.ID                     = Convert.ToInt32(aReader[0]);
                formaccess.CODE                   = aReader[1].ToString();
                formaccess.NAME                   = aReader[2].ToString();
                formaccess.SAVE                   = Convert.ToBoolean(aReader[3]);
                formaccess.DELETE                 = Convert.ToBoolean(aReader[4]);
                formaccess.VIEW                   = Convert.ToBoolean(aReader[5]);
                formaccess.POST                   = Convert.ToBoolean(aReader[6]);
                formaccess.PRINT                  = Convert.ToBoolean(aReader[7]);
                formaccess.USER                   = new User(Convert.ToInt32(aReader[8]));
                formaccess.MODIFIED_BY            = aReader["modified_by"].ToString();
                formaccess.MODIFIED_DATE          = Convert.ToDateTime(aReader["modified_date"].ToString());
                formaccess.MODIFIED_COMPUTER_NAME = aReader["modified_computer"].ToString();
                result.Add(formaccess);
            }
            return(result);
        }
Esempio n. 6
0
 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();
     }
 }