}//method end...
public void insert_student_status(student_status_class sa)
{
SqlConnection conn = new SqlConnection(connstring);
try
{
SqlCommand cmd = new SqlCommand("insert_student_status", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@sa_st_id", SqlDbType.Int).Value = sa.status_student_id;
cmd.Parameters.Add("@sa_class_id", SqlDbType.Int).Value = sa.class_id;
cmd.Parameters.Add("@sa_year", SqlDbType.Int).Value = sa.year;
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("DATA record has been inserted successfully.....");
}
catch (Exception)
{
MessageBox.Show("data is not inserted !!!");
}
finally
{
conn.Close();
}
}//method end...
}//method end...
public void insert_Fees(student_status_class sa, string id)
{
SqlConnection conn = new SqlConnection(connstring);
try
{
SqlCommand cmd = new SqlCommand("insert_tblfees", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@fee_amount", SqlDbType.Float).Value = sa.class_fees;
cmd.Parameters.Add("@fee_date", SqlDbType.NVarChar).Value = System.DateTime.Now.ToShortDateString();
cmd.Parameters.Add("@fee_fk_std_id", SqlDbType.Int).Value = id;
cmd.Parameters.Add("@@sa_st_id", SqlDbType.Int).Value = sa.status_student_id;
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("DATA record has been inserted successfully.....");
}
catch (Exception)
{
MessageBox.Show("data is not inserted !!!");
}
finally
{
conn.Close();
}
}//method end...
private void button1_Click(object sender, EventArgs e)
{
Student s = new Student();
s.sfk = Form1.fk_ad;
s.sdate = System.DateTime.Now.ToShortDateString();
s.sname = textBox4.Text;
s.sfname = textBox3.Text;
if (radioButton4.Checked == true)
{
s.sgender = "Male";
}
else if (radioButton3.Checked == true)
{
s.sgender = "Female";
}
else
{
MessageBox.Show("Please select your gender!");
}
s.saddress = richTextBox2.Text;
MessageBox.Show(i.insert_srecord(s));
returnclass r = new returnclass();
student_status_class sa = new student_status_class();
sa.year = System.DateTime.Now.Year.ToString();
sa.class_id = Convert.ToInt16(comboBox1.SelectedValue.ToString());
sa.status_student_id = Convert.ToInt32(r.scalarReturn("select max(std_id) from student"));
i.insert_student_status(sa);
}
private void button5_Click(object sender, EventArgs e)
{
returnclass r = new returnclass();
student_status_class sa = new student_status_class();
sa.year = System.DateTime.Now.Year.ToString();
sa.class_id = Convert.ToInt16(comboBox1.SelectedValue.ToString());
sa.status_student_id = Convert.ToInt32(textBox7.Text);
i.insert_student_status(sa);
}
private void button2_Click_1(object sender, EventArgs e)
{
student_status_class sa = new student_status_class();
sa.status_student_id = Convert.ToInt32(label6.Text);
sa.class_fees = label5.Text;
sa.class_name = label4.Text;
insert i = new insert();
i.insert_Fees(sa, textBox1.Text);
}