private void experiment_Load(object sender, EventArgs e) { algo o = new algo(); string today = o.month_id_method(s); sqlreturn sq = new sqlreturn(); string yesterday = sq.scalarReturn("select top 1 f_m_id from monthly_fess "); string montname = o.month_name_method(s); if (today != yesterday) { DialogResult d = MessageBox.Show("you want to update it All", "imp msg", MessageBoxButtons.YesNo); if (d == DialogResult.Yes) { string initiallimit = sq.scalarReturn("select top 1 f_s_id from monthly_fess"); string finallimit = sq.scalarReturn("select top 1 f_s_id from monthly_fess ORDER BY f_s_id DESC"); int s1 = Convert.ToInt32(initiallimit); int sl = Convert.ToInt32(finallimit); update_class up = new update_class(); for (int i = s1; i <= sl; i++) { up.update_monthchanges(i.ToString(), today, montname, System.DateTime.Now.Year.ToString()); } MessageBox.Show("fees record has been UPDATED successfully....."); } } }
private void button3_Click_1(object sender, EventArgs e) { {//MY CODE HANDLING biodata[0] = txtname.Text; biodata[1] = txtfname.Text; biodata[2] = txtreligion.Text; biodata[3] = cmbmonth.SelectedItem.ToString() + "-" + cmbyear.SelectedItem.ToString() + "-" + cmbdate.SelectedItem.ToString(); biodata[4] = cmbclass.SelectedItem.ToString(); biodata[5] = txtaddress.Text; biodata[6] = txtcontct.Text; biodata[7] = textBox5.Text; //date biodata[8] = textBox6.Text; //fess if (checkBox3.Checked == true) { biodata[9] = "self"; } else if (checkBox4.Checked == true) { biodata[9] = "Transport"; } else if (checkBox4.Checked == true && checkBox3.Checked == true) { biodata[9] = "Both"; } else { biodata[9] = "NONE"; } biodata[10] = txt_id.Text; //fess MEDICALdata[0] = textBox1.Text; //HEIGHT MEDICALdata[1] = textBox2.Text; //WEIGHT MEDICALdata[2] = textBox3.Text; //EYESIGHT MEDICALdata[3] = textBox4.Text; //BLOODGROUP.. MEDICALdata[4] = biodata[10]; } //code handling.... update_class up = new update_class(); up.update_record(biodata); up.update_medicalreord(MEDICALdata); }