private void btnApprove_Click(object sender, EventArgs e) { try { CurrencyVsINRDB cvinrDB = new CurrencyVsINRDB(); DialogResult dialog = MessageBox.Show("Are you sure to Approve the document ?", "Yes", MessageBoxButtons.YesNo); if (dialog == DialogResult.Yes) { if (cvinrDB.ApproveCVINR(prevcvi)) { MessageBox.Show("CVINR Approved"); if (!updateDashBoard(prevcvi, 2)) { MessageBox.Show("DashBoard Fail to update"); } closeAllPanels(); listOption = 1; ListFilteredCVINR(listOption); setButtonVisibility("btnEditPanel"); } } } catch (Exception) { } }
private void ListFilteredCVINR(int option) { try { grdList.Rows.Clear(); forwarderList = demDB.getForwarders(docID, Login.empLoggedIn); approverList = demDB.getApprovers(docID, Login.empLoggedIn); CurrencyVsINRDB dbrecord = new CurrencyVsINRDB(); List <cvinr> CVINRs = dbrecord.getFilteredCVINR(userString, option); if (option == 1) { lblActionHeader.Text = "List of Action Pending Documents"; } else if (option == 2) { lblActionHeader.Text = "List of In-Process Documents"; } else if (option == 3 || option == 6) { lblActionHeader.Text = "List of Approved Documents"; } foreach (cvinr cvi in CVINRs) { if (option == 1) { if (cvi.documentStatus == 99) { continue; } } else { } grdList.Rows.Add(cvi.ConversionDate, cvi.CurrencyID + "-" + cvi.CurrencyName, ComboFIll.getCurrencyConversionTypeString(cvi.type), cvi.INRValue, // ComboFIll.getDocumentStatusString(cvi.documentStatus), cvi.status, cvi.documentStatus, cvi.CreateUser, cvi.ForwardUser, cvi.ApproveUser, cvi.ForwarderList); } } catch (Exception) { MessageBox.Show("Error in CVINR listing"); } setButtonVisibility("init"); pnlCVINRList.Visible = true; grdList.Columns["Creator"].Visible = true; grdList.Columns["Forwarder"].Visible = true; grdList.Columns["Approver"].Visible = true; }
private void btnReverse_Click(object sender, EventArgs e) { try { DialogResult dialog = MessageBox.Show("Are you sure to Reverse the document ?", "Yes", MessageBoxButtons.YesNo); if (dialog == DialogResult.Yes) { string reverseStr = getReverseString(prevcvi.ForwarderList); //do forward activities //prevpopi.CommentStatus = DocCommenterDB.removeUnapprovedCommentStatus(prevpopi.CommentStatus); CurrencyVsINRDB cvinrDB = new CurrencyVsINRDB(); if (reverseStr.Trim().Length > 0) { int ind = reverseStr.IndexOf("!@#"); prevcvi.ForwarderList = reverseStr.Substring(0, ind); prevcvi.ForwardUser = reverseStr.Substring(ind + 3); prevcvi.documentStatus = prevcvi.documentStatus - 1; } else { prevcvi.ForwarderList = ""; prevcvi.ForwardUser = ""; prevcvi.documentStatus = 1; } if (cvinrDB.reverseCVINR(prevcvi)) { MessageBox.Show("CVINR Document Reversed"); closeAllPanels(); listOption = 1; ListFilteredCVINR(listOption); setButtonVisibility("btnEditPanel"); //activites are same for cance, forward,approce and reverse } } } catch (Exception ex) { } }
private void lvForwardOK_Click(object sender, EventArgs e) { try { int kount = 0; string approverUID = ""; string approverUName = ""; foreach (ListViewItem itemRow in lvApprover.Items) { if (itemRow.Checked) { approverUID = itemRow.SubItems[2].Text; approverUName = itemRow.SubItems[1].Text; kount++; } } if (kount == 0) { MessageBox.Show("Select one approver"); return; } if (kount > 1) { MessageBox.Show("Select only one approver"); return; } else { DialogResult dialog = MessageBox.Show("Are you sure to forward the document ?", "Yes", MessageBoxButtons.YesNo); if (dialog == DialogResult.Yes) { //do forward activities CurrencyVsINRDB cvinrDB = new CurrencyVsINRDB(); prevcvi.ForwardUser = approverUID; string s = prevcvi.ForwarderList; prevcvi.ForwarderList = prevcvi.ForwarderList + approverUName + Main.delimiter1 + approverUID + Main.delimiter1 + Main.delimiter2; if (cvinrDB.forwardCVINR(prevcvi)) { frmPopup.Close(); frmPopup.Dispose(); MessageBox.Show("CVINR Forwarded"); if (!updateDashBoard(prevcvi, 1)) { MessageBox.Show("DashBoard Fail to update"); } closeAllPanels(); pnlForwarder.Controls.Remove(lvApprover); pnlForwarder.Visible = false; listOption = 1; ListFilteredCVINR(listOption); setButtonVisibility("btnEditPanel"); //activites are same for cance, forward,approce and reverse } } } } catch (Exception) { } }
private void btnSave_Click(object sender, EventArgs e) { Boolean status = true; try { cvinr cvi = new cvinr(); CurrencyVsINRDB cvinrDB = new CurrencyVsINRDB(); cvi.ConversionDate = dtDate.Value; try { cvi.CurrencyID = cmbCurrency.SelectedItem.ToString().Trim().Substring(0, cmbCurrency.SelectedItem.ToString().Trim().IndexOf('-')); cvi.CurrencyName = cmbCurrency.SelectedItem.ToString().Trim().Substring(cmbCurrency.SelectedItem.ToString().Trim().IndexOf('-') + 1); cvi.INRValue = float.Parse(txtINRValue.Text); cvi.ForwarderList = prevcvi.ForwarderList; cvi.type = ComboFIll.getCurrencyConversionTypeCode(cmbType.SelectedItem.ToString()); } catch (Exception ex) { status = false; MessageBox.Show("CVINR Data Validation failed"); return; } System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button; string btnText = btn.Text; if (cvinrDB.validateCVINR(cvi)) { //cvi.documentStatus = prevcvi.documentStatus; if (btnText.Equals("Update")) { if (cvinrDB.updateCVINR(cvi, prevcvi)) { MessageBox.Show("CVINR updated"); closeAllPanels(); listOption = 1; ListFilteredCVINR(listOption); } else { status = false; MessageBox.Show("Failed to update CVINR"); } } else if (btnText.Equals("Save")) { cvi.documentStatus = 1;//created if (cvinrDB.insertCVINR(cvi)) { MessageBox.Show("CVINR Added"); closeAllPanels(); listOption = 1; ListFilteredCVINR(listOption); } else { status = false; MessageBox.Show("Failed to Insert CVINR"); } } } else { status = false; MessageBox.Show("CVINR Data Validation failed"); return; } } catch (Exception ex) { status = false; MessageBox.Show("Failed Adding / Editing CVINR"); } if (status) { setButtonVisibility("btnEditPanel"); //activites are same for cancel, forward,approve, reverse and save } }