public async Task <ReciboDto> GetInfoRecibo(ParametersReciboDto parameters)
{
ReciboDto recibo = new ReciboDto();
try
{
GenerateResponse response = new GenerateResponse();
response = await _cuponeraRepository.ValidateRecibo(_mapper.Map <ParametersRecibo>(parameters));
if (response.P_NCODE == 0)
{
var ReciboResult = await _cuponeraRepository.GetInfoRecibo(_mapper.Map <ParametersRecibo>(parameters));
if (ReciboResult == null)
{
return(null);
}
recibo = _mapper.Map <ReciboDto>(ReciboResult);
}
else
{
recibo.P_NCODE = response.P_NCODE;
recibo.P_SMESSAGE = response.P_SMESSAGE;
}
} catch (Exception ex)
{
_logger.LogError(ex.InnerException.ToString());
}
return(recibo);
}
public Task <GenerateResponse> GenerateCupon(ParametersRecibo parametersRecibo)
{
GenerateResponse response = new GenerateResponse();
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(new OracleParameter("NRECEIPT", OracleDbType.Int64, parametersRecibo.NroRecibo, ParameterDirection.Input));
parameters.Add(new OracleParameter("SKEY", OracleDbType.NVarchar2, parametersRecibo.Key, ParameterDirection.Input));
parameters.Add(new OracleParameter("NUSERCODE", OracleDbType.Int32, parametersRecibo.UserCode, ParameterDirection.Input));
var P_NCODE = new OracleParameter("NERROR", OracleDbType.Int32, ParameterDirection.Output);
var NUM_CUPON = new OracleParameter("NCUPONERA", OracleDbType.Int64, ParameterDirection.Output);
P_NCODE.Size = 100;
NUM_CUPON.Size = 100;
parameters.Add(P_NCODE);
parameters.Add(NUM_CUPON);
using (OracleDataReader dr = (OracleDataReader)_connectionBase.ExecuteByStoredProcedure("PKG_CRE_CUPONERA.CRECOUPON", parameters, ConnectionBase.enuTypeDataBase.OracleVTime))
{
response.P_NCODE = Int32.Parse(P_NCODE.Value.ToString());
response.data = NUM_CUPON.Value.ToString();
}
return(Task.FromResult(response));
}
public static GenerateResponse GenerateCodes(int coudeAmmount, int length)
{
using (var context = new EPSContext())
{
GenerateResponse resp = new GenerateResponse();
try
{
List <CardCode> cardCodes = new List <CardCode>();
for (int i = 0; i < coudeAmmount; i++)
{
var cardCode = UniqueCode(context, length);
cardCodes.Add(new CardCode()
{
Code = cardCode
});
}
context.CardCodes.AddRange(cardCodes);
context.SaveChanges();
resp.GenerateStatus = Protocol.CodeGenerateEnum.Generated;
return(resp);
}
catch (Exception e)
{
resp.Notification = "Error generating Codes";
resp.GenerateStatus = Protocol.CodeGenerateEnum.Error;
return(resp);
}
}
}
private void Run()
{
isRunning = true;
socketServer = new WebSocketServer(string.Format("ws://0.0.0.0:{0}", port));
socketServer.ListenerSocket.NoDelay = true;
socketServer.RestartAfterListenError = true;
socketServer.SupportedSubProtocols = new[] { "nowplaying_data" };
wsThread = new Thread(new ThreadStart(RunTask));
wsThread.Start();
GenerateResponse.WsRef = this;
socketServer.Start(socket =>
{
socket.OnOpen = () =>
{
allSockets.Add(socket);
IsForced = true;
};
socket.OnClose = () =>
{
allSockets.Remove(socket);
};
socket.OnMessage = message =>
{
if (message.Length > 0)
{
GenerateResponse.HandleResponse(message);
}
};
});
}
private void btnPreview_Click(object sender, EventArgs e)
{
GenerateResponse generateResponse = GetFromData();
this.dataGridView1.DataSource = generateResponse.QueryResult;
this.txtDataSQL.Text = generateResponse.SQL.ToString();
}
private GenerateResponse GetFromData()
{
DataTable dtReturn = null;
DataLayer.DataRunner objDR = null;
var generateResponse = new GenerateResponse();
var myConnection = new SqlConnection(this.txtConnectionString1.Text);
try
{
myConnection.Open();
var myCommand = new SqlCommand(this.txtConnectionString1.Text, myConnection);
SqlDataAdapter adapter = new SqlDataAdapter(queryString, connection);
DataSet customers = new DataSet();
adapter.Fill(customers, "Customers");
using (SqlDataReader oReader = myCommand.ExecuteReader())
{
oReader.Read()
while (oReader.Read())
{
matchingPerson.firstName = oReader["FirstName"].ToString();
matchingPerson.lastName = oReader["LastName"].ToString();
}
myConnection.Close();
}
objDR = new DataLayer.DataRunner(this.txtConnectionString1.Text);
dtReturn = objDR.ExecuteDataTableSQL(this.txtSQLSelect.Text);
this.lblCount.Text = dtReturn.Rows.Count.ToString();
generateResponse.SQL = GetSQLFromDataText(dtReturn);
generateResponse.QueryResult = dtReturn;
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, "Problem", MessageBoxButtons.OK);
}
finally
{
myConnection.Close();
}
//Save the connection string and the SQL
this.LastConnectionString1 = this.txtConnectionString1.Text;
this.LastSQL = this.txtSQLSelect.Text;
//dtReturn.DefaultView.RowFilter = "Name = 'sourcing'";
return(generateResponse);
}
private void RunTask()
{
while (isRunning)
{
SendMessage(GenerateResponse.GetNowPlayingData(IsForced));
IsForced = false;
Thread.Sleep(500);
}
}
private void btnSaveSQL_Click(object sender, EventArgs e)
{
GenerateResponse generateResponse = GetFromData();
using (SaveFileDialog dialog = new SaveFileDialog())
{
if (dialog.ShowDialog(this) == DialogResult.OK)
{
File.WriteAllText(dialog.FileName, generateResponse.SQL.ToString());
}
}
}
private async void Generate()
{
string uriData = $"%7B%22name%22%3A%22{Name}%22%2C%22portion%22%3A%22{Portion}%22%2C%22company%22%3A%22{Company}%22%2C%22seller%22%3A%22{Seller}%22%2C%22from_date%22%3A%22{FromDate.ToString()}%22%2C%22to_date%22%3A%22{ToDate.ToString()}%22%7D";
Dictionary <string, string> args = new Dictionary <string, string>();
args.Add("access_token", _session.AccessToken);
args.Add("data", uriData);
GenerateResponse res = await _session.GetJson <GenerateResponse>("generate", args);
if (res.Hash != string.Empty)
{
IronBarCode.BarcodeWriter.CreateBarcode(res.Hash, IronBarCode.BarcodeWriterEncoding.QRCode).SaveAsPng(res.Hash + ".png");
MessageBox.Show("Операция выполнена успешно", "PharmaChain", MessageBoxButton.OK);
}
else
{
MessageBox.Show("Ошибка токена", "PharmChain", MessageBoxButton.OK);
}
}
public async Task <GenerateResponse> AnnulmentCupon(ParametersReciboDto parametersRecibo)
{
GenerateResponse Cupon = null;
try
{
var ReciboResult = await _cuponeraRepository.AnnulmentCupon(_mapper.Map <ParametersRecibo>(parametersRecibo));
if (ReciboResult == null)
{
return(null);
}
Cupon = _mapper.Map <GenerateResponse>(ReciboResult);
}
catch (Exception ex)
{
_logger.LogError(ex.InnerException.ToString());
}
return(Cupon);
}
public async Task <GenerateResponse> GetDirectLineTokenAsync(string secret)
{
GenerateResponse result = null;
byte[] byteData = Encoding.UTF8.GetBytes(JsonConvert.SerializeObject(new { }));
using (var content = new ByteArrayContent(byteData))
{
content.Headers.ContentType = new MediaTypeHeaderValue("application/json");
httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", $"{secret}");
var response = await httpClient.PostAsync($"https://directline.botframework.com/v3/directline/tokens/generate", content);
if (response.IsSuccessStatusCode)
{
var json = await response.Content.ReadAsStringAsync();
result = JsonConvert.DeserializeObject <GenerateResponse>(json);
}
}
return(result);
}
public async Task <GenerateResponse> PrintCupon(PrintCupon paramPrint)
{
GenerateResponse Cupon = null;
List <TemplateCupon1> template = null;
try
{
var ReciboResult = await _cuponeraRepository.PrintCupon(_mapper.Map <PrintCupon>(paramPrint));
if (ReciboResult == null)
{
return(null);
}
template = _mapper.Map <List <TemplateCupon1> >(ReciboResult);
Cupon =
ConsumeService <GenerateResponse, List <TemplateCupon1> > .PostRequest(_ldapSettings.UrlServicioGestor, "Report/GenerateReport", template);
if (Cupon.P_NCODE == 0 && paramPrint.flgCronograma)
{
GenerateResponse cronoResponse = null;
List <TemplateCupon2> ListCronograma = new List <TemplateCupon2>();
var Cronograma = await _cuponeraRepository.PrintCuponCrono(_mapper.Map <PrintCupon>(paramPrint));
ListCronograma = _mapper.Map <List <TemplateCupon2> >(Cronograma);
cronoResponse =
ConsumeService <GenerateResponse, List <TemplateCupon2> > .PostRequest(_ldapSettings.UrlServicioGestor, "Report/GenerateReportCrono", ListCronograma);
if (cronoResponse.P_NCODE == 0)
{
Cupon.data2 = cronoResponse.data;
}
}
}
catch (Exception ex)
{
_logger.LogError(ex.InnerException.ToString());
}
return(Cupon);
}
public async void GetDirectLineTokenTest()
{
// arrage
var expectedGenerateResponse = new GenerateResponse()
{
conversationId = "conversation_id", expires_in = 100, token = "token"
};
var jsonExpectedGenerateResponse = JsonConvert.SerializeObject(expectedGenerateResponse);
var handlerMock = new Mock <HttpMessageHandler>(MockBehavior.Strict);
handlerMock
.Protected()
.Setup <Task <HttpResponseMessage> >(
"SendAsync",
ItExpr.IsAny <HttpRequestMessage>(),
ItExpr.IsAny <CancellationToken>()
)
.ReturnsAsync(new HttpResponseMessage()
{
StatusCode = HttpStatusCode.OK,
Content = new StringContent(jsonExpectedGenerateResponse),
})
.Verifiable();
var httpClient = new HttpClient(handlerMock.Object)
{
BaseAddress = new Uri("http://localhost/")
};
// act
IWebChatService webChatService = new WebChatService(httpClient, EnvironmentName, ContentRootPath);
GenerateResponse response = await webChatService.GetDirectLineTokenAsync(configuration.Secret);
// assert
Assert.Equal(expectedGenerateResponse.conversationId, response.conversationId);
Assert.Equal(expectedGenerateResponse.expires_in, response.expires_in);
Assert.Equal(expectedGenerateResponse.token, response.token);
}
public Task <GenerateResponse> ValidateRecibo(ParametersRecibo parametersRecibo)
{
GenerateResponse response = new GenerateResponse();
List <OracleParameter> parameters = new List <OracleParameter>
{
new OracleParameter("P_NRECEIPT", OracleDbType.Int64, parametersRecibo.NroRecibo, ParameterDirection.Input),
new OracleParameter("P_NTRANS_CUP", OracleDbType.Int32, parametersRecibo.idTransacion, ParameterDirection.Input)
};
var P_NCODE = new OracleParameter("P_NCODE", OracleDbType.Int32, ParameterDirection.Output);
var P_SMESSAGE = new OracleParameter("P_SMESSAGE", OracleDbType.Varchar2, ParameterDirection.Output);
P_NCODE.Size = 100;
P_SMESSAGE.Size = 4000;
parameters.Add(P_NCODE);
parameters.Add(P_SMESSAGE);
using (OracleDataReader dr = (OracleDataReader)_connectionBase.ExecuteByStoredProcedure("PKG_VAL_CUPONERA.VAL_RECEIPT", parameters, ConnectionBase.enuTypeDataBase.OracleVTime))
{
response.P_NCODE = Int32.Parse(P_NCODE.Value.ToString());
response.P_SMESSAGE = P_SMESSAGE.Value.ToString();
}
return(Task.FromResult <GenerateResponse>(response));
}
private GenerateResponse GetFromData()
{
DataTable dtReturn = null;
DataLayer.DataRunner objDR = null;
var generateResponse = new GenerateResponse();
var myConnection = new SqlConnection(this.txtConnectionString1.Text);
try
{
myConnection.Open();
var myCommand = new SqlCommand(this.txtConnectionString1.Text, myConnection);
SqlDataAdapter adapter = new SqlDataAdapter(queryString, connection);
DataSet customers = new DataSet();
adapter.Fill(customers, "Customers");
using (SqlDataReader oReader = myCommand.ExecuteReader())
{
oReader.Read()
while (oReader.Read())
{
matchingPerson.firstName = oReader["FirstName"].ToString();
matchingPerson.lastName = oReader["LastName"].ToString();
}
myConnection.Close();
}
objDR = new DataLayer.DataRunner(this.txtConnectionString1.Text);
dtReturn = objDR.ExecuteDataTableSQL(this.txtSQLSelect.Text);
this.lblCount.Text = dtReturn.Rows.Count.ToString();
generateResponse.SQL = GetSQLFromDataText(dtReturn);
generateResponse.QueryResult = dtReturn;
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, "Problem", MessageBoxButtons.OK);
}
finally
{
myConnection.Close();
}
//Save the connection string and the SQL
this.LastConnectionString1 = this.txtConnectionString1.Text;
this.LastSQL = this.txtSQLSelect.Text;
//dtReturn.DefaultView.RowFilter = "Name = 'sourcing'";
return generateResponse;
}
public async Task <IActionResult> Post()
{
GenerateResponse result = await webChatService.GetDirectLineTokenAsync(webChatService.GetConfiguration().Secret);
return((ActionResult) new OkObjectResult(new { result.token }));
}
