// Run the Query and Return the Result Database. public DataSet RunQueryEx(String paQuery, QueryClass.ConnectionMode paConnectionMode) { DataSet lcDataSet; SqlCommand lcCommand; SqlDataAdapter lcDataAdapter; SqlConnection lcConnection; if (paConnectionMode != QueryClass.ConnectionMode.None) { lcConnection = new SqlConnection((paConnectionMode == QueryClass.ConnectionMode.EService) && (!String.IsNullOrEmpty(ConfigClass.GetInstance().EServiceRemoteConnectionStr)) ? ConfigClass.GetInstance().EServiceRemoteConnectionStr : ConfigClass.GetInstance().DefaultConnectionStr); lcCommand = new SqlCommand(paQuery, lcConnection); lcCommand.CommandTimeout = ConfigClass.GetInstance().CommandTimeOut; lcDataAdapter = new SqlDataAdapter(lcCommand); lcDataSet = new DataSet(); lcDataAdapter.Fill(lcDataSet); return(lcDataSet); } else { return(null); } }
private ApplicationFrame(Page paPage) { String lcFormName; HttpContext.Current.Items.Add(ctVARApplicationFrameInstance, this); clPage = paPage; clAjaxMode = true; clClientScriptManager = paPage.ClientScript; clWebStateBlock = new WebStateBlock(); clActiveGlobalMetaBlock = new GlobalMetaBlock(); ConfigClass.GetInstance().ResetConfiguration(); if (!String.IsNullOrEmpty(clServiceRequestToken = GetStateParameter(ctPRMServiceRequestToken))) { if ((clSubscriptionManager = SubscriptionManager.CreateInstance(clServiceRequestToken, GetParameter(ctPRMLanguage))) != null) { if (clSubscriptionManager.Status == SubscriptionManager.SubscriptionStatus.Valid) { clServiceRequestLogManager = new ServiceRequestLogManager(clSubscriptionManager.ActiveRow.SubscriptionID); clSessionController = new SessionController(); // if (clSubscriptionManager.Status == SubscriptionManager.SubscriptionStatus.Valid) // { /* clSessionController.LogIn("AMT", "81DC9BDB52D04DC20036DBD8313ED055"); */ if (String.IsNullOrEmpty(lcFormName = GetParameter(ctPRMFormName))) { lcFormName = clSubscriptionManager.ActiveEService.GetEncodedPrimaryFormName(); } clFormInfoManager = FormInfoManager.CreateInstance(lcFormName); if (((clFormInfoManager == null) || (!clFormInfoManager.IsAttributeSet(FormInfoManager.FormAttribute.NoSession))) && (ActiveEservice.IsMandatorySession) && (ActiveSessionController.Status == SessionController.SessionStatus.NoSession)) { clSessionController.LogOut(); lcFormName = clSubscriptionManager.ActiveEService.GetEncodedLogInFormName(); clFormInfoManager = FormInfoManager.CreateInstance(lcFormName); } //if ((ActiveEservice.IsMandatorySession) && (ActiveSessionController.Status == SessionController.SessionStatus.NoSession)) // lcFormName = clSubscriptionManager.ActiveEService.GetEncodedLogInFormName(); //else if (String.IsNullOrEmpty(lcFormName = GetParameter(ctPRMFormName))) // lcFormName = clSubscriptionManager.ActiveEService.GetEncodedPrimaryFormName(); // clFormInfoManager = FormInfoManager.CreateInstance(lcFormName); clFormStack = GetFormStack(); ActiveGlobalMetaBlock.AddMetaDataElement(MetaDataElement.CreateMetaDataElement(ctMETAFormName, lcFormName)); if ((ApplicationFrame.GetInstance().ActiveSubscription.IsDemoMode()) && (ApplicationFrame.GetInstance().ActiveSubscription.IsDynamicDateMode())) { DynamicQueryManager.GetInstance().GetStringResult(DynamicQueryManager.ExecuteMode.NonQuery, ctDYQUpdateDemoDynamicDate, null); } clInitializationStatus = InitializationStatus.Success; } //else //{ // lcFormName = clSubscriptionManager.ActiveEService.GetEncodedLogInFormName(); // clFormInfoManager = FormInfoManager.CreateInstance(lcFormName); // clFormStack = GetFormStack(); // ActiveGlobalMetaBlock.AddMetaDataElement(MetaDataElement.CreateMetaDataElement(ctMETAFormName, lcFormName)); //} return; } } else { clServiceRequestLogManager = new ServiceRequestLogManager(String.Empty); } clInitializationStatus = InitializationStatus.Fail; }
public CobraPage() { ConfigClass.GetInstance().SetStandardUnit(true); ApplicationFrame.InitalizeInstance(this); }
// Execute the Query Return the Single Value result. public object ExecuteScalar(String paQuery, QueryClass.ConnectionMode paConnectionMode) { object lcResult; SqlCommand lcCommand; SqlConnection lcConnection; if (paConnectionMode != QueryClass.ConnectionMode.None) { lcConnection = new SqlConnection((paConnectionMode == QueryClass.ConnectionMode.EService) && (!String.IsNullOrEmpty(ConfigClass.GetInstance().EServiceRemoteConnectionStr)) ? ConfigClass.GetInstance().EServiceRemoteConnectionStr : ConfigClass.GetInstance().DefaultConnectionStr); lcCommand = new SqlCommand(paQuery, lcConnection); try { lcConnection.Open(); lcResult = lcCommand.ExecuteScalar(); lcConnection.Close(); if ((lcResult == null) || (lcResult.GetType().ToString() == "System.DBNull")) { lcResult = null; } } catch (Exception paException) { lcConnection.Close(); throw new Exception("ExecuteScalar() : Query Execution Error", paException); } return(lcResult); } else { return(null); } }
// Execute the Query and Fetch the Value from the Feedback Variable. public object ExecuteFeedBackQuery(String paQuery, String paFeedBackVar, QueryClass.ConnectionMode paConnectionMode) { object lcResult; SqlCommand lcCommand; SqlConnection lcConnection; lcResult = null; if (paConnectionMode != QueryClass.ConnectionMode.None) { lcConnection = new SqlConnection((paConnectionMode == QueryClass.ConnectionMode.EService) && (!String.IsNullOrEmpty(ConfigClass.GetInstance().EServiceRemoteConnectionStr)) ? ConfigClass.GetInstance().EServiceRemoteConnectionStr : ConfigClass.GetInstance().DefaultConnectionStr); lcCommand = new SqlCommand(paQuery, lcConnection); try { lcConnection.Open(); lcCommand.ExecuteNonQuery(); lcCommand.CommandText = "SELECT " + paFeedBackVar; lcResult = lcCommand.ExecuteScalar(); lcConnection.Close(); } catch (Exception paException) { lcConnection.Close(); throw new Exception("ExecuteFeedBackQuery() : Query Execution Error", paException); } } return(lcResult); } // DatabaseInterface Class
// Execute the Query and Return the Number of Effected Rows. public int ExecuteNonQuery(String paQuery, QueryClass.ConnectionMode paConnectionMode) { int lcResult; SqlCommand lcCommand; SqlConnection lcConnection; SqlParameter lcEffectedRowCount; if (paConnectionMode != QueryClass.ConnectionMode.None) { lcConnection = new SqlConnection((paConnectionMode == QueryClass.ConnectionMode.EService) && (!String.IsNullOrEmpty(ConfigClass.GetInstance().EServiceRemoteConnectionStr)) ? ConfigClass.GetInstance().EServiceRemoteConnectionStr : ConfigClass.GetInstance().DefaultConnectionStr); lcCommand = new SqlCommand(paQuery, lcConnection); lcEffectedRowCount = new SqlParameter("@CSP_EffectedRowCount", SqlDbType.Int) { Direction = ParameterDirection.Output }; lcCommand.Parameters.Add(lcEffectedRowCount); try { lcConnection.Open(); lcResult = lcCommand.ExecuteNonQuery(); lcConnection.Close(); } catch (Exception paException) { lcConnection.Close(); throw new Exception("ExecuteNonQuery() : Query Execution Error", paException); } if (lcEffectedRowCount.Value.GetType() != typeof(DBNull)) { return(General.ParseInt(lcEffectedRowCount.Value.ToString(), -1)); } else { return(lcResult); } } else { return(-1); } }
protected void AddFormStyle(ComponentController paComponentController) { String lcFormCSSClass; String lcCustomWallPaper; lcFormCSSClass = String.IsNullOrWhiteSpace(clFormInfoManager.ActiveRow.FormCSSClass) ? clFormInfoManager.ActiveRow.RenderMode : clFormInfoManager.ActiveRow.FormCSSClass; paComponentController.AddAttribute(HtmlAttribute.Class, ctCLSPanel + " " + lcFormCSSClass); paComponentController.AddElementType(ComponentController.ElementType.Form); if (ApplicationFrame.GetInstance().ActiveSubscription.IsDemoMode()) { paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_DemoMode, "true"); } paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_FormProtocolList, General.Base64Encode(clSettingManager.FormProtocolListStr)); paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_ServiceRequestToken, ApplicationFrame.GetInstance().ActiveServiceRequestToken); paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_FormStack, ApplicationFrame.GetInstance().FormStack); paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_FormName, clFormInfoManager.ActiveRow.FormName); paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_EncodedFormName, clFormInfoManager.EncodedFormName); paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_DataGroupName, clFormInfoManager.ActiveRow.DataGroup); paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_LandingPage, General.Base64Encode(ApplicationFrame.GetInstance().ActiveSubscription.GetLandingPage())); paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_Language, ApplicationFrame.GetInstance().ActiveSubscription.ActiveLanguage.ActiveRow.Language.ToLower()); paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_LocalNumberMode, ApplicationFrame.GetInstance().ActiveSubscription.ActiveSetting.LocalNumberMode.ToString().ToLower()); paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_LocalDigits, ApplicationFrame.GetInstance().ActiveSubscription.ActiveLanguage.LocalDigits); paComponentController.AddStyle(CSSStyle.Width, clFormInfoManager.ActiveRow.FormWidth.ToString() + ConfigClass.GetInstance().StandardXUnit); paComponentController.AddStyle(CSSStyle.Height, clFormInfoManager.ActiveRow.FormHeight.ToString() + ConfigClass.GetInstance().StandardYUnit); if ((lcCustomWallPaper = ApplicationFrame.GetInstance().ActiveSubscription.GetCustomWallPaper(clFormInfoManager.ActiveRow.FormName)) != null) { if (lcCustomWallPaper.ToLower().Contains(ctWallPaperPath)) { SetCustomBackground(paComponentController, lcCustomWallPaper); } else { paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_desktopbackgroundcss, lcCustomWallPaper); } } }
protected void RenderElementContainer(ComponentController paComponentController) { WidgetRenderingManager lcWidgetRenderingManager; lcWidgetRenderingManager = new WidgetRenderingManager(this, clFormInfoManager, paComponentController); paComponentController.AddAttribute(HtmlAttribute.Class, ctCLSElementContainer); paComponentController.AddStyle(CSSStyle.Height, clFormInfoManager.ActiveRow.ContainerHeight.ToString() + ConfigClass.GetInstance().StandardYUnit); paComponentController.RenderBeginTag(HtmlTag.Div); lcWidgetRenderingManager.RenderWidget(); paComponentController.RenderEndTag(); }