public SectionAddModify(SectionMainform sMain)
 {
     InitializeComponent();
     cgrade     = new ClassGrade();
     section    = new ClassSection();
     this.sMain = sMain;
 }
예제 #2
0
        public int update(MySqlConnection con, int id)
        {
            int gradeid = gradeID(con);
            //   int programid = programID(con);
            int sectionid = new ClassSection().getSectionID(con, section, grade);

            query = @"UPDATE student SET rfid=?rfid, studentID=?stdid, lrn=?lrn, lname=?lname, fname=?fname,
                        mname=?mname, sex=?sex, gradeID=?gid, sectionID=?sectionid, mobileNo=?mobile,  pMobileNo=?pmobile, guardian=?guardian, img=?img, isExempted=?xmtd WHERE id=?id";
            cmd   = new MySqlCommand(query, con);
            cmd.Parameters.AddWithValue("?rfid", rfid);
            cmd.Parameters.AddWithValue("?stdid", studentID);
            cmd.Parameters.AddWithValue("?lrn", lrn);
            cmd.Parameters.AddWithValue("?lname", lname);
            cmd.Parameters.AddWithValue("?fname", fname);
            cmd.Parameters.AddWithValue("?mname", mname);
            cmd.Parameters.AddWithValue("?sex", sex);
            cmd.Parameters.AddWithValue("?gid", gradeid);
            cmd.Parameters.AddWithValue("?sectionid", sectionid);
            // cmd.Parameters.AddWithValue("?progID", programid);
            //  cmd.Parameters.AddWithValue("?yrlvl", yearlvl);
            cmd.Parameters.AddWithValue("?mobile", mobileNo);
            cmd.Parameters.AddWithValue("?pmobile", pmobileNo);
            cmd.Parameters.AddWithValue("?guardian", guardian);
            cmd.Parameters.AddWithValue("?img", imgData());
            cmd.Parameters.AddWithValue("?xmtd", exempted);
            cmd.Parameters.AddWithValue("?id", id);
            int i = cmd.ExecuteNonQuery();

            cmd.Dispose();
            return(i);
        }
        //public StudentAddForm()
        //{
        //    InitializeComponent();
        //}

        public StudentAddForm(StudentMainform _frm)
        {
            InitializeComponent();
            std      = new ClassStudent();
            cGrade   = new ClassGrade();
            cSection = new ClassSection();
            cProgram = new Programs();
            open     = new OpenFileDialog();

            this._frm = _frm;
        }
예제 #4
0
 public SectionMainform()
 {
     InitializeComponent();
     section = new ClassSection();
     cGrade  = new ClassGrade();
 }