public DataTable GetServiceSyncDataValue(DBSetting dbSetting, SyncDataTypeEnum dataType)
{
string sQuery = string.Format(DBScripts.MASTER_GETSERVICESYNCDATA_BYDATATYPE, dataType.ToString());
sQuery = DBHelper.Instance.QueryScript(DBTables.TABLE_FLEX_SERVICESYNCDATA, sQuery);
DataTable dt = dbSetting.GetDataTable(sQuery, false);
return(dt);
}
public DataTable GetTriggerMaintenance_ByMaintenanceValue(DBSetting dbSetting, CategoryEnum category, ActionTypeEnum actionType, string maintenanceValue)
{
string sQuery = string.Format(DBScripts.TRIGGERMAINTENANCE_GETLIST_BYMAINTENANCEVALUE, category.ToString().ToUpper(), maintenanceValue.ToString(), actionType.ToString().ToUpperInvariant());
sQuery = DBHelper.Instance.QueryScript(DBTables.TABLE_TRIGGERMAINTENANCE, sQuery);
DataTable dt = dbSetting.GetDataTable(sQuery, false);
return(dt);
}