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