private void Button1_Click(object sender, EventArgs e) { applyOrUpdate aou = new applyOrUpdate(); this.Hide(); aou.Show(); }
private void Button2_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=LAPTOP-3CMESOM3;Initial Catalog=DisasterManagement;Integrated Security=True;Pooling=False"); SqlCommand cmd = new SqlCommand("updateDetails", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SSN", Convert.ToInt32(ssnText.Text)); cmd.Parameters.AddWithValue("@FName", fnameText.Text); cmd.Parameters.AddWithValue("@Lname", lnameText.Text); cmd.Parameters.AddWithValue("@Mname", mnameText.Text); cmd.Parameters.AddWithValue("@Address", addressText.Text); cmd.Parameters.AddWithValue("@Phone", Convert.ToInt64(phoneText.Text)); cmd.Parameters.AddWithValue("@D_no", Convert.ToInt32(dnoText.Text)); cmd.Parameters.AddWithValue("@noOfPerson", Convert.ToInt32(noText.Text)); con.Open(); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(" INVALID OPERATION : " + ex); } con.Close(); SqlCommand cmd1 = new SqlCommand("updateLoss", con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@SSN", Convert.ToInt64(ssnText.Text)); cmd1.Parameters.AddWithValue("@RequestedAmount", Convert.ToInt32(amountText.Text)); cmd1.Parameters.AddWithValue("@EstimatedLoss", Convert.ToInt32(estimatedText.Text)); cmd1.Parameters.AddWithValue("@DescAboutLoss", descText.Text); con.Open(); try { cmd1.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(" INVALID OPERATION : " + ex); } con.Close(); MessageBox.Show("UPDATED SUCCESSFULLY"); applyOrUpdate au = new applyOrUpdate(); this.Hide(); au.Show(); }
private void FnameText_TextChanged(object sender, EventArgs e) { SqlConnection con = new SqlConnection("Data Source=LAPTOP-3CMESOM3;Initial Catalog=DisasterManagement;Integrated Security=True;Pooling=False"); SqlCommand cmd; SqlDataReader dr; int ssn; ssn = Convert.ToInt32(ssnText.Text); Boolean a = false; if (true) { con.Open(); String syntax = "SELECT * FROM PERSON"; cmd = new SqlCommand(syntax, con); dr = cmd.ExecuteReader(); while (dr.Read()) { if (ssn == dr.GetInt32(0)) { a = true; break; } else { a = false; } } con.Close(); if (a == false) { MessageBox.Show("SSN DOES NOT EXIST IN DATABASE"); applyOrUpdate aou = new applyOrUpdate(); this.Hide(); aou.Show(); } } }
private void Button1_Click(object sender, EventArgs e) { if (ssnText.Text == "enter 10 digit number") { ssnText.Text = ""; } if (phoneText.Text == "enter 10 digit number") { phoneText.Text = ""; } if (incomeText.Text == "" || propertyText.Text == "" || ssnText.Text == "" || fnameText.Text == "" || lnameText.Text == "" || mnameText.Text == "" || addressText.Text == "" || phoneText.Text == "" || estimatedText.Text == "" || phoneText.Text == "" || dnoText.Text == "" || noText.Text == "" || descText.Text == "") { MessageBox.Show("ALL FIELDS SHOULD BE FILLED"); } else { SqlConnection con = new SqlConnection(@"Data Source=LAPTOP-3CMESOM3;Initial Catalog=DisasterManagement;Integrated Security=True;Pooling=False"); SqlCommand cmd = new SqlCommand("insertion", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SSN", Convert.ToInt32(ssnText.Text)); cmd.Parameters.AddWithValue("@FName", fnameText.Text); cmd.Parameters.AddWithValue("@Lname", lnameText.Text); cmd.Parameters.AddWithValue("@Mname", mnameText.Text); cmd.Parameters.AddWithValue("@Address", addressText.Text); cmd.Parameters.AddWithValue("@Phone", Convert.ToInt64(phoneText.Text)); cmd.Parameters.AddWithValue("@D_no", Convert.ToInt32(dnoText.Text)); cmd.Parameters.AddWithValue("@noOfPerson", Convert.ToInt32(noText.Text)); cmd.Parameters.AddWithValue("@income", Convert.ToInt32(incomeText.Text)); cmd.Parameters.AddWithValue("@property", Convert.ToInt32(propertyText.Text)); con.Open(); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(" INVALID OPERATION : " + ex); } con.Close(); SqlCommand cmd1 = new SqlCommand("insertionLoss", con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@SSN", Convert.ToInt64(ssnText.Text)); cmd1.Parameters.AddWithValue("@RequestedAmount", Convert.ToInt32(amountText.Text)); cmd1.Parameters.AddWithValue("@EstimatedLoss", Convert.ToInt32(estimatedText.Text)); cmd1.Parameters.AddWithValue("@DescAboutLoss", descText.Text); con.Open(); try { cmd1.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(" INVALID OPERATION : " + ex); } con.Close(); MessageBox.Show("SUBMITTED SUCCESSFULLY"); applyOrUpdate au = new applyOrUpdate(); this.Hide(); au.Show(); } }