private Hashtable ServiceItemIdTable() { Hashtable ht = new Hashtable(); serviceitem st = new serviceitem(); ServiceItemsDB Serviceitemdb = new ServiceItemsDB(); List <serviceitem> ServiceItems = Serviceitemdb.getServiceItems(); foreach (serviceitem sitem in ServiceItems) { try { string id = sitem.ServiceItemID; string key = id.Substring(0, 6); string value = id.Substring(6, 4); if (ht.ContainsKey(key)) { ht[key] = value; } else { ht.Add(key, value); } } catch (Exception ex) { } } return(ht); }
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 ServiceItemsDB sidb = new ServiceItemsDB(); prevsitem.ForwardUser = approverUID; string s = prevsitem.ForwarderList; prevsitem.ForwarderList = prevsitem.ForwarderList + approverUName + Main.delimiter1 + approverUID + Main.delimiter1 + Main.delimiter2; if (sidb.forwardServiceItem(prevsitem)) { pnlCmtr.Visible = false; pnlCmtr.Controls.Remove(lvApprover); MessageBox.Show("Document Forwarded"); closeAllPanels(); listOption = 1; ListServiceItem(listOption); setButtonVisibility("btnEditPanel"); //activites are same for cance, forward,approce and reverse } } } } } catch (Exception) { } }
private void btnApprove_Click_1(object sender, EventArgs e) { try { ServiceItemsDB Serviceitemdb = new ServiceItemsDB(); DialogResult dialog = MessageBox.Show("Are you sure to Approve the document ?", "Yes", MessageBoxButtons.YesNo); if (dialog == DialogResult.Yes) { if (Serviceitemdb.ApproveServiceItem(prevsitem, id)) { MessageBox.Show("Service Item Approved"); closeAllPanels(); listOption = 1; ListServiceItem(listOption); setButtonVisibility("btnEditPanel"); } } } catch (Exception) { } }
private void btnReverse_Click_1(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(prevsitem.ForwarderList); //do forward activities //prevpopi.CommentStatus = DocCommenterDB.removeUnapprovedCommentStatus(prevpopi.CommentStatus); ServiceItemsDB sidb = new ServiceItemsDB(); if (reverseStr.Trim().Length > 0) { int ind = reverseStr.IndexOf("!@#"); prevsitem.ForwarderList = reverseStr.Substring(0, ind); prevsitem.ForwardUser = reverseStr.Substring(ind + 3); prevsitem.documentStatus = prevsitem.documentStatus - 1; } else { prevsitem.ForwarderList = ""; prevsitem.ForwardUser = ""; prevsitem.documentStatus = 1; } if (sidb.reverseServiceITem(prevsitem)) { MessageBox.Show("Service ITem Reversed"); closeAllPanels(); listOption = 1; ListServiceItem(listOption); setButtonVisibility("btnEditPanel"); //activites are same for cance, forward,approce and reverse } } } catch (Exception ex) { } }
private void ListServiceItem(int option) { try { // pnlActionButtons.Visible = true; lblActionHeader.Visible = true; grdList.Rows.Clear(); txtSearch.Text = ""; forwarderList = demDB.getForwarders(docID, Login.empLoggedIn); approverList = demDB.getApprovers(docID, Login.empLoggedIn); 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"; } ServiceItemsDB Serviceitemdb = new ServiceItemsDB(); List <serviceitem> ServiceItems = Serviceitemdb.getFilteredServiceItems(userString, option); foreach (serviceitem sitem in ServiceItems) { if (option == 1) { if (sitem.documentStatus == 99) { continue; } } else { } grdList.Rows.Add(); grdList.Rows[grdList.RowCount - 1].Cells["ServiceItemID"].Value = sitem.ServiceItemID; grdList.Rows[grdList.RowCount - 1].Cells["Description"].Value = sitem.Name; grdList.Rows[grdList.RowCount - 1].Cells["Group1"].Value = sitem.Group1CodeDescription; grdList.Rows[grdList.RowCount - 1].Cells["Group2"].Value = sitem.Group2CodeDescription; grdList.Rows[grdList.RowCount - 1].Cells["Group3"].Value = sitem.Group3CodeDescription; grdList.Rows[grdList.RowCount - 1].Cells["Group1Code"].Value = sitem.Group1Code; grdList.Rows[grdList.RowCount - 1].Cells["Group2Code"].Value = sitem.Group2Code; grdList.Rows[grdList.RowCount - 1].Cells["Group3Code"].Value = sitem.Group3Code; grdList.Rows[grdList.RowCount - 1].Cells["Status"].Value = sitem.status; grdList.Rows[grdList.RowCount - 1].Cells["DocumentStatus"].Value = sitem.documentStatus; grdList.Rows[grdList.RowCount - 1].Cells["CreateUser"].Value = sitem.CreateUser; grdList.Rows[grdList.RowCount - 1].Cells["HSNCode"].Value = sitem.HSNCode; grdList.Rows[grdList.RowCount - 1].Cells["Creator"].Value = sitem.CreateUserName; grdList.Rows[grdList.RowCount - 1].Cells["Forwarder"].Value = sitem.ForwardUserName; grdList.Rows[grdList.RowCount - 1].Cells["Approver"].Value = sitem.ApproveUserName; grdList.Rows[grdList.RowCount - 1].Cells["ForwarderLists"].Value = sitem.ForwarderList; } } catch (Exception ex) { MessageBox.Show("Error in Service Item listing"); } setButtonVisibility("init"); isTempEdit = false; txtSearch.Visible = true; lblSearch.Visible = true; grdList.Columns["Creator"].Visible = true; grdList.Columns["Forwarder"].Visible = true; grdList.Columns["Approver"].Visible = true; if ((listOption == 6 || listOption == 3) && getuserPrivilegeStatus() != 1) { grdList.Columns["TempEdit"].Visible = true; } else { grdList.Columns["TempEdit"].Visible = false; } pnlList.Visible = true; grdList.Visible = true; }
private void btnSave_Click_1(object sender, EventArgs e) { Boolean status = true; try { serviceitem sitem = new serviceitem(); ServiceItemsDB Serviceitemdb = new ServiceItemsDB(); //cvi.ConversionDate = dtDate.Value; try { sitem.Group1Code = cmbGroup1Select.SelectedItem.ToString().Trim().Substring(0, cmbGroup1Select.SelectedItem.ToString().Trim().IndexOf('-')); sitem.Group1CodeDescription = cmbGroup1Select.SelectedItem.ToString().Trim().Substring(cmbGroup1Select.SelectedItem.ToString().Trim().IndexOf('-') + 1); } catch (Exception) { sitem.Group1Code = ""; sitem.Group1CodeDescription = ""; } try { sitem.Group2Code = cmbGroup2Select.SelectedItem.ToString().Trim().Substring(0, cmbGroup2Select.SelectedItem.ToString().Trim().IndexOf('-')); sitem.Group2CodeDescription = cmbGroup2Select.SelectedItem.ToString().Trim().Substring(cmbGroup2Select.SelectedItem.ToString().Trim().IndexOf('-') + 1); } catch (Exception) { sitem.Group2Code = ""; sitem.Group2CodeDescription = ""; } try { sitem.Group3Code = cmbGroup3Select.SelectedItem.ToString().Trim().Substring(0, cmbGroup3Select.SelectedItem.ToString().Trim().IndexOf('-')); sitem.Group3CodeDescription = cmbGroup3Select.SelectedItem.ToString().Trim().Substring(cmbGroup3Select.SelectedItem.ToString().Trim().IndexOf('-') + 1); } catch (Exception) { sitem.Group3Code = ""; sitem.Group3CodeDescription = ""; } //sitem.ServiceItemID = CreateServiceItemID(itc); sitem.Name = txtName.Text; sitem.ForwarderList = prevsitem.ForwarderList; sitem.HSNCode = txtHSNCode1.Text; System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button; string btnText = btn.Text; if (btnText.Equals("Update")) { if (isTempEdit) { sitem.status = getStatusCode(cmbStatus.SelectedItem.ToString()); } else { sitem.status = 0; } } if (Serviceitemdb.validateServiceItem(sitem)) { if (btnText.Equals("Update")) { if (Serviceitemdb.updateServiceItem(sitem, prevsitem)) { MessageBox.Show("Service Item updated"); closeAllPanels(); listOption = 1; ListServiceItem(listOption); } else { status = false; MessageBox.Show("Failed to Update Service Item"); } } else if (btnText.Equals("Save")) { sitem.documentStatus = 1;//created if (Serviceitemdb.insertServiceItem(sitem)) { MessageBox.Show("Service Item Added"); closeAllPanels(); listOption = 1; ListServiceItem(listOption); } else { status = false; MessageBox.Show("Failed to Insert Service Item"); } } } else { MessageBox.Show("Service Item Data Validation failed"); } } catch (Exception ex) { MessageBox.Show("Failed Adding / Editing Service Item"); } if (status) { setButtonVisibility("btnEditPanel"); //activites are same for cancel, forward,approve, reverse and save } }