private bool VerificaLogin(string Login, string Senha)
{
var sucesso = false;
try
{
if (!string.IsNullOrEmpty(Login) && !string.IsNullOrEmpty(Senha))
{
using (var db = new BaseDataContext())
{
var usuarios = db.Usuarios.Where(u => u.NM_LOGIN == Login.Trim() && u.NM_SENHA == Senha.Trim() && u.FL_HABILITA == 1);
if (usuarios.Count() > 0)
{
sucesso = true;
}
usuarios = null;
}
}
}
catch (Exception ex)
{
}
return(sucesso);
}
protected void rbSalvaEdicao_Click(object sender, EventArgs e)
{
using (var db = new BaseDataContext())
{
try
{
if (Validacao("Editar"))
{
var banco = db.Bancos.Single(u => u.ID_BANCO == int.Parse(hfID_Banco.Value));
banco.NR_BANCO = rtbNR_Banco.Text;
banco.NM_DESCRICAO = rtbNM_Descricao.Text.ToUpper().Trim();
db.SubmitChanges();
rwBanco.Visible = false;
rgBancos.Rebind();
rwmWindow.RadAlert("Banco alterado com sucesso!", 400, 100, "Atenção", null);
}
else
{
rwmWindow.RadAlert(aviso, 350, 100, "Atenção", null);
}
}
catch (Exception ex)
{
rwmWindow.RadAlert(ex.Message, 350, 100, "Atenção", null);
}
}
}
public void Registration(User us)
{
using (var db = new BaseDataContext())
{
var Log = db.Users.FirstOrDefault(b => b.Login == us.Login);
if (Log == null)
{
ViewBag.UserAuth = true;
us.Role = 0;
db.Users.Add(us);
db.SaveChanges();
Response.Cookies["UserId"].Value = Convert.ToString(us.Id);
Response.Cookies["UserId"].Expires = DateTime.Now.AddDays(1);
Response.Cookies["UserName"].Value = Convert.ToString(us.Name);
Response.Cookies["UserName"].Expires = DateTime.Now.AddDays(1);
Response.Cookies["UserRole"].Value = Convert.ToString(us.Role);
Response.Cookies["UserRole"].Expires = DateTime.Now.AddDays(1);
Response.Redirect("/");
}
else
{
ModelState.AddModelError("", "Логин уже занят");
//return View();
}
}
}
public User GetUser(int id)
{
using (var db = new BaseDataContext())
{
return(db.Users.FirstOrDefault(b => b.Id == id));
}
}
public ActionResult EditLot(Lot _lot)
{
using (var db = new BaseDataContext())
{
db.Entry(_lot).State = EntityState.Modified;
try
{
db.SaveChanges();
return(RedirectToRoute(new { controller = "List", action = "ViewList" }));
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult validationError in ex.EntityValidationErrors)
{
Response.Write("Object: " + validationError.Entry.Entity.ToString());
foreach (DbValidationError err in validationError.ValidationErrors)
{
Response.Write(" ");
Response.Write(err.ErrorMessage + "");
}
}
};
return(View());
}
}
private bool Pesquisa(string Acao)
{
var sucesso = false;
try
{
using (var db = new BaseDataContext())
{
var lstUsuarios = db.Usuarios.ToList();
var loginEmUso = lstUsuarios.Where(u => u.NM_LOGIN == rtbLogin.Text);
var emailEmUso = lstUsuarios.Where(u => u.NM_EMAIL == rtbEmail.Text);
var cpfEmUso = lstUsuarios.Where(u => u.NR_CPF == rmtbCPF.Text);
var celularEmUso = lstUsuarios.Where(u => u.NR_CELULAR == rmtbCelular.Text);
if (Acao == "Incluir")
{
if (loginEmUso.Count() > 0)
{
aviso = "Login duplicado";
}
if (emailEmUso.Count() > 0)
{
aviso = "E-mail duplicado";
}
if (cpfEmUso.Count() > 0)
{
aviso = "CPF duplicado";
}
if (celularEmUso.Count() > 0)
{
aviso = "Celular duplicado";
}
if (rtbNome.Text.Length <= 3)
{
aviso = "Nome inválido";
}
if (rmtbCelular.Text.Length != 11)
{
aviso = "número de celular inválido";
}
if (aviso == string.Empty)
{
sucesso = true;
}
}
lstUsuarios = null;
loginEmUso = null;
emailEmUso = null;
cpfEmUso = null;
celularEmUso = null;
}
}
catch (Exception ex)
{
aviso = $"{ex.Message}";
}
return(sucesso);
}
protected void rbLogIn_Click1(object sender, EventArgs e)
{
if (VerificaLogin(rtbLogIn.Text, rtbSenha.Text))
{
using (var db = new BaseDataContext())
{
var usuarios = db.Usuarios.Where(u => u.NM_LOGIN == rtbLogIn.Text.Trim() && u.NM_SENHA == rtbSenha.Text.Trim());
if (usuarios.Count() > 0)
{
var usuario = usuarios.Single();
Session["IDUsuario"] = usuario.ID_USUARIO;
Session["Usuario_DT_UA"] = usuario.DT_ULTIMO_ACESSO;
Session["UsuarioLogin"] = usuario.NM_LOGIN;
Session["Perfil"] = usuario.ID_PERFIL;
Response.Redirect(@"~\Pages\PaginaInicial.aspx");
usuario = null;
}
usuarios = null;
}
}
else
{
rwmLogin.RadAlert("Usuário não autorizado.<Br />Entre em contato com a área de suporte.", 400, 160, "Erro no acesso", null);
}
}
protected void rbSalvaEdicao_Click(object sender, EventArgs e)
{
using (var db = new BaseDataContext())
{
try
{
if (Validacao("Editar"))
{
var usuario = db.Usuarios.Single(u => u.ID_USUARIO == int.Parse(hfID_Usuario.Value));
usuario.NM_NOME = rtbNome.Text.ToUpper().Trim();
usuario.NM_EMAIL = rtbEmail.Text.ToLower().Trim();
usuario.NR_CPF = rmtbCPF.Text;
usuario.NR_TELEFONE = rmtbTelefone.Text;
usuario.NR_CELULAR = rmtbCelular.Text;
usuario.NM_LOGIN = rtbLogin.Text.ToLower().Trim();
usuario.FL_HABILITA = (byte)(rcbFL_Habilita.Checked == true ? 1 : 0);
db.SubmitChanges();
rwUsuarios.Visible = false;
rgUsuarios.Rebind();
rwmUsuario.RadAlert("Usuário alterado com sucesso!", 400, 100, "Atenção", null);
}
else
{
rwmUsuario.RadAlert(aviso, 350, 100, "Atenção", null);
}
}
catch (Exception ex)
{
rwmUsuario.RadAlert(ex.Message, 350, 100, "Atenção", null);
}
}
}
public void DeletePerchase(int id)
{
using (var db = new BaseDataContext())
{
db.Perchases.Remove(db.Perchases.FirstOrDefault(b => b.Id == id));
}
}
private bool ValidaTransacao()
{
var sucesso = false;
using (var db = new BaseDataContext())
{
var contaDe = db.Contas.Single(c => c.ID_CONTA == int.Parse(hfID_ContaDe.Value));
var contaPara = db.Contas.Single(c => c.ID_CONTA == int.Parse(hfID_ContaPara.Value));
if (contaDe.VL_SALDO < Convert.ToDecimal(rntbVL_Valor.Value))
{
aviso = "Saldo insuficiente";
}
else if (contaPara.FL_HABILITA == 0)
{
aviso = "Conta favorecida desabilitada";
}
else if (contaDe.FL_HABILITA == 0)
{
aviso = "Conta cliente desabilitada";
}
else
{
sucesso = true;
}
contaDe = null;
contaPara = null;
}
return(sucesso);
}
public Perchase GetPerchase(int id)
{
using (var db = new BaseDataContext())
{
return(db.Perchases.FirstOrDefault(b => b.Id == id));
}
}
protected void rbIncluir_Click(object sender, EventArgs e)
{
using (var db = new BaseDataContext())
{
try
{
if (Validacao("Incluir"))
{
var moeda = new ListaMoeda();
moeda.NM_SIGLA = rtbSigla.Text.ToUpper().Trim();
moeda.NM_DESCRICAO = rtbDescricao.Text.ToUpper().Trim();
moeda.VL_BASE = 1;
moeda.VL_REAL = Convert.ToDecimal(rntbCotacao.Value);
moeda.FL_HABILITA = 1;
db.ListaMoedas.InsertOnSubmit(moeda);
db.SubmitChanges();
rwMoedas.Visible = false;
rgMoedas.Rebind();
rwmMoeda.RadAlert("Moeda adicionada com sucesso!", 400, 100, "Atenção", null);
}
else
{
rwmMoeda.RadAlert(aviso, 350, 100, "Atenção", null);
}
}
catch (Exception ex)
{
rwmMoeda.RadAlert(ex.Message, 350, 100, "Atenção", null);
}
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, BaseDataContext baseDataContext)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
baseDataContext.EnsureSeedDataForContext();
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseSession();
app.UseRouting();
app.UseAuthentication();
app.UseAuthorization();
app.UseSwagger();
app.UseSwaggerUI(c =>
{
c.SwaggerEndpoint("/swagger/v1/swagger.json", "Best Path API V1");
});
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller=Home}/{action=Index}/{id?}");
});
}
protected void rbSalvaEdicao_Click(object sender, EventArgs e)
{
using (var db = new BaseDataContext())
{
try
{
if (Validacao("Editar"))
{
var Conta = db.Contas.Single(u => u.ID_CONTA == int.Parse(hfID_Conta.Value));
Conta.ID_BANCO = Convert.ToInt32(rcbID_Banco.SelectedItem.Value);
Conta.NR_AGENCIA = rtbNR_Agencia.Text;
Conta.NR_CCORRENTE = rtbNR_CCorrente.Text.Trim();
Conta.NR_DV = rtbNR_DV.Text;
Conta.FL_HABILITA = (byte)(rcbFL_Habilita.Checked == true ? 1 : 0);
db.SubmitChanges();
rwConta.Visible = false;
rgContas.Rebind();
rwmWindow.RadAlert("Conta alterada com sucesso!", 400, 100, "Atenção", null);
}
else
{
rwmWindow.RadAlert(aviso, 350, 100, "Atenção", null);
}
}
catch (Exception ex)
{
rwmWindow.RadAlert(ex.Message, 350, 100, "Atenção", null);
}
}
}
protected void rbSalvaEdicao_Click(object sender, EventArgs e)
{
using (var db = new BaseDataContext())
{
try
{
if (Validacao("Editar"))
{
var moeda = db.ListaMoedas.Single(u => u.ID_MOEDA == int.Parse(hfID_Moeda.Value));
moeda.NM_SIGLA = rtbSigla.Text.ToUpper().Trim();
moeda.NM_DESCRICAO = rtbDescricao.Text.ToUpper().Trim();
moeda.VL_REAL = Convert.ToDecimal(rntbCotacao.Value);
moeda.FL_HABILITA = (byte)(rcbFL_Habilita.Checked == true ? 1 : 0);
db.SubmitChanges();
rwMoedas.Visible = false;
rgMoedas.Rebind();
rwmMoeda.RadAlert("Moeda alterada com sucesso!", 400, 100, "Atenção", null);
}
else
{
rwmMoeda.RadAlert(aviso, 350, 100, "Atenção", null);
}
}
catch (Exception ex)
{
rwmMoeda.RadAlert(ex.Message, 350, 100, "Atenção", null);
}
}
}
public void Login(string username, string password)
{
using (var db = new BaseDataContext())
{
User us = db.Users.FirstOrDefault(b => b.Login == username);
if (us.Pass == password)
{
Response.Cookies["UserId"].Value = Convert.ToString(us.Id);
Response.Cookies["UserId"].Expires = DateTime.Now.AddDays(1);
Response.Cookies["UserName"].Value = Convert.ToString(us.Name);
Response.Cookies["UserName"].Expires = DateTime.Now.AddDays(1);
Response.Cookies["UserRole"].Value = Convert.ToString(us.Role);
Response.Cookies["UserRole"].Expires = DateTime.Now.AddDays(1);
ViewBag.UserAuth = true;
if (us.Role == 1)
{
ViewBag.Admin = true;
Response.Redirect("/");
}
else
{
ViewBag.Admin = false;
Response.Redirect("/");
}
}
else
{
ModelState.AddModelError("", "Некорректное имя пользователя или пароль");
}
}
}
public Lot GetLot(int id)
{
using (var db = new BaseDataContext())
{
return(db.Lots.FirstOrDefault(b => b.Id == id));
}
}
protected void rbIncluir_Click(object sender, EventArgs e)
{
using (var db = new BaseDataContext())
{
try
{
if (Validacao("Incluir"))
{
var banco = new Banco();
banco.NR_BANCO = rtbNR_Banco.Text;
banco.NM_DESCRICAO = rtbNM_Descricao.Text.ToUpper().Trim();
db.Bancos.InsertOnSubmit(banco);
db.SubmitChanges();
rwBanco.Visible = false;
rgBancos.Rebind();
rwmWindow.RadAlert("Banco adicionado com sucesso!", 400, 100, "Atenção", null);
}
else
{
rwmWindow.RadAlert(aviso, 350, 100, "Atenção", null);
}
}
catch (Exception ex)
{
rwmWindow.RadAlert(ex.Message, 350, 100, "Atenção", null);
}
}
}
public void Setup()
{
this.rawData = new RawTradingDataContext();
this.singleton = new StServerMockSingleton();
this.stServer = (StServerClassMock)this.singleton.Instance;
this.manager = new SmartComOrderManager(this.singleton, this.rawData, new NullLogger());
}
public void Setup()
{
this.rawData = new RawTradingDataContext();
this.tradingData = new TradingDataContext();
MakeOrderDeliveryConfirmationOnOrderSucceeded handler =
new MakeOrderDeliveryConfirmationOnOrderSucceeded(this.rawData, this.tradingData, new NullLogger());
}
public MakeTradeOnPendingTradeInfo(BaseDataContext rawData,
IDataContext tradingData,
ILogger logger)
: base(rawData)
{
this.tradingData = tradingData;
this.logger = logger;
}
public MakeTradeOnCookieToOrderNoAssociation(BaseDataContext rawData,
IDataContext tradingData,
ILogger logger)
: base(rawData)
{
this.tradingData = tradingData;
this.logger = logger;
}
public IEnumerable <Perchase> GetAllPerchases()
{
using (var db = new BaseDataContext())
{
IEnumerable <Perchase> Perchases = db.Perchases.ToArray();
return(Perchases);
}
}
private void CarregaBanco()
{
using (var db = new BaseDataContext())
{
var lstBanco = db.Bancos.ToList();
rcbID_Banco.DataSource = lstBanco.ToList();
rcbID_Banco.DataBind();
}
}
private void CarregaUsuario()
{
using (var db = new BaseDataContext())
{
var lstUsuarios = db.Usuarios.Where(u => u.FL_HABILITA == 1).ToList();
rcbNM_Nome.DataSource = lstUsuarios.ToList();
rcbNM_Nome.DataBind();
}
}
public ActionResult EditLot(Lot _lot)
{
using (var db = new BaseDataContext())
{
db.Entry(_lot).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToRoute(new { controller = "List", action = "ViewList" }));
}
/*public User GetUser(int id)
* {
* using (var db = new BaseDataContext())
* {
* return db.Users.FirstOrDefault(b => b.Id == id);
* }
* }
*
* public Lot GetLot(int id)
* {
* using (var db = new BaseDataContext())
* {
* return db.Lots.FirstOrDefault(b => b.Id == id);
* }
* }*/
public void DeletePerchase(int id)
{
using (var db = new BaseDataContext())
{
var p = db.Perchases.First(b => b.Id == id);
db.Perchases.Remove(p);
db.SaveChanges();
}
}
public ActionResult ViewList()
{
using (var dbBooks = new BaseDataContext())
{
IEnumerable <Lot> Lots = dbBooks.Lots.ToArray();
ViewBag.Lots = Lots;
}
return(View("ViewList"));
}
public ActionResult ViewListPerchases()
{
using (var db = new BaseDataContext())
{
IEnumerable <Perchase> Perchases = db.Perchases.ToArray();
ViewBag.Perchases = Perchases;
}
return(View());
}
public ActionResult ViewListUsers()
{
using (var db = new BaseDataContext())
{
IEnumerable <User> Users = db.Users.ToArray();
ViewBag.Users = Users;
}
return(View());
}
