/// <summary>
/// Returns JSON object having set all columns/tables configurations
/// </summary>
/// <param name="configType"></param>
/// <returns></returns>
/// <remarks></remarks>
private string GetJSON(int configType)
{
List <SearchDataConfigs> lstConfigurations = default(List <SearchDataConfigs>);
JavaScriptSerializer jsSerializer = new JavaScriptSerializer();
List <Dictionary <string, object> > arrConfigurations = new List <Dictionary <string, object> >();
Dictionary <string, object> configurationProperty = default(Dictionary <string, object>);
lstConfigurations = DataConfigs.FindAll(x => x.ConfigType == configType);
foreach (SearchDataConfigs configuration in lstConfigurations)
{
configurationProperty = new Dictionary <string, object>();
configurationProperty.Add("searchType", configuration.SearchType);
if (configuration.ConfigType == 2)
{
configurationProperty.Add("idx", configuration.ConfigIndex);
configurationProperty.Add("table", configuration.TableName);
}
else
{
configurationProperty.Add("dbColumn", configuration.ColumnName);
configurationProperty.Add("header", configuration.ColumnHeaderText);
configurationProperty.Add("colType", configuration.ColumnType);
configurationProperty.Add("sort", configuration.IsSortable ? "1" : "0");
configurationProperty.Add("show", configuration.IsVisible ? "1" : "0");
configurationProperty.Add("edit", configuration.IsEditable ? "1" : "0");
configurationProperty.Add("pk", configuration.IsPrimaryKey ? "1" : "0");
}
arrConfigurations.Add(configurationProperty);
}
return(jsSerializer.Serialize(arrConfigurations));
}
public void SetBorrarRegistros(bool valor)
{
dataConfigs = new DataConfigs();
try
{
dataConfigs.SetConfig(3, valor.ToString());
}
catch (Exception ex)
{
throw new AppException("Error al intentar guardar configuración en la base de datos", "Fatal", ex);
}
}
public int ImportDataTable(string filePath)
{
var iRet = 0;
_dataConfigs.ListDataConfig.Clear();
if (File.Exists(filePath))
{
_dataConfigs = (DataConfigs)XmlSerializerHelper.ReadXML(filePath, typeof(DataConfigs));
}
return(iRet);
}
/// <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 string GetVersion()
{
DataConfigs dataConfigs = new DataConfigs();
string valor = "";
try
{
valor = dataConfigs.GetConfig(1);
}
catch (Exception ex)
{
throw ex;
}
return(valor);
}
public void SetEstadoEmpleados(bool estado)
{
dataConfigs = new DataConfigs();
try
{
dataConfigs.SetConfig(10, estado.ToString());
}
catch (AppException appex)
{
throw appex;
}
catch (Exception ex)
{
throw new AppException("Error no controlado al intentar guardar la configuración.", "Fatal", ex);
}
}
public void SetFinRango(string valor)
{
dataConfigs = new DataConfigs();
try
{
dataConfigs.SetConfig(9, valor);
}
catch (AppException appex)
{
throw appex;
}
catch (Exception ex)
{
throw new AppException("Error al intentar guardar configuración en archivo de configuraciones", "Fatal", ex);
}
}
public void SetEstadoRango(bool valor)
{
dataConfigs = new DataConfigs();
try
{
dataConfigs.SetConfig(10, valor.ToString());
}
catch (AppException appex)
{
throw appex;
}
catch (Exception ex)
{
throw new AppException("Error al intentar guardar configuración en archivo de configuraciones", "Fatal", ex);
}
}
public string GetHoraFinRango()
{
dataConfigs = new DataConfigs();
try
{
return(dataConfigs.GetConfig(9));
}
catch (AppException appex)
{
throw appex;
}
catch (Exception ex)
{
throw new AppException("Error desconocido durante la consulta de configuraciones", "Fatal", ex);
}
}
public bool GetEstadoRutinaRegs()
{
dataConfigs = new DataConfigs();
bool valor = false;
try
{
if (!Boolean.TryParse(dataConfigs.GetConfig(4), out valor))
{
throw new AppException("Error al intentar convertir los tipos de datos");
}
}
catch (AppException appex)
{
throw appex;
}
catch (Exception ex)
{
throw new AppException("Error no controlado al verificar el archivo de configuraciones", "Fatal", ex);
}
return(valor);
}
public bool GetEstadoRango()
{
dataConfigs = new DataConfigs();
bool valor = false;
try
{
if (!Boolean.TryParse(dataConfigs.GetConfig(10), out valor))
{
throw new AppException("Error al intentar convertir los tipos de datos");
}
}
catch (AppException appex)
{
throw appex;
}
catch (Exception ex)
{
throw new AppException("Error desconocido durante la consulta de configuraciones", "Fatal", ex);
}
return(valor);
}
public bool IsEmpleados()
{
dataConfigs = new DataConfigs();
string valor;
bool parse;
try
{
valor = dataConfigs.GetConfig(10);
if (!bool.TryParse(valor, out parse))
{
throw new AppException("Error al intentar convertir el valor de la configuración.");
}
}
catch (AppException appex)
{
throw appex;
}
catch (Exception ex)
{
throw new AppException("Error no controlado al intentar consultar la configuración.", "Fatal", ex);
}
return(parse);
}
