public Student getStudent(String Conditions) { List <String> itemList = new List <String>(); Student _stud = new Student(); itemList = FetchList(TPerson, "*", Conditions); _stud.USERNAME = itemList[0]; _stud.PASSWORD = itemList[1]; _stud.ID = itemList[2]; _stud.FIRSTNAME = itemList[3]; _stud.LASTNAME = itemList[4]; _stud.MAIL = itemList[5]; _stud.PHONE = itemList[6]; _stud.GENDER = (Gender)(Convert.ToInt32(itemList[7])); _stud.DEPT = (Department)(Convert.ToInt32(itemList[8])); //-------------------------------------------------------------------------------------------// itemList = FetchList(TStudent, "*", "id = " + _stud.ID); //-------------------------------------------------------------------------------------------// _stud.AVERAGE = Convert.ToSingle(itemList[1]); _stud.STATE = Convert.ToBoolean(itemList[2]); _stud.decrypt_books(itemList[3]); _stud.decrypt_courses(itemList[4]); _stud.decrypt_grades(itemList[5]); _stud.YEAR = (Year)(Convert.ToInt32(itemList[6])); _stud.SEMESTER = (Semester)(Convert.ToInt32(itemList[7])); return(_stud); }
private void button1_Click(object sender, EventArgs e) { List <String> bnums = new List <String>(); Boolean copies_flag = false, ownership_flag = false; for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToBoolean(dataGridView1.Rows[i].Cells[0].Value) == true) { if (Convert.ToInt32(dt.Rows[i].ItemArray[3].ToString()) > 0) { foreach (Book value in user.BOOKS) { if (value.BNUM == Convert.ToInt32(dt.Rows[i].ItemArray[0])) { ownership_flag = true; } } bnums.Add(dt.Rows[i].ItemArray[0].ToString()); } else { copies_flag = true; } } } if (copies_flag == true) { MessageBox.Show("One or more of the selected books is not in stock!", "Message"); return; } if (ownership_flag == true) { MessageBox.Show("You already have one or more of the selected books!", "Message"); return; } int num; dataGridView1.Columns[4].ReadOnly = false; for (int i = 0; i < dt.Rows.Count; i++) { if (bnums.Contains(dt.Rows[i].ItemArray[0].ToString())) { num = Convert.ToInt32(dt.Rows[i].ItemArray[3].ToString()) - 1; dataGridView1.Rows[i].Cells[4].Value = num; dt.Rows[i].ItemArray[3] = num; } } dataGridView1.Columns[4].ReadOnly = true; dt = db.UpdateTable(db.TLIBRARY, "Book_Number, Book_Count", "Department = 0 OR Department = " + (int)user.DEPT, dt); foreach (Book value in user.BOOKS) { bnums.Add(value.BNUM.ToString()); } String book_code = user.encrypt_books(bnums); db.SimpleUpdate(db.TSTUDENT, "Books = '" + book_code + "'", "id = " + user.ID); user.decrypt_books(book_code); MessageBox.Show("You have successfully taken all the selected books!", "Message"); foreach (DataGridViewRow value in dataGridView1.Rows) { DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)value.Cells[0]; chk.Value = false; } }