private void button4_Click(object sender, EventArgs e)
{
string[] history = new string[10];
string id = textBox7.Text;
sqlreturn s1 = new sqlreturn();
history[0] = textBox7.Text;
history[1] = s1.scalarReturn("select s_name from student_record where s_id=" + id);
history[2] = s1.scalarReturn("select s_fname from student_record where s_id=" + id);
history[3] = s1.scalarReturn("select s_address from student_record where s_id=" + id);
history[4] = s1.scalarReturn("select s_date_of_birth from student_record where s_id=" + id);
history[5] = s1.scalarReturn("select s_class from student_record where s_id=" + id);
history[6] = s1.scalarReturn("select s_contact from student_record where s_id=" + id);
history[7] = s1.scalarReturn("select s_admission_date from student_record where s_id=" + id);
history[8] = System.DateTime.Now.ToString();
Deletion_CLASS d = new Deletion_CLASS();
d.insertinto_history(history);
Deletion_CLASS d1 = new Deletion_CLASS();
d1.DELETE_DATA(id, "deleting_medical", "@m_s_id");
d1.DELETE_DATA(id, "deleting_fees", "@f_s_id");
Deletion_CLASS d2 = new Deletion_CLASS();
d2.DELETE_DATA(id, "deleting_records", "@s_id");
}
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 button1_Click(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";
}
MEDICALdata[0] = textBox1.Text; //HEIGHT
MEDICALdata[1] = textBox2.Text; //WEIGHT
MEDICALdata[2] = textBox3.Text; //EYESIGHT
MEDICALdata[3] = textBox4.Text; //BLOODGROUP..
string s = System.DateTime.Now.ToString();
algo a = new algo();
month_id = a.month_id_method(s);
month_name = a.month_name_method(s);
sqlreturn s1 = new sqlreturn("select MAX(voucher) from voucher_record");
string voucher_s = s1.scalarReturn();
algo ab = new algo();
voucher = "P-" + ab.voucher_return(voucher_s);
insert_class v1 = new insert_class();
v1.insert_voucher(voucher);
} //MY CODE HANDLING
insert_class C1 = new insert_class();
C1.insert_record(biodata);
string querry = "select s_id from student_record where s_name='" + biodata[0] + "'";
sqlreturn ob = new sqlreturn(querry);
MEDICALdata[4] = ob.scalarReturn(); //THIS IS ID FOR MEDICAL RECORD......
insert_class M1 = new insert_class();
M1.insert_medicalreord(MEDICALdata);
sqlreturn ob2 = new sqlreturn(querry);
string M_D = ob2.scalarReturn();
insert_class F1 = new insert_class();
F1.insert_monthlyfees(M_D, fees, month_id, month_name, cmbyear.SelectedItem.ToString(), voucher);
F1.insert_hisotryfees(M_D, fees, month_id, month_name, cmbyear.SelectedItem.ToString(), voucher, biodata[0], biodata[1]);
}
