protected void btnadd_Click(object sender, EventArgs e) { string password = new SomeFunctionalities().CreateStrongPassword(); cmd = new SqlCommand("insert into tbl_newemp values('" + txtname.Text + "','" + txtphno.Text + "','" + txtdoj.Text + "','" + txtemail.Text + "','" + txtlogin.Text + "','" + password + "')", con); con.Open(); int k = cmd.ExecuteNonQuery(); con.Close(); if (k == 1) { string to = txtemail.Text; string subject = "Account Confirmation Mail"; string message = "Dear Mr./Mrs. " + txtname.Text + "\n" + "\tYour User ID is : " + txtlogin.Text + "\n" + "\tYour Password is : " + password + "\n" + "Please use this information to login into your account."; new SomeFunctionalities().SendEmail(to, subject, message); Response.Write("<script>alert('Employee Details Added. Login info is mailed')</script>"); } else { Response.Write("<script>alert('Error Occured')</script>"); } }
protected void Button1_Click(object sender, EventArgs e) { try { /****** CREATION OF NECCESSARY OBJECTS ********/ if (adapter == null) { adapter = new SqlDataAdapter(); adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; } /**********************************************************/ // generate strings string password = new SomeFunctionalities().CreateStrongPassword(); //string sqlToInsert = "insert into tblSeminarNWorkshop (title,date,time,venue,description,organisedBy) VALUES (@title,@date,@time,@venue,@description,@organisedBy',getdate())"; string sqlToInsert = "insert into tblSeminarNWorkshop (title,wdate,wtime,venue,wdescription,organisedBy,dt) VALUES (@title,@wdate,@wtime,@venue,@wdescription,@organisedBy,getdate())"; // Create command adapter.InsertCommand = new SqlCommand(sqlToInsert, con); // Create parameters adapter.InsertCommand.Parameters.AddWithValue("@title", TextBox1.Text); adapter.InsertCommand.Parameters.AddWithValue("@wdate", TextBox2.Text); adapter.InsertCommand.Parameters.AddWithValue("@wtime", TextBox3.Text); adapter.InsertCommand.Parameters.AddWithValue("@venue", TextBox4.Text); adapter.InsertCommand.Parameters.AddWithValue("@wdescription", TextBox6.Text); adapter.InsertCommand.Parameters.AddWithValue("@organisedBy", TextBox5.Text); // Execute command if (con.State == ConnectionState.Closed) { con.Open(); } int rowsAffected = adapter.InsertCommand.ExecuteNonQuery(); if (con.State == ConnectionState.Open) { con.Close(); } if (rowsAffected != 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Successfully Added.')", true); lblStatus.Text = "Successfully Added."; TextBox1.Text = string.Empty; TextBox2.Text = string.Empty; TextBox3.Text = string.Empty; TextBox4.Text = string.Empty; TextBox5.Text = string.Empty; TextBox6.Text = string.Empty; } } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Error : " + ex.Message + "')", true); lblStatus.Text = "Error : " + ex.Message; } }
protected void btnSendPass_Click(object sender, EventArgs e) { try { /****** CREATION OF NECCESSARY OBJECTS ********/ if (adapter == null) { adapter = new SqlDataAdapter(); adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; } /**********************************************************/ // Create SQL Command string sql = "select COUNT(id) FROM tblStudentRegistration where email = @email"; // Create command adapter.SelectCommand = new SqlCommand(sql, con); // Create parameter adapter.SelectCommand.Parameters.AddWithValue("@email", txtEmail.Text); // Execute command if (con.State == ConnectionState.Closed) { con.Open(); } adapter.SelectCommand.ExecuteScalar(); if (con.State == ConnectionState.Open) { con.Close(); } dataSet = new DataSet(); adapter.Fill(dataSet, "tblStudentRegistration"); string temp = dataSet.Tables["tblStudentRegistration"].Rows[0][0].ToString(); int count = dataSet.Tables["tblStudentRegistration"].Rows.Count; if (count == 1 && temp == "1") { adapter = null; dataSet = null; string newPassword = new SomeFunctionalities().CreateStrongPassword(); /****** CREATION OF NECCESSARY OBJECTS ********/ if (adapter == null) { adapter = new SqlDataAdapter(); adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; } SqlDataAdapter adapter2 = new SqlDataAdapter(); adapter2.MissingSchemaAction = MissingSchemaAction.AddWithKey; dataSet = new DataSet(); /**********************************************************/ // Create SQL Command string sqltoUpdatePassword = "******"; string sqltoFetchDetails = "select firstName, lastName FROM tblStudentRegistration WHERE email = @email"; // Create command adapter.UpdateCommand = new SqlCommand(sqltoUpdatePassword, con); adapter2.SelectCommand = new SqlCommand(sqltoFetchDetails, con); // Create parameter adapter.UpdateCommand.Parameters.AddWithValue("@pass", newPassword); adapter.UpdateCommand.Parameters.AddWithValue("@email", txtEmail.Text); adapter2.SelectCommand.Parameters.AddWithValue("@email", txtEmail.Text); // Execute command if (con.State == ConnectionState.Closed) { con.Open(); } int rowsAffected = adapter.UpdateCommand.ExecuteNonQuery(); adapter2.SelectCommand.ExecuteScalar(); if (con.State == ConnectionState.Open) { con.Close(); } if (rowsAffected != 0) { adapter2.Fill(dataSet, "tblStudentRegistration"); DataTable table = dataSet.Tables[0]; DataRow row = table.Rows[0]; string firstName = row[0].ToString(); string lastName = row[1].ToString(); string to = txtEmail.Text; string subject = "Password changed successfully"; string body = "Mr./Mrs. " + firstName + " " + lastName + ",\n" + "\tYour password is successfully changed. Your new login details are :\n" + "Email : " + txtEmail.Text + "\n" + "Password : "******"Password successfully reset. To know new password check your mail"; lblStatus.ForeColor = System.Drawing.Color.Green; txtEmail.Text = string.Empty; } } else { lblStatus.Text = "This email id is not registered with us."; lblStatus.ForeColor = System.Drawing.Color.Red; txtEmail.Focus(); } } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('" + ex.Message + "')", true); } }
protected void Button1_Click(object sender, EventArgs e) { var IsValidCaptcha = CaptchaValidate(); string val = ""; try { IsValidCaptcha.TryGetValue(true, out val); if (val == null) { lblCaptchaResult.Text = "Provided security code is not valid plese try again...."; lblCaptchaResult.ForeColor = System.Drawing.Color.Red; return; } } catch (Exception ex) { lblCaptchaResult.Text = "Provided security code is not valid plese try again...."; lblCaptchaResult.BackColor = System.Drawing.Color.Red; return; } if (Label17.Text == "Username is Available.") { string password = new SomeFunctionalities().CreateStrongPassword(); string email = TextBox4.Text; string gender = ddlGender.Text; da = new SqlDataAdapter("insert into tbl_login(uname,password,securitycode,status,cdate)values('" + TextBox9.Text + "','" + password + "','" + TextBox11.Text + "','Activate',getdate())", con); da.SelectCommand.ExecuteNonQuery(); int uid = GetUid(TextBox9.Text); if (uid > 0) { da = new SqlDataAdapter("insert into tbl_contact(uid,fname,lname,gender,email,city,state,country,mobileno,cdate)values(" + uid + ",'" + TextBox1.Text + "','" + TextBox2.Text + "','" + gender + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "',getdate())", con); int n = da.SelectCommand.ExecuteNonQuery(); // int k = da.ExecuteNonQuery(); if (n == 1) { /*********** SEND MAIL *************/ string subject = "Account Confirmation Mail"; string message = "Dear Mr./Mrs. " + TextBox1.Text + " " + TextBox2.Text + "\n" + "\tYour User ID is : " + TextBox9.Text + "\n" + "\tYour Password is : " + password + "\n" + "Please use this information to login into your account."; new SomeFunctionalities().SendEmail(email, subject, message); /************************************/ //Response.Write("<script>alert('User Details Added')</script>"); //System.Web.HttpContext.Current.Response.Write("<SCRIPT LANGUAGE='JavaScript'>alert(' You have successfully registered.\n Your User ID ')</SCRIPT>"); Response.Redirect("~/Userlogin.aspx"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('You have successfully registered. Your User ID and Password is send to your email address')", true); } } } else { Label1.Text = "The Username is already taken.Choose another Name."; Label1.BackColor = System.Drawing.Color.Red; } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (lblDuplicateEmail.Text != "This email id is already registered with us.") { try { /****** CREATION OF NECCESSARY OBJECTS ********/ if (adapter == null) { adapter = new SqlDataAdapter(); adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; } /**********************************************************/ // generate strings string password = new SomeFunctionalities().CreateStrongPassword(); string sqlToInsert = "insert into tblFacultyRegistration (firstName,lastName,email,pass,mobileNumber,joiningYear,department,doorNStreet,rlyStation,po,postalCode,district,state,status,dt) VALUES (@firstName,@lastName,@email,@pass,@mobileNumber,@joiningYear,@department,@doorNStreet,@rlyStation,@po,@postalCode,@district,@state,'Deactivated',getdate())"; // Create command adapter.InsertCommand = new SqlCommand(sqlToInsert, con); // Create parameters adapter.InsertCommand.Parameters.AddWithValue("@firstName", TextBoxFirstName.Text); adapter.InsertCommand.Parameters.AddWithValue("@lastName", TextBoxLastName.Text); adapter.InsertCommand.Parameters.AddWithValue("@email", TextBoxEmail.Text); adapter.InsertCommand.Parameters.AddWithValue("@pass", password); adapter.InsertCommand.Parameters.AddWithValue("@mobileNumber", TextBoxMobile.Text); adapter.InsertCommand.Parameters.AddWithValue("@joiningYear", DropDownListYear.Text); adapter.InsertCommand.Parameters.AddWithValue("@department", TextBoxDepartment.Text); adapter.InsertCommand.Parameters.AddWithValue("@doorNStreet", TextBoxDoorNStreet.Text); adapter.InsertCommand.Parameters.AddWithValue("@rlyStation", TextBoxRlyStation.Text); adapter.InsertCommand.Parameters.AddWithValue("@po", TextBoxPO.Text); adapter.InsertCommand.Parameters.AddWithValue("@postalCode", TextBoxPostalCode.Text); adapter.InsertCommand.Parameters.AddWithValue("@district", TextBoxDistrict.Text); adapter.InsertCommand.Parameters.AddWithValue("@state", TextBoxState.Text); // Execute command if (con.State == ConnectionState.Closed) { con.Open(); } int rowsAffected = adapter.InsertCommand.ExecuteNonQuery(); if (con.State == ConnectionState.Open) { con.Close(); } /************ SEND USER ID AND PASSWORD TO THE PROVIDED MAIL ADDRESS *********/ //if (rowsAffected != 0) //{ // string subject = "Account Confirmation Mail"; // string message = "Dear Mr./Mrs. " + TextBoxFirstName.Text + " " + TextBoxLastName.Text + "\n" // + "\tYour User ID is : " + TextBoxEmail.Text + "\n" // + "\tYour Password is : " + password + "\n" + // "Please use this information to login into your account."; // //new SomeFunctionalities().SendEmail(TextBoxEmail.Text, subject, message); //} /************************************************************************************/ //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('You have successfully registered. Your User ID and Password will be shortly send to your email address after approval from admin')", true); lblStatus.Text = "You have successfully registered. Your User ID and Password will be shortly send to your email address after approval from admin"; lblStatus.ForeColor = System.Drawing.Color.Green; TextBoxFirstName.Text = string.Empty; TextBoxLastName.Text = string.Empty; TextBoxEmail.Text = string.Empty; TextBoxMobile.Text = string.Empty; //TextBoxye.Text = string.Empty; DropDownListYear.SelectedIndex = 0; TextBoxDepartment.Text = string.Empty; TextBoxDoorNStreet.Text = string.Empty; TextBoxRlyStation.Text = string.Empty; TextBoxPO.Text = string.Empty; TextBoxPostalCode.Text = string.Empty; TextBoxDistrict.Text = string.Empty; TextBoxState.Text = string.Empty; } catch (Exception ex) { //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('" + ex.Message + "')", true); lblStatus.Text = "Error : " + ex.Message; lblStatus.ForeColor = System.Drawing.Color.Red; } } else { lblStatus.Text = "Please use a different email address."; lblStatus.ForeColor = System.Drawing.Color.Red; TextBoxEmail.Focus(); } }