protected void btnSubmit_Click(object sender, EventArgs e)
{
if ((EmailValidation.IsValidEmail(txtUserName.Text)) && txtPassword.Text !="")
{
con.ConnectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=V_indeed;Integrated Security=True";
string QuantcommandString = "select * from VLogin where User_Email = '" + txtUserName.Text + "'and User_Password='******'and User_Activated =1";
SqlCommand commandselect = new SqlCommand(QuantcommandString, con);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
// commandselect.Parameters.AddWithValue("@User_Activated", '1');
SqlDataReader rdr = commandselect.ExecuteReader();
if (rdr.Read())
{
//WebForm1 form2 = new WebForm1(tempSoldier);
Login logInfo = new Login();
logInfo.User_Email = txtUserName.Text;
logInfo.User_Password = txtPassword.Text;
logInfo.User_Role = rdr["User_Role"].ToString();
Session["user"] = rdr["User_Role"].ToString();
if (rdr["User_Role"].ToString() == "Organization")
{
Response.Redirect("JobPost.aspx");
}
else
{
Response.Redirect("WebForm1.aspx");
}
Response.Redirect("WebForm1.aspx");
}
else
{
lblmessage.Text = " incorrect login or not yet registered or activated";
}
rdr.Close();
con.Close();
}
else {
lblmessage.Text = "incorrect login information";
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
//*******************************************************
/*string to = txtUserName.Text; //To address
* string from = "*****@*****.**"; //From address
* MailMessage message = new MailMessage(from, to);
*
* string mailbody = "In this article you will learn how to send a email using Asp.Net & C#";
* message.Subject = "Sending Email Using Asp.Net & C#";
* message.Body = mailbody;
* message.BodyEncoding = Encoding.UTF8;
* message.IsBodyHtml = true;
* SmtpClient client = new SmtpClient("smtp.gmail.com", 587); //Gmail smtp
* System.Net.NetworkCredential basicCredential1 = new
* System.Net.NetworkCredential("*****@*****.**", "Don'treply");
* client.EnableSsl = true;
* client.UseDefaultCredentials = false;
* client.Credentials = basicCredential1;
* try
* {
* client.Send(message);
* }
*
* catch (Exception ex)
* {
* throw ex;
* }
*/
//**********************************************************************
if (EmailValidation.IsValidEmail(txtUserName.Text))
{
if ((txtPassword.Text != txtPasswordConfirm.Text) || (txtPassword.Text == "") || (txtPasswordConfirm.Text == ""))
{
lblmessage.Text = "The password is not confirm";
return;
}
else
{
con.ConnectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=V_indeed;Integrated Security=True";
// check first if the user does not exist before adding
string QuantcommandString = "select * from VLogin where User_Email = '" + txtUserName.Text + "'";
SqlCommand commandQuant = new SqlCommand(QuantcommandString, con);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlDataReader rdr = commandQuant.ExecuteReader();
if (rdr.Read())
{
lblmessage.Text = "User already exist, please go either to login, reset password or use another email to continue";
}
else
{
//********************************************************************************************
// con.Close();
rdr.Close();
Random randm = new Random();
int rand_Numb = randm.Next(0, 10000000);
string activationCode = txtUserName.Text.Substring(0, 1);
activationCode = activationCode + rand_Numb;
SqlCommand cmd = new SqlCommand("insert into VLogin (User_Email,User_Password,User_Role,Activation_code) values (@User_Email,@User_Password,@User_Role,@Activation_code)", con);
cmd.Parameters.AddWithValue("User_Email", txtUserName.Text);
cmd.Parameters.AddWithValue("User_Password", txtPassword.Text);
cmd.Parameters.AddWithValue("User_Role", ddlRole.SelectedItem.Value);
cmd.Parameters.AddWithValue("Activation_code", activationCode.ToString());
// con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
//send a mail if successful registration is done
if (i != 0)
{
MailMessage mm = new MailMessage();
mm.From = new MailAddress("*****@*****.**");
mm.To.Add(txtUserName.Text);
mm.Subject = "Activation code";
mm.Body = "here your activation code, take it back to the registration page to activate your account: " + activationCode;
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
System.Net.NetworkCredential NetworkCred = new System.Net.NetworkCredential();
NetworkCred.UserName = "******";
NetworkCred.Password = "******";
smtp.UseDefaultCredentials = true;
smtp.Credentials = NetworkCred;
smtp.Port = 587;
try
{
smtp.Send(mm);
}
catch (Exception ex)
{
throw ex;
}
lblmessage.ForeColor = System.Drawing.Color.ForestGreen;
lblmessage.Text = "Please go to your email to access your activation code.";
lblmessage.ForeColor = System.Drawing.Color.ForestGreen;
}
//lblmessage.Text = "The registration was successful";
}
rdr.Close();
con.Close();
}
}
else
{
lblmessage.Text = "Please use a valid email address";
return;
}
}
