private void Button19_Click(object sender, EventArgs e)
{
int count = int.Parse(textBox10.Text);
var provider = new DatabaseProcess();
provider.UpdateBedCount(ID, count);
}
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 student_result_lstbx_SelectedIndexChanged(object sender, EventArgs e)
{
string query = "", query2 = "", query3, book_name, code, waiting_recieve = "";
int student_id;
List <int> book_id = new List <int>();
if (student_result_lstbx.SelectedIndex > -1)
{
student_index = student_result_lstbx.SelectedIndex;
student_info_lbl.Text = student_result_lstbx.SelectedItem.ToString();
student_id = list_student[student_index].Id;
query = "SELECT book_id FROM lend_book WHERE student_id={0} && recieve_case=0";
query2 = "SELECT name,code FROM book WHERE id={0};";
query = string.Format(query, student_id.ToString());
}
try
{
DatabaseProcess.conn_open();
MySqlCommand cmd = new MySqlCommand(query, DatabaseProcess.myconn);
MySqlDataReader dt_reader;
dt_reader = cmd.ExecuteReader();
while (dt_reader.Read())
{
book_id.Add(dt_reader.GetInt32("book_id"));
}
DatabaseProcess.conn_close();
if (book_id.Count == 0)
{
waiting_recive_book_lbl.Text = "Ödünç aldığı kitap yok";
}
else
{
for (int i = 0; i < book_id.Count; i++)
{
DatabaseProcess.conn_open();
query3 = string.Format(query2, book_id[i].ToString());
cmd = new MySqlCommand(query3, DatabaseProcess.myconn);
dt_reader = cmd.ExecuteReader();
dt_reader.Read();
code = dt_reader.GetString("code");
book_name = dt_reader.GetString("name");
if (i > 0)
{
waiting_recieve += "\n" + book_name + " | " + code;
}
else
{
waiting_recieve = book_name + " | " + code;
}
waiting_recive_book_lbl.Text = waiting_recieve;
DatabaseProcess.conn_close();
}
}
}
catch (Exception)
{
}
}
private void students_Load(object sender, EventArgs e)
{
update_btn.Enabled = false;
string query, name;
int id;
query = "SELECT id,name FROM faculty";
try
{
DatabaseProcess.conn_open();
MySqlCommand cmd = new MySqlCommand(query, DatabaseProcess.myconn);
MySqlDataReader dt_reader = cmd.ExecuteReader();
while (dt_reader.Read())
{
name = dt_reader.GetString("name");
id = dt_reader.GetInt32("id");
faculty_cmbx.Items.Add(name);
list_faculty.Add(new faculty(id, name));
}
DatabaseProcess.conn_close();
}
catch
{}
}
private void faculty_cmbx_SelectedIndexChanged(object sender, EventArgs e)
{
department_cmbx.Items.Clear();
string query, name;
int id, faculty_id, index;
index = faculty_cmbx.SelectedIndex;
faculty_id = list_faculty[index].Id;
query = "SELECT id,name FROM department WHERE faculty_id={0}";
query = string.Format(query, faculty_id);
try
{
DatabaseProcess.conn_open();
MySqlCommand cmd = new MySqlCommand(query, DatabaseProcess.myconn);
MySqlDataReader dt_reader = cmd.ExecuteReader();
while (dt_reader.Read())
{
name = dt_reader.GetString("name");
id = dt_reader.GetInt32("id");
department_cmbx.Items.Add(name);
list_department.Add(new department(id, name));
}
DatabaseProcess.conn_close();
}
catch
{ }
}
private void faculty_cmbx_SelectedIndexChanged(object sender, EventArgs e)
{
department_cmbx.Items.Clear();
int index, id;
string faculty_id, query, value, name;
index = faculty_cmbx.SelectedIndex;
faculty_id = Utils.faculty_list[index].Id.ToString();
query = "SELECT id, name FROM department WHERE faculty_id={0};";
query = string.Format(query, faculty_id);
DatabaseProcess.conn_open();
MySqlCommand cmd = new MySqlCommand(query, DatabaseProcess.myconn);
MySqlDataReader dt_reader = cmd.ExecuteReader();
while (dt_reader.Read())
{
id = dt_reader.GetInt32("id");
name = dt_reader.GetString("name");
value = id.ToString() + " - " + name;
department_cmbx.Items.Add(value);
list_department.Add(new department(id, name));
}
DatabaseProcess.conn_close();
}
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 student_search_txtbx_TextChanged(object sender, EventArgs e)
{
student_result_lstbx.Items.Clear();
string query = "SELECT * FROM student WHERE {0}";
string search_with_name = " concat_ws(' ',name, surname) like '%{0}%'";
string search_with_number = "number={0}";
if (student_search_txtbx.Text.Length > 2)
{
list_student.Clear();
string name, surname = "", string_number;
int number, id;
if (student_search_txtbx.Text.Any(char.IsLetter))
{
name = student_search_txtbx.Text;
query = string.Format(query, search_with_name);
query = string.Format(query, name);
}
else
{
string_number = student_search_txtbx.Text;
query = string.Format(query, search_with_number);
query = string.Format(query, string_number);
}
try
{
DatabaseProcess.conn_open();
MySqlCommand cmd = new MySqlCommand(query, DatabaseProcess.myconn);
MySqlDataReader dt_reader = cmd.ExecuteReader();
while (dt_reader.Read())
{
id = dt_reader.GetInt32("id");
name = dt_reader.GetString("name");
surname = dt_reader.GetString("surname");
number = dt_reader.GetInt32("number");
string_number = number.ToString();
list_student.Add(new student(id));
student_result_lstbx.Items.Add(name + " " + surname + " | " + string_number);
}
DatabaseProcess.conn_close();
}
catch { }
if (student_result_lstbx.Items.Count == 0)
{
student_result_lstbx.Items.Add("Eşleşme yok");
}
} //if
else
{
student_result_lstbx.Items.Add("Arama için en az 3 karakter girmelisiniz.");
}
}//student_search_txtbx_TextChanged
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 receive_it_btn_Click(object sender, EventArgs e)
{
string query;
Boolean result;
query = "UPDATE lend_book SET recieve_case=1,delivery_date=NOW() WHERE id={0};";
query = string.Format(query, lend_book_id);
result = DatabaseProcess.update(query);
if (result)
{
MessageBox.Show("Kitap alındı");
this.Close();
}
else
{
MessageBox.Show("Bir sorun oluştu");
}
}
public DataResultArgs <bool> InsertOrUpdatePaymentType(string encryptId, PaymentTypeEntity paymentTypeEntity)
{
DatabaseProcess currentProcess = DatabaseProcess.Add;
paymentTypeEntity.Id = 0;
if (!string.IsNullOrEmpty(encryptId))
{
int.TryParse(Cipher.Decrypt(encryptId), out var id);
if (id > 0)
{
currentProcess = DatabaseProcess.Update;
}
paymentTypeEntity.Id = id;
}
paymentTypeEntity.DatabaseProcess = currentProcess;
return(new PaymentTypeBusiness().Set_PaymentType(paymentTypeEntity));
}
public static void list_faculty()
{
faculty_list.Clear();
int new_id;
string new_name;
string query = "SELECT id,name FROM faculty;";
DatabaseProcess.conn_open();
MySqlCommand cmd = new MySqlCommand(query, DatabaseProcess.myconn);
MySqlDataReader dt_reader = cmd.ExecuteReader();
while (dt_reader.Read())
{
new_id = dt_reader.GetInt32("id");
new_name = dt_reader.GetString("name");
faculty_list.Add(new faculty(new_id, new_name));
}
DatabaseProcess.conn_close();
}
private void giris_btn_Click(object sender, EventArgs e)
{
string email, password;
email = email_txtbx.Text;
password = psswrd_txtbx.Text;
string hash = Utils.get_hash(password);
string query = "SELECT * FROM User WHERE email='" + email + "' and password='******';";
try
{
DatabaseProcess.conn_open();
MySqlCommand cmd = new MySqlCommand(query, DatabaseProcess.myconn);
MySqlDataReader dt_reader = cmd.ExecuteReader();
if (dt_reader.Read())
{
Utils.User.id = dt_reader.GetInt32("id");
Utils.User.name = dt_reader.GetString("name");
Utils.User.surname = dt_reader.GetString("surname");
int id = dt_reader.GetInt32("id");
main_panel main_panel_form = new main_panel();
main_panel_form.show_singin = this;
this.Visible = false;
main_panel_form.Show();
}
else
{
msg_lbl.Text = "Email, parola combinasyonu bulunamadı. Bilgileri kontrol ediniz.";
}
DatabaseProcess.conn_close();
}
catch (Exception)
{
}
}
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 book_search_txtbx_TextChanged(object sender, EventArgs e)
{
// Keys ile arama çalışmıyo!!
book_result_lstbx.Items.Clear();
int recieve_case;
int id;
string search, name, author, code;
string query = "SELECT * FROM book WHERE {0}";
string search_with_name = "name LIKE '%{0}%' OR code LIKE '%{1}%' OR ISBN_number LIKE '%{2}%' OR author LIKE '%{3}%';";
string query2 = "SELECT recieve_case FROM lend_book WHERE book_id={0}" +
" AND lend_date=(SELECT MAX(lend_date) FROM lend_book WHERE book_id={0});";
string query3;
string[] temp;
if (book_search_txtbx.Text.Length > 2)
{
list_book.Clear();
search = book_search_txtbx.Text;
query = string.Format(query, search_with_name);
query = string.Format(query, search, search, search, search);
try
{
DatabaseProcess.conn_open();
MySqlCommand cmd = new MySqlCommand(query, DatabaseProcess.myconn);
MySqlDataReader dt_reader = cmd.ExecuteReader();
while (dt_reader.Read())
{
id = dt_reader.GetInt32("id");
name = dt_reader.GetString("name").ToUpper();
author = dt_reader.GetString("author");
code = dt_reader.GetString("code");
list_book.Add(new book(id));
book_result_lstbx.Items.Add(name + " | " + author + " | " + code);
}
DatabaseProcess.conn_close();
}
catch
{ }
if (book_result_lstbx.Items.Count <= 0)
{
book_result_lstbx.Items.Add("Eşleşen kayıt yok");
}
else if (book_search_txtbx.Text.Length > 2)
{
// Start with ">>>" substring which books on students
temp = new string[list_book.Count];
for (int i = 0; i < list_book.Count; i++)
{
temp[i] = book_result_lstbx.Items[i].ToString();
}
book_result_lstbx.Items.Clear();
for (int i = 0; i < list_book.Count; i++)
{
query3 = string.Format(query2, list_book[i].Id.ToString());
DatabaseProcess.conn_open();
MySqlCommand cmd2 = new MySqlCommand(query3, DatabaseProcess.myconn);
MySqlDataReader dt_reader2 = cmd2.ExecuteReader();
if (dt_reader2.Read())
{
recieve_case = dt_reader2.GetByte("recieve_case");
if (recieve_case == 0)
{
temp[i] = "<!> | " + temp[i];
}
}
book_result_lstbx.Items.Add(temp[i]);
DatabaseProcess.conn_close();
}
}
}//if(book_search_txtbx.Text.Length > 2)
else
{
book_result_lstbx.Items.Add("Arama için en az 3 karakter girmelisiniz.");
}
}
private void singup_Load(object sender, EventArgs e)
{
gsm_txtbx.Text = "0";
error_lbl.Text = "";
//// create database /////
//try
//{
Boolean result = DatabaseProcess.conn_open();
if (!result)
{
string connline = "server=127.0.0.1;port=3306;user id=root;password=1234";
string query = "CREATE DATABASE library";
MySqlConnection conn = new MySqlConnection(connline);
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
cmd.CommandText = query;
cmd.Connection.Open();
try
{
cmd.ExecuteNonQuery();
query = "use library; CREATE TABLE book (id int(11) NOT NULL,code varchar(45) NOT NULL,name varchar(45) NOT NULL,category varchar(45) NOT NULL,published_year int(11) NOT NULL,ISBN_number varchar(45) NOT NULL,page_count int(11) NOT NULL,search_keys varchar(250) NOT NULL,author varchar(45) NOT NULL,PRIMARY KEY (id),UNIQUE KEY id_UNIQUE (id),UNIQUE KEY code_UNIQUE (code));";
DatabaseProcess.conn_open();
cmd = new MySqlCommand(query, DatabaseProcess.myconn);
cmd.ExecuteNonQuery();
DatabaseProcess.conn_close();
query = "CREATE TABLE faculty (" +
"id int(11) NOT NULL," +
"name varchar(100) NOT NULL," +
"create_time datetime NOT NULL," +
"PRIMARY KEY (id)," +
"UNIQUE KEY id_UNIQUE (id)," +
"UNIQUE KEY name_UNIQUE (name))";
cmd = new MySqlCommand(query, DatabaseProcess.myconn);
DatabaseProcess.conn_open();
cmd.ExecuteNonQuery();
DatabaseProcess.conn_close();
query = "CREATE TABLE department (" +
"id int(11) NOT NULL," +
"faculty_id int(11) NOT NULL," +
"name varchar(100) NOT NULL," +
"create_date datetime NOT NULL," +
"PRIMARY KEY (id)," +
"UNIQUE KEY id_UNIQUE (id)," +
"UNIQUE KEY name_UNIQUE (name)," +
"KEY fakulty_id_idx (faculty_id)," +
"CONSTRAINT fakulty_id FOREIGN KEY (faculty_id) " +
"REFERENCES faculty (id) ON UPDATE NO ACTION)";
cmd = new MySqlCommand(query, DatabaseProcess.myconn);
DatabaseProcess.conn_open();
cmd.ExecuteNonQuery();
DatabaseProcess.conn_close();
query = "CREATE TABLE student (" +
"id int(11) NOT NULL," +
"number int(11) NOT NULL," +
"name varchar(45) NOT NULL," +
"surname varchar(45) NOT NULL," +
"adress varchar(255) NOT NULL," +
"hometown_address varchar(255) NOT NULL," +
"gsm varchar(11) NOT NULL," +
"department_id int(11) NOT NULL," +
"PRIMARY KEY (id)," +
" UNIQUE KEY id_UNIQUE (id)," +
"UNIQUE KEY number_UNIQUE (number)," +
"UNIQUE KEY gsm_number_UNIQUE (gsm)," +
"KEY department_id_idx (department_id)," +
"CONSTRAINT department_id FOREIGN KEY (department_id) REFERENCES department (id) ON DELETE NO ACTION ON UPDATE NO ACTION)";
cmd = new MySqlCommand(query, DatabaseProcess.myconn);
DatabaseProcess.conn_open();
cmd.ExecuteNonQuery();
DatabaseProcess.conn_close();
query = "CREATE TABLE user (" +
"id int(11) NOT NULL," +
"name varchar(45) NOT NULL," +
"surname varchar(45) NOT NULL," +
"singup_date datetime NOT NULL," +
"gsm varchar(11) NOT NULL," +
"email varchar(45) NOT NULL," +
"password varchar(255) NOT NULL," +
"PRIMARY KEY (id)," +
" UNIQUE KEY id_UNIQUE (id)," +
" UNIQUE KEY tel_UNIQUE (gsm)," +
" UNIQUE KEY email_UNIQUE (email))";
cmd = new MySqlCommand(query, DatabaseProcess.myconn);
DatabaseProcess.conn_open();
cmd.ExecuteNonQuery();
DatabaseProcess.conn_close();
query = "CREATE TABLE lend_book (" +
"id int(11) NOT NULL," +
"student_id int(11) NOT NULL," +
"book_id int(11) NOT NULL," +
"recieve_by_id int(11) DEFAULT NULL," +
"lend_date datetime NOT NULL," +
"expiry_date datetime NOT NULL," +
"delivery_date datetime DEFAULT NULL," +
"recieve_case tinyint(1) DEFAULT 0," +
"PRIMARY KEY (id)," +
"UNIQUE KEY id_UNIQUE (id)," +
"KEY student_id_idx (student_id)," +
"KEY book_id_idx (book_id)," +
"KEY recieve_by_id_idx (recieve_by_id)," +
"CONSTRAINT book_id FOREIGN KEY (book_id) REFERENCES book (id) ON DELETE NO ACTION ON UPDATE NO ACTION," +
"CONSTRAINT recieve_by_id FOREIGN KEY (recieve_by_id) REFERENCES user (id) ON DELETE NO ACTION ON UPDATE NO ACTION," +
"CONSTRAINT student_id FOREIGN KEY (student_id) REFERENCES student (id) ON DELETE NO ACTION ON UPDATE NO ACTION) ";
cmd = new MySqlCommand(query, DatabaseProcess.myconn);
DatabaseProcess.conn_open();
cmd.ExecuteNonQuery();
DatabaseProcess.conn_close();
}
catch (Exception)
{
}
}
else
{
DatabaseProcess.conn_close();
}
//}
//catch
//{
// MessageBox.Show("Hata verdi");
//}
}
private void btnDisable_Click(object sender, EventArgs e)
{
var userID = int.Parse(txtID.Text);
DatabaseProcess database = new DatabaseProcess();
}
private void processToDatabase(DatabaseProcess databaseProcess)
{
StudentEntity entity = new StudentEntity();
entity.DatabaseProcess = databaseProcess;
entity.Id = GeneralFunctions.GetData <Int32>(hdnId.Value);
entity.CitizenshipNumber = txtTckn.Text;
entity.Name = txtName.Text;
entity.Surname = txtSurname.Text;
entity.MiddleName = txtMiddleName.Text;
entity.FatherName = txtFatherName.Text;
entity.MotherName = txtMotherName.Text;
if (!string.IsNullOrEmpty(txtBirthday.Text))
{
entity.Birthday = GeneralFunctions.GetData <DateTime>(txtBirthday.Text);
}
entity.FatherPhoneNumber = txtFatherPhoneNumber.Text;
entity.MotherPhoneNumber = txtMotherPhoneNumber.Text;
entity.IsActive = chcIsActive.Checked;
entity.IsStudent = drpStudentState.SelectedValue == "0";
entity.Notes = txtNotes.Text;
entity.DateOfMeeting = GeneralFunctions.GetData <DateTime>(txtDateOfMeeting.Text);
entity.SpokenPrice = GeneralFunctions.GetData <decimal>(txtSpokenPrice.Text);
entity.Email = txtEmail.Text;
if (entity.DatabaseProcess == DatabaseProcess.Add)
{
entity.IsAddAfterPaymentUnPayment = true;
}
if (hdnStudentState.Value == "1" && entity.IsStudent)
{
entity.IsAddAfterPaymentUnPayment = true;
}
DataResultArgs <StudentEntity> resultSet = business.Set_Student(entity);
if (resultSet.HasError)
{
divInformation.ErrorText = resultSet.ErrorDescription;
return;
}
else
{
if (databaseProcess == DatabaseProcess.Deleted)
{
divInformation.SuccessfulText = RecordMessage.Delete;
pnlBody.Enabled = false;
}
else
{
divInformation.SuccessfulText = (databaseProcess == DatabaseProcess.Add) ? RecordMessage.Add : RecordMessage.Update;
btnSubmit.Text = ButtonText.Submit;
pnlBody.Enabled = false;
if (entity.IsStudent)
{
divInformation.SetAnotherText("<a href = \"PaymentDetail.aspx?Id=" + resultSet.Result.EncryptId + "\">" + paymentDetail + "</a>");
}
else
{
btnPaymentDetail.Visible = false;
}
}
}
}
private void search_btn_Click(object sender, EventArgs e)
{
string query, query2, query3, code, student_id = "", book_id = "", name, surname, number, author, temp = "";
DateTime lend_date, expiry_date, today = DateTime.Today;
int remaining_time;
query = "SELECT id,student_id,lend_date,expiry_date FROM lend_book WHERE book_id={0} AND recieve_case=0;";
query2 = "SELECT name, surname, number FROM student WHERE id={0};";
query3 = "SELECT id,name, author FROM book WHERE code='{0}';";
code = search_txtbx.Text;
query3 = string.Format(query3, code);
try
{
DatabaseProcess.conn_open();
MySqlCommand cmd = new MySqlCommand(query3, DatabaseProcess.myconn);
MySqlDataReader dt_reader = cmd.ExecuteReader();
dt_reader.Read();
book_id = dt_reader.GetInt32("id").ToString();
name = dt_reader.GetString("name");
author = dt_reader.GetString("author");
book_info_lbl.Text = name + " " + author + " | " + code;
DatabaseProcess.conn_close();
}
catch
{}
if (book_id != "")
{
query = string.Format(query, book_id);
try
{
DatabaseProcess.conn_open();
MySqlCommand cmd = new MySqlCommand(query, DatabaseProcess.myconn);
MySqlDataReader dt_reader = cmd.ExecuteReader();
dt_reader.Read();
lend_book_id = dt_reader.GetInt32("id").ToString();
student_id = dt_reader.GetInt32("student_id").ToString();
lend_date = dt_reader.GetDateTime("lend_date");
expiry_date = dt_reader.GetDateTime("expiry_date");
lend_date_lbl.Text = lend_date.ToShortDateString();
remaining_time = (int)today.Subtract(expiry_date).TotalDays;
if (remaining_time <= 0)
{
remaining_time_lbl.Text = Math.Abs((int)remaining_time) + " gün kaldı";
}
else
{
remaining_time_lbl.Text = Math.Abs((int)remaining_time) + " gün geçti";
}
DatabaseProcess.conn_close();
}
catch
{
DatabaseProcess.conn_close();
}
if (student_id != "")
{
query2 = string.Format(query2, student_id);
try
{
DatabaseProcess.conn_open();
MySqlCommand cmd = new MySqlCommand(query2, DatabaseProcess.myconn);
MySqlDataReader dt_reader = cmd.ExecuteReader();
dt_reader.Read();
name = dt_reader.GetString("name");
surname = dt_reader.GetString("surname");
number = dt_reader.GetInt32("number").ToString();
student_info_lbl.Text = name + " " + surname + " | " + number;
DatabaseProcess.conn_close();
}
catch
{ }
groupBox1.Visible = true;
}//if(student_id != "")
else
{
query = "SELECT name FROM book WHERE code='{0}';";
query = string.Format(query, code);
MessageBox.Show(query);
try
{
DatabaseProcess.conn_open();
MySqlCommand cmd = new MySqlCommand(query, DatabaseProcess.myconn);
MySqlDataReader dt_reader = cmd.ExecuteReader();
while (dt_reader.Read())
{
temp = dt_reader.GetString("name");
}
DatabaseProcess.conn_close();
}
catch
{
}
if (temp != "")
{
MessageBox.Show("Bu kitap zaten rafta");
}
else
{
MessageBox.Show("Kitap kodu hatalı!");
}
}
}//if(book_id != "")
else
{
MessageBox.Show("Kitap kodu hatalı!");
}
}//student_search_txtbx_TextChanged
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.";
}
}
}
