private DEBusinessUnitURLDevice GetBusinessUnitFromDB(string[] url) { DEBusinessUnitURLDevice BusinessUnitURLDeviceEntity = new DEBusinessUnitURLDevice(); string cacheString = null; //Loop backwards through the length of the array for (int i = url.Length - 1; i >= 0; i += -1) { cacheString = GetNextURLString(url, i); TalentDataObjects tDataObjects = new TalentDataObjects(); tDataObjects.Settings = GetBasicSettingsObject(false); System.Data.DataTable dt = tDataObjects.AppVariableSettings.TblUrlBu.GetBUByURL(cacheString); if (dt.Rows.Count > 0) { if (!Utilities.CheckForDBNull_Boolean_DefaultFalse(dt.Rows[0]["DISABLED"])) { BusinessUnitURLDeviceEntity.BusinessUnit = dt.Rows[0]["BUSINESS_UNIT"].ToString(); BusinessUnitURLDeviceEntity.BusinessUnitGroup = Utilities.CheckForDBNull_String(dt.Rows[0]["BU_GROUP"]); BusinessUnitURLDeviceEntity.DeviceType = Utilities.CheckForDBNull_String(dt.Rows[0]["DEVICE_TYPE"]); BusinessUnitURLDeviceEntity.URL = Utilities.CheckForDBNull_String(dt.Rows[0]["URL"]); BusinessUnitURLDeviceEntity.URLGroup = Utilities.CheckForDBNull_String(dt.Rows[0]["URL_GROUP"]); //todo call ecom module defaults data object for the given bu to get queue url Data.Cache.Add("BU" + cacheString, BusinessUnitURLDeviceEntity, CacheTimeInMins); return(BusinessUnitURLDeviceEntity); } } } return(BusinessUnitURLDeviceEntity); }
private DEAgent GetAgentEntity(string cacheDependencyPath) { DEAgent agentEntity = new DEAgent(); if (!String.IsNullOrEmpty(Data.Session.SessionId) && Data.Session.Get("Agent") != null && Data.Session.Get("Agent").ToString().Trim().Length > 0) { TalentDataObjects talDataObject = new TalentDataObjects(); DESettings settings = new DESettings(); settings.FrontEndConnectionString = FrontEndConnectionString; settings.CacheDependencyPath = cacheDependencyPath; settings.DestinationDatabase = GlobalConstants.SQL2005DESTINATIONDATABASE; talDataObject.Settings = settings; DataTable dtTblAgent = talDataObject.AgentSettings.TblAgent.GetByAgentName(Data.Session.SessionId, Data.Session.Get("Agent").ToString()); if (dtTblAgent != null && dtTblAgent.Rows.Count > 0) { agentEntity.AgentUsername = Data.Validation.CheckForDBNull_String(dtTblAgent.Rows[0]["AGENT_NAME"]); agentEntity.AgentType = Data.Session.Get("AgentType").ToString(); agentEntity.Department = Data.Validation.CheckForDBNull_String(dtTblAgent.Rows[0]["DEPARTMENT"]).Trim(); agentEntity.PrinterNameDefault = Data.Validation.CheckForDBNull_String(dtTblAgent.Rows[0]["PRINTER_NAME_DEFAULT"]); agentEntity.BulkSalesMode = Data.Validation.CheckForDBNull_Boolean_DefaultFalse(dtTblAgent.Rows[0]["BULK_SALES_MODE"]); } else { if (!Url.ToLower().Contains("agentlogin.aspx?logout=expired")) { Data.Session.Remove("Agent"); Data.Session.Add("IsAgentProfileEmpty", true); HttpContext.Current.Response.Redirect("~/PagesPublic/Agent/AgentLogin.aspx?logout=expired"); } } } return(agentEntity); }
/// <summary> /// Get the default values for a particular templare /// </summary> /// <param name="templateID"></param> /// <returns>A DefaultValues object</returns> private DefaultValues GetDefaultValues(int templateID) { TimeSpan timeSpan = DateTime.Now.TimeOfDay; DefaultValues def = new DefaultValues(); TalentDataObjects talDataObjects = new TalentDataObjects(); string cacheKey = "ActivityTemplateDefaults" + Talent.Common.Utilities.FixStringLength("MAINTENANCE", 50) + Talent.Common.Utilities.FixStringLength("*ALL", 50); talDataObjects.Settings = businessObjects.Environment.Settings.GetBasicSettingsObject(); DataTable defaults = talDataObjects.ActivitiesSettings.TblActivityTemplatesDefaults.GetDefaultsByTemplateID(templateID); if (Talent.Common.TalentThreadSafe.ItemIsInCache(cacheKey)) { def = (DefaultValues)businessObjects.Data.Cache.Get(cacheKey); } else { try { if (defaults.Rows.Count > 0) { def = PopulateDefaults(def, defaults); } } catch (Exception ex) { } //Add to cache now businessObjects.Data.Cache.Add(cacheKey, def, businessObjects.Environment.Settings.CacheTimeInMins); } businessObjects.Logging.LoadTestLog("ActivityTemplateDefaults.cs", "GetDefaultValuesByTemplateID", timeSpan); return(def); }
private List <CustomerSearch.Clubs> GetClubDetails(CustomerSearchInputModel inputModel) { TalentDataObjects dataObjects = new TalentDataObjects(); dataObjects.Settings = Environment.Settings.DESettings; List <CustomerSearch.Clubs> clubs = new List <CustomerSearch.Clubs>(); DataTable partnerClub = dataObjects.ClubSettings.GetPartnerUserClubByAgentTypeLoginID(inputModel.AgentType, inputModel.AgentLoginID); if (partnerClub.Rows.Count > 0) { clubs = Data.PopulateObjectListFromTable <CustomerSearch.Clubs>(dataObjects.ClubSettings.GetTblClubDetailsByAgentType(inputModel.AgentType)); } return(clubs); }
public String GetPartner() { string partner = "*ALL"; TalentDataObjects tDataObjects = new TalentDataObjects(); tDataObjects.Settings = GetBasicSettingsObject(); //string sesh = Data.Session.SessionId.ToString(); long basketHeaderID = tDataObjects.BasketSettings.TblBasketHeader.GetHeaderByBasketSessionID(Data.Session.SessionId.ToString(), BusinessUnit); DataTable dt = tDataObjects.BasketSettings.TblBasketHeader.GetHeaderByBasketHeaderID(basketHeaderID.ToString()); if (dt != null && dt.Rows.Count > 0) { if (Utilities.CheckForDBNull_String(dt.Rows[0]["PARTNER"]) != string.Empty) { partner = dt.Rows[0]["PARTNER"].ToString(); } } return(partner); }
private string GetCurrentPageName() { string path = GetAbsolutePath(); System.IO.FileInfo oInfo = new System.IO.FileInfo(path); string sRet = oInfo.Name; string saveRet = sRet; NameValueCollection queryString = HttpContext.Current.Request.QueryString; if (!sRet.EndsWith(".aspx")) { //This assumes the page name is being retreieved from a webmethod such as: "VisualSeatSelection.aspx/GetSeating" //We need the page name "VisualSeatSelection.aspx" and not the method name "GetSeating" sRet = oInfo.Directory.Name; } switch (sRet.ToUpper()) { case "USERDEFINED.ASPX": sRet = sRet + "?"; string[] pageCodeQueryKeys = DefaultValues.UserDefinedPageQueryKeys.Split(';'); if (pageCodeQueryKeys != null && pageCodeQueryKeys.Length > 0) { for (int arrIndex = 0; arrIndex <= pageCodeQueryKeys.Length - 1; arrIndex++) { foreach (string queryKey in queryString.AllKeys) { if (pageCodeQueryKeys[arrIndex].ToLower() == queryKey.ToLower()) { sRet = sRet + queryKey + "=" + queryString[queryKey] + "&"; break; // TODO: might not be correct. Was : Exit For } } } } sRet = sRet.TrimEnd('&'); break; case "PRODUCTHOME.ASPX": if (!(string.IsNullOrEmpty(queryString["ProductSubType"]))) { sRet = sRet + "?" + "ProductSubType=" + queryString["ProductSubType"].ToUpper(); } break; case "PRODUCTSEASON.ASPX": if (!(string.IsNullOrEmpty(queryString["ProductSubType"]))) { sRet = sRet + "?" + "ProductSubType=" + queryString["ProductSubType"].ToUpper(); } break; case "PRODUCTAWAY.ASPX": if (!(string.IsNullOrEmpty(queryString["ProductSubType"]))) { sRet = sRet + "?" + "ProductSubType=" + queryString["ProductSubType"].ToUpper(); } break; case "PRODUCTEVENT.ASPX": case "PRODUCTTRAVEL.ASPX": if (!(string.IsNullOrEmpty(queryString["ProductSubType"]))) { sRet = sRet + "?" + "ProductSubType=" + queryString["ProductSubType"].ToUpper(); } break; case "PRODUCTMEMBERSHIP.ASPX": if (!(string.IsNullOrEmpty(queryString["ProductSubType"]))) { sRet = sRet + "?" + "ProductSubType=" + queryString["ProductSubType"].ToUpper(); } break; } //Validate that a page exists if we have added a query string for product groups if (saveRet != sRet && sRet.ToUpper() != "USERDEFINED.ASPX") { TalentDataObjects tDataObjects = new TalentDataObjects(); tDataObjects.Settings = GetBasicSettingsObject(); DataTable dt = tDataObjects.PageSettings.TblPage.GetByPageCode(sRet, BusinessUnit); if (dt == null || dt.Rows.Count == 0) { sRet = saveRet; } } return(sRet); }