public IActionResult GetParameters(string key = null)
{
Debug.Assert(key != "undefined");
if (string.IsNullOrWhiteSpace(key))
{
key = Guid.NewGuid().ToString().ToLower();
log.Information($"new browser key {key} allocated");
}
var styles = this.musicOptions.Styles.Select(s => new StyleDTO {
Id = s.Style, Enabled = s.Enabled, DisplayName = s.Style.ToDescription()
}).ToArray();
var dto = new ParametersDTO
{
BrowserKey = key,
AppName = this.environment.IsDevelopment() ? "Apollo Dev" : "Apollo",
IsMobile = this.Request.IsMobileBrowser(),
IsIpad = this.Request.IsIpad(),// this.IsMobile == false && ipadRegex.IsMatch(Request.UserAgent()),
Browser = this.Request.GetBrowser().ToString(),
ClientIPAddress = this.Request.HttpContext.GetRemoteIPAddress(),
CompactLayoutWidth = this.musicServerOptions.CompactLayoutWidth,
Styles = styles
};
return(SuccessResult(dto));
}
public IHttpActionResult putParameters(string id, [FromBody] ParametersDTO values)
{
logger.Debug("setting parameters for /drones/{0}", id);
Drone target = droneMgr.getById(new Guid(id));
if (null != target)
{
if (!target.isConnected())
{
return(BadRequest("Target system is not connected, refusing request"));
}
Boolean result = true;
foreach (String key in values.parameters.Keys)
{
ParamValueDTO parameter = values.parameters[key];
bool parameterSetResult = target.setParameter(parameter.param_id, parameter.param_value, (MAVLink.MAV_PARAM_TYPE)Enum.Parse(typeof(MAVLink.MAV_PARAM_TYPE), parameter.param_type));
result = result && parameterSetResult;
}
Dictionary <String, ParamValue> parameters = target.Parameters;
if ((null != parameters) && (result))
{
return(Ok(DTOFactory.DTOFactory.createParametersDTO(parameters)));
}
else
{
return(ResponseMessage(new HttpResponseMessage(HttpStatusCode.RequestTimeout)));
}
}
else
{
return(NotFound());
}
}
public frmSaleProductMovemnet()
{
InitializeComponent();
_repository = new Repository();
_parameters = new ParametersDTO();
SetForm();
}
public frmSatis()
{
InitializeComponent();
Control.CheckForIllegalCrossThreadCalls = false;
_repository = new Repository();
_parameters = new ParametersDTO();
setForm();
}
public async Task <IActionResult> Put(ParametersDTO Parameters)
{
var isUpdated = await _parametersService.UpdateParameter(Parameters);
var response = new ApiResponse <bool>(isUpdated);
return(Ok(response));
}
public async Task <IActionResult> GetParameters(int id)
{
ParametersDTO Parameters = await _parametersService.GetParameter(id);
var response = new ApiResponse <ParametersDTO>(Parameters);
return(Ok(response));
}
public frmSpeedSatis()
{
InitializeComponent();
_repository = new Repository();
_parameters = new ParametersDTO();
Set_Form();
}
public frmStockEdit()
{
InitializeComponent();
_repository = new Repository();
_parameters = new ParametersDTO();
set_Form();
}
public async Task <ParametersDTO> GetParameter(int id)
{
Parameters dbRecord = await _unitOfWork.ParametersRepository.GetById(id);
ParametersDTO result = _mapper.Map <ParametersDTO>(dbRecord);
return(result);
}
public async Task InsertParameter(ParametersDTO newParameters)
{
Parameters dbRecord = _mapper.Map <Parameters>(newParameters);
await _unitOfWork.ParametersRepository.Add(dbRecord);
await _unitOfWork.SaveAdministrationSwitchChangesAsync();
}
public async Task <ActionResult <SourceServerResponseDTO> > GetSourceServerResponse([FromQuery] string sourceName, [FromQuery] string model, [FromQuery] string version, [FromQuery] bool isBeta, [FromQuery] string keyword, [FromQuery] bool isSearch)
{
var validation = ValidateStringParameter(nameof(sourceName), sourceName, 100);
if (!string.IsNullOrWhiteSpace(validation))
{
return(BadRequest(validation));
}
validation = ValidateStringParameter(nameof(model), model, 100);
if (!string.IsNullOrWhiteSpace(validation))
{
return(BadRequest(validation));
}
validation = ValidateStringParameter(nameof(version), version, 100);
if (!string.IsNullOrWhiteSpace(validation))
{
return(BadRequest(validation));
}
validation = ValidateStringParameter(nameof(keyword), keyword, 300);
if (!string.IsNullOrWhiteSpace(validation))
{
return(BadRequest(validation));
}
SourceServerResponseDTO response;
if (model == null)
{
model = AppSettingsProvider.AppSettings.DefaultModel;
}
if (version == null)
{
version = AppSettingsProvider.AppSettings.DefaultVersion;
}
var versionDto = this.versionService.GetVersion(version);
var sourceDto = this.sourceService.GetSource(sourceName);
var modelDto = this.modelService.GetModel(model);
if (sourceDto != null && versionDto != null && modelDto != null)
{
response = await this.spkService.GetPackages(sourceName,
sourceDto.Url,
modelDto.Arch,
modelDto.Name,
versionDto,
isBeta,
sourceDto.CustomUserAgent,
isSearch,
keyword,
sourceDto.UseGetMethod);
}
else
{
ParametersDTO parameters = new ParametersDTO(sourceName, model, version, isBeta, keyword);
response = new SourceServerResponseDTO(false, "Given parameters are not valid", parameters, null, Model.Enums.ResultFrom.NotSpecified, null);
}
return(new ObjectResult(response));
}
private void setForm()
{
_parameters = _repository.Run <SettingsService, ParametersDTO>(x => x.Get_Parameters());
if (_parameters.IsBarcode.GetValueOrDefault())
{
serialPort1.PortName = _parameters.BorcodeCOM;
serialPort1.BaudRate = 9600;
}
}
private void frmStok_Load(object sender, EventArgs e)
{
repositoryItemLookUpEdit1.DataSource = _repository.Run <DepotStockService, List <UnitsDTO> >(x => x.GetListUnit());
repositoryItemLookUpEdit1.ValueMember = "UID";
repositoryItemLookUpEdit1.DisplayMember = "UName";
_parameters = _repository.Run <SettingsService, ParametersDTO>(x => x.Get_Parameters());
do_refresh();
mspTool.Get_GridControl(this.Name, gcProducts);
}
private void Parameters_Load(object sender, EventArgs e)
{
string[] portlar = SerialPort.GetPortNames();
foreach (string portAdi in portlar)
{
comboBoxEdit2.Properties.Items.Add(portAdi);
}
lcRapor.Properties.DataSource = report_List;
lcRapor.Properties.DisplayMember = "Value";
lcRapor.Properties.ValueMember = "Id";
_parameters = _repository.Run <SettingsService, ParametersDTO>(x => x.Get_Parameters());
bs_Parameter.DataSource = _parameters;
}
public static ParametersDTO createParametersDTO(Dictionary <String, ParamValue> source)
{
if (null == source)
{
return(null);
}
ParametersDTO result = new ParametersDTO();
result.parameters = new Dictionary <string, ParamValueDTO>();
foreach (String key in source.Keys)
{
result.parameters.Add(key, createParamValueDTO(source[key]));
}
result.count = result.parameters.Keys.Count;
return(result);
}
public async Task <bool> UpdateParameter(ParametersDTO updatedParametersDTO)
{
Parameters existingRecord = await _unitOfWork.ParametersRepository.GetById(updatedParametersDTO.Id);
if (existingRecord == null)
{
throw new ValidationException("Registro no existe para el ID proporcionado.");
}
var updatedRecord = _mapper.Map <Parameters>(updatedParametersDTO);
_unitOfWork.ParametersRepository.Update(existingRecord, updatedRecord);
await _unitOfWork.SaveAdministrationSwitchChangesAsync();
return(true);
}
public ActionResponse <ParametersDTO> Save_Parameters(ParametersDTO model)
{
ActionResponse <ParametersDTO> response = new ActionResponse <ParametersDTO>()
{
Response = model,
ResponseType = ResponseType.Ok
};
using (MspDbContext _db = new MspDbContext())
{
try
{
if (response.Response.RecId == 0)
{
_db.Parameters.Add(base.Map <ParametersDTO, Parameters>(model));
_db.SaveChanges();
}
else
{
var entity = _db.Parameters.FirstOrDefault(x => x.RecId == response.Response.RecId);
if (entity != null)
{
_db.Entry(entity).CurrentValues.SetValues(model);
_db.Entry(entity).State = System.Data.Entity.EntityState.Modified;
}
}
_db.SaveChanges();
}
catch (Exception e)
{
response.Message = e.ToString();
response.ResponseType = ResponseType.Error;
}
}
return(response);
}
public async Task <IActionResult> Post(ParametersDTO Parameters)
{
await _parametersService.InsertParameter(Parameters);
return(Ok());
}
public async Task <RawSpkResultDto> GetRawPackages(
string sourceName,
string url,
string arch,
string unique,
VersionDTO versionDto,
bool isBeta,
string customUserAgent,
bool isSearch,
string keyword = null,
bool useGetMethod = false
)
{
RawSpkResultDto result;
ParametersDTO parameters = new ParametersDTO(sourceName, unique, versionDto, isBeta, keyword);
SearchLogEntryDTO logEntry = new SearchLogEntryDTO(parameters);
logEntry.RequestType = isSearch ? RequestType.Search : RequestType.Browse;
logEntry.LogType = LogType.Parameters;
logger.LogInformation(Utils.GetSearchLogEntryString(logEntry));
logEntry.LogType = LogType.Result;
var stopwatch = Stopwatch.StartNew();
var cacheResult = await cacheService.GetSpkResponseForRepositoryFromCache(sourceName, arch, versionDto.Build.ToString(), isBeta);
if (!cacheResult.HasValidCache)
{
var parametersRequest = PrepareParametersForRequest(arch, unique, versionDto, isBeta, customUserAgent, out var userAgent);
IDownloadService downloadService = downloadFactory.GetDefaultDownloadService();
var response = await downloadService.Execute(url, parametersRequest, userAgent, useGetMethod);
if (response.Success)
{
logEntry.ResultFrom = ResultFrom.Server;
try
{
var rawResponse = ParseResponse(sourceName, url, arch, unique, versionDto, isBeta, response.Content);
result = new RawSpkResultDto(rawResponse, null);
}
catch (Exception ex)
{
logger.LogError(ex, $"Could not parse response from server {url}");
result = new RawSpkResultDto(null, ex.Message);
}
}
else
{
logger.LogError($"Could not get any data from the server {url}");
result = new RawSpkResultDto(null, $"Could not get any data from the server {url}");
}
}
else //return response from valid cache
{
result = new RawSpkResultDto(cacheResult.Cache?.SpkResult, null);
logEntry.CacheOld = cacheResult.Cache.CacheOld;
logEntry.LogType = LogType.Result;
logEntry.ResultFrom = ResultFrom.Cache;
}
stopwatch.Stop();
logEntry.ExecutionTime = stopwatch.ElapsedMilliseconds;
logger.LogInformation(Utils.GetSearchLogEntryString(logEntry));
return(result);
}
private ParametersDTO[] getOracleParameters(string package, string procedure)
{
var strSqlParameters = "SELECT ARGUMENT_NAME, DATA_TYPE, nvl(DATA_LENGTH,'') DATA_LENGTH, nvl(DATA_PRECISION,'') , PLS_TYPE,POSITION, " +
" IN_OUT FROM USER_ARGUMENTS WHERE package_name = upper(:package) AND upper(OBJECT_NAME) = upper(:procedure) " +
"ORDER BY POSITION, IN_OUT";
//string connectionString = "DATA SOURCE=localhost:1521/xe;PERSIST SECURITY INFO=True;USER ID=Portafolio;Password=1234;";
OracleConnection conn = new OracleConnection(_dataSource); // C#
//OracleConnection conn = new OracleConnection(connectionString); */// C#
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = strSqlParameters;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new OracleParameter("package", package));
cmd.Parameters.Add(new OracleParameter("procedure", procedure));
OracleDataReader dataReader = cmd.ExecuteReader();
List <ParametersDTO> listParametersDTO = new List <ParametersDTO>();
var parametersDTO = new ParametersDTO();
int fila = 0;
while (dataReader.Read())
{
parametersDTO = new ParametersDTO();
parametersDTO.argumentName = dataReader.GetString(0);
parametersDTO.dataType = dataReader.GetString(1);
//if (parametersDTO.dataType.Equals("NUMBER"))
//{
parametersDTO.dataLength = dataReader.GetValue(2).ToString() != "" ? Int16.Parse(dataReader.GetValue(2).ToString()) : 0;
parametersDTO.dataPrecision = dataReader.GetValue(3).ToString().Length > 0 ? Int16.Parse(dataReader.GetValue(3).ToString()) : 0;
//}
//else {
// parametersDTO.dataLength = 0;
// parametersDTO.dataPrecision = 0;
//}
if (!parametersDTO.dataType.Equals("REF CURSOR"))
{
parametersDTO.plsType = dataReader.GetString(4);
}
else
{
parametersDTO.plsType = "";
}
parametersDTO.position = Int16.Parse(dataReader.GetValue(5).ToString());
parametersDTO.inOut = dataReader.GetValue(6).ToString().Length > 0 ? dataReader.GetValue(6).ToString() : "0";
listParametersDTO.Add(parametersDTO);
fila++;
}
dataReader.Dispose();
conn.Close();
var arrParametersDTO = listParametersDTO.ToArray();
return(arrParametersDTO);
}
private async Task <SourceServerResponseDTO> GenerateResult(string sourceName, string keyword, ParametersDTO parameters, SpkResult result, ResultFrom resultFrom, double?cacheOld)
{
var processIconsTask = this.cacheService.ProcessIcons(sourceName, result.Packages);
List <PackageDTO> list = new List <PackageDTO>();
if (result.Packages == null)
{
return(new SourceServerResponseDTO(true, null, parameters, null, resultFrom, cacheOld));
}
foreach (var spkPackage in result.Packages)
{
if (string.IsNullOrWhiteSpace(keyword) || KeywordExists(keyword, spkPackage))
{
PackageDTO package = new PackageDTO();
spkPackage.Map(package);
package.IconFileName = cacheService.GetIconFileName(sourceName, package.Name);
package.SourceName = sourceName;
list.Add(package);
}
}
list.Sort();
await processIconsTask;
return(new SourceServerResponseDTO(true, null, parameters, list, resultFrom, cacheOld));
}
public async Task <SourceServerResponseDTO> GetPackages(
string sourceName,
string url,
string arch,
string model,
VersionDTO versionDto,
bool isBeta,
string customUserAgent,
bool isSearch,
string keyword = null,
bool useGetMethod = false)
{
Stopwatch stopwatch = new Stopwatch();
string errorMessage;
ResultFrom resultFrom;
double? cacheOld = null;
ParametersDTO parameters = new ParametersDTO(sourceName, model, versionDto, isBeta, keyword);
SearchLogEntryDTO logEntry = new SearchLogEntryDTO(parameters);
logEntry.RequestType = isSearch ? RequestType.Search : RequestType.Browse;
logEntry.LogType = LogType.Parameters;
logger.LogInformation(Utils.GetSearchLogEntryString(logEntry));
logEntry.LogType = LogType.Result;
stopwatch.Start();
var cacheResult = await cacheService.GetSpkResponseFromCache(sourceName, arch, model, versionDto.Build.ToString(), isBeta);
SpkResult result;
if (!cacheResult.HasValidCache)
{
string unique = $"synology_{arch}_{model}"; //TODO: DSM provide model without leading "DS" or "RS", so we should do the same some day.
var parametersRequest = PrepareParametersForRequest(arch, unique, versionDto, isBeta, customUserAgent, out var userAgent);
IDownloadService downloadService = downloadFactory.GetDefaultDownloadService();
var response = await downloadService.Execute(url, parametersRequest, userAgent, useGetMethod);
if (response.Success)
{
try
{
result = ParseResponse(sourceName, url, arch, model, versionDto, isBeta, response.Content);
resultFrom = ResultFrom.Server;
}
catch (Exception ex)
{
logger.LogError(ex, $"Unable to parse response from {url}: {response.Content}");
if (cacheResult.Cache != null)
{
logger.LogInformation("Returning data from cache");
result = cacheResult.Cache.SpkResult;
resultFrom = ResultFrom.Cache;
cacheOld = cacheResult.Cache.CacheOld;
}
else
{
logger.LogError($"Error getting response for url: {url}. No cache available.");
return(new SourceServerResponseDTO(false, "No data from source server. No cache available", parameters, null, ResultFrom.NotSpecified, null));
}
}
}
else if (cacheResult.Cache != null)
{
logger.LogError($"Error getting response for url: {url}: {response.ErrorMessage}");
result = cacheResult.Cache.SpkResult;
resultFrom = ResultFrom.ExpiredCache;
cacheOld = cacheResult.Cache.CacheOld;
}
else //no cache && no server response
{
errorMessage = $"{response.ErrorMessage}";
logger.LogError($"Error getting response for url: {url}: {errorMessage}");
return(new SourceServerResponseDTO(false, errorMessage, parameters, null, ResultFrom.NotSpecified, null));
}
}
else // get data from Valid cache
{
result = cacheResult.Cache.SpkResult;
resultFrom = ResultFrom.Cache;
cacheOld = cacheResult.Cache.CacheOld;
}
if (result != null)
{
var finalResult = await GenerateResult(sourceName, keyword, parameters, result, resultFrom, cacheOld);
stopwatch.Stop();
logEntry.ResultFrom = resultFrom;
logEntry.CacheOld = cacheOld;
logEntry.ExecutionTime = stopwatch.ElapsedMilliseconds;
logger.LogInformation(Utils.GetSearchLogEntryString(logEntry));
return(finalResult);
}
else
{
errorMessage = "Spk result is empty";
stopwatch.Stop();
logEntry.ResultFrom = ResultFrom.NotSpecified;
logEntry.CacheOld = null;
logEntry.ExecutionTime = stopwatch.ElapsedMilliseconds;
logger.LogWarning("Spk result is empty {0}", Utils.GetSearchLogEntryString(logEntry));
return(new SourceServerResponseDTO(false, errorMessage, parameters, null, resultFrom, cacheOld));
}
}
private void do_refresh()
{
products = _repository.Run <DepotStockService, List <ProductDTO> >(x => x.GetListProduct());
speedSaleProducts = _repository.Run <SaleService, List <SpeedSaleProductDTO> >(x => x.GetList_SpeedSaleProduct());
_parameters = _repository.Run <SettingsService, ParametersDTO>(x => x.Get_Parameters());
}
public InvoiceList()
{
InitializeComponent();
_repository = new Repository();
_parameters = new ParametersDTO();
}
