internal int SaveSearchConfiguration(SearchAutomationSettings searchAutomationSettings)
{
try
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@SearchConfigurationID", searchAutomationSettings.SearchConfigurationID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@PortalID", searchAutomationSettings.PortalID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@ModuleName", searchAutomationSettings.ModuleName));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@TableName", searchAutomationSettings.TableName));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@SettingKey", searchAutomationSettings.SettingKey));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@SettingValue", searchAutomationSettings.SettingValue));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@ColumnNames", searchAutomationSettings.ColumnNames));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@ColumnUAS", searchAutomationSettings.ColumnUAS));
string sp = "[dbo].[usp_AddUpdateSearchAutomationSettings]";
SQLHandler sagesql = new SQLHandler();
return(sagesql.ExecuteNonQuery(sp, ParaMeterCollection, Helper.OutputParam));
}
catch
{
return(-1);
}
}
/// <summary>
/// Save Automated Search Info [ SearchConfiguration , SearchSetting, SearchMapping, SearchQueryString ]
/// </summary>
/// <param name="automatedSearchInfo"></param>
/// <returns></returns>
public MessageCode SaveeSearchConfiguration(AutomatesSearchGatewayInfo gateWayInfo)
{
if (gateWayInfo != null)
{
if (gateWayInfo.ModuleName != null && gateWayInfo.ModuleName.Trim() != string.Empty)
{
string moduleName = gateWayInfo.ModuleName.Trim();
string tableName = gateWayInfo.TableName.Trim();
if (tableName == null || tableName == string.Empty)
{
return new MessageCode()
{
Code = Helper.ErrorCode, Message = "Table name was not provided"
}
}
;
string columnNames = string.Empty;
if (gateWayInfo.ChoosenColumns != null && gateWayInfo.ChoosenColumns.Length > 0)
{
columnNames = string.Join(",", gateWayInfo.ChoosenColumns);
}
else
{
columnNames = "";
}
string columnUAS = string.Empty;
if (gateWayInfo.ColumnAliasHeaders != null &&
gateWayInfo.ColumnAliasNames != null &&
gateWayInfo.ColumnAliasHeaders.Length > 0 &&
gateWayInfo.ColumnAliasNames.Length > 0)
{
for (int i = 0; i < gateWayInfo.ColumnAliasHeaders.Length; i++)
{
columnUAS += $"<Y><X>{gateWayInfo.ColumnAliasHeaders[i]}</X><X>{gateWayInfo.ColumnAliasNames[i]}</X><X>{i}</X></Y>";
}
}
SearchAutomationSettings searchSettings = new SearchAutomationSettings()
{
SearchConfigurationID = gateWayInfo.SearchConfigurationID,
PortalID = gateWayInfo.PortalID,
ModuleName = moduleName,
TableName = tableName,
SettingKey = Helper.QueryStringIdentifier,
SettingValue = (gateWayInfo.IsExtensionLess) ? "1" : "0",
ColumnNames = columnNames,
ColumnUAS = columnUAS,
};
AutomatedSearchProvider provider = new AutomatedSearchProvider();
int returnValue = provider.SaveSearchConfiguration(searchSettings);
if (returnValue != Helper.SuccessCode)
{
return new MessageCode()
{
Code = Helper.ErrorCode, Message = "Error while updating search settings"
}
}
;
return(new MessageCode()
{
Code = Helper.SuccessCode, Message = "Search Settings were updated"
});
}
else
{
return new MessageCode()
{
Code = Helper.ErrorCode, Message = "Module Name could not be found"
}
};
}
else
{
return new MessageCode()
{
Code = Helper.ErrorCode, Message = "Could not process the request"
}
};
}
