Esempio n. 1
0
        private void btn_pay_Click(object sender, EventArgs e)
        {
            if (!(txt_DATE.Text == "" && txt_Fee.Text == ""))
            {
                da = new SqlDataAdapter("select s_sem from std where s_grno='" + txt_grno.Text + "'", con);
                DataTable dt = new DataTable();
                da.Fill(dt);
                if (!(dt.Rows[0][0].ToString() == txt_nextSEM.Text))
                {
                    String sql;
                    sql = "INSERT INTO admission  (s_grno, s_name, s_course, s_sem, s_fee, s_date,s_type) VALUES   ('" + txt_grno.Text + "','" + txt_stud_name.Text + "','" + txt_Course.Text + "'," + txt_nextSEM.Text + "," + fee + ",'" + txt_DATE.Text + "','Old')";
                    try
                    {
                        cmd = new SqlCommand(sql, con);
                        int i = cmd.ExecuteNonQuery();
                        if (i == 0)
                        {
                            MessageBox.Show("Oops Error.!!");
                        }
                        else
                        {
                            DataTable xxx = new DataTable();
                            xxx.Columns.Add("s_grno", typeof(String));
                            xxx.Columns.Add("s_name", typeof(String));
                            xxx.Columns.Add("s_course", typeof(String));
                            xxx.Columns.Add("s_sem", typeof(String));
                            xxx.Columns.Add("s_fee", typeof(String));
                            xxx.Rows.Add(txt_grno.Text, txt_stud_name.Text, txt_Course.Text, txt_nextSEM.Text, txt_Fee.Text);

                            Std_fee_print a = new Std_fee_print(xxx);
                            a.MdiParent = this.MdiParent;
                            a.Location  = new Point(0, 66);
                            a.Size      = new Size(deskWidth, deskHeight);
                            a.ShowDialog();
                        }

                        cmd = new SqlCommand("UPDATE  std SET s_sem = '" + txt_nextSEM.Text + "',s_fee='" + fee + "' WHERE   (std.s_grno = '" + txt_grno.Text + "')", con);
                        i   = cmd.ExecuteNonQuery();
                        if (i == 0)
                        {
                            MessageBox.Show("Student Semester NOT Updated");
                        }
                    }
                    catch (Exception x)
                    {
                        MessageBox.Show("Error ::" + x);
                    }
                }
                else
                {
                    MessageBox.Show("Fee Already Tacken");
                }
            }
            else
            {
                MessageBox.Show("Student G.R.No Not Found");
            }
        }
        //Save Student
        private void btn_SAVE_Click(object sender, EventArgs e)
        {
            int tmp;

            tmp = getresult();
            if (tmp == 1)
            {
                try
                {
                    if (ImageByte == null)
                    {
                        MessageBox.Show("Select Image");
                    }
                    else
                    {
                        //
                        //\\GET G.R. NO.
                        //
                        grno = get_grno();
                        cmd  = new SqlCommand("INSERT INTO grno([year], course, [no]) VALUES(" + DateTime.Now.Year + ",'" + grno_course + "'," + grNO + ");", con);
                        cmd.ExecuteNonQuery();

                        //
                        //\\GET SEM FEE
                        //
                        cmd = new SqlCommand("select c_id from course where c_name='" + cmbCourse.Text + "'", con);
                        SqlDataReader dr1 = cmd.ExecuteReader();
                        dr1.Read();
                        int sem_id = Int32.Parse(dr1.GetValue(0).ToString());
                        cmd = new SqlCommand("SELECT   SUM(fee_rs) FROM semester WHERE (sem = " + cmb_sem.Text + " and c_id='" + sem_id + "')", con);
                        Object a = cmd.ExecuteScalar();
                        fee = Int32.Parse(a.ToString());



                        //
                        //\\ADMISSION OF STUDENT
                        //
                        cmd = new SqlCommand("INSERT INTO std (s_name, s_grno, s_city, s_add, s_gen, s_email, s_mobile, s_dob, s_course, s_sem,s_fee,s_img,s_join_dt) VALUES('" + txtfnm.Text + "','" + grno + "','" + cmb_city.Text + "','" + txtAdd.Text + "', '" + gen + "' ,'" + txtEmail.Text + "','" + txtMobile.Text + "','" + DOB.Text + "','" + cmbCourse.Text + "','" + cmb_sem.Text + "'," + fee + ",@s_img,'" + DateTime.Now.ToString() + "')", con);
                        cmd.Parameters.Add("@s_img", ImageByte);
                        int m = cmd.ExecuteNonQuery();
                        if (m == 1)
                        {
                            if (MessageBox.Show("Admission Done \n Print Recipt.?", "Print", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
                            {
                                String date = DateTime.Now.ToString();
                                cmd = new SqlCommand("INSERT INTO admission  (s_grno, s_name, s_course, s_sem, s_fee, s_date,s_type) VALUES   ('" + grno + "', '" + txtfnm.Text + "', '" + cmbCourse.Text + "', '" + cmb_sem.Text + "', " + fee.ToString() + ",'" + date + "','New')", con);
                                int f = cmd.ExecuteNonQuery();
                                if (f == 0)
                                {
                                }
                                else
                                {
                                    da = new SqlDataAdapter("select a_id from admission where s_grno='" + grno + "' and s_sem='" + cmb_sem.Text + "'", con);
                                    dt = new DataTable();
                                    da.Fill(dt);

                                    DataTable xxx = new DataTable();
                                    xxx.Columns.Add("a_id", typeof(String));
                                    xxx.Columns.Add("s_grno", typeof(String));
                                    xxx.Columns.Add("s_name", typeof(String));
                                    xxx.Columns.Add("s_course", typeof(String));
                                    xxx.Columns.Add("s_sem", typeof(String));
                                    xxx.Columns.Add("s_fee", typeof(String));
                                    xxx.Rows.Add(dt.Rows[0][0].ToString(), grno, txtfnm.Text, cmbCourse.Text, cmb_sem.Text, fee.ToString());
                                    Std_fee_print z = new Std_fee_print(xxx);
                                    z.Show();
                                    Reload_Controls();
                                }
                            }
                            Reload_Controls();
                        }
                        else
                        {
                            MessageBox.Show("Student admission failed");
                        }
                    }
                }
                catch (Exception xx)
                {
                    MessageBox.Show("Error Check The Course/Semester fee");
                }
            }
        }