public phones[] getMultiPhone() { phones[] request_phone = new phones[getCountMultiPhone()]; SQLiteConnection connection = openConnection(); string query = "SELECT * FROM phone ORDER BY id_notebook;"; SQLiteCommand Command = new SQLiteCommand(query, connection); SQLiteDataReader reader = Command.ExecuteReader(); int i = 0; while (reader.Read()) { request_phone[i].id = Convert.ToInt32(reader["id"]); request_phone[i].id_notebook = Convert.ToInt32(reader["id_notebook"]); request_phone[i].phone = reader["phone"].ToString(); request_phone[i].note = reader["note"].ToString(); i++; } reader.Close(); closeConnection(ref connection); return(request_phone); }
public phones[] getSinglePhone(int id) { // Получаем номера текущей записи phones[] request_phone = new phones[getCountPhone(id)];; request_phone[0].id = 0; request_phone[0].id_notebook = id; request_phone[0].phone = ""; request_phone[0].note = ""; SQLiteConnection connection = openConnection(); string query = "SELECT * FROM phone WHERE id_notebook =" + id + " limit 4;"; SQLiteCommand Command = new SQLiteCommand(query, connection); SQLiteDataReader reader = Command.ExecuteReader(); int i = 0; while (reader.Read()) { request_phone[i].id = Convert.ToInt32(reader["id"]); request_phone[i].phone = reader["phone"].ToString(); request_phone[i].note = reader["note"].ToString(); i++; } reader.Close(); closeConnection(ref connection); return(request_phone); }
private void edit_Click(object sender, EventArgs e) { notebooks request; request.id = id; request.firstname = firstname.Text; request.secondname = secondname.Text; request.lastname = lastname.Text; request.sex = sex; request.date = date.Value; request.job = job.Text; request.position = position.Text; request.more = more.Text; addresss addressRequest; addressRequest.id = 0; addressRequest.id_notebook = id; addressRequest.address = address.Text; addressRequest.city = city.Text; addressRequest.state = state.Text; addressRequest.country = country.Text; addressRequest.postal = postal.Text; phones[] phoneRequest = new phones[4]; for (int i = 0; i < 4; i++) { Control[] temp = phone.Controls.Find("phone" + (i + 1), true); phoneRequest[i].id_notebook = id; phoneRequest[i].phone = temp[0].Text; temp = phone.Controls.Find("note" + (i + 1), true); phoneRequest[i].note = temp[0].Text; } if (id > 0) { note.setSingleNote(request); // Изменить текущую запись note.setSingleNote(addressRequest); note.setSingleNote(phoneRequest); } else { note.addSingleNote(request); // Добавить новую запись addressRequest.id_notebook = note.getLastId(); for (int i = 0; i < 4; i++) { phoneRequest[i].id_notebook = addressRequest.id_notebook; } note.addSingleNote(addressRequest); note.setSingleNote(phoneRequest); } Form1.refresh = true; this.Close(); }
private void Form1_Load(object sender, EventArgs e) { int size = note.getCountNote(); notebooks[] answer = new notebooks[size]; phones[] phoneAnswer = new phones[note.getCountMultiPhone()]; answer = note.getMultiNote(size); phoneAnswer = note.getMultiPhone(); createFormObject(size, answer, phoneAnswer); }
private void refreshForm() { if (refresh == true) { notes.Controls.Clear(); int size = note.getCountNote(); notebooks[] answer = new notebooks[size]; phones[] phoneAnswer = new phones[note.getCountMultiPhone()]; answer = note.getMultiNote(size); phoneAnswer = note.getMultiPhone(); createFormObject(size, answer, phoneAnswer); refresh = false; } }