Timing limit in Activation mail in User registration

Question

I have done activation link for user registration.. it works fine..

i need to add timing for that particular link.

eg: Aft 20 mins, the link should be deactivated and the values inserted while registration also be deleted

if the user doesn't activated his account within that particular time...

 

 

protected void Button1_Click(object sender, EventArgs e)

{

int userId = 0;

string constr = ConfigurationManager.ConnectionStrings["mlaConnectionString"].ConnectionString;

using (SqlConnection con = new SqlConnection(constr))

{

using (SqlCommand cmd = new SqlCommand("Insert_User"))

{

using (SqlDataAdapter sda = new SqlDataAdapter())

{

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@username", txtusername.Text.Trim());

cmd.Parameters.AddWithValue("@password", txtpassword.Text.Trim());

cmd.Parameters.AddWithValue("@email", txtemailid.Text.Trim());

cmd.Connection = con;

con.Open();

userId = Convert.ToInt32(cmd.ExecuteScalar());

con.Close();

}

}

string message = string.Empty;

switch (userId)

{

case -1:

message = "Username already exists.\\nPlease choose a different username.";

break;

case -2:

message = "Supplied email address has already been used.";

break;

default:

message = "Registration successful.\\nUser Id: " + userId.ToString();

SendActivationEmail(userId);

break;

}

ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + message + "');", true);

}

}

private void SendActivationEmail(int userId)

{

string constr = ConfigurationManager.ConnectionStrings["mlaConnectionString"].ConnectionString;

string activationCode = Guid.NewGuid().ToString();

using (SqlConnection con = new SqlConnection(constr))

{

using (SqlCommand cmd = new SqlCommand("INSERT INTO UserActivation VALUES(@UserId, @ActivationCode)"))

{

using (SqlDataAdapter sda = new SqlDataAdapter())

{

cmd.CommandType = CommandType.Text;

cmd.Parameters.AddWithValue("@UserId", userId);

cmd.Parameters.AddWithValue("@ActivationCode", activationCode);

cmd.Connection = con;

con.Open();

cmd.ExecuteNonQuery();

con.Close();

}

}

}

using (MailMessage mm = new MailMessage("[email protected]", txtemailid.Text))

{

mm.Subject = "Account Activation";

string body = "Hello " + txtusername.Text.Trim() + ",";

body += "<br /><br />Please click the following link to activate your account";

body += "<br /><a href = '" + Request.Url.AbsoluteUri.Replace("registration.aspx", "activation.aspx?ActivationCode=" + activationCode) + "'>Click here to activate your account.</a>";

body += "<br /><br />Thanks";

mm.Body = body;

mm.IsBodyHtml = true;

SmtpClient smtp = new SmtpClient();

smtp.Host = "smtp.gmail.com";

smtp.EnableSsl = true;

NetworkCredential NetworkCred = new NetworkCredential("[email protected]", "********");

smtp.UseDefaultCredentials = true;

smtp.Credentials = NetworkCred;

smtp.Port = 587;

smtp.Send(mm);

}

}

 

 

what are all the modification i have to do in this coding.... 

 

thanks in advance