예제 #1
0
        public bool Add(Journal model)
        {
            SqlParameter[] parameters = {
                    new SqlParameter("@ISSN", SqlDbType.NVarChar,32),
                    new SqlParameter("@EISSN", SqlDbType.NVarChar,32),
                    new SqlParameter("@Publisher", SqlDbType.NVarChar,1024),
                    new SqlParameter("@Subject", SqlDbType.NVarChar,1024),
                    new SqlParameter("@JournalLanguage", SqlDbType.NVarChar,128),
                    new SqlParameter("@StartYear", SqlDbType.NVarChar,32),
                    new SqlParameter("@PublicationFee", SqlDbType.NVarChar,32),
                    new SqlParameter("@CategoryWebsiteID", SqlDbType.Int,4),
                    new SqlParameter("@JournalName", SqlDbType.NVarChar, 1024)
                                        };
            parameters[0].Value = model.ISSN;
            parameters[1].Value = model.EISSN;
            parameters[2].Value = model.Publisher;
            parameters[3].Value = model.Subject;
            parameters[4].Value = model.JournalLanguage;
            parameters[5].Value = model.StartYear;
            parameters[6].Value = model.PublicationFee;
            parameters[7].Value = model.CategoryWebsiteID;
            parameters[8].Value = model.JournalName;

            StringBuilder sb = new StringBuilder();
            sb.Append(SQL_INSERT_JOURNAL);
            bool result =new DBHelperSQL().ExecuteNonQuery(sb, parameters, MethodInfo.GetCurrentMethod().Name);
            return result;
        }
예제 #2
0
 public IList<CategoryWebsite> GetAllCategoryWebsites()
 {
     IList<CategoryWebsite> categoryWebsites = new List<CategoryWebsite>();
     try
     {
         DataTable dt = new DataTable();
         StringBuilder sb = new StringBuilder();
         sb.Append(SQL_SELECT_CategoryWebsite);
         dt =new DBHelperSQL().ExecuteQuery(sb, MethodInfo.GetCurrentMethod().Name);
         foreach (DataRow dr in dt.Rows)
         {
             CategoryWebsite cw = new CategoryWebsite(Convert.ToInt32(dr["CategoryWebsiteID"].ToString()), dr["CategoryLevelOne"].ToString(), dr["CategoryLevelTwo"].ToString(), dr["CategoryLevelThree"].ToString(), dr["Website"].ToString(), Convert.ToInt32(dr["WebsiteCount"].ToString()));
             categoryWebsites.Add(cw);
         }
         return categoryWebsites;
     }
     catch (System.Exception ex)
     {
         Console.WriteLine(ex.Message);
     }
     return null;
 }