TextBox11

58   public void Button1_Click(System.Object sender, System.EventArgs e)
59   {
60    int a = default(int);
61    decimal b = new decimal();
62
63    if (Information.IsNumeric(TextBox3.Text))
64    {
65     if (int.Parse(TextBox3.Text) <= 20 )
66     {
67      a = (int) ((double.Parse(TextBox3.Text) * 100) / 20);
68      TextBox4.Text = a.ToString();
69      b = (decimal) (a * 0.1);
70      TextBox5.Text = b.ToString();
71     }
72     else
73     {
74      MessageBox.Show("Please Enter value equal to 20 and below!");
75     }
76    }
77    if (Information.IsNumeric(TextBox6.Text))
78    {
79
80     if (int.Parse(TextBox6.Text) <= 50 )
81     {
82      int c = default(int);
83      decimal d = new decimal();
84      c = (int) ((double.Parse(TextBox6.Text) * 100) / 50);
85      TextBox7.Text = c.ToString();
86      d = (decimal) (c * 0.1);
87      TextBox8.Text = d.ToString();
88
89     }
90     else
91     {
92      MessageBox.Show("Please Enter value equal to 50 and below!");
93
94
95     }
96    }
97
98    if (Information.IsNumeric(TextBox9.Text))
99    {
100     if (int.Parse(TextBox9.Text) <= 50 )
101     {
102      int g = default(int);
103      decimal f = new decimal();
104      g = (int) ((double.Parse(TextBox9.Text) * 100) / 50);
105      TextBox10.Text = g.ToString();
106      f = (decimal) (g * 0.2);
107      TextBox11.Text = f.ToString();
108
109     }
110     else
111     {
112      MessageBox.Show("Please Enter value equal to 50 and below!");
113
114
115     }
116    }
117    if (Information.IsNumeric(TextBox12.Text))
118    {
119     if (int.Parse(TextBox12.Text) <= 100 )
120     {
121      int g = default(int);
122      decimal f = new decimal();
123      g = (int) ((double.Parse(TextBox12.Text) * 100) / 100);
124      TextBox13.Text = g.ToString();
125      f = (decimal) (g * 0.3);
126      TextBox14.Text = f.ToString();
127
128     }
129     else
130     {
131      MessageBox.Show("Please Enter value equal to 100 and below!");
132
133
134     }
135    }
136
137    if (Information.IsNumeric(TextBox15.Text))
138    {
139     if (int.Parse(TextBox15.Text) <= 100 )
140     {
141      int j = default(int);
142      decimal f1 = new decimal();
143      j = (int) ((double.Parse(TextBox15.Text) * 100) / 100);
144      TextBox16.Text = j.ToString();
145      f1 = (decimal) (j * 0.3);
146      TextBox17.Text = f1.ToString();
147
148     }
149     else
150     {
151      MessageBox.Show("Please Enter value equal to 100 and below!");
152
153
154     }
155    }
156
157    decimal adal = new decimal();
158    adal = (decimal) (Conversion.Val(TextBox5.Text) + Conversion.Val(TextBox8.Text) + Conversion.Val(TextBox11.Text) + Conversion.Val(TextBox14.Text) + Conversion.Val(TextBox17.Text));
159
160    TextBox18.Text = adal.ToString();
161
162    if (Conversion.Val(TextBox18.Text) <= 74)
163    {
164
165     TextBox19.Text = "Failed";
166     TextBox19.ForeColor = Color.Red;
167    }
168    else
169    {
170     TextBox19.Text = "Passed";
171     TextBox19.ForeColor = Color.Black;
172
173
174    }
175
176
177   }

185   public void Button3_Click(System.Object sender, System.EventArgs e)
186   {
187
188    TextBox1.Text = "";
189    TextBox12.Text = "";
190    TextBox3.Text = "";
191    TextBox4.Text = "";
192    TextBox5.Text = "";
193    TextBox6.Text = "";
194    TextBox7.Text = "";
195    TextBox8.Text = "";
196    TextBox9.Text = "";
197    TextBox10.Text = "";
198    TextBox11.Text = "";
199    TextBox12.Text = "";
200    TextBox13.Text = "";
201    TextBox14.Text = "";
202    TextBox15.Text = "";
203    TextBox16.Text = "";
204    TextBox17.Text = "";
205    TextBox18.Text = "";
206    TextBox19.Text = "";
207
208
209   }

254   public void NavRecords()
255   {
256
257    STUDID.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][1]);
258    TextBox1.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][2]);
259    TextBox2.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][3]);
260    TextBox3.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][4]);
261    TextBox4.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][5]);
262    TextBox5.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][6]);
263    TextBox6.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][7]);
264    TextBox7.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][8]);
265    TextBox8.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][9]);
266    TextBox9.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][10]);
267    TextBox10.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][11]);
268    TextBox11.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][12]);
269    TextBox12.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][13]);
270    TextBox13.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][14]);
271    TextBox14.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][15]);
272    TextBox15.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][16]);
273    TextBox16.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][17]);
274    TextBox17.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][18]);
275    TextBox18.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][19]);
276    TextBox19.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][20]);
277
278   }

347   public void Button6_Click(System.Object sender, System.EventArgs e)
348   {
349
350    TextBox1.Text = DataGridView1.CurrentRow.Cells[1].Value.ToString();
351    TextBox2.Text = DataGridView1.CurrentRow.Cells[2].Value.ToString();
352    TextBox3.Text = DataGridView1.CurrentRow.Cells[3].Value.ToString();
353    TextBox4.Text = DataGridView1.CurrentRow.Cells[4].Value.ToString();
354    TextBox5.Text = DataGridView1.CurrentRow.Cells[5].Value.ToString();
355    TextBox6.Text = DataGridView1.CurrentRow.Cells[6].Value.ToString();
356    TextBox7.Text = DataGridView1.CurrentRow.Cells[7].Value.ToString();
357    TextBox8.Text = DataGridView1.CurrentRow.Cells[8].Value.ToString();
358    TextBox9.Text = DataGridView1.CurrentRow.Cells[9].Value.ToString();
359    TextBox10.Text = DataGridView1.CurrentRow.Cells[10].Value.ToString();
360    TextBox11.Text = DataGridView1.CurrentRow.Cells[11].Value.ToString();
361    TextBox12.Text = DataGridView1.CurrentRow.Cells[12].Value.ToString();
362    TextBox13.Text = DataGridView1.CurrentRow.Cells[13].Value.ToString();
363    TextBox14.Text = DataGridView1.CurrentRow.Cells[14].Value.ToString();
364    TextBox15.Text = DataGridView1.CurrentRow.Cells[15].Value.ToString();
365    TextBox16.Text = DataGridView1.CurrentRow.Cells[16].Value.ToString();
366    TextBox17.Text = DataGridView1.CurrentRow.Cells[17].Value.ToString();
367    TextBox18.Text = DataGridView1.CurrentRow.Cells[18].Value.ToString();
368    TextBox19.Text = DataGridView1.CurrentRow.Cells[19].Value.ToString();
369    STUDID.Text = DataGridView1.CurrentRow.Cells[0].Value.ToString();
370
371   }

397   public void DataGridView1_CellDoubleClick(object sender, System.Windows.Forms.DataGridViewCellEventArgs e)
398   {
399    TextBox1.Text = DataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
400    TextBox2.Text = DataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
401    TextBox3.Text = DataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
402    TextBox4.Text = DataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
403    TextBox5.Text = DataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString();
404    TextBox6.Text = DataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString();
405    TextBox7.Text = DataGridView1.Rows[e.RowIndex].Cells[7].Value.ToString();
406    TextBox8.Text = DataGridView1.Rows[e.RowIndex].Cells[8].Value.ToString();
407    TextBox9.Text = DataGridView1.Rows[e.RowIndex].Cells[9].Value.ToString();
408    TextBox10.Text = DataGridView1.Rows[e.RowIndex].Cells[10].Value.ToString();
409    TextBox11.Text = DataGridView1.Rows[e.RowIndex].Cells[11].Value.ToString();
410    TextBox12.Text = DataGridView1.Rows[e.RowIndex].Cells[12].Value.ToString();
411    TextBox13.Text = DataGridView1.Rows[e.RowIndex].Cells[13].Value.ToString();
412    TextBox14.Text = DataGridView1.Rows[e.RowIndex].Cells[14].Value.ToString();
413    TextBox15.Text = DataGridView1.Rows[e.RowIndex].Cells[15].Value.ToString();
414    TextBox16.Text = DataGridView1.Rows[e.RowIndex].Cells[16].Value.ToString();
415    TextBox17.Text = DataGridView1.Rows[e.RowIndex].Cells[17].Value.ToString();
416    TextBox18.Text = DataGridView1.Rows[e.RowIndex].Cells[18].Value.ToString();
417    TextBox19.Text = DataGridView1.Rows[e.RowIndex].Cells[19].Value.ToString();
418    STUDID.Text = DataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
419
420
421   }

80   public void clearall()
81   {
82    Form1.Default.TextBox1.Text = "";
83    Form1.Default.TextBox2.Text = "";
84    Form1.Default.TextBox3.Text = "";
85    Form1.Default.TextBox4.Text = "";
86    Form1.Default.TextBox5.Text = "";
87    Form1.Default.TextBox6.Text = "";
88    Form1.Default.TextBox7.Text = "";
89    Form1.Default.TextBox8.Text = "";
90    Form1.Default.TextBox9.Text = "";
91    Form1.Default.TextBox10.Text = "";
92    Form1.Default.TextBox11.Text = "";
93    Form1.Default.TextBox12.Text = "";
94    Form1.Default.TextBox13.Text = "";
95    Form1.Default.TextBox14.Text = "";
96    Form1.Default.TextBox15.Text = "";
97    Form1.Default.TextBox16.Text = "";
98    Form1.Default.TextBox17.Text = "";
99    Form1.Default.TextBox18.Text = "";
100    Form1.Default.TextBox19.Text = "";
101    Form1.Default.STUDID.Text = "";
102
103
104   }

110   public DataSet SaveItem(string sortfield)
111   {
112
113    System.Data.OleDb.OleDbConnection conn = GetConnection();
114
115    try
116    {
117
118     string SQL = default(string);
119
120     SQL = "INSERT INTO TABLE1 (STUDENTID, DATA1, DATA2, DATA3, DATA4, DATA5,DATA6, DATA7," + "DATA8, DATA9, DATA10, DATA11, DATA12, DATA13, DATA14, DATA15, DATA16, DATA17, DATA18," + "DATA19) VALUES(@STUDENTID, @DATA1, @DATA2, @DATA3, @DATA4, @DATA5,@DATA6, @DATA7,DATA8, @DATA9," + "@DATA10, @DATA11, @DATA12, @DATA13, @DATA14, @DATA15, @DATA16, @DATA17, @DATA18, @DATA19)";
121     System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(SQL, conn);
122     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@STUDENTID", Form1.Default.STUDID.Text));
123     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA1", Form1.Default.TextBox1.Text));
124     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA2", Form1.Default.TextBox2.Text));
125     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA3", Form1.Default.TextBox3.Text));
126     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA4", Form1.Default.TextBox4.Text));
127     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA5", Form1.Default.TextBox5.Text));
128     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA6", Form1.Default.TextBox6.Text));
129     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA7", Form1.Default.TextBox7.Text));
130     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA8", Form1.Default.TextBox8.Text));
131     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA9", Form1.Default.TextBox9.Text));
132     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA10", Form1.Default.TextBox10.Text));
133     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA11", Form1.Default.TextBox11.Text));
134     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA12", Form1.Default.TextBox12.Text));
135     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA13", Form1.Default.TextBox13.Text));
136     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA14", Form1.Default.TextBox14.Text));
137     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA15", Form1.Default.TextBox15.Text));
138     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA16", Form1.Default.TextBox16.Text));
139     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA17", Form1.Default.TextBox17.Text));
140     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA18", Form1.Default.TextBox18.Text));
141     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA19", Form1.Default.TextBox19.Text));
142
143     conn.Open();
144     cmd.ExecuteNonQuery();
145     conn.Close();
146     MessageBox.Show("New data is Added!");
147
148     Form1.Default.TextBox1.Text = "";
149     Form1.Default.TextBox2.Text = "";
150     Form1.Default.TextBox3.Text = "";
151     Form1.Default.TextBox4.Text = "";
152     Form1.Default.TextBox5.Text = "";
153     Form1.Default.TextBox6.Text = "";
154     Form1.Default.TextBox7.Text = "";
155     Form1.Default.TextBox8.Text = "";
156     Form1.Default.TextBox9.Text = "";
157     Form1.Default.TextBox10.Text = "";
158     Form1.Default.TextBox11.Text = "";
159     Form1.Default.TextBox12.Text = "";
160     Form1.Default.TextBox13.Text = "";
161     Form1.Default.TextBox14.Text = "";
162     Form1.Default.TextBox15.Text = "";
163     Form1.Default.TextBox16.Text = "";
164     Form1.Default.TextBox17.Text = "";
165     Form1.Default.TextBox18.Text = "";
166     Form1.Default.TextBox19.Text = "";
167     Form1.Default.STUDID.Text = "";
168
169     RefreshDGV();
170
171    }
172    finally
173    {
174     conn.Close();
175     conn.Dispose();
176    }
177
178    return default(DataSet);
179   }

276   public DataSet updtedata(string sortfield)
277   {
278
279    System.Data.OleDb.OleDbConnection conn = GetConnection();
280    DataSet ds = new DataSet();
281
282    try
283    {
284
285     string sqlupdate = default(string);
286
287     sqlupdate = "UPDATE Table1 set STUDENTID=@STUDENTID, data1=@data1, data2=@data2, data3=@data3, data4=@data4," + "data5=@data5, data6=@data6, data7=@data7, data8=@data8, data9=@data9, data10=@data10," + "data11=@data11, data12=@data12, data13=@data13, data14=@data14, data15=@data15, data16=@data16," + "data17=@data17, data18=@data18, data19=@data19 where STUDENTID=\'" + Form1.Default.STUDID.Text + "\'";
288     System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(sqlupdate, conn);
289
290     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@STUDENTID", Form1.Default.STUDID.Text));
291     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA1", Form1.Default.TextBox1.Text));
292     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA2", Form1.Default.TextBox2.Text));
293     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA3", Form1.Default.TextBox3.Text));
294     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA4", Form1.Default.TextBox4.Text));
295     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA5", Form1.Default.TextBox5.Text));
296     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA6", Form1.Default.TextBox6.Text));
297     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA7", Form1.Default.TextBox7.Text));
298     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA8", Form1.Default.TextBox8.Text));
299     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA9", Form1.Default.TextBox9.Text));
300     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA10", Form1.Default.TextBox10.Text));
301     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA11", Form1.Default.TextBox11.Text));
302     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA12", Form1.Default.TextBox12.Text));
303     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA13", Form1.Default.TextBox13.Text));
304     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA14", Form1.Default.TextBox14.Text));
305     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA15", Form1.Default.TextBox15.Text));
306     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA16", Form1.Default.TextBox16.Text));
307     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA17", Form1.Default.TextBox17.Text));
308     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA18", Form1.Default.TextBox18.Text));
309     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA19", Form1.Default.TextBox19.Text));
310
311     conn.Open();
312     cmd.ExecuteNonQuery();
313     conn.Close();
314     MessageBox.Show("Data Updated in the Database");
315     RefreshDGV();
316
317    }
318    finally
319    {
320    }
321    return ds;
322   }

66         private void button1_Click(object sender, EventArgs e)
67         {
68             SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=F:\Sem.4\C# Projects\Trials\HospitalManagementSystemCSharp\HospitalManagementSystemCSharp\hospital.mdf;Integrated Security=True");
69             con.Open();
70             string gen = string.Empty;
71             if (radioButton1.Checked)
72             {
73                 gen = "Male";
74             }
75             else
76             {
77                 gen = "Female";
78             }
79             try
80             {
81                 string str = "INSERT INTO checkout(name,gen,age,contact,addr,disease,date_in,date_out,build,r_no,r_type,status,med_price,total) VALUES('" + textBox2.Text + "','" + gen + "','" + textBox3.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox8.Text + "','" + textBox9.Text + "','" + textBox10.Text + "','" + textBox11.Text + "','" + textBox12.Text + "','" + textBox14.Text + "','" + textBox13.Text + "','" + textBox15.Text + "'); ";
82
83                 SqlCommand cmd = new SqlCommand(str, con);
84                 cmd.ExecuteNonQuery();
85                 string str1 = "select max(Id) from checkout;";
86
87                 SqlCommand cmd1 = new SqlCommand(str1, con);
88                 SqlDataReader dr = cmd1.ExecuteReader();
89                 if (dr.Read())
90                 {
91                     MessageBox.Show("Patient Checkout Information Saved Successfully..");
92                     textBox2.Text = "";
93                     textBox3.Text = "";
94
95                     textBox5.Text = "";
96                     textBox6.Text = "";
97                     textBox7.Text = "";
98                     textBox8.Text = "";
99                     textBox9.Text = "";
100                     textBox10.Text = "";
101                     textBox11.Text = "";
102                     textBox12.Text = "";
103                     textBox13.Text = "";
104                     textBox14.Text = "";
105                     textBox15.Text = "";
106                 }
107             }
108             catch (SqlException excep)
109             {
110                 MessageBox.Show(excep.Message);
111             }
112             con.Close();
113         }

115         private void button2_Click(object sender, EventArgs e)
116         {
117             textBox2.Text = "";
118             textBox3.Text = "";
119
120             textBox5.Text = "";
121             textBox6.Text = "";
122             textBox7.Text = "";
123             textBox8.Text = "";
124             textBox9.Text = "";
125             textBox10.Text = "";
126             textBox11.Text = "";
127             textBox12.Text = "";
128             textBox13.Text = "";
129             textBox14.Text = "";
130             textBox15.Text = "";
131         }