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.";
}
}
}
