public Model mExceBD_SQL(ConfigWeb ConfigWeb_, string sCMD)
{
SqlConnection Conn = new SqlConnection();
Model modeloRpta = new Model();
DataTable dtData = new DataTable("DATA");
string sCadCon = ConfigWeb_.ConnectionStrings_.connectionString_SQL;
try
{
Conn = new SqlConnection(sCadCon);
Conn.Open();
SqlDataAdapter sda = new SqlDataAdapter(sCMD, Conn);
sda.Fill(dtData);
modeloRpta.bEstado = true;
modeloRpta.iCodigo = 0;
modeloRpta.sRpta = "OK";
modeloRpta.obj = dtData;
}
catch (Exception ex)
{
modeloRpta.bEstado = false;
modeloRpta.iCodigo = sCodErrorDataAPi;
modeloRpta.sRpta = String.Format("Class: {0} > StackTrace: {1} - Message: {2} ", "WebAPi/Data_", ex.StackTrace, ex.Message);
modeloRpta.obj = null;
}
finally
{
Conn.Close();
}
return(modeloRpta);
}
public static async Task Execute(ISession session, WebSocketSession webSocketSession, string requestID)
{
var profilePath = Path.Combine(Directory.GetCurrentDirectory(), "");
var profileConfigPath = Path.Combine(profilePath, "config");
var authFile = Path.Combine(profileConfigPath, "auth.json");
var authSchemaFile = Path.Combine(profileConfigPath, "auth.schema.json");
var authJson = File.ReadAllText(authFile, Encoding.UTF8);
var authSchemaJson = File.ReadAllText(authSchemaFile, Encoding.UTF8);
var configFile = Path.Combine(profileConfigPath, "config.json");
var configSchemaFile = Path.Combine(profileConfigPath, "config.schema.json");
var configJson = File.ReadAllText(configFile, Encoding.UTF8);
var configSchemaJson = File.ReadAllText(configSchemaFile, Encoding.UTF8);
var list = new ConfigWeb
{
AuthJson = authJson,
AuthSchemaJson = authSchemaJson,
ConfigJson = configJson,
ConfigSchemaJson = configSchemaJson
};
webSocketSession.Send(EncodingHelper.Serialize(new ConfigResponce(list, requestID)));
}
/// <summary>
/// Validates the authorization.
/// </summary>
/// <param name="loginName">Name of the login.</param>
/// <returns></returns>
public virtual bool ValidateAuthorization(string loginName)
{
try
{
return(ConfigWeb.DoesUserHavePermissions(loginName, SPBasePermissions.AddAndCustomizePages));
}
catch (Exception e)
{
throw new APIException((int)Errors.GlobalGVMValidateAuthorization, e.Message);
}
}
public Database()
{
ConnString = new MySqlConnectionStringBuilder();
ConfigWeb dbconfig = Configuracao.Configuracao.GetConfig();
ConnString.Server = dbconfig.dbHost;
ConnString.UserID = dbconfig.dbUser;
ConnString.Password = dbconfig.dbPass;
ConnString.Database = dbconfig.dbDatabase;
ConnString.SslMode = MySqlSslMode.None;
}
public ActionResult Edit(DMTT dMTT)
{
try
{
dMTT.NgayCN = DateTime.Now;
dMTT.Alias = ConfigWeb.convertToUnSign3(dMTT.TenDMTT).ToLower();
db.Entry(dMTT).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(dMTT));
}
}
public ActionResult Create(DMTT dMTT)
{
try
{
dMTT.NgayCN = DateTime.Now;
dMTT.Alias = ConfigWeb.convertToUnSign3(dMTT.TenDMTT).ToLower();
db.DMTT.Add(dMTT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(dMTT));
}
}
//�Protected�Methods�(2)�
/// <summary>
/// Releases unmanaged and - optionally - managed resources
/// </summary>
/// <param name="disposing"><c>true</c> to release both managed and unmanaged resources; <c>false</c> to release only unmanaged resources.</param>
protected virtual void Dispose(Boolean disposing)
{
if (!disposing)
{
return;
}
if (ConfigWeb == null)
{
return;
}
ConfigWeb.Dispose();
ConfigWeb = null;
}
public Model mGuardarCompraVenta(ConfigWeb ConfigWeb_,
string sTipoOrden, string sTipoNegociacion, string sNemonico, string sISN,
string sNumeroTitulos, string sValorPrecio, string sDiasVigencia, string sMoneda,
string sTipoCambio, string sOtra, string sCuentaAbono, bool bRetencion, bool bFirma,
string sObservaciones, string sRepresentante, string sCuentaValor, string sOptionRadio,
string sOrden, string sTipoComision, string sComision,
LoginUser modLoin)
{
return(new Logic.Logic_Ordenes().mGuardarCompraVenta(ConfigWeb_,
sTipoOrden, sTipoNegociacion, sNemonico, sISN,
sNumeroTitulos, sValorPrecio, sDiasVigencia, sMoneda,
sTipoCambio, sOtra, sCuentaAbono, bRetencion, bFirma,
sObservaciones, sRepresentante, sCuentaValor, sOptionRadio,
sOrden, sTipoComision, sComision,
modLoin));
}
public BolsaController(IConfiguration myConfiguration)
{
_myConfiguration = myConfiguration;
ConfigWeb_ = new ConfigWeb();
_myConfiguration.GetSection("ConfigWeb").Bind(ConfigWeb_);
ConnectionStringsX ConnectionStrings_ = new ConnectionStringsX();
_myConfiguration.GetSection("ConnectionStringsX").Bind(ConnectionStrings_);
ConfigWeb_.ConnectionStrings_ = ConnectionStrings_;
AppSettings AppSettings_ = new AppSettings();
_myConfiguration.GetSection("AppSettings").Bind(AppSettings_);
ConfigWeb_.AppSettings_ = AppSettings_;
}
public ActionResult Edit(GIOITHIEU gIOITHIEU, HttpPostedFileBase hinhanh)
{
try
{
if (hinhanh != null)
{
gIOITHIEU.HinhAnh = UploadImage(hinhanh);
}
gIOITHIEU.Alias = ConfigWeb.convertToUnSign3(gIOITHIEU.Ten);
db.Entry(gIOITHIEU).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(gIOITHIEU));
}
}
public Model mListaFiltroRentaFija(ConfigWeb ConfigWeb_, string sTipoRenta, string sNemonico)
{
Model modeloRpta = new Model();
try
{
string sCMD = "EXEC [SAB_Nemonico_Listar] '" + sTipoRenta + "','" + sNemonico + "' ";
modeloRpta = new Data_().mExceBD_SQL(ConfigWeb_, sCMD);
}
catch (Exception ex)
{
modeloRpta.bEstado = false;
modeloRpta.iCodigo = sCodErrorLogicAPi;
modeloRpta.sRpta = String.Format("Class: {0} > StackTrace: {1} - Message: {2} ", "Logic_", ex.StackTrace, ex.Message);
modeloRpta.obj = null;
}
return(modeloRpta);
}
public Model mGetTipoComision(ConfigWeb ConfigWeb_)
{
Model modeloRpta = new Model();
try
{
string sCMD = "EXEC SAB_TipoComision_Listar ";
modeloRpta = new Data_().mExceBD_SQL(ConfigWeb_, sCMD);
}
catch (Exception ex)
{
modeloRpta.bEstado = false;
modeloRpta.iCodigo = sCodErrorLogicAPi;
modeloRpta.sRpta = String.Format("Class: {0} > StackTrace: {1} - Message: {2} ", "Logic_", ex.StackTrace, ex.Message);
modeloRpta.obj = null;
}
return(modeloRpta);
}
public ActionResult Edit(TINTUC tINTUC, HttpPostedFileBase hinhanh)
{
try
{
if (hinhanh != null)
{
tINTUC.HinhAnh = UploadImage(hinhanh);
}
tINTUC.Alias = ConfigWeb.convertToUnSign3(tINTUC.TenTinTuc);
db.Entry(tINTUC).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
ViewBag.DMTT_ID = new SelectList(db.DMTT, "ID", "TenDMTT", tINTUC.DMTT_ID);
return(View(tINTUC));
}
}
public ActionResult Create(GIOITHIEU gIOITHIEU, HttpPostedFileBase hinhanh)
{
try
{
if (hinhanh != null)
{
gIOITHIEU.HinhAnh = UploadImage(hinhanh);
}
else
{
gIOITHIEU.HinhAnh = "https://png.pngtree.com/png-clipart/20190611/original/pngtree-404-hand-painted-pattern-png-image_2805465.jpg";
}
gIOITHIEU.Alias = ConfigWeb.convertToUnSign3(gIOITHIEU.TieuDeSeo);
db.GIOITHIEU.Add(gIOITHIEU);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(gIOITHIEU));
}
}
public async Task <Model> mGetConsultaCliente(ConfigWeb ConfigWeb_, IConnectHttpClient IConnectHttpClient_)
{
Model modeloRpta = new Model();
try
{
string sUrlWebApi = ConfigWeb_.Url_WebApi;
string sMetodo = "api/bolsa/mConsultaCliente";
object data = await IConnectHttpClient_.ConnectHttpClientAsync(sUrlWebApi, sMetodo, "");
modeloRpta = (Model)data;
}
catch (Exception ex)
{
modeloRpta.bEstado = false;
modeloRpta.iCodigo = this.iCode_Error_Logic;
modeloRpta.sRpta = new Utility().mErrorParse(this.sTAG, ex.StackTrace, ex.Message);
modeloRpta.obj = null;
}
return(modeloRpta);
}
public async Task <IActionResult> Configweb([Bind("id,number_of_test_cases_running_concurrently,number_of_urls_per_user")] ConfigWeb config_)
{
if (ModelState.IsValid)
{
try
{
_context.Update(config_);
await _context.SaveChangesAsync();
StatusMessage = "Update successfully";
return(RedirectToAction("Config"));
}
catch (DbUpdateConcurrencyException)
{
return(NotFound());
}
//return RedirectToAction(nameof(Index));
}
StatusMessage = "Update failed";
ViewData["Message"] = StatusMessage;
TempData.Remove(StatusMessage);
return(RedirectToAction("Config"));
}
public LoginController(IConfiguration myConfiguration
//, IHttpContextAccessor httpContextAccessor
)
{
//::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
_myConfiguration = myConfiguration;
// _httpContextAccessor = httpContextAccessor;
//::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
ConfigWeb_ = new ConfigWeb();
_myConfiguration.GetSection("ConfigWeb").Bind(ConfigWeb_);
ConnectionStringsX ConnectionStrings_ = new ConnectionStringsX();
_myConfiguration.GetSection("ConnectionStringsX").Bind(ConnectionStrings_);
ConfigWeb_.ConnectionStrings_ = ConnectionStrings_;
AppSettings AppSettings_ = new AppSettings();
_myConfiguration.GetSection("AppSettings").Bind(AppSettings_);
ConfigWeb_.AppSettings_ = AppSettings_;
}
public ActionResult Create(TINTUC tINTUC, HttpPostedFileBase hinhanh)
{
try
{
if (hinhanh != null)
{
tINTUC.HinhAnh = UploadImage(hinhanh);
}
else
{
tINTUC.HinhAnh = "https://png.pngtree.com/png-clipart/20190611/original/pngtree-404-hand-painted-pattern-png-image_2805465.jpg";
}
tINTUC.Alias = ConfigWeb.convertToUnSign3(tINTUC.TenTinTuc);
db.TINTUC.Add(tINTUC);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
}
ViewBag.DMTT_ID = new SelectList(db.DMTT, "ID", "TenDMTT", tINTUC.DMTT_ID);
return(View(tINTUC));
}
public ConsultasController(IConfiguration myConfiguration, IConnectHttpClient _IConnectHttpClient_)
{
//::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
_myConfiguration = myConfiguration;
IConnectHttpClient_ = _IConnectHttpClient_;
// _httpContextAccessor = httpContextAccessor;
//::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
ConfigWeb_ = new ConfigWeb();
_myConfiguration.GetSection("ConfigWeb").Bind(ConfigWeb_);
ConnectionStringsX ConnectionStrings_ = new ConnectionStringsX();
_myConfiguration.GetSection("ConnectionStringsX").Bind(ConnectionStrings_);
ConfigWeb_.ConnectionStrings_ = ConnectionStrings_;
AppSettings AppSettings_ = new AppSettings();
_myConfiguration.GetSection("AppSettings").Bind(AppSettings_);
ConfigWeb_.AppSettings_ = AppSettings_;
}
public Model mGetOrden(ConfigWeb ConfigWeb_, int iCodigoOpcion)
{
return(new Logic_().mGetOrden(ConfigWeb_, iCodigoOpcion));
}
public Model mGetTipoComision(ConfigWeb ConfigWeb_)
{
return(new Logic_().mGetTipoComision(ConfigWeb_));
}
public Model mGetTipoPrecio(ConfigWeb ConfigWeb_)
{
return(new Logic_().mGetTipoPrecio(ConfigWeb_));
}
public async Task<Model> mConsultaCliente(ConfigWeb ConfigWeb_, IConnectHttpClient IConnectHttpClient_)
{
return await new Logic.Logic_Consultas().mConsultaCliente(ConfigWeb_, IConnectHttpClient_);
}
public Model mGetMoneda(ConfigWeb ConfigWeb_)
{
return(new Logic_().mGetMoneda(ConfigWeb_));
}
public Model mListaFiltroRentaFija(ConfigWeb ConfigWeb_, string sTipoRenta, string sNemonico)
{
return(new Logic_().mListaFiltroRentaFija(ConfigWeb_, sTipoRenta, sNemonico));
}
private string UrlHubIntegrador(ConfigWeb ConfigWeb_, string Transaccion)
{
string UrlReturn = new Utility().ServidorHI(ConfigWeb_) + new Utility().RetornaServicioHubIntegrador(ConfigWeb_, Transaccion).ToLower();
return(UrlReturn);
}
public Model mLogin(ConfigWeb ConfigWeb_, string sUsuario, string sPassword)
{
Model modeloRpta = new Model();
//string sUrlWebApi = ConfigurationManager.ConnectionStrings["Url_WebApi"].ConnectionString.ToString();
Utility util = new Utility();
try
{
String strSesion = "00001";
string sTransaccion = "VLA0";
LoginUser modLogin = new LoginUser();
modLogin.sUsuario = sUsuario;
modLogin.sPassword = sPassword;
modLogin.SessionId = strSesion;
WebClient webClient = new WebClient();
byte[] resByte = null;
byte[] reqString = null;
objHeader = new Utility().RetornaHeaderEnvio(ConfigWeb_, sTransaccion, sUsuario, strSesion);
oRequestTransaccionVLA0.requestHeader = objHeader;
oRequestTransaccionVLA0.asunto1 = sUsuario;
oRequestTransaccionVLA0.asunto2 = sPassword;
oRootTransaccionVLA0.integrationRequest = oRequestTransaccionVLA0;
urlToPost = this.UrlHubIntegrador(ConfigWeb_, sTransaccion);
webClient.Headers.Add("Content-Type", "application/json");
reqString = Encoding.Default.GetBytes(JsonConvert.SerializeObject(oRootTransaccionVLA0, Formatting.Indented));
//string serializedJson = JsonConvert.SerializeObject(oRootTransaccionVLA0);
resByte = webClient.UploadData(this.urlToPost, "post", reqString);
resString = Encoding.Default.GetString(resByte);
// Console.WriteLine(resString);
webClient.Dispose();
// capturar el formato JSON y deserializarlo en el objeto response para pasarlo a la grilla.
//dtTabla = oFormateoJSOn.ResponseDatatableTrama("VLA0", oFormateoJSOn.resString, strCol, out booMasPaginas, out strSiguienteRegistro, out strSiguienteRegistro2, out mySession);
oTransaccionVLA0Response = (VLA0_RootResponse)util.ResponseObjectTrama("VLA0", resString);
if (oTransaccionVLA0Response.XMLNSC == null)
{
obj_cadenaerror = (Error_RootResponse)util.ResponseObjectError(resString);
string sCodigoError = obj_cadenaerror.integrationResponse.responseHeader.codigoError;
string sIdSesion = obj_cadenaerror.integrationResponse.responseHeader.idSesion;
string sMensajeError = obj_cadenaerror.integrationResponse.responseHeader.mensajeError;
modeloRpta.bEstado = false;
modeloRpta.iCodigo = 1;
modeloRpta.sRpta = "CodigoError: " + sCodigoError + " / IdSesion: " + sIdSesion + " / Msg: " + sMensajeError;
modeloRpta.obj = null;
}
else
{
/** Comentado por cambio solicitado: WO0000000100275
* oUsuario = oFormateador.RetornaUsuarioSesion(strCadenaRespuesta);
**/
if (oTransaccionVLA0Response.XMLNSC.integrationResponse.cod_ret == "00")
{
//oUsuario.HuboError = false;
//oUsuario.SessionId = "00001";
modeloRpta.bEstado = true;
modeloRpta.iCodigo = 0;
modeloRpta.sRpta = "SessionId: 00001";
modeloRpta.obj = JsonConvert.SerializeObject(modLogin);
}
else
{
//oUsuario.HuboError = true;
//oUsuario.SessionId = "00001";
modeloRpta.bEstado = false;
modeloRpta.iCodigo = 1;
modeloRpta.sRpta = "mLogin - SessionId: 00001";
modeloRpta.obj = null;
}
}
}
catch (Exception ex)
{
modeloRpta.bEstado = false;
modeloRpta.iCodigo = this.iCode_Error_Logic;
modeloRpta.sRpta = new Utility().mErrorParse(this.sTAG, ex.StackTrace, ex.Message);
//modeloRpta.dt = dt;
modeloRpta.obj = null;
}
return(modeloRpta);
}
public async Task <Model> mGetOrden(ConfigWeb ConfigWeb_, IConnectHttpClient IConnectHttpClient_, int iCodigoOpcion)
{
return(await new Logic.Logic_Ordenes().mGetOrden(ConfigWeb_, IConnectHttpClient_, iCodigoOpcion));
}
public Model mSearchInfo(ConfigWeb ConfigWeb_, string sTypeSearch, string sValSearch, LoginUser modLoin)
{
return(new Logic.Logic_Ordenes().mSearchInfo(ConfigWeb_, sTypeSearch, sValSearch, modLoin));
}
public async Task <Model> mGetMoneda(ConfigWeb ConfigWeb_, IConnectHttpClient IConnectHttpClient_)
{
return(await new Logic.Logic_Ordenes().mGetMoneda(ConfigWeb_, IConnectHttpClient_));
}
