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();
}
}
