// ''' <summary>
// ''' Returns data to build a data grid
// ''' </summary>
// ''' <param name="params"></param>
// ''' <returns></returns>
// ''' <remarks></remarks>
//Public Function GetData(ByVal params As Dictionary(Of String, String)) As JQueryDataTable
// Dim gridData As New JQueryDataTable
// Dim offset As Integer = params("start")
// Dim pageSize As Integer = params("length")
// Dim columnNames As String() = params("columnnames").Split(",")
// Dim columnIndex = CType(params("order[0].column"), Integer)
// Dim sortColumn As String = columnNames(columnIndex)
// Dim sortOrder As String = params("order[0].dir")
// Dim searchText As String = params("searchtext")
// Dim searchType As String = params("searchtype")
// Dim searchData As New DataSet
// Dim totalRecords As Integer
// Dim sortingOrder As Boolean
// sortingOrder = IIf(sortOrder.ToLower = "asc", False, True)
// Select Case searchType
// Case Is = "TEXTSEARCH"
// Dim dbTextSearch As New DBTextSearch(settings)
// searchData = dbTextSearch.TextSearch(searchText, offset, pageSize, sortColumn, IIf(sortOrder.ToLower = "asc", False, True))
// Case Is = "PAYMENTTYPESEARCH"
// Dim dbPaymentTypeSearch As New DBPaymentTypeSearch(settings)
// searchData = dbPaymentTypeSearch.PaymentTypeSearch(searchText, offset, pageSize, sortColumn, IIf(sortOrder.ToLower = "asc", False, True))
// End Select
// totalRecords = CType(searchData.Tables(0).Rows(0)(0), Integer)
// gridData.draw = params("draw")
// gridData.recordsTotal = totalRecords
// gridData.recordsFiltered = totalRecords
// gridData.data = ConvertDataTableToList(searchData.Tables(1))
// Return gridData
//End Function
/// <summary>
/// Returns data to build a data grid
/// </summary>
/// <param name="params"></param>
/// <param name="searchType"></param>
/// <param name="offset"></param>
/// <param name="pageSize"></param>
/// <param name="sortColumn"></param>
/// <param name="sortOrder"></param>
/// <param name="searchText"></param>
/// <returns></returns>
/// <remarks></remarks>
public JQueryDataTable GetData(Dictionary <string, string> @params, int draw, string searchType, int offset, int pageSize, string sortColumn, string sortOrder, string searchText)
{
JQueryDataTable gridData = new JQueryDataTable();
DataSet searchData = new DataSet();
int totalRecords = 0;
bool sortingOrder;
sortingOrder = sortOrder.ToLower() == "asc" ? false : true;
switch (searchType)
{
case "TEXTSEARCH":
TalentSystemDefaults.DESettings temp_settings = settings;
Database_Text_Search dbTextSearch = new Database_Text_Search(ref temp_settings);
settings = temp_settings;
searchData = dbTextSearch.TextSearch(searchText, offset, pageSize, sortColumn, sortOrder.ToLower() == "asc" ? false : true);
break;
case "PAYMENTTYPESEARCH":
TalentSystemDefaults.DESettings temp_settings2 = settings;
Database_PaymentType_Search dbPaymentTypeSearch = new Database_PaymentType_Search(ref temp_settings2);
settings = temp_settings2;
searchData = dbPaymentTypeSearch.PaymentTypeSearch(searchText, offset, pageSize, sortColumn, sortOrder.ToLower() == "asc" ? false : true);
break;
}
totalRecords = System.Convert.ToInt32(searchData.Tables[0].Rows[0][0]);
gridData.draw = draw;
gridData.recordsTotal = totalRecords;
gridData.recordsFiltered = totalRecords;
gridData.data = ConvertDataTableToList(searchData.Tables[1]);
return(gridData);
}
/// <summary>
/// Get next available transaction group id
/// </summary>
/// <param name="settings"></param>
/// <returns></returns>
/// <remarks></remarks>
public static int GetGroupID(DESettings settings)
{
TalentSystemDefaults.DataAccess.DataObjects.tbl_ecommerce_module_defaults_bu tblEcommerceDefaults = new TalentSystemDefaults.DataAccess.DataObjects.tbl_ecommerce_module_defaults_bu(ref settings);
int retVal = 0;
retVal = tblEcommerceDefaults.GetGroupID();
return(retVal);
}
public static bool InsertErrorLog(DESettings settings, string sourceClass, string sourceMethod, string logCode, string logFilter1, string logFilter2, string logFilter3, string logFilter4, string logFilter5, string logContent)
{
bool retVal = false;
tbl_logs tblLogs = new tbl_logs(settings);
retVal = tblLogs.InsertLog(sourceClass, sourceMethod, logCode, logFilter1, logFilter2, logFilter3, logFilter4, logFilter5, logContent);
return(retVal);
}
public DLBase(DESettings settings, Dictionary <string, string> filters = null)
{
this.settings = settings;
DEList = new DEList();
Initialise();
DEList.AddURL = GetAddURL();
DEList.UpdateURL = GetUpdateURL();
DEList.DeleteURL = GetDeleteURL();
}
public static DLBase GetDLObject(string talentListName, DESettings settings, Dictionary <string, string> filters = null)
{
string className = Utilities.GetClassName(GlobalConstants.NS_TALENTLISTS, talentListName);
object[] parameters = new object[] { settings, filters };
DLBase obj = ReflectionUtils.CreateInstance(className, parameters);
return(obj);
}
public static DBObjectBase GetModuleObject(string moduleObjectName, DESettings settings)
{
string className = Utilities.GetClassName(GlobalConstants.NS_DATAACCESS_MODULEOBJECTS, moduleObjectName);
object[] parameters = new object[] { settings };
DBObjectBase obj = ReflectionUtils.CreateInstance(className, parameters);
return(obj);
}
public static string[] GetDisplayTabs(DESettings settings)
{
tbl_page_text_lang textLang = new tbl_page_text_lang(ref settings);
var pageTexts = textLang.GetTextsForPage(settings.DefaultBusinessUnit, "SystemDefaults.aspx");
var displayTabs = new DisplayTabs(pageTexts);
Array results = (Array)(displayTabs.Classes.Select(item => item.Key).ToArray());
return((string[])results);
}
public static DMBase GetDMObject(DESettings settings, bool initialiseData = true)
{
string talentModuleName = settings.Module_Name;
string className = Utilities.GetClassName(GlobalConstants.NS_TALENTMODULES, talentModuleName);
object[] parameters = new object[] { settings, initialiseData };
DMBase obj = ReflectionUtils.CreateInstance(className, parameters);
return(obj);
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="settings"></param>
/// <remarks></remarks>
public DBObjectBase(DESettings settings)
{
this.settings = settings;
if (settings.VariableKey1 != string.Empty)
{
variableKey1Value = settings.VariableKey1;
}
if (settings.Company != string.Empty)
{
companyCode = settings.Company;
}
}
public static string[] GetBusinessUnits(DESettings settings)
{
System.Collections.Generic.List <string> buList = new System.Collections.Generic.List <string>();
string application = "EBusiness";
DataAccess.DataObjects.SystemObjects.tbl_url_bu objUrlBU = new DataAccess.DataObjects.SystemObjects.tbl_url_bu(ref settings);
DataTable dataTable = objUrlBU.RetrieveBusinessUnit(application);
foreach (DataRow row in dataTable.Rows)
{
buList.Add(row["BUSINESS_UNIT"].ToString());
}
return(buList.ToArray());
}
public static ConfigurationEntity[] GetDMConfigurations(DESettings settings, string talentModuleName)
{
string className = Utilities.GetClassName(GlobalConstants.NS_TALENTMODULES, talentModuleName);
TypeInfo type = (TypeInfo)(ReflectionUtils.GetTypeInfo(className));
System.Collections.Generic.List <string> list = new System.Collections.Generic.List <string>();
foreach (FieldInfo field in type.GetFields((System.Reflection.BindingFlags)(BindingFlags.Public | BindingFlags.Static | BindingFlags.FlattenHierarchy)))
{
list.Add(System.Convert.ToString(field.GetValue(null)));
}
tbl_config_detail configDetail = new tbl_config_detail(settings);
return(configDetail.RetrieveConfigurationEntities(list));
}
/// <summary>
/// Updates data modified inside a data grid
/// </summary>
/// <param name="params"></param>
/// <param name="searchType"></param>
/// <param name="jsonData"></param>
/// <returns></returns>
/// <remarks></remarks>
public bool Save(Dictionary <string, string> @params, string searchType, string jsonData)
{
bool retVal = true;
JavaScriptSerializer jsSerializer = new JavaScriptSerializer();
object objEntity = new object();
Database_Text_Search dbTextSearch = default(Database_Text_Search);
List <TextSearchEntity> lstTextSearchEntity = new List <TextSearchEntity>();
TextSearchEntity objTextSearchEntity = default(TextSearchEntity);
var typeTextSearchUpdatedData = (new List <TextSearchUpdateData>()).GetType();
List <SearchDataConfigs> lstTables = null;
Dictionary <string, string> tableList = new Dictionary <string, string>();
switch (searchType)
{
case "TEXTSEARCH":
objEntity = jsSerializer.Deserialize(jsonData, typeTextSearchUpdatedData);
try
{
TalentSystemDefaults.DESettings temp_settings = settings;
dbTextSearch = new Database_Text_Search(ref temp_settings);
settings = temp_settings;
lstTables = DataConfigs.FindAll(x => x.ConfigType == System.Convert.ToInt32(ConfigurationTypes.Table) & x.SearchType == TEXTSEARCH);
foreach (var tableConfig in lstTables)
{
tableList.Add(tableConfig.TableName, tableConfig.ConfigIndex.ToString());
}
// convert into an entity object
foreach (TextSearchUpdateData UpdatedRow in ((List <TextSearchUpdateData>)objEntity))
{
objTextSearchEntity = new TextSearchEntity();
objTextSearchEntity.ID = int.Parse(UpdatedRow.id);
objTextSearchEntity.TableName = UpdatedRow.dbTable;
objTextSearchEntity.Text_Code = UpdatedRow.text_code;
objTextSearchEntity.Text_Content = UpdatedRow.text_content;
lstTextSearchEntity.Add(objTextSearchEntity);
}
retVal = dbTextSearch.SaveTextSearchData(lstTextSearchEntity, tableList);
}
catch (Exception)
{
throw;
}
break;
case "PAYMENTTYPESEARCH":
break;
}
return(retVal);
}
public Database_PaymentType_Search(ref DESettings settings)
: base(settings)
{
}
public Database_Text_Search(ref DESettings settings)
: base(settings)
{
}
public int Execute(DESettings settings)
{
int affectedRows = 0;
System.Collections.Generic.List <TalentDB2Access> removeList = new System.Collections.Generic.List <TalentDB2Access>();
foreach (TalentDB2Access db2Access in this)
{
bool hasQuote = false;
foreach (DEDB2Parameter param in db2Access.CommandElements.CommandParameter)
{
if (param.ParamValue != null && System.Convert.ToString(param.ParamValue).Contains("'"))
{
hasQuote = true;
break;
}
}
if (hasQuote)
{
ErrorObj err = default(ErrorObj);
affectedRows += System.Convert.ToInt32(Execute(db2Access, ref err));
if (err.HasError)
{
throw new Exception(err.ErrorMessage);
}
removeList.Add(db2Access);
}
}
foreach (TalentDB2Access item in removeList)
{
this.Remove(item);
}
if (Count > 0)
{
if (Count == 1)
{
ErrorObj err = default(ErrorObj);
affectedRows += Execute(this[0], ref err);
if (err.HasError)
{
throw new Exception(err.ErrorMessage);
}
}
else
{
ErrorObj err = default(ErrorObj);
settings.FunctionName = "UpdateDB2Data";
string xmlString = GetXML();
DEDB2Defaults deDB2Defaults = new DEDB2Defaults();
deDB2Defaults.XMLString = xmlString;
TalentDB2Access talentDB2AccessDetail = new TalentDB2Access();
DataTable outputDataTable = default(DataTable);
try
{
talentDB2AccessDetail.Settings = settings;
//Execute
err = talentDB2AccessDetail.DB2DefaultsAccess(DestinationDatabase.TALENTTKT, deDB2Defaults);
if ((!(err.HasError)) && (!(talentDB2AccessDetail.ResultDataSet == null)))
{
outputDataTable = talentDB2AccessDetail.ResultDataSet.Tables[1];
affectedRows = System.Convert.ToInt32(outputDataTable.Rows[0]["AffectedRows"]);
}
}
catch (Exception)
{
throw;
}
finally
{
talentDB2AccessDetail = null;
}
}
}
Clear();
return(affectedRows);
}
/// <summary>
/// XML Comment
/// </summary>
/// <param name="objtalentSqlAccessDetail"></param>
/// <param name="settings"></param>
/// <remarks></remarks>
public static void SerializeTransaction(TalentDataAccess objtalentSqlAccessDetail, DESettings settings)
{
DataAccess.ConfigObjects.tbl_config_detail_audit objAudit = new DataAccess.ConfigObjects.tbl_config_detail_audit(ref settings);
MemoryStream ms = new MemoryStream();
BinaryFormatter bf = new BinaryFormatter();
// serialize the object
bf.Serialize(ms, objtalentSqlAccessDetail);
if (settings.GroupID == "")
{
settings.GroupID = GetGroupID(settings).ToString();
}
// add it to DB
objAudit.Insert(ms, settings.GroupID, settings.Module_Name, settings.AgentName, objtalentSqlAccessDetail.TableName, objtalentSqlAccessDetail.Action, objtalentSqlAccessDetail.DataSource, objtalentSqlAccessDetail.Catalog, settings.BusinessUnit);
}