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++;
}
}
}
}
