public static Confs GetSearchPubs(int ConfID, string cancertype, string subject, string audience, string publicationformat, string series, string languages) { String procedureName = "sp_KIOSK_SearchPubs"; Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand(procedureName); db.AddInParameter(dbCommand, "ConfID", DbType.Int32, ConfID); db.AddInParameter(dbCommand, "cancertype", DbType.String, cancertype); db.AddInParameter(dbCommand, "subject", DbType.String, subject); db.AddInParameter(dbCommand, "audience", DbType.String, audience); db.AddInParameter(dbCommand, "publicationformat", DbType.String, publicationformat); db.AddInParameter(dbCommand, "series", DbType.String, series); db.AddInParameter(dbCommand, "languages", DbType.String, languages); using (System.Data.IDataReader dr = ExecuteReader(db, dbCommand)) { Confs coll = new Confs(); Conf newConf; while (dr.Read()) { newConf = new Conf(Convert.ToInt32(dr["pubid"]), (string)dr["productid"]); coll.Add(newConf); } return(coll); } }
public static String GetSearchCategory(int ConfID, String CategoryType) { String categoryjavascript = ""; String category_selid = ""; String category_optdesc = ""; if (CategoryType == "CANCERTYPE") { category_selid = "optCancerType"; category_optdesc = "Type of Cancer"; } else if (CategoryType == "SUBJECT") { category_selid = "optSubject"; category_optdesc = "Subject"; } else if (CategoryType == "AUDIENCE") { category_selid = "optAudience"; category_optdesc = "Audience"; } else if (CategoryType == "PUBLICATIONFORMAT") { category_selid = "optPublicationFormat"; category_optdesc = "Publication Format"; } else if (CategoryType == "SERIES") //Collections { category_selid = "optSeries"; category_optdesc = "Collections"; } else if (CategoryType == "LANGUAGES") { category_selid = "optLanguages"; category_optdesc = "Languages"; } Confs CategoryList = new Confs(); CategoryList = PubEnt.DAL.DAL.GetSearchCategory(ConfID, CategoryType); if (CategoryList.Count > 0) { categoryjavascript = "document.write('<tr>');"; categoryjavascript = categoryjavascript + "document.write('<td class=\"floatmenudrop\" align=\"left\">');"; categoryjavascript = categoryjavascript + "document.write('<select name=\"" + category_selid + "\" id=\"" + category_selid + "\" onchange=\"goSearch(this);\" style=\"width:400px\">');"; categoryjavascript = categoryjavascript + "document.write('<option value=\"\">" + category_optdesc + "</option>');"; foreach (Conf CategoryItem in CategoryList) { categoryjavascript = categoryjavascript + "document.write('<option value=\"" + CategoryItem.ConfID.ToString() + "\">" + CategoryItem.ConfName + "</option>');"; } categoryjavascript = categoryjavascript + "document.write('</select>');"; categoryjavascript = categoryjavascript + "document.write('</td>');"; categoryjavascript = categoryjavascript + "document.write('</tr>');"; } return(categoryjavascript); }
public static Confs GetSearchCategory(int ConfID, String CategoryType) { String procedureName = ""; if (CategoryType == "CANCERTYPE") { procedureName = "sp_KIOSK_getCancerTypesByConfID"; } else if (CategoryType == "SUBJECT") { procedureName = "sp_KIOSK_getSubjectByConfID"; } else if (CategoryType == "AUDIENCE") { procedureName = "sp_KIOSK_getAudienceByConfID"; } else if (CategoryType == "PUBLICATIONFORMAT") { procedureName = "sp_KIOSK_getFormatByConfID"; } else if (CategoryType == "SERIES") //Collections { procedureName = "sp_KIOSK_getSeriesByConfID"; } else if (CategoryType == "LANGUAGES") { procedureName = "sp_KIOSK_getLanguageByConfID"; } Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand(procedureName); db.AddInParameter(dbCommand, "ConfID", DbType.Int32, ConfID); using (System.Data.IDataReader dr = ExecuteReader(db, dbCommand)) { Confs coll = new Confs(); Conf newConf; while (dr.Read()) { newConf = new Conf(Convert.ToInt32(dr["OPT_ID"]), (string)dr["OPT_DESC"]); coll.Add(newConf); } return(coll); } }
public static Confs GetAllConf() { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand(strSpGetAllConfName); using (System.Data.IDataReader dr = ExecuteReader(db, dbCommand)) { Confs coll = new Confs(); Conf newConf; while (dr.Read()) { newConf = new Conf(Convert.ToInt32(dr["CONFERENCEID"]), (string)dr["CONFERENCENAME"]); coll.Add(newConf); } return(coll); } }
private void confsChanges(Confs conf, VariantVar value) { switch (conf) { case Confs.MONGODB_HOST: reconnect = true; this.conf_host = value.AsString; break; case Confs.MONGODB_PORT: reconnect = true; this.conf_port = value.AsString; break; case Confs.MONGODB_CARS_COLLECTION_NAME: reconnect = true; this.conf_collection = value.AsString; break; } }
protected void Page_Load(object sender, EventArgs e) { ScanInputData(); confid = Request.QueryString["ConfID"]; //***EAC Hide ViewCart button or not...Better to do on PageLoad for each page than in Master.cs! if (Session["KIOSK_Qtys"].ToString() != "") { Master.FindControl("btnViewCart").Visible = true; } else { Master.FindControl("btnViewCart").Visible = false; } Master.FindControl("btnFinish").Visible = false; //Session["KIOSK_TypeOfCancer"] = ""; //Session["KIOSK_Subject"] = ""; //Session["KIOSK_Audience"] = ""; //Session["KIOSK_ProductFormat"] = ""; //Session["KIOSK_Series"] = ""; //Or collection //Session["KIOSK_Language"] = ""; if (Request.QueryString["CancerType"] != null) { Session["KIOSK_TypeOfCancer"] = Request.QueryString["CancerType"]; } if (Request.QueryString["Subject"] != null) { Session["KIOSK_Subject"] = Request.QueryString["Subject"]; } if (Request.QueryString["Audience"] != null) { Session["KIOSK_Audience"] = Request.QueryString["Audience"]; } if (Request.QueryString["ProductFormat"] != null) { Session["KIOSK_ProductFormat"] = Request.QueryString["ProductFormat"]; } if (Request.QueryString["Series"] != null) { Session["KIOSK_Series"] = Request.QueryString["Series"]; } if (Request.QueryString["Languages"] != null) { Session["KIOSK_Language"] = Request.QueryString["Languages"]; } if (Request.QueryString["st"] != null) { PubEnt.GlobalUtils.Utils UtilMethodClean = new PubEnt.GlobalUtils.Utils(); Session["KIOSK_Extratext"] = " for " + UtilMethodClean.Clean(Request.QueryString["st"]); } extratext = Session["KIOSK_Extratext"].ToString(); if (!Page.IsPostBack) { Confs PubsList = new Confs(); PubsList = PubEnt.DAL.DAL.GetSearchPubs(int.Parse(confid), Session["KIOSK_TypeOfCancer"].ToString(), Session["KIOSK_Subject"].ToString(), Session["KIOSK_Audience"].ToString(), Session["KIOSK_ProductFormat"].ToString(), Session["KIOSK_Series"].ToString(), Session["KIOSK_Language"].ToString()); string DirectoryPath = "pubimages/kioskimages/"; string DirectoryName = Server.MapPath(DirectoryPath); rackjavascript = ""; rackImagejavascript = ""; int i = 0; if (PubsList.Count > 0) { foreach (Conf PubsListItem in PubsList) { //--- Validate large size publication image to see if it exists and not display if it is not. rackjavascript += "rack[" + i.ToString() + "] = '" + PubsListItem.ConfName + "';"; if (PubEnt.GlobalUtils.Utils.SearchDirectory(PubsListItem.ConfName.Trim() + ".jpg", DirectoryName) >= 1) { rackImagejavascript += "rackImage[" + i.ToString() + "] = '" + DirectoryPath + PubsListItem.ConfName.Trim() + ".jpg';"; } else { rackImagejavascript += "rackImage[" + i.ToString() + "] = '" + DirectoryPath + "blank.jpg';"; } i++; } } } }