public int UpdateKeywordInfo(KeywordInfoBLL KBLL) { try { Conn.Open(); using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"])) { SqlParameter[] par = new SqlParameter[15]; par[0] = new SqlParameter("@KeyId", KBLL.KeyId1); par[1] = new SqlParameter("@KeywordName", KBLL.KeywordName1); par[2] = new SqlParameter("@KeywordSyntax", KBLL.KeywordSyntax1); par[3] = new SqlParameter("@KeywordPurpose", KBLL.KeywordPurpose1); par[4] = new SqlParameter("@KeyDiscip", KBLL.KeyDiscip1); par[5] = new SqlParameter("@EntryDate", KBLL.EntryDate1); par[6] = new SqlParameter("@WebsiteGroup", KBLL.WebsiteGroup1); par[7] = new SqlParameter("@status", 11); par[7].Direction = ParameterDirection.Output; row = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "KeyInfoUpdate", par); } } catch (Exception ex) { throw ex; } finally { Conn.Close(); } return(row); }
public void SelectKeywordInfo(KeywordInfoBLL KBLL) { SqlDataReader dr; try { Conn.Open(); using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"])) { SqlParameter[] par = new SqlParameter[15]; par[0] = new SqlParameter("@KeyId", KBLL.KeyId1); par[1] = new SqlParameter("@status", 11); par[1].Direction = ParameterDirection.Output; dr = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "KeyInfoSelectData", par); if (dr.HasRows) { dr.Read(); KBLL.KeywordName1 = Convert.ToString(dr["KeywordName"]); KBLL.KeywordSyntax1 = Convert.ToString(dr["KeywordSyntax"]); KBLL.KeywordPurpose1 = Convert.ToString(dr["KeywordPurpose"]); KBLL.KeyDiscip1 = Convert.ToString(dr["KeyDiscip"]); KBLL.EntryDate1 = Convert.ToString(dr["EntryDate"]); KBLL.WebsiteGroup1 = Convert.ToString(dr["WebsiteGroup"]); } } } catch (Exception ex) { throw ex; } finally { Conn.Close(); } }
public DataSet LoadKeywordInfo(KeywordInfoBLL KBLL) { DataSet ds = new DataSet(); try { using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"])) { con.Open(); ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "KeyInfoLoad"); } } catch (Exception ex) { throw ex; } finally { } return(ds); }
public int UpdateInfo(KeywordInfoBLL KBLL) { int i = KEYDAL.UpdateKeywordInfo(KBLL); return(i); }
public int AddInfo(KeywordInfoBLL KBLL) { int i = KEYDAL.AddKeywordInfo(KBLL); return(i); }
public void SelectInfo(KeywordInfoBLL KBLL) { KEYDAL.SelectKeywordInfo(KBLL); }
public DataSet LoadInfo(KeywordInfoBLL KBLL) { return(ds = KEYDAL.LoadKeywordInfo(KBLL)); }