private void button1_Click(object sender, EventArgs e) { con.Open(); String s = "select count(*) from aadhaar where UID='" + uidtextbox.Text + "';"; cmd = new SqlCommand(s, con); dr1 = cmd.ExecuteReader(); dr1.Read(); if (dr1[0].Equals(1)) { dr1.Close(); String syn = "select password from aadhaar where UID='" + uidtextbox.Text + "';"; cmd1 = new SqlCommand(syn, con); dr2 = cmd1.ExecuteReader(); dr2.Read(); String UIDpass = dr2[0].ToString(); String pass = passwordtextbox.Text; dr2.Close(); if (pass.Equals(UIDpass)) { String str = "select count(*) from Eligible_For where UID='" + uidtextbox.Text + "';"; cmd2 = new SqlCommand(str, con); dr3 = cmd2.ExecuteReader(); dr3.Read(); String i = dr3[0].ToString(); int j = Convert.ToInt32(i); dr3.Close(); if (j > 0) { Eligible obe = new Eligible(uidtextbox.Text); this.Hide(); obe.Show(); } else { Services observ = new Services(uidtextbox.Text.ToString()); this.Hide(); observ.Show(); } } else { // don't login MessageBox.Show("Log In Failed.Invalid Credentials!"); } } else { // don't login MessageBox.Show("Log In Failed.Invalid Credentials!"); } con.Close(); }
private void button1_Click(object sender, EventArgs e) { try { con.Open(); String s = "select count(*) from Eligible_for where UID='" + UID + "';"; c = new SqlCommand(s, con); dr4 = c.ExecuteReader(); dr4.Read(); if (dr4[0].Equals(0)) { dr4.Close(); comnd = new SqlCommand("SELECT DOB,Annual_Income,Occupation from PAN where UID =@UID; ", con); comnd.Parameters.AddWithValue("@UID", UID); dr1 = comnd.ExecuteReader(); dr1.Read(); String AnnualIncome = dr1[1].ToString(); String Occupation = dr1[2].ToString(); int income = Int32.Parse(AnnualIncome); String DOB = dr1[0].ToString(); DateTime newDate = Convert.ToDateTime(DOB); int age = CalculateAge(newDate); dr1.Close(); cmd2 = new SqlCommand("SELECT Gender from Aadhaar where UID =@UID; ", con); cmd2.Parameters.AddWithValue("@UID", UID); dr3 = cmd2.ExecuteReader(); dr3.Read(); String gender = dr3[0].ToString(); dr3.Close(); String code = "0000"; StringBuilder sb = new StringBuilder(code); if (income < 500000) { sb[0] = '1'; } else { sb[0] = '2'; } if (age <= 18) { sb[1] = '1'; } else { sb[1] = '2'; } switch (Occupation) { case "Student": sb[2] = '1'; break; case "Business": sb[2] = '2'; break; case "Housewife": sb[2] = '3'; break; case "Entrepreneur": sb[2] = '4'; break; case "Agriculture": sb[2] = '5'; break; case "Employed": sb[2] = '6'; break; case "Unemployed": sb[2] = '7'; break; case "Retired": sb[2] = '8'; break; } if (gender.Equals("Male")) { sb[3] = '1'; } else { sb[3] = '2'; } if (sb[1] == '2') { c1 = new SqlCommand("Insert into ELIGIBLE_FOR values('" + UID + "','10521');", con); c1.ExecuteNonQuery(); c2 = new SqlCommand("Insert into ELIGIBLE_FOR values('" + UID + "','10591');", con); c2.ExecuteNonQuery(); } if (sb[0] == '1' && sb[1] == '2') { c3 = new SqlCommand("Insert into ELIGIBLE_FOR values('" + UID + "','10531');", con); c3.ExecuteNonQuery(); c4 = new SqlCommand("Insert into ELIGIBLE_FOR values('" + UID + "','10551');", con); c4.ExecuteNonQuery(); } if (sb[1] == '1' && sb[3] == '2') { c5 = new SqlCommand("Insert into ELIGIBLE_FOR values('" + UID + "','10541');", con); c5.ExecuteNonQuery(); c6 = new SqlCommand("Insert into ELIGIBLE_FOR values('" + UID + "','10611');", con); c6.ExecuteNonQuery(); } if (sb[2] == '5') { c7 = new SqlCommand("Insert into ELIGIBLE_FOR values('" + UID + "','10561');", con); c7.ExecuteNonQuery(); c8 = new SqlCommand("Insert into ELIGIBLE_FOR values('" + UID + "','10581');", con); c8.ExecuteNonQuery(); } if (sb[2] == '4') { c9 = new SqlCommand("Insert into ELIGIBLE_FOR values('" + UID + "','10571');", con); c9.ExecuteNonQuery(); } if (sb[0] == '1' && sb[2] == '1') { c10 = new SqlCommand("Insert into ELIGIBLE_FOR values('" + UID + "','10621');", con); c10.ExecuteNonQuery(); } if (sb[1] == '1' && sb[2] == '1') { c11 = new SqlCommand("Insert into ELIGIBLE_FOR values('" + UID + "','10631');", con); c11.ExecuteNonQuery(); } } Eligible obj5 = new Eligible(UID); this.Hide(); obj5.Show(); } catch (System.Exception excp) { MessageBox.Show("Error is :" + excp); con.Close(); } }