private void ListSubDocumentReceiver() { try { grdList.Rows.Clear(); SubDocumentReceiverDB drdb = new SubDocumentReceiverDB(); List <subdocreceiver> DocumentReceivers = drdb.getsubdocreceiverList(); foreach (subdocreceiver drrec in DocumentReceivers) { grdList.Rows.Add(); grdList.Rows[grdList.Rows.Count - 1].Cells["RowID"].Value = drrec.RowID; grdList.Rows[grdList.Rows.Count - 1].Cells["DocumentID"].Value = drrec.DocumentID; grdList.Rows[grdList.Rows.Count - 1].Cells["DocumentName"].Value = drrec.DocumentName; grdList.Rows[grdList.Rows.Count - 1].Cells["EmployeeID"].Value = drrec.EmployeeID; grdList.Rows[grdList.Rows.Count - 1].Cells["Employee"].Value = drrec.EmployeeName; grdList.Rows[grdList.Rows.Count - 1].Cells["SubDocumentID"].Value = drrec.SubDocID; grdList.Rows[grdList.Rows.Count - 1].Cells["Status"].Value = getDocStatusString(drrec.Status); } } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } enableBottomButtons(); pnlDocumentList.Visible = true; }
private void btnSave_Click(object sender, EventArgs e) { try { subdocreceiver drrec = new subdocreceiver(); SubDocumentReceiverDB drDB = new SubDocumentReceiverDB(); try { string[] docmts = txtDocument.Text.Split('-'); string[] emply = txtEmployee.Text.Split('-'); drrec.DocumentID = docmts[1]; drrec.EmployeeID = emply[1]; drrec.SubDocID = ((Structures.ComboBoxItem)cmbSubDOc.SelectedItem).HiddenValue; } catch (Exception) { drrec.DocumentID = ""; drrec.DocumentName = ""; drrec.EmployeeName = ""; drrec.EmployeeID = ""; drrec.SubDocID = ""; } drrec.Status = getStatusCode(cmbStatus.SelectedItem.ToString()); System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button; string btnText = btn.Text; { if (btnText.Equals("Update")) { if (drDB.updateSubdocReceiver(drrec, prevdoc)) { MessageBox.Show("Sub Document Receiver Status updated"); closeAllPanels(); ListSubDocumentReceiver(); } else { MessageBox.Show("Failed to update Document Receiver Status"); } } else if (btnText.Equals("Save")) { if (drDB.validateDocument(drrec)) { if (drDB.insertSubDocumentReceivers(drrec)) { MessageBox.Show("Sub Document Receiver Added"); closeAllPanels(); ListSubDocumentReceiver(); } else { MessageBox.Show("Failed to Insert Sub Document Receiver"); } } else { MessageBox.Show("Sub Document Receiver Validation failed"); } } } } catch (Exception) { MessageBox.Show("Failed Adding / Editing Sub Document Receiver"); } }