// 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();
}