private void frmDetails_Loaded(object sender, RoutedEventArgs e) { lblId.Visibility = Visibility.Hidden; Details doc = task.AllDetails(Id); OpenWindow(doc); }
private void btnModify_MouseUp(object sender, MouseButtonEventArgs e) { if (string.IsNullOrEmpty(txtClass.Text) || string.IsNullOrEmpty(txtTitle.Text) || string.IsNullOrEmpty(txtType.Text) || dtpDate.SelectedDate == null || dtpSubmission.SelectedDate == null) { return; } else if ((string.IsNullOrEmpty(txtSubBy.Text) && string.IsNullOrEmpty(txtSurBra.Text)) || (string.IsNullOrEmpty(txtSubTo.Text) && string.IsNullOrEmpty(txtSudBra.Text))) { return; } Details det = new Details() { Datee = dtpDate.SelectedDate.Value.Date, Title = txtTitle.Text, Clas = txtClass.Text, Type = txtType.Text, State = cmbState.SelectionBoxItem.ToString(), Author = txtAuthor.Text, Status = cmbStatus.SelectionBoxItem.ToString(), DocNumber = txtDocNo.Text, RepliedNumber = txtReplied.Text, Description = txtDesc.Text, SubDatee = dtpSubmission.SelectedDate.Value.Date, SubmittedBy = txtSubBy.Text, SubmittedTo = txtSubTo.Text, SubmitterBranch = txtSurBra.Text, SubmittedBranch = txtSudBra.Text, RoomNo = txtRoomNo.Text, ShelfNo = txtShelfNo.Text, FileNo = txtFileNo.Text, Borrower = txtBorrower.Text, DigitalCopy = selected.DigitalCopy, }; OleDbConnection conn = new OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0; Data Source = " + System.IO.Path.GetDirectoryName(System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName) + @"\document.accdb;Persist Security Info=False;"); Details selectedd = task.AllDetails(selected.Id); if (task.EditCheckDocNo(det, selectedd) == true) { if (string.IsNullOrEmpty(det.RepliedNumber) == true || task.CheckReply(det) == true) { try { conn.Open(); OleDbCommand update1 = new OleDbCommand("UPDATE Details SET Datee=@Datee, Title=@Title, Clas=@Clas, Type=@Type, State=@State, Author=@Author, Status=@Status, DocNumber=@DocNumber, RepliedNumber=@RepliedNumber, Description=@Description, DigitalCopy=@DigitalCopy WHERE Id=@Id", conn); OleDbCommand update2 = new OleDbCommand("UPDATE Submission SET SubDatee=@SubDatee, SubmittedBy=@SubmittedBy, SubmittedTo=@SubmittedTo, SubmitterBranch=@SubmitterBranch, SubmittedBranch=@SubmittedBranch WHERE Id=@Id", conn); OleDbCommand update3 = new OleDbCommand("UPDATE Location SET RoomNo=@RoomNo, ShelfNo=@ShelfNo, FileNo=@FileNo, Borrower=@Borrower WHERE Id=@Id", conn); update1.Parameters.AddWithValue("Datee", OleDbType.Date).Value = det.Datee; update1.Parameters.AddWithValue("Title", OleDbType.VarChar).Value = det.Title; update1.Parameters.AddWithValue("Clas", OleDbType.VarChar).Value = det.Clas; update1.Parameters.AddWithValue("Type", OleDbType.VarChar).Value = det.Type; update1.Parameters.AddWithValue("State", OleDbType.VarChar).Value = det.State; update1.Parameters.AddWithValue("Author", OleDbType.VarChar).Value = det.Author;; update1.Parameters.AddWithValue("Status", OleDbType.VarChar).Value = det.Status; update1.Parameters.AddWithValue("DocNumber", OleDbType.VarChar).Value = det.DocNumber; update1.Parameters.AddWithValue("RepliedNumber", OleDbType.VarChar).Value = det.RepliedNumber; update1.Parameters.AddWithValue("Description", OleDbType.LongVarChar).Value = det.Description; update1.Parameters.AddWithValue("DigitalCopy", OleDbType.VarChar).Value = det.DigitalCopy; update1.Parameters.AddWithValue("Id", selected.Id); update2.Parameters.AddWithValue("Datee", det.SubDatee); update2.Parameters.AddWithValue("SubmittedBy", det.SubmittedBy); update2.Parameters.AddWithValue("SubmittedTo", det.SubmittedTo); update2.Parameters.AddWithValue("SubmitterBranch", det.SubmitterBranch); update2.Parameters.AddWithValue("SubmittedBranch", det.SubmittedBranch); update2.Parameters.AddWithValue("Id", selected.Id); update3.Parameters.AddWithValue("RoomNo", det.RoomNo); update3.Parameters.AddWithValue("ShelfNo", det.ShelfNo); update3.Parameters.AddWithValue("FileNo", det.FileNo); update3.Parameters.AddWithValue("Borrower", det.Borrower); update3.Parameters.AddWithValue("Id", selected.Id); update1.ExecuteNonQuery(); update2.ExecuteNonQuery(); update3.ExecuteNonQuery(); conn.Close(); Close(); } catch (Exception ex) { conn.Close(); MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } } else { MessageBox.Show("There is no document number like written in 'Reply Document Number'", "Reply Document Number Doesn't Exist", MessageBoxButton.OK, MessageBoxImage.Information); imgReply.Source = new BitmapImage(new Uri(@"\lib\docno.png", UriKind.Relative)); } } else { if (string.IsNullOrEmpty(det.DocNumber)) { MessageBox.Show("This Document Already Saved", "Dublication Document Information", MessageBoxButton.OK, MessageBoxImage.Information); } else { MessageBox.Show("The Document Number* Already Saved", "Dublication Document Number", MessageBoxButton.OK, MessageBoxImage.Information); imgDocNumber.Source = new BitmapImage(new Uri(@"\lib\docno.png", UriKind.Relative)); } } }