private void record_btn_Click(object sender, EventArgs e) { string department_name, faculty_id, query; int index; Boolean result; department_name = department_name_txtbx.Text; index = faculty_name_cmbx.SelectedIndex; if (department_name != "" && index > -1) { faculty_id = Utils.faculty_list[index].Id.ToString(); query = "INSERT INTO department(id,faculty_id,name,create_date) " + "values(new_id,{0},'{1}',NOW());"; query = string.Format(query, faculty_id, department_name); result = DatabaseProcess.insert(query, "department"); if (result) { MessageBox.Show("Bölüm başarıyla kayıt ededildi"); } else { error_msg_lbl.Text = DatabaseProcess.error_msg; } DatabaseProcess.conn_close(); } }
private void record_btn_Click(object sender, EventArgs e) { string code, name, category, isbn_number, keys, author, page_count, print_year; string query; Boolean result; name = name_txtbx.Text; author = author_txtbx.Text; category = category_cmbx.Text; code = code_txtbx.Text; isbn_number = isbn_txtbx.Text; keys = keys_txtbx.Text; page_count = page_count_txbx.Text; print_year = year_cmbx.Text; if (name != "" && author != "" && category != "" && code != "" && isbn_number != "" && print_year != "") { query = "INSERT INTO book() values(new_id, '{0}','{1}','{2}',{3},'{4}',{5},'{6}','{7}');"; query = string.Format(query, code, name, category, print_year, isbn_number, page_count, keys, author); result = DatabaseProcess.insert(query, "book"); if (result) { MessageBox.Show("Kitap kaydı başarıyla gerçekleşmiştir."); } else { error_msg_lbl.Text = DatabaseProcess.error_msg; } } else { error_msg_lbl.Text = "Yıldızlı alanların doldurulması zorunludur."; } }
private void singup_btn_Click(object sender, EventArgs e) { string name, surname, gsm, email, password, password2; name = name_txtbx.Text; surname = surname_txtbx.Text; gsm = gsm_txtbx.Text; email = email_txtbx.Text; password = password__txtbx.Text; password2 = password2_txtbx.Text; if ((password == password2) && Utils.is_email(email) && gsm.Length == 11) { MessageBox.Show("Test"); string hash = Utils.get_hash(password); string tel = gsm.Replace(" ", ""); DateTime date = DateTime.Now; string query = "INSERT INTO User(id,name,surname,singup_date,gsm,email,password)" + " values(new_id,'new_name','new_surname',NOW(),'new_tel','new_email','new_password');"; query = query.Replace("new_name", name); query = query.Replace("new_surname", surname); query = query.Replace("new_tel", tel); query = query.Replace("new_email", email); query = query.Replace("new_password", hash); Boolean a = DatabaseProcess.insert(query, "User"); if (a == true) { MessageBox.Show("Kayıt işleminiz başarıyla tamamlandı.\n Artık giriş yapabilirsiniz."); this.Close(); singin_frm singin_form = new singin_frm(); singin_form.Show(); } else { error_lbl.Text = DatabaseProcess.error_msg; } } else { if (password != password2) { error_lbl.Text = "Şifreler aynı değil!"; password__txtbx.Text = password2_txtbx.Text = ""; } else if (!Utils.is_email(email)) { error_lbl.Text = "Girdiğiniz email hatalı!"; } } }
private void record_btn_Click(object sender, EventArgs e) { string faculty_name = faculty_name_txtbx.Text + " Fakültesi"; string query = "INSERT INTO faculty(id, name, create_time) values(new_id, '{0}', NOW());"; query = string.Format(query, faculty_name); Boolean result = DatabaseProcess.insert(query, "faculty"); if (result) { MessageBox.Show("Fakülte kaydınız başarıyla tamamlanmıştır."); } else { error_msg_lbl.Text = DatabaseProcess.error_msg; } }
private void record_btn_Click(object sender, EventArgs e) { string name, surname, number, address, home_address, gsm, department_id; string query; int index; Boolean result; name = name_txtbx.Text; surname = surname_txtbx.Text; number = number_txtbx.Text; address = address_txtbx.Text; home_address = home_address_txtbx.Text; gsm = gsm_txtbx.Text; index = department_cmbx.SelectedIndex; department_id = list_department[index].Id.ToString(); if (name != "" && surname != "" && number != "" && address != "" && home_address != "" && department_id != "" && gsm.Length == 11) { query = "INSERT INTO student() values(new_id,{0},'{1}','{2}','{3}','{4}',{5},{6});"; query = string.Format(query, number, name, surname, address, home_address, gsm, department_id); result = DatabaseProcess.insert(query, "student"); if (result) { MessageBox.Show("Yeni öğrenci kaydı başarıyla tamamlandı"); } else { MessageBox.Show(DatabaseProcess.error_msg); } } else { MessageBox.Show("hatalı"); } DatabaseProcess.conn_close(); }
private void lend_btn_Click(object sender, EventArgs e) { Boolean result; int user_id, student_id, book_id, expiry_date, recieve_case; string query = "INSERT INTO lend_book(id,student_id,book_id,recieve_by_id,lend_date,expiry_date)" + "values(new_id,{0},{1},{2},NOW()," + "DATE_ADD(NOW(),INTERVAL {3} DAY));"; string query2 = "SELECT recieve_case FROM lend_book WHERE book_id={0}"; user_id = Utils.User.id; student_id = list_student[student_index].Id; book_id = list_book[book_index].Id; query2 = string.Format(query2, book_id.ToString()); DatabaseProcess.conn_open(); MySqlCommand cmd = new MySqlCommand(query2, DatabaseProcess.myconn); MySqlDataReader dt_reader = cmd.ExecuteReader(); if (dt_reader.Read()) { recieve_case = dt_reader.GetByte("recieve_case"); } else { recieve_case = 1; } DatabaseProcess.conn_close(); if (change_lend_time_rdbtn.Enabled == false) { expiry_date = Convert.ToInt32(lend_time_cmbx.Text); } else { expiry_date = 15; } if (student_index > -1 && book_index > -1 && recieve_case == 1) { query = string.Format(query, student_id, book_id, user_id, "15"); result = DatabaseProcess.insert(query, "lend_book"); if (result) { MessageBox.Show("Tamamlandı!"); } else { error_msg_lbl.Text = DatabaseProcess.error_msg; } } else { if (recieve_case == 0) { MessageBox.Show("Bu kitap şu an rafta değil!"); } else { error_msg_lbl.Text = "Lütfen gerekli alanları doldurunuz."; } } }