private void ListEmpFinLimit()
{
try
{
grdList.Rows.Clear();
FinancialLimitDB fdb = new FinancialLimitDB();
List <financiallimit> finList = fdb.getEmpFinancialLimit();
foreach (financiallimit flim in finList)
{
grdList.Rows.Add(flim.DocumentID, flim.DocumentName,
flim.EmployeeName + "-" + flim.EmployeeID, flim.FinancialLimit,
ComboFIll.getStatusString(flim.DocumentStatus));
}
}
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
{
financiallimit flist = new financiallimit();
FinancialLimitDB fdb = new FinancialLimitDB();
try
{
string[] docmts = txtDocument.Text.Trim().Split('-');
string[] emply = txtEmployee.Text.Trim().Split('-');
////////flist.DocumentID = cmbDocument.SelectedItem.ToString().Trim().Substring(0, cmbDocument.SelectedItem.ToString().Trim().IndexOf('-'));
flist.DocumentID = docmts[1];
////////flist.DocumentName = cmbDocument.SelectedItem.ToString().Trim().Substring(cmbDocument.SelectedItem.ToString().Trim().IndexOf('-') + 1);
flist.DocumentName = docmts[0];
//flist.EmployeeName = txtEmployee.Text.Trim().Substring(0, txtEmployee.Text.Trim().IndexOf('-'));
//flist.EmployeeID = txtEmployee.Text.Trim().Substring(txtEmployee.Text.Trim().IndexOf('-') + 1);
flist.EmployeeName = emply[0];
flist.EmployeeID = emply[1];
flist.FinancialLimit = Convert.ToDouble(txtFinancialLimit.Text);
}
catch (Exception ex)
{
flist.DocumentID = "";
flist.DocumentName = "";
flist.EmployeeName = "";
flist.EmployeeID = "";
}
flist.DocumentStatus = ComboFIll.getStatusCode(cmbDocumentStatus.SelectedItem.ToString());
System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button;
string btnText = btn.Text;
{
if (btnText.Equals("Update"))
{
if (fdb.updateFinancialLimit(flist, prevflim))
{
MessageBox.Show("DocEmpMapping Status updated");
closeAllPanels();
ListEmpFinLimit();
}
else
{
MessageBox.Show("Failed to update DocEmpMapping Status");
}
}
else if (btnText.Equals("Save"))
{
if (fdb.validateFinancialLimit(flist))
{
if (fdb.insertFinancialLimit(flist))
{
MessageBox.Show("EMP Financial list data Added");
closeAllPanels();
ListEmpFinLimit();
}
else
{
MessageBox.Show("Failed to Insert DocEmpMapping");
}
}
else
{
MessageBox.Show("DocEmpMapping Data Validation failed");
}
}
}
}
catch (Exception)
{
MessageBox.Show("Failed Adding / Editing User Data");
}
}
