// 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
public DataRecordUpdate(Dictionary <String, String> paDataList, String paUpdateQuery) { clDataList = paDataList; clUpdateQuery = paUpdateQuery; clConnectionMode = ApplicationFrame.GetInstance().ActiveFormInfoManager.ConnectionMode; clMetaMode = ApplicationFrame.GetInstance().ActiveFormInfoManager.IsAttributeSet(FormInfoManager.FormAttribute.MetaMode); }
private FormInfoManager(FormInfoRow paFormInfoRow, String paEncodedFormName, Dictionary <String, String> paFormParam) { clFormInfoRow = paFormInfoRow; ParseDataGroup(); clEncodedFormName = paEncodedFormName; clConnectionMode = General.ParseEnum <QueryClass.ConnectionMode>(clFormInfoRow.ConnectionMode, QueryClass.ConnectionMode.None); clFieldInfoManager = new FieldInfoManager(this); clFormParam = paFormParam; clFormParam.MergeDictionary(paFormInfoRow.DefaultParameters.Split(new[] { ctSecondLevelDelimiter }, StringSplitOptions.RemoveEmptyEntries) .Select(part => part.Split(new[] { ctFirstLevelDelimiter }, StringSplitOptions.None)) .ToDictionary(split => split[0], split => split[1])); TranslateDictionary(clFormParam); clToolBarConfig = new MetaDataBlockCollection(ActiveRow.ToolBarConfig)[0]; }
// 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); } }
// 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); } }
// 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); } }
public EServiceQueryClass(QueryType paQueryType) { clConnectionMode = QueryClass.ConnectionMode.EService; ChooseQuery(paQueryType); }
public DataListUpdate(dynamic paDataList, String paUpdateQuery) { clDataList = paDataList; clUpdateQuery = paUpdateQuery; clConnectionMode = ApplicationFrame.GetInstance().ActiveFormInfoManager.ConnectionMode; }