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
}
}
