public tb_login Add(tb_login login)
{
tb_login user = db.tb_login.Add(login);
db.SaveChanges();
return(user);
}
public ActionResult Fzr()
{
string sql = @"select UserName,Bank,Start_Date,End_Date,a.id,Meeting,b.MeetingName,a.GamePwd from tb_login a left join tb_Meeting b on a.Meeting=b.id where Lvl=1 and a.isdel=0 order by a.id desc";
MessasgeData mgdata = Datafun.MgfunctionData(sql);
List <tb_login> listorder = new List <tb_login>();
if (mgdata.Mgdatacount > 0)
{
foreach (DataRow dr in mgdata.Mgdata.Rows)
{
tb_login cbai = new tb_login
{
id = Convert.ToInt32(dr["id"].ToString()),
UserName = dr["UserName"].ToString(),
Bank = dr["Bank"].ToString(),
Start_Date = Convert.ToDateTime(dr["Start_Date"].ToString()),
End_Date = Convert.ToDateTime(dr["End_Date"].ToString()),
Meeting = Convert.ToInt32(dr["Meeting"].ToString()),
added1 = dr["MeetingName"].ToString(),
GamePwd = dr["GamePwd"].ToString()
};
listorder.Add(cbai);
}
;
}
return(View(listorder));
}
public void AtualizarToken(string email, string token)
{
tb_login user = db.tb_login.Where(y => y.email == email).FirstOrDefault <tb_login>();
user.token = token;
db.SaveChanges();
}
//funciona
public HttpResponseMessage ValidarTokenTelefone(string email, string senha, string token, string telefone)
{
tb_usuario user2 = loginService.RetornaUsuario(email, senha);
tb_login user1 = loginService.Get(user2.codLogin);
string tokenUser = user1.token.Trim();
string tokenSended = token;
if (tokenUser.Equals(tokenSended))
{
//validou ok ativa o usuario
user2.ativo = true;
//user2.celular = telefone;
//atualiza a tabela
usuarioService.Update(user2);
user1.serialChip = telefone;
//loginService.Update(user1);
var resp = new HttpResponseMessage()
{
Content = new StringContent("{\"Message\":\"Token validado com sucesso\"}")
};
resp.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");
return(resp);
}
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Token inválido"));
}
public ActionResult Auth(tb_login model, string returnUrl)
{
bd_gestmoveEntities db = new bd_gestmoveEntities();
var dataItem = db.tb_login.Where(x => x.usuario == model.usuario && x.senha == model.senha).FirstOrDefault();
if (dataItem != null)
{
FormsAuthentication.SetAuthCookie(dataItem.usuario, false);
if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") &&
!returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\"))
{
return(Redirect(returnUrl));
}
else
{
return(RedirectToAction("Index"));
}
}
else
{
ModelState.AddModelError("", "Invalid user/pass");
return(RedirectToAction("Index", "Home"));
}
}
public tb_usuario RetornaUsuario(string email, string senha)
{
tb_login currentLogin = db.tb_login.Where(x => x.email == email && x.senha == senha).FirstOrDefault <tb_login>();
tb_usuario currentUser = db.tb_usuario.Where(z => z.codLogin == currentLogin.codLogin).FirstOrDefault <tb_usuario>();
return(currentUser);
}
public HttpResponseMessage ReenviarToken(long codLogin)
{
if (codLogin == 0)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "CodUsuario zero"));
}
tb_login User = loginService.Get(codLogin);
if (User == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "CodLogin não encontrado"));
}
string token = User.token;
EnviarTokenEmail(User.email, token);
var resp = new HttpResponseMessage()
{
Content = new StringContent("{\"Message\":\"Token foi enviado no email\"}")
};
resp.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");
return(resp);
}
public bool UpDateDadosAdmin(tb_login obj)
{
{
try
{
string sSQL = "";
MySqlCommand cmd = new MySqlCommand();
MySqlConnection cn = new MySqlConnection(CConexao.Get_StringConexao());
cn.Open();
sSQL = "update tb_login set tipo=@tipo, ativo=@ativo";
cmd.Parameters.AddWithValue("@tipo", obj.Tipo);
cmd.Parameters.AddWithValue("@ativo", obj.Ativo);
cmd.CommandText = sSQL;
cmd.Connection = cn;
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
string msg = e.Message;
return(false);
}
}
}
public bool UpDateDadosUsuario(tb_login obj)
{
{
try
{
string sSQL = "";
MySqlCommand cmd = new MySqlCommand();
MySqlConnection cn = new MySqlConnection(CConexao.Get_StringConexao());
cn.Open();
sSQL = "update tb_login set nome=@nome, email=@email, telefone=@telefone, cpf_cnpj@cpf_cnpj, senha@senha";
cmd.Parameters.AddWithValue("@nome", obj.Nome);
cmd.Parameters.AddWithValue("@email", obj.Email);
cmd.Parameters.AddWithValue("@telefone", obj.Telefone);
cmd.Parameters.AddWithValue("@cpf_cnpj", obj.CPF_CNPJ);
cmd.Parameters.AddWithValue("@senha", obj.Senha);
cmd.CommandText = sSQL;
cmd.Connection = cn;
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
string msg = e.Message;
return(false);
}
}
}
public bool InserirDados(tb_login obj)
{
try
{
string sSQL = "";
MySqlCommand cmd = new MySqlCommand();
MySqlConnection cn = new MySqlConnection(CConexao.Get_StringConexao());
cn.Open();
sSQL = "insert into tb_login(nome, email, telefone, cpf_cnpj, senha, tipo, datacadastro, ativo) values " +
"(@nome, @email, @telefone, @cpf_cnpj, @senha, 'C', Now(), 1)";
cmd.Parameters.AddWithValue("@nome", obj.Nome);
cmd.Parameters.AddWithValue("@email", obj.Email);
cmd.Parameters.AddWithValue("@telefone", obj.Telefone);
cmd.Parameters.AddWithValue("@cpf_cnpj", obj.CPF_CNPJ);
cmd.Parameters.AddWithValue("@senha", obj.Senha);
cmd.CommandText = sSQL;
cmd.Connection = cn;
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
string msg = e.Message;
return(false);
}
}
protected void btnLogin_Click(object sender, ImageClickEventArgs e)
{
tb_login login = new tb_login();
login.Name = txtUser.Text;
login.Pass = txtPsw.Text;
if (txtCheckNum.Text == Session["ValidateCode"].ToString())
{
if (lb.isLogin(login))
{
Session["UserName"] = login.Name;
Response.AddHeader("Refresh", "0");
}
else
{
Response.Write("<script>alert('用户名或密码错误！')</script>");
Response.AddHeader("Refresh", "0");
}
}
else
{
Response.Write("<script>alert('验证码错误！')</script>");
Response.AddHeader("Refresh", "0");
}
}
public tb_login Remove(long id)
{
tb_login user = db.tb_login.Find(id);
db.tb_login.Remove(user);
db.SaveChanges();
return(user);
}
public ActionResult DeleteConfirmed(int id)
{
tb_login tb_login = db.tb_login.Find(id);
db.tb_login.Remove(tb_login);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,usuario,senha,nv_user")] tb_login tb_login)
{
if (ModelState.IsValid)
{
db.Entry(tb_login).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tb_login));
}
public ActionResult Create([Bind(Include = "ID, usuario, senha, nv_user")] tb_login tb_login)
{
if (ModelState.IsValid)
{
db.tb_login.Add(tb_login);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tb_login));
}
public bool isLogin(tb_login login)
{
if (ld.isLogin(login) == 0)
{
return(false);
}
else
{
return(true);
}
}
public HttpResponseMessage listarLoginId(long id)
{
tb_login resultLogin = loginService.Get(id);
if (resultLogin == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Usuario não encontrado"));
}
return(Request.CreateResponse(HttpStatusCode.OK, resultLogin));
}
public IActionResult EditarAdmin(int CodigoLogin, string Tipo, string Ativo)
{
var model = new tb_login();
model.CodigoLogin = CodigoLogin;
model.Tipo = Tipo;
model.Ativo = Ativo;
ViewData["Valida"] = "";
return(View("CadastroFuncionario", model));
}
public bool verificarTelefone(string email, string senha, string telefone)
{
tb_login currentUser = db.tb_login.Where(x => x.email == email && x.senha == senha).FirstOrDefault <tb_login>();
if (currentUser != null)
{
if (currentUser.serialChip == telefone)
{
return(true);
}
}
return(false);
}
public HttpResponseMessage AlterarLogin(JObject login)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
var user = login.ToObject <tb_login>();
if (user == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Usuario nulo"));
}
if (user.codLogin == 0)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "CodLogin nulo"));
}
if (user.email == null || user.email == "")
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Email nulo"));
}
if (user.senha == null || user.senha == "")
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Senha nula"));
}
if (user.token == null || user.token == "")
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Token nulo"));
}
if (user.serialChip == null || user.serialChip == "")
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Telefone nulo"));
}
string resultado = loginService.Update(user);
if (resultado == "Dados de login alterados com sucesso")
{
tb_login updatedLogin = loginService.Get(user.codLogin);
return(Request.CreateResponse(HttpStatusCode.OK, updatedLogin));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, resultado));
}
}
public string Validar(tb_login obj)
{
LoginDB Usuario = new LoginDB();
if (String.IsNullOrEmpty(obj.Tipo))
{
return("<div class='alert alert-warning text-center' role='alert'>Digite o tipo</div>");
}
if (Usuario.Validalogin(obj))
{
return("<div class='alert alert-warning text-center' role='alert'>Nome já existente!</div>");
}
return("");
}
// GET: Usuarios/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tb_login tb_login = db.tb_login.Find(id);
if (tb_login == null)
{
return(HttpNotFound());
}
return(View(tb_login));
}
public IActionResult EditarCliente(int CodigoLogin, string Nome, string Email, string Telefone, string Cpf, string Senha, string Tipo, string Ativo)
{
var model = new tb_login();
model.CodigoLogin = CodigoLogin;
model.Nome = Nome;
model.Email = Email;
model.Telefone = Telefone;
model.CPF_CNPJ = Cpf;
model.Senha = Senha;
model.Tipo = Tipo;
model.Ativo = Ativo;
ViewData["Valida"] = "";
return(View("CadastroCliente", model));
}
public void DesativarUsuario(string email, string senha)
{
tb_login currentUser = db.tb_login.Where(x => x.email == email && x.senha == senha).FirstOrDefault <tb_login>();
if (currentUser != null)
{
long codLogin = currentUser.codLogin;
tb_usuario usuario = db.tb_usuario.Where(y => y.codLogin == codLogin).FirstOrDefault <tb_usuario>();
if (usuario != null)
{
usuario.ativo = false;
db.SaveChanges();
}
}
}
public string AddUser(tb_login login)
{
var data = con.Table <tb_login>();
var d1 = data.Where(x => x.ID_CC == login.ID_CC).FirstOrDefault();
if (d1 == null)
{
con.Insert(login);
return("Sucessfully Added");
}
else
{
return("Already Mail id Exist");
}
}
public string VerificarEmail(tb_login login)
{
string result = "";
var emailBase = db.tb_login.Any(e => e.email == login.email);
if (emailBase == false)
{
result = "liberado";
}
else
{
result = "Login já existe no banco de dados";
}
return(result);
}
public HttpResponseMessage EnviarTokenEmailInativo(string email, string senha)
{
tb_usuario user2 = loginService.RetornaUsuario(email, senha);
tb_login user1 = loginService.Get(user2.codLogin);
string tokenUser = user1.token.Trim();
EnviarTokenEmail(email, tokenUser);
var resp = new HttpResponseMessage()
{
Content = new StringContent("{\"Message\":\"Token foi enviado no email\"}")
};
return(resp);
}
public bool VerificarAtivo(string email, string senha)
{
bool ativo = false;
tb_login login = db.tb_login.Where(s => s.email == email && s.senha == senha).FirstOrDefault <tb_login>();
if (login != null)
{
tb_usuario usuario = db.tb_usuario.Where(k => k.codLogin == login.codLogin).FirstOrDefault <tb_usuario>();
if (usuario != null)
{
ativo = usuario.ativo;
}
}
return(ativo);
}
public ActionResult Create([Bind(Include = "ID,usuario,senha,nv_user")] tb_login tb_login)
{
//Dessa forma que da um console.log no dado requisitado
//Console.WriteLine(tb_login.usuario);
//tb_login.senha = Crypto.HashPassword(tb_login.senha);
//Console.WriteLine(tb_login);
if (ModelState.IsValid)
{
//criptografando
db.tb_login.Add(tb_login);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tb_login));
}
public HttpResponseMessage EsqueciSenha(string email)
{
tb_login login = loginService.EsqueciSenha(email);
if (login == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Email não encontrado"));
}
else
{
string senha = login.senha;
string emailx = login.email;
var resp = EnviarSenhaEmail(emailx, senha);
return(resp);
}
}
