Hello All, We are going to start new batch from next week. message/call or mail us for more details.

6 July 2012

Data inserted in database and send it in mail to user after user has registered


//Inserting registration data of user!!!
SqlConnection con = new SqlConnection(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 = new MailMessage();
    msg.From = new MailAddress("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 = new SmtpClient("smtp.gmail.com");
    Sc.Port = 587;
    Sc.Credentials = new NetworkCredential("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