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 grdList_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
{
try
{
// pnlActionButtons.Visible = false;
lblActionHeader.Visible = false;
if (e.RowIndex < 0)
{
return;
}
string columnName = grdList.Columns[e.ColumnIndex].Name;
if (columnName.Equals("Edit") || columnName.Equals("Approve") || columnName.Equals("LoadDocument") ||
columnName.Equals("View") || columnName.Equals("ViewDocument") || columnName.Equals("TempEdit"))
{
clearData();
setButtonVisibility(columnName);
prevsitem = new serviceitem();
int rowID = e.RowIndex;
txtSearch.Visible = false;
lblSearch.Visible = false;
try
{
prevsitem.ServiceItemID = grdList.Rows[e.RowIndex].Cells["ServiceItemID"].Value.ToString();
prevsitem.Name = grdList.Rows[e.RowIndex].Cells["Description"].Value.ToString();
prevsitem.documentStatus = Convert.ToInt32(grdList.Rows[e.RowIndex].Cells["DocumentStatus"].Value.ToString());
prevsitem.CreateUser = grdList.Rows[e.RowIndex].Cells["CreateUser"].Value.ToString();
prevsitem.ForwarderList = grdList.Rows[e.RowIndex].Cells["ForwarderLists"].Value.ToString();
prevsitem.HSNCode = grdList.Rows[e.RowIndex].Cells["HSNCode"].Value.ToString();
}
catch (Exception ez)
{
}
//--------Load Documents
if (columnName.Equals("LoadDocument"))
{
string hdrString = "ServiceItemID" + prevsitem.ServiceItemID + "\n" +
"ServiceItem name:" + prevsitem.Name;
string dicDir = Main.documentDirectory + "\\" + docID;
string subDir = prevsitem.ServiceItemID + "-" + prevsitem.Name;
FileManager.LoadDocuments load = new FileManager.LoadDocuments(dicDir, subDir, docID, hdrString);
load.ShowDialog();
this.RemoveOwnedForm(load);
btnCancel_Click_1(null, null);
return;
}
//--------
if (columnName.Equals("ViewDocument"))
{
return;
}
if (columnName.Equals("TempEdit"))
{
lblStatus.Visible = true;
cmbStatus.Visible = true;
isTempEdit = true;
cmbStatus.SelectedIndex = cmbStatus.
FindString(getStatusString(Convert.ToInt32(grdList.Rows[e.RowIndex].Cells["Status"].Value)));
}
btnSave.Text = "Update";
//dtDate.Value = DateTime.Parse(grdList.Rows[e.RowIndex].Cells[0].Value.ToString());
txtServiceItemID.Text = grdList.Rows[e.RowIndex].Cells[0].Value.ToString();
txtName.Text = grdList.Rows[e.RowIndex].Cells[1].Value.ToString();
txtHSNCode1.Text = grdList.Rows[e.RowIndex].Cells["HSNCode"].Value.ToString();
cmbGroup1Select.SelectedIndex = cmbGroup1Select.FindString(grdList.Rows[e.RowIndex].Cells["Group1Code"].Value.ToString());
cmbGroup2Select.SelectedIndex = cmbGroup2Select.FindString(grdList.Rows[e.RowIndex].Cells["Group2Code"].Value.ToString());
cmbGroup3Select.SelectedIndex = cmbGroup3Select.FindString(grdList.Rows[e.RowIndex].Cells["Group3Code"].Value.ToString());
if (columnName.Equals("Approve"))
{
string gd1 = cmbGroup1Select.SelectedItem.ToString().Trim().Substring(0, cmbGroup1Select.SelectedItem.ToString().Trim().IndexOf('-'));
string gd2 = cmbGroup2Select.SelectedItem.ToString().Trim().Substring(0, cmbGroup2Select.SelectedItem.ToString().Trim().IndexOf('-'));
string gd3 = cmbGroup3Select.SelectedItem.ToString().Trim().Substring(0, cmbGroup3Select.SelectedItem.ToString().Trim().IndexOf('-'));
string itc = gd1 + gd2 + gd3;
id = CreateServiceItemID(itc);
}
pnlCVINRInner.Visible = true;
pnlCVINROuter.Visible = true;
pnlList.Visible = false;
}
}
catch (Exception ex)
{
}
}
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
}
}
