public void UpdateSYS_Language(SYS_Language sys_language)
        {
            DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);

            conn.Open();

            try
            {
                List <DbParameter> para = new List <DbParameter>();

                para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_language.ID, false));
                para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_language.Name, false));
                para.Add(_DbHelper.CreateParameter(FIELD_CODE, sys_language.Code, false));
                para.Add(_DbHelper.CreateParameter(FIELD_ISDEFAULT, sys_language.IsDefault, false));
                para.Add(_DbHelper.CreateParameter(FIELD_PATH, sys_language.Path, false));

                _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Language_Update]", para.ToArray());
            }
            catch (Exception ex)
            {
                throw new Exception(String.Format("SYS_LanguageDataAccess.Update: {0}", ex.Message));
            }
            finally
            {
                conn.Close();
            }
        }
        public int InsertSYS_Language(SYS_Language sys_language)
        {
            DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);

            conn.Open();
            try
            {
                List <DbParameter> para  = new List <DbParameter>();
                DbParameter        ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
                para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_language.Name, false));
                para.Add(_DbHelper.CreateParameter(FIELD_CODE, sys_language.Code, false));
                para.Add(_DbHelper.CreateParameter(FIELD_ISDEFAULT, sys_language.IsDefault, false));
                para.Add(_DbHelper.CreateParameter(FIELD_PATH, sys_language.Path, false));
                para.Add(ouput);
                _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Language_Insert]", para.ToArray());
                return((int)ouput.Value);
            }
            catch (Exception ex)
            {
                throw new Exception(String.Format("SYS_LanguageDataAccess.Insert: {0}", ex.Message));
            }
            finally
            {
                conn.Close();
            }
        }
 private static void SetSYS_LanguageInfo(DbDataReader reader, ref SYS_Language sys_language)
 {
     sys_language.ID   = int.Parse("0" + reader[FIELD_ID]);
     sys_language.Name = "" + reader[FIELD_NAME];
     sys_language.Code = "" + reader[FIELD_CODE];
     sys_language.Path = "" + reader[FIELD_PATH];
 }
Example #4
0
        public SYS_Language SelectSYS_Language(int ID)
        {
            SYS_Language sys_language = new SYS_Language();
            DbDataReader reader       = null;
            DbConnection connection   = _DbHelper.CreateConnection(Common.ConnectionString);

            connection.Open();
            try
            {
                List <DbParameter> para = new List <DbParameter>();
                para.Add(_DbHelper.CreateParameter(FIELD_ID, ID, false));

                reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_Language_SelectById]", para.ToArray());
                if (reader.HasRows && reader.Read())
                {
                    SYS_LanguageDataAccess.SetSYS_LanguageInfo(reader, ref sys_language);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(String.Format("SYS_LanguageDataAccess.SelectById: {0}", ex.Message));
            }
            finally
            {
                if (reader != null)
                {
                    reader.Close();
                }
                connection.Close();
            }
            return(sys_language);
        }
        private static void SetListSYS_LanguageInfo(ref DbDataReader reader, ref List <SYS_Language> sys_languages)
        {
            SYS_Language sys_language = null;

            while (reader.Read())
            {
                sys_language = new SYS_Language();
                SYS_LanguageDataAccess.SetSYS_LanguageInfo(reader, ref sys_language);
                sys_languages.Add(sys_language);
            }
        }
        public void UpdateSYS_Language(DbTransaction transaction, SYS_Language sys_language)
        {
            try
            {
                List <DbParameter> para = new List <DbParameter>();

                para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_language.ID, false));
                para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_language.Name, false));
                para.Add(_DbHelper.CreateParameter(FIELD_CODE, sys_language.Code, false));
                para.Add(_DbHelper.CreateParameter(FIELD_ISDEFAULT, sys_language.IsDefault, false));
                para.Add(_DbHelper.CreateParameter(FIELD_PATH, sys_language.Path, false));

                _DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_Language_Update]", para.ToArray());
            }
            catch (Exception ex)
            {
                throw new Exception(String.Format("SYS_LanguageDataAccess.Update: {0}", ex.Message));
            }
        }
        public void DeleteSYS_Language(SYS_Language sys_language)
        {
            DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);

            conn.Open();
            try
            {
                List <DbParameter> para = new List <DbParameter>();
                para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_language.ID, false));
                _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Language_Delete]", para.ToArray());
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                conn.Close();
            }
        }
Example #8
0
        public SYS_Language SelectDefaultLanguage(string connect)
        {
            SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess();

            connect = connectionDataAccess.DecryptSYS_ConfigConnection(connect);
            SYS_Language sys_language = new SYS_Language();
            DbDataReader reader       = null;
            DbConnection connection   = _DbHelper.CreateConnection(connect);

            connection.Open();
            List <DbParameter> para = new List <DbParameter>();

            para.Add(_DbHelper.CreateParameter(FIELD_ISDEFAULT, true, false));
            try
            {
                reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_Language_GetDefault]", para.ToArray());
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        SetSYS_LanguageInfo(reader, ref sys_language);
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(String.Format(" SYS_LanguageDataAccess.SYS_Language_GetDefault: {0}", ex.Message));
            }
            finally
            {
                if (reader != null)
                {
                    reader.Close();
                }
                connection.Close();
            }
            return(sys_language);
        }
        public int InsertSYS_Language(DbTransaction transaction, SYS_Language sys_language)
        {
            try
            {
                List <DbParameter> para = new List <DbParameter>();

                DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
                para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_language.Name, false));
                para.Add(_DbHelper.CreateParameter(FIELD_CODE, sys_language.Code, false));
                para.Add(_DbHelper.CreateParameter(FIELD_ISDEFAULT, sys_language.IsDefault, false));
                para.Add(_DbHelper.CreateParameter(FIELD_PATH, sys_language.Path, false));

                para.Add(ouput);

                _DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_Language_Insert]", para.ToArray());

                return((int)ouput.Value);
            }
            catch (Exception ex)
            {
                throw new Exception(String.Format("SYS_LanguageDataAccess.Insert: {0}", ex.Message));
            }
        }
Example #10
0
 public void DeleteSYS_Language(SYS_Language sys_Languages)
 {
     _sys_LanguageDataAccess.DeleteSYS_Language(sys_Languages);
 }
Example #11
0
 public void UpdateSYS_Language(SYS_Language sys_Language)
 {
     _sys_LanguageDataAccess.UpdateSYS_Language(sys_Language);
 }
Example #12
0
 public int InsertSYS_Language(SYS_Language sys_Language)
 {
     return(_sys_LanguageDataAccess.InsertSYS_Language(sys_Language));
 }