public void ReplaceQueryPlaceHolder(QueryClass paQueryClass)
{
UserRow lcUserRow;
if (paQueryClass != null)
{
if (ApplicationFrame.GetInstance().ActiveSessionController.User.IsLoggedIn)
{
paQueryClass.ReplacePlaceHolder("$USERID", ApplicationFrame.GetInstance().ActiveSessionController.User.ActiveRow.UserID.ToString(), true);
}
paQueryClass.ReplaceRowPlaceHolder(ApplicationFrame.GetInstance().ActiveSubscription.ActiveRow.Row);
paQueryClass.ReplaceRowPlaceHolder(ApplicationFrame.GetInstance().ActiveEservice.ActiveRow.Row);
if ((lcUserRow = ApplicationFrame.GetInstance().ActiveSessionController.User.ActiveRow) == null)
{
lcUserRow = new UserRow(TableManager.GetInstance().GetNewRow(TableManager.TableType.User, true));
}
paQueryClass.ReplaceRowPlaceHolder(lcUserRow.Row);
paQueryClass.ReplacePlaceHolder("$ACTIVELANGUAGE", ApplicationFrame.GetInstance().ActiveSubscription.ActiveSetting.Language, true);
paQueryClass.ReplaceDictionaryPlaceHolder(clFormParam, false);
}
}
private DataTable RetrieveInputInfoList(String paDataGroup)
{
QueryClass lcQuery;
lcQuery = new QueryClass(QueryClass.QueryType.RetrieveInputInfo);
lcQuery.ReplacePlaceHolder("$ESERVICEID", clEServiceID, true);
lcQuery.ReplacePlaceHolder("$INPUTGROUP", paDataGroup, true);
return(lcQuery.RunQuery());
}
public void UpdateSessionAccessInfo()
{
QueryClass lcQuery;
lcQuery = new QueryClass(QueryClass.QueryType.UpdateSessionAccessInfo);
lcQuery.ReplacePlaceHolder("$SUBSCRIPTIONID", ActiveRow.SubscriptionID, true);
lcQuery.ReplacePlaceHolder("$LASTACCESSTIME", General.ConvertUTCToSystemLocalTime(DateTime.UtcNow).ToString("yyyy-MM-dd HH:mm:ss"), true);
lcQuery.ReplacePlaceHolder("$LOGINID", ActiveRow.LoginID, true);
lcQuery.ExecuteNonQuery();
}
private DataTable RetrieveMessageList()
{
QueryClass lcQuery;
lcQuery = new QueryClass(QueryClass.QueryType.RetrieveMessageList);
lcQuery.ReplacePlaceHolder("$LANGUAGE", ApplicationFrame.GetInstance().ActiveSubscription.ActiveLanguage.ActiveRow.Language.ToLower(), true);
lcQuery.ReplacePlaceHolder("$FORMNAME", clFormInfoManager.ActiveRow.FormName, true);
clFormInfoManager.ReplaceQueryPlaceHolder(lcQuery);
return(lcQuery.RunQuery());
}
public bool UpdateOrderInfoRemark(String paOrderRemark)
{
QueryClass lcQueryClass;
lcQueryClass = new QueryClass(QueryClass.QueryType.UpdateOrderInfoRemark);
lcQueryClass.ReplacePlaceHolder("$ORDERNO", clOrderNo.ToString(), false);
lcQueryClass.ReplacePlaceHolder("$ORDERREMARK", paOrderRemark, true);
lcQueryClass.ReplacePlaceHolder("$SUBSCRIPTIONID", ApplicationFrame.GetInstance().ActiveSubscription.ActiveRow.SubscriptionID, true);
lcQueryClass.ExecuteNonQuery();
return(true);
}
protected static SessionRow GetSessionRow(String paSubscriptionID, String paLoginID)
{
QueryClass lcQuery;
DataTable lcDataTable;
lcQuery = new QueryClass(QueryClass.QueryType.GetSessionRow);
lcQuery.ReplacePlaceHolder("$SUBSCRIPTIONID", paSubscriptionID, true);
lcQuery.ReplacePlaceHolder("$LOGINID", paLoginID, true);
if (((lcDataTable = lcQuery.RunQuery()) != null) && (lcDataTable.Rows.Count > 0))
{
return(new SessionRow(lcDataTable.Rows[0]));
}
else
{
return(null);
}
}
private bool UpdatDataRecord(Dictionary <String, String> paActiveDataList)
{
QueryClass lcQuery;
try
{
lcQuery = new QueryClass(clUpdateQuery, clConnectionMode);
lcQuery.ReplaceDictionaryPlaceHolder(paActiveDataList);
lcQuery.ReplacePlaceHolder("$COLUMNLIST", "N\'(" + paActiveDataList.GetData(ctKEYDataColumnList) + ")\'", false);
lcQuery.ReplacePlaceHolder("$VALUELIST", BuildSQLValueString(paActiveDataList, ctKEYDataColumnList, ctComma), false);
lcQuery.ReplacePlaceHolder("$UPDATEDATASTRING", BuildSQLColumnValueString(paActiveDataList, ctKEYDataColumnList, ctComma), false);
lcQuery.ReplacePlaceHolder("$CONDITIONSTRING", BuildSQLColumnValueString(paActiveDataList, ctKEYKeyColumnList, " And "), false);
return(lcQuery.ExecuteNonQuery() > 0);
}
catch (Exception paException)
{
General.WriteExceptionLog(paException, "UPDATEDATA : " + ApplicationFrame.GetInstance().ActiveSubscription.ActiveRow.SubscriptionID);
return(false);
}
}
private AppManifestRow GetAppManifestRow(String paSubscriptionID)
{
DataTable lcDataTable;
QueryClass lcQuery;
lcQuery = new QueryClass(QueryClass.QueryType.GetAppManifestRow);
lcQuery.ReplacePlaceHolder("$SUBSCRIPTIONID", paSubscriptionID, true);
if (((lcDataTable = lcQuery.RunQuery()) != null) && (lcDataTable.Rows.Count > 0))
{
return(new AppManifestRow(lcDataTable.Rows[0]));
}
else
{
return(null);
}
}
protected static SessionRow GetSessionRow(String paSessionKey)
{
QueryClass lcQuery;
DataTable lcDataTable;
lcQuery = new QueryClass(QueryClass.QueryType.GetSessionRowBySessionKey);
lcQuery.ReplacePlaceHolder("$SESSIONKEY", paSessionKey, true);
if (((lcDataTable = lcQuery.RunQuery()) != null) && (lcDataTable.Rows.Count > 0))
{
return(new SessionRow(lcDataTable.Rows[0]));
}
else
{
return(null);
}
}
static private FormInfoRow GetFormInfoRow(String paFormName)
{
QueryClass lcQuery;
DataTable lcDataTable;
lcQuery = new QueryClass(QueryClass.QueryType.GetFormInfoRow);
lcQuery.ReplacePlaceHolder("$FORMNAME", paFormName, true);
if (((lcDataTable = lcQuery.RunQuery()) != null) && (lcDataTable.Rows.Count > 0))
{
return(new FormInfoRow(lcDataTable.Rows[0]));
}
else
{
return(null);
}
}
private void ChooseQuery(QueryType paQueryType)
{
switch (paQueryType)
{
case QueryType.GetPOSReceiptRow: clQueryClass = new QueryClass(ctGetPOSReceiptRow, clConnectionMode); break;
case QueryType.GetPOSLastReceiptNo: clQueryClass = new QueryClass(ctGetPOSLastReceiptNo, clConnectionMode); break;
case QueryType.GetPOSStakeHolderRowByStakeHolderID: clQueryClass = new QueryClass(ctGetPOSStakeHolderRowByStakeHolderID, clConnectionMode); break;
case QueryType.GetPOSStakeHolderRowByCodeNo: clQueryClass = new QueryClass(ctGetPOSStakeHolderRowByCodeNo, clConnectionMode); break;
case QueryType.POSUpdateReceipt: clQueryClass = new QueryClass(ctPOSUpdateReceipt, clConnectionMode); break;
}
clQueryClass.ReplacePlaceHolder("$SUBSCRIPTIONID", ApplicationFrame.GetInstance().ActiveSubscription.ActiveRow.SubscriptionID, true);
}
public bool UpdateData()
{
String lcPlaceHolder;
String lcValue;
QueryClass lcMasterQuery;
QueryClass lcQueryClass;
lcQueryClass = null;
lcMasterQuery = null;
try
{
for (int lcCount = 0; lcCount < clDataList.Length; lcCount++)
{
lcQueryClass = new QueryClass(clUpdateQuery, clConnectionMode);
ApplicationFrame.GetInstance().ActiveFormInfoManager.ReplaceQueryPlaceHolder(lcQueryClass);
foreach (dynamic lcKey in clDataList[lcCount].Keys)
{
lcPlaceHolder = "$" + lcKey.ToUpper();
lcValue = Convert.ToString(clDataList[lcCount][lcKey]);
lcQueryClass.ReplacePlaceHolder(lcPlaceHolder, lcValue, true);
}
if (lcMasterQuery == null)
{
lcMasterQuery = lcQueryClass;
}
else
{
lcMasterQuery.SetInnerQuery(lcQueryClass);
}
}
lcMasterQuery.ExecuteNonQueryChain();
return(true);
}
catch (Exception paException)
{
General.WriteExceptionLog(paException, "DATALISTUPDATE : " + ApplicationFrame.GetInstance().ActiveSubscription.ActiveRow.SubscriptionID);
return(false);
}
}