protected void lnkAlterarSenha_Click(object sender, EventArgs e)
{
try
{
DataKartDataContext dk = new DataKartDataContext();
Usuario u = (from p in dk.Usuarios
where p.idUsuario == Convert.ToInt16(IdUsuario.Value)
select p).FirstOrDefault();
if (u != null)
{
if (u.Senha.Trim() != txtSenhaAntiga.Text.Trim())
{
Alert("A senha antiga não confere!");
return;
}
if (txtSenhaNova1.Text.Trim() != txtSenhaNova2.Text.Trim())
{
Alert("A senhas novas não confere!");
return;
}
u.Senha = txtSenhaNova1.Text.Trim();
dk.SubmitChanges(ConflictMode.FailOnFirstConflict);
txtSenhaAntiga.Text = "";
txtSenhaNova1.Text = "";
txtSenhaNova2.Text = "";
phpbb_user userbb = (from f in dk.phpbb_users
where f.user_email == u.Email ||
f.username == u.Email
select f).FirstOrDefault();
if (userbb != null)
{
userbb.user_password = EncryptMd5(u.Senha);
userbb.user_email_hash = EncryptCrc32(u.Email + u.Email.Length.ToString());
dk.SubmitChanges();
}
Alert("Senha alterada com sucesso!");
}
else
{
Alert("Erro para alterar a senha!\nTente mais tarde!");
}
}
catch (Exception ex)
{
Alert(ex);
}
}
private void UpdateUserForumPHP()
{
DataKartDataContext dk = new DataKartDataContext();
try
{
Usuario[] us = (from p in dk.Usuarios
where p.Ativo == true
select p).ToArray();
foreach (Usuario u in us)
{
//Verificar se exsite no forum
bool exiteForum = (from f in dk.phpbb_users
where f.user_email == u.Email ||
f.username == u.Email
select f).Count() > 0;
if (exiteForum == false)
{
//Efetuar o cadastro no Forum
phpbb_user phpu = new phpbb_user()
{
user_type = 1,
group_id = 2,
user_permissions = "",
user_perm_from = 0,
user_ip = "",
user_regdate = 1396623164,
username = "",
username_clean = "",
user_password = EncryptMd5(u.Senha),
user_passchg = 1396623164,
user_pass_convert = 0,
user_email = "",
user_email_hash = EncryptCrc32(u.Email + u.Email.Length.ToString()),
user_birthday = "",
user_lastvisit = 0,
user_lastmark = 1396623164,
user_lastpost_time = 0,
user_lastpage = "",
user_last_confirm_key = "",
user_last_search = 0,
user_warnings = 0,
user_last_warning = 0,
user_login_attempts = 0,
user_inactive_reason = 1,
user_inactive_time = 1396623164,
user_posts = 0,
user_lang = "pt_br",
user_timezone = -3,
user_dst = 1,
user_dateformat = "D M d, Y h:i",
user_style = 2,
user_rank = 0,
user_colour = "",
user_new_privmsg = 0,
user_unread_privmsg = 0,
user_last_privmsg = 0,
user_message_rules = 0,
user_full_folder = -3,
user_emailtime = 0,
user_topic_show_days = 0,
user_topic_sortby_type = "t",
user_topic_sortby_dir = "d",
user_post_show_days = 0,
user_post_sortby_type = "t",
user_post_sortby_dir = "a",
user_notify = 0,
user_notify_pm = 1,
user_notify_type = 0,
user_allow_pm = 1,
user_allow_viewonline = 1,
user_allow_viewemail = 1,
user_allow_massemail = 1,
user_options = 230271,
user_avatar = "",
user_avatar_type = 0,
user_avatar_width = 0,
user_avatar_height = 0,
user_sig = "",
user_sig_bbcode_uid = "",
user_sig_bbcode_bitfield = "",
user_from = "",
user_icq = "",
user_aim = "",
user_yim = "",
user_msnm = "",
user_jabber = "",
user_website = "",
user_occ = "",
user_interests = "",
user_actkey = Tools.UniqueKey.GetUniqueKey(8), //"8XC9FRJ9",
user_newpasswd = "",
user_form_salt = Tools.UniqueKey.GetUniqueKey(16, false, false), //"52567f871eccdc80",
user_new = 1,
user_reminded = 0,
user_reminded_time = 0
};
phpu.username = u.Email;
phpu.username_clean = u.Email;
phpu.user_email = u.Email;
phpu.user_password = EncryptMd5(u.Senha);
dk.phpbb_users.InsertOnSubmit(phpu);
dk.SubmitChanges();
dk.phpbb_user_groups.InsertOnSubmit(new phpbb_user_group()
{
user_id = phpu.user_id, group_id = 2, group_leader = 0, user_pending = 0
});
dk.SubmitChanges();
dk.phpbb_user_groups.InsertOnSubmit(new phpbb_user_group()
{
user_id = phpu.user_id, group_id = 7, group_leader = 0, user_pending = 0
});
dk.SubmitChanges();
}
}
}
finally
{
if (dk != null)
{
dk.Dispose();
}
}
}
protected void btnCadastrar_Click(object sender, EventArgs e)
{
string s = "";
string msg = "";
string mail = txtMail.Text;
int idGrupo = Convert.ToInt32(ViewState["id"].ToString());
if (string.IsNullOrEmpty(mail))
{
Alert("O Campo e-mail é obrigatório.");
return;
}
if (mail.IndexOf("@") < 0 || mail.IndexOf(".") < 0)
{
Alert("O e-mail é inválido.");
return;
}
if (this.Session["CaptchaImageText"] != null)
{
s = this.Session["CaptchaImageText"].ToString();
}
else if (this.ViewState["CaptchaImageText"] != null)
{
s = this.ViewState["CaptchaImageText"].ToString();
}
if ((txtCaptcha.Text != s && !string.IsNullOrEmpty(s)) || string.IsNullOrEmpty(txtCaptcha.Text))
{
Alert("O valor da captcha não confere.");
return;
}
DataKartDataContext dk = new DataKartDataContext();
//Verificar se já existe cadastro um usuario com este e-mail.
Usuario usr = (from k in dk.Usuarios
where k.Email == mail
select k).FirstOrDefault();
bool ExistUser = true;
if (usr == null)
{
ExistUser = false;
string Apelido = mail.Substring(0, mail.IndexOf('@'));
if (Apelido.Length >= 29)
{
Apelido.Substring(0, 29);
}
usr = new Usuario();
usr.Nome = mail;
usr.Email = mail;
usr.Apelido = Apelido;
usr.Senha = GerarSenhaAleatorio();
usr.MostarInfo = true;
usr.Ativo = false;
usr.dtCriacao = DateTime.Now;
dk.GetTable <Usuario>().InsertOnSubmit(usr);
dk.SubmitChanges(ConflictMode.FailOnFirstConflict);
msg += "Usuário cadastrado com sucesso!\n";
try
{
//Efetuar o cadastro no Forum
phpbb_user phpu = new phpbb_user()
{
user_type = 1,
group_id = 2,
user_permissions = "",
user_perm_from = 0,
user_ip = "",
user_regdate = 1396623164,
username = "",
username_clean = "",
user_password = EncryptMd5("123qwe"),
user_passchg = 1396623164,
user_pass_convert = 0,
user_email = "",
user_email_hash = EncryptCrc32(usr.Email + usr.Email.Length.ToString()),
user_birthday = "",
user_lastvisit = 0,
user_lastmark = 1396623164,
user_lastpost_time = 0,
user_lastpage = "",
user_last_confirm_key = "",
user_last_search = 0,
user_warnings = 0,
user_last_warning = 0,
user_login_attempts = 0,
user_inactive_reason = 1,
user_inactive_time = 1396623164,
user_posts = 0,
user_lang = "pt_br",
user_timezone = -3,
user_dst = 1,
user_dateformat = "D M d, Y h:i",
user_style = 2,
user_rank = 0,
user_colour = "",
user_new_privmsg = 0,
user_unread_privmsg = 0,
user_last_privmsg = 0,
user_message_rules = 0,
user_full_folder = -3,
user_emailtime = 0,
user_topic_show_days = 0,
user_topic_sortby_type = "t",
user_topic_sortby_dir = "d",
user_post_show_days = 0,
user_post_sortby_type = "t",
user_post_sortby_dir = "a",
user_notify = 0,
user_notify_pm = 1,
user_notify_type = 0,
user_allow_pm = 1,
user_allow_viewonline = 1,
user_allow_viewemail = 1,
user_allow_massemail = 1,
user_options = 230271,
user_avatar = "",
user_avatar_type = 0,
user_avatar_width = 0,
user_avatar_height = 0,
user_sig = "",
user_sig_bbcode_uid = "",
user_sig_bbcode_bitfield = "",
user_from = "",
user_icq = "",
user_aim = "",
user_yim = "",
user_msnm = "",
user_jabber = "",
user_website = "",
user_occ = "",
user_interests = "",
user_actkey = "8XC9FRJ9",
user_newpasswd = "",
user_form_salt = "52567f871eccdc80",
user_new = 1,
user_reminded = 0,
user_reminded_time = 0
};
phpu.username = mail;
phpu.username_clean = mail;
phpu.user_email = mail;
dk.phpbb_users.InsertOnSubmit(phpu);
dk.SubmitChanges();
dk.phpbb_user_groups.InsertOnSubmit(new phpbb_user_group()
{
user_id = phpu.user_id, group_id = 2, group_leader = 0, user_pending = 0
});
dk.SubmitChanges();
dk.phpbb_user_groups.InsertOnSubmit(new phpbb_user_group()
{
user_id = phpu.user_id, group_id = 7, group_leader = 0, user_pending = 0
});
dk.SubmitChanges();
ScriptManager.RegisterStartupScript(this, this.GetType(), "AddPHP", " $(document).ready(function() {$.ajax({ type: 'post', data: 'password="******"&email=" + usr.Email.Trim() + "', url: 'http://forum.afonsoft.com.br/UserAddScript.php', success: function (retorno) { $('#" + HiddenFieldReturnAjax.ClientID + "').value = retorno; } }); }); ", true);
}
catch
{
//Ignore o PHP Forum
}
}
else
{
msg += "Este e-mail já existe na nossa base de dados!\n";
}
if (idGrupo > 0)
{
bool exist = (from g in dk.Kart_Usuario_Grupos
where g.idGrupo == idGrupo &&
g.idUsuario == usr.idUsuario
select g).Count() > 0;
if (!exist)
{
Kart_Usuario_Grupo kug = new Kart_Usuario_Grupo();
kug.Admin = false;
kug.Aprovado = true;
kug.idGrupo = idGrupo;
kug.idUsuario = usr.idUsuario;
kug.dtCriacao = DateTime.Now;
dk.GetTable <Kart_Usuario_Grupo>().InsertOnSubmit(kug);
dk.SubmitChanges(ConflictMode.FailOnFirstConflict);
msg += "Usuário associado ao grupo com sucesso!\n";
}
else
{
msg += "Este e-mail já está associado a este grupo!\n";
}
}
if (!ExistUser)
{
EMail.EnviarEmailBemvido(usr, idGrupo);
Alert("Atenção!\n\n" + msg, null, "index.aspx");
}
else
{
Alert("Atenção!\n\n" + msg);
}
}
protected void btnAtualizar_Click(object sender, EventArgs e)
{
try
{
DataKartDataContext dk = new DataKartDataContext();
Usuario u = (from p in dk.Usuarios
where p.idUsuario == Convert.ToInt16(IdUsuario.Value)
select p).FirstOrDefault();
if (u != null)
{
u.Nome = txtNome.Text;
//u.Email= txtEmail.Text;
u.Apelido = txtApelido.Text;
if (!string.IsNullOrEmpty(txtPeso.Text))
{
u.Peso = Convert.ToDecimal(txtPeso.Text);
}
if (!string.IsNullOrEmpty(txtAltura.Text))
{
u.Altura = Convert.ToDecimal(txtAltura.Text);
}
if (!string.IsNullOrEmpty(txtDtNascimento.Text))
{
u.DtNascimento = Convert.ToDateTime(txtDtNascimento.Text);
}
u.Telefone = txtTelefone.Text;
u.Celular = txtCelular.Text;
u.Endereco = txtEndereco.Text;
u.Cidade = txtCidade.Text;
u.Estado = ddlEstado.SelectedValue;
u.Sexo = Convert.ToChar(ddlSexo.SelectedValue);
u.Perfil_Facebook = txtPerfilFacebook.Text;
u.Perfil_Plus = txtPerfilPlus.Text;
u.Perfil_Twitter = txtPerfilTwitter.Text;
u.Obs = txtObs.Text;
u.MostarInfo = true;
u.Ativo = true;
dk.SubmitChanges(ConflictMode.FailOnFirstConflict);
if (UsuarioLogado.idUsuario == u.idUsuario)
{
Session["Usuario"] = u;
}
try {
//Verificar se exsite no forum
bool exiteForum = (from f in dk.phpbb_users
where f.user_email == u.Email ||
f.username == u.Email
select f).Count() > 0;
if (exiteForum == false)
{
//Efetuar o cadastro no Forum
phpbb_user phpu = new phpbb_user()
{
user_type = 1,
group_id = 2,
user_permissions = "",
user_perm_from = 0,
user_ip = "",
user_regdate = 1396623164,
username = "",
username_clean = "",
user_password = EncryptMd5(u.Senha),
user_passchg = 1396623164,
user_pass_convert = 0,
user_email = "",
user_email_hash = EncryptCrc32(u.Email + u.Email.Length.ToString()),
user_birthday = "",
user_lastvisit = 0,
user_lastmark = 1396623164,
user_lastpost_time = 0,
user_lastpage = "",
user_last_confirm_key = "",
user_last_search = 0,
user_warnings = 0,
user_last_warning = 0,
user_login_attempts = 0,
user_inactive_reason = 1,
user_inactive_time = 1396623164,
user_posts = 0,
user_lang = "pt_br",
user_timezone = -3,
user_dst = 1,
user_dateformat = "D M d, Y h:i",
user_style = 2,
user_rank = 0,
user_colour = "",
user_new_privmsg = 0,
user_unread_privmsg = 0,
user_last_privmsg = 0,
user_message_rules = 0,
user_full_folder = -3,
user_emailtime = 0,
user_topic_show_days = 0,
user_topic_sortby_type = "t",
user_topic_sortby_dir = "d",
user_post_show_days = 0,
user_post_sortby_type = "t",
user_post_sortby_dir = "a",
user_notify = 0,
user_notify_pm = 1,
user_notify_type = 0,
user_allow_pm = 1,
user_allow_viewonline = 1,
user_allow_viewemail = 1,
user_allow_massemail = 1,
user_options = 230271,
user_avatar = "",
user_avatar_type = 0,
user_avatar_width = 0,
user_avatar_height = 0,
user_sig = "",
user_sig_bbcode_uid = "",
user_sig_bbcode_bitfield = "",
user_from = "",
user_icq = "",
user_aim = "",
user_yim = "",
user_msnm = "",
user_jabber = "",
user_website = "",
user_occ = "",
user_interests = "",
user_actkey = Tools.UniqueKey.GetUniqueKey(8), //"8XC9FRJ9",
user_newpasswd = "",
user_form_salt = Tools.UniqueKey.GetUniqueKey(16, false, false), //"52567f871eccdc80",
user_new = 1,
user_reminded = 0,
user_reminded_time = 0
};
phpu.username = u.Email;
phpu.username_clean = u.Email;
phpu.user_email = u.Email;
phpu.user_password = EncryptMd5(u.Senha);
dk.phpbb_users.InsertOnSubmit(phpu);
dk.SubmitChanges();
dk.phpbb_user_groups.InsertOnSubmit(new phpbb_user_group()
{
user_id = phpu.user_id, group_id = 2, group_leader = 0, user_pending = 0
});
dk.SubmitChanges();
dk.phpbb_user_groups.InsertOnSubmit(new phpbb_user_group()
{
user_id = phpu.user_id, group_id = 7, group_leader = 0, user_pending = 0
});
dk.SubmitChanges();
}
}
catch
{
//Igonore erro do php
}
Alert("Perfil atualizado com sucesso!", null, "/Administrador/home.aspx");
}
else
{
throw new Exception("Usuario não localizado na base!");
}
}
catch (Exception ex)
{
Alert(ex);
}
}
