private void shortcut_Click(object sender, RoutedEventArgs e) { ViewStudent viewStudent = new ViewStudent(); (this.Parent as Grid).Children.Add(viewStudent); (this.Parent as Grid).Children.Remove(this); }
private void save_Click(object sender, RoutedEventArgs e) { try { SQLiteConnection conn; conn = new SQLiteConnection(@"Data Source=Database\MainDatabase.db;Version=3;"); conn.Open(); if (student_name.Text == "" || contact_no1.Text == "" || reg_no.Text == "" || batch.Text == "") { MessageBox.Show("Student Name, Contact number, Registration Number and Batch are mandatory."); return; } Int64 temp; if (!(Int64.TryParse(contact_no1.Text, out temp))) { MessageBox.Show("Enter proper contact number"); return; } string sql, sql2; if (updateStudent == null) { sql = "INSERT INTO student( student_name, contact_no1, studying_at, studying_at_name, address, student_email, parent_name, contact_no2, reg_no, batch, subjects, other_details, balance_fees) VALUES('" + student_name.Text + "', '" + contact_no1.Text + "', '" + studying_at.Text + "', '" + studying_at_name.Text + "', '" + address.Text + "', '" + student_email.Text + "', '" + parent_name.Text + "', '" + contact_no2.Text + "', '" + reg_no.Text + "', '" + batch.Text + "', '" + subjects.Text + "', '" + other_details.Text + "', '" + balance_fees.Text + "');"; Student student = new Student(); student.Name = student_name.Text; student.RegNo = reg_no.Text; string json = JsonConvert.SerializeObject(student); sql2 = "INSERT INTO attendance VALUES('" + reg_no.Text + "', '" + json + "', '" + json + "', '" + json + "', '" + json + "', '" + json + "', '" + json + "', '" + json + "', '" + json + "', '" + json + "', '" + json + "', '" + json + "', '" + json + "');"; } else { sql = "update student set student_name='" + student_name.Text + "', contact_no1 ='" + contact_no1.Text + "', studying_at ='" + studying_at.Text + "', studying_at_name='" + studying_at_name.Text + "', address='" + address.Text + "', student_email='" + student_email.Text + "', parent_name= '" + parent_name.Text + "', contact_no2='" + contact_no2.Text + "', reg_no='" + reg_no.Text + "', batch='" + batch.Text + "', subjects='" + subjects.Text + "', other_details= '" + other_details.Text + "', balance_fees='" + balance_fees.Text + "' where reg_no='" + updateStudent + "';"; sql2 = "UPDATE attendance SET reg_no='" + reg_no.Text + "' WHERE reg_no='" + updateStudent + "';"; } SQLiteCommand command = new SQLiteCommand(sql, conn); command.ExecuteNonQuery(); command = new SQLiteCommand(sql2, conn); command.ExecuteNonQuery(); conn.Close(); student_name.Text = contact_no1.Text = address.Text = studying_at.Text = ""; studying_at_name.Text = student_email.Text = parent_name.Text = contact_no2.Text = reg_no.Text = ""; batch.Text = subjects.Text = other_details.Text = balance_fees.Text = ""; if (updateStudent == null) { //MessageBox.Show("Saved"); MessageBox.Show("Saved"); } else { ViewStudent vwstud = new ViewStudent(); vwstud.FillDataGrid(); (this.Parent as Grid).Children.Add(vwstud); (this.Parent as Grid).Children.Remove(this); } } catch (SQLiteException) { MessageBox.Show("Please check input again (Reg no might already be in use)"); } catch (Exception ex) { string msg = ex.GetType().Name + " : " + ex.Message; MessageBox.Show(msg); } }