//Inserting registration data of user!!!
SqlConnection con = newSqlConnection(ConfigurationManager.ConnectionStrings["RegConnectionString"].ConnectionString);
string inscmd = "Insert into Registration(Username, Password,EmailAddress,FullName,CNIC,city) Values(@UserName, @Password, @EmailAddress, @FullName, @CNIC, @City)";
SqlCommand InsertUser = new SqlCommand(inscmd, con);
InsertUser.Parameters.AddWithValue("@UserName", TextBoxUN.Text);
InsertUser.Parameters.AddWithValue("@Password", TextBoxPass.Text);
InsertUser.Parameters.AddWithValue("@EmailAddress", TextBoxEA.Text);
InsertUser.Parameters.AddWithValue("@FullName", TextBoxFN.Text);
InsertUser.Parameters.AddWithValue("@CNIC", TextBoxCNIC.Text);
InsertUser.Parameters.AddWithValue("@City", DropDownListCity.SelectedItem.ToString());
try
{
con.Open();
//Response.Write("Trying ...");
InsertUser.ExecuteNonQuery();
con.Close();
}
catch(SqlException ex)
{
Response.Write(ex.Message);
Response.Write("Failed!!! ...");
Response.Write("<b>Something really bad happened .. try again later</b>");
}
//send mail message after user fills registration form
try
{
MailMessage msg = newMailMessage();
msg.From = newMailAddress("pankaj.ics@gmail.com");
msg.To.Add(TextBoxEA.Text);
msg.Subject = "Your Registration is confirmed! ";
msg.Body = "Dear " + TextBoxFN.Text + " Your Registration to motion voter system has been confirmed. .. Kindly note down your Voter's Identity Number(VIN) required for your login";
SmtpClient Sc = newSmtpClient("smtp.gmail.com");
Sc.Port = 587;
Sc.Credentials = newNetworkCredential("pankaj.ics@gmail.com","password");
Sc.EnableSsl = true;
Sc.Send(msg);
Response.Write("Sent!!! ... ");
Response.Redirect("Login.aspx");
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
No comments:
Post a Comment