private void btnForward_Click_1(object sender, EventArgs e)
{
removeControlsFromForwarderPanel();
lvApprover = new ListView();
lvApprover.Clear();
pnlForwarder.BorderStyle = BorderStyle.FixedSingle;
pnlForwarder.Bounds = new Rectangle(new Point(100, 10), new Size(700, 300));
lvApprover = DocEmpMappingDB.ApproverLV(docID, Login.empLoggedIn);
lvApprover.Bounds = new Rectangle(new Point(50, 50), new Size(500, 200));
pnlForwarder.Controls.Remove(lvApprover);
pnlForwarder.Controls.Add(lvApprover);
Button lvForwrdOK = new Button();
lvForwrdOK.Text = "OK";
lvForwrdOK.Size = new Size(150, 20);
lvForwrdOK.Location = new Point(50, 270);
lvForwrdOK.Click += new System.EventHandler(this.lvForwardOK_Click);
pnlForwarder.Controls.Add(lvForwrdOK);
Button lvForwardCancel = new Button();
lvForwardCancel.Text = "Cancel";
lvForwardCancel.Size = new Size(150, 20);
lvForwardCancel.Location = new Point(250, 270);
lvForwardCancel.Click += new System.EventHandler(this.lvForwardCancel_Click);
pnlForwarder.Controls.Add(lvForwardCancel);
pnlForwarder.Visible = true;
pnlAddEdit.Controls.Add(pnlForwarder);
pnlAddEdit.BringToFront();
pnlForwarder.BringToFront();
pnlForwarder.Focus();
}
private void btnForward_Click_1(object sender, EventArgs e)
{
//removeControlsFromForwarderPanel();
//lvApprover = new ListView();
////lvApprover.Enabled = true;
//lvApprover.Clear();
//pnlForwarder.BorderStyle = BorderStyle.FixedSingle;
//pnlForwarder.Bounds = new Rectangle(new Point(100, 10), new Size(500, 300));
frmPopup = new Form();
frmPopup.StartPosition = FormStartPosition.CenterScreen;
frmPopup.BackColor = Color.CadetBlue;
frmPopup.MaximizeBox = false;
frmPopup.MinimizeBox = false;
frmPopup.ControlBox = false;
frmPopup.FormBorderStyle = FormBorderStyle.FixedSingle;
frmPopup.Size = new Size(450, 300);
string DeptList = "Production" + Main.delimiter1 + "QC" + Main.delimiter1 + "ProductSupport";
lvApprover = DocEmpMappingDB.ApproverLV(docID, Login.empLoggedIn);
lvApprover.Bounds = new Rectangle(new Point(0, 0), new Size(450, 250));
///pnlForwarder.Controls.Remove(lvApprover);
frmPopup.Controls.Add(lvApprover);
Button lvForwrdOK = new Button();
lvForwrdOK.BackColor = Color.Tan;
lvForwrdOK.Text = "OK";
lvForwrdOK.Location = new Point(40, 265);
lvForwrdOK.Click += new System.EventHandler(this.lvForwardOK_Click);
frmPopup.Controls.Add(lvForwrdOK);
Button lvForwardCancel = new Button();
lvForwardCancel.BackColor = Color.Tan;
lvForwardCancel.Text = "CANCEL";
lvForwardCancel.Location = new Point(130, 265);
lvForwardCancel.Click += new System.EventHandler(this.lvForwardCancel_Click);
frmPopup.Controls.Add(lvForwardCancel);
////lvForwardCancel.Visible = false;
frmPopup.ShowDialog();
//pnlForwarder.Visible = true;
//pnlOuter.Controls.Add(pnlForwarder);
//pnlOuter.BringToFront();
//pnlForwarder.BringToFront();
//pnlForwarder.Focus();
}
private void ListDocValues(string tablename)
{
try
{
grdList.Rows.Clear();
DocumentCancelDB dbrecord = new DocumentCancelDB();
List <DocCancel> docValues = dbrecord.getDocumentInfo(tablename, selectedDocID);
foreach (DocCancel val in docValues)
{
//get the employee code of user approved the document
ERPUserDB erpuserdb = new ERPUserDB();
string ecode = "";
if (val.ForwardUser.Length != 0)
{
ecode = erpuserdb.getEmpCode(val.ForwardUser.Trim());
}
string edet = Login.userLoggedInName + Main.delimiter1 + Login.userLoggedIn + Main.delimiter2;
string approverList = DocEmpMappingDB.getApproverList(selectedDocID, ecode);
string tstr = Login.userLoggedInName + Main.delimiter1 + Login.userLoggedIn + Main.delimiter1 + Main.delimiter2;
////users who can unlock a document
////user should be found in forwarder list and logged in user is the approver and
////user shall be a member of the approverlist of the document
if (!(val.ForwardUser == Login.userLoggedIn || val.forwarderlist.Contains(tstr)) &&
approverList.Contains(edet))
{
grdList.Rows.Add(val.TemporaryNo, val.TemporaryDate, val.ForwardUser, val.TableName, val.forwarderlist, val.RowID);
}
else if (unlockCommiteelist != null && unlockCommiteelist.Contains(";" + Login.userLoggedIn + ";"))
{
grdList.Rows.Add(val.TemporaryNo, val.TemporaryDate, val.ForwardUser, val.TableName, val.forwarderlist, val.RowID);
}
////if (!val.ApprovedUser.Equals(Login.empLoggedIn) || !val.forwarderlist.Contains(Login.empLoggedIn))
////{
//// grdList.Rows.Add(val.TemporaryNo, val.TemporaryDate, val.ApprovedUser, val.TableName, val.forwarderlist);
////}
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
pnlDocUnlockList.Visible = true;
}
////private void Form1_Load(object sender, EventArgs e)
////{
//// try
//// {
//// ListDocEmpMapping();
//// }
//// catch (Exception)
//// {
//// }
////}
private void ListDocEmpMapping()
{
try
{
grdList.Rows.Clear();
DocEmpMappingDB dbrecord = new DocEmpMappingDB();
List <docempmapping> DocEmpMappings = dbrecord.getDocEmpMapping();
foreach (docempmapping doc in DocEmpMappings)
{
grdList.Rows.Add(doc.DocumentID, doc.DocumentName,
doc.EmployeeName + "-" + doc.EmployeeID,
doc.SeniorEmployeeName + "-" + doc.SeniorEmployeeID,
ComboFIll.getStatusString(doc.DocumentStatus));
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
enableBottomButtons();
pnlDocumentList.Visible = true;
}
private void showDocumentDataGridView()
{
try
{
frmPopup = new Form();
frmPopup.StartPosition = FormStartPosition.CenterScreen;
frmPopup.BackColor = Color.CadetBlue;
frmPopup.MaximizeBox = false;
frmPopup.MinimizeBox = false;
frmPopup.ControlBox = false;
frmPopup.FormBorderStyle = FormBorderStyle.FixedSingle;
frmPopup.Size = new Size(520, 370);
Label lblSearch = new Label();
lblSearch.Location = new System.Drawing.Point(120, 5);
lblSearch.AutoSize = true;
lblSearch.Text = "Search by Name";
lblSearch.Font = new System.Drawing.Font("Microsoft Sans Serif", 9, FontStyle.Bold);
lblSearch.ForeColor = Color.Black;
frmPopup.Controls.Add(lblSearch);
txtSearch = new TextBox();
txtSearch.Size = new Size(220, 18);
txtSearch.Location = new System.Drawing.Point(250, 3);
txtSearch.Font = new System.Drawing.Font("Microsoft Sans Serif", 9, FontStyle.Regular);
txtSearch.ForeColor = Color.Black;
txtSearch.TextChanged += new System.EventHandler(this.txtSearch_TextChangedInDocGridList);
txtSearch.TabIndex = 0;
txtSearch.Focus();
frmPopup.Controls.Add(txtSearch);
DocEmpMappingDB empDB = new DocEmpMappingDB();
grdEmpList = empDB.getDocumentlistGrid();
grdEmpList.Bounds = new Rectangle(new Point(0, 27), new Size(520, 300));
frmPopup.Controls.Add(grdEmpList);
grdEmpList.Columns["TableName"].Visible = false;
grdEmpList.Columns["IsReversible"].Visible = false;
grdEmpList.Columns["DocumentStatus"].Visible = false;
grdEmpList.Columns["userCreateUser"].Visible = false;
grdEmpList.Columns["userCreateime"].Visible = false;
grdEmpList.Columns["DocumentID"].Width = 200;
grdEmpList.Columns["DocumentName"].Width = 250;
foreach (DataGridViewColumn column in grdEmpList.Columns)
{
column.SortMode = DataGridViewColumnSortMode.Automatic;
}
Button lvOK = new Button();
lvOK.BackColor = Color.Tan;
lvOK.Text = "OK";
lvOK.Location = new System.Drawing.Point(20, 335);
lvOK.Click += new System.EventHandler(this.grddocOK_Click1);
frmPopup.Controls.Add(lvOK);
Button lvCancel = new Button();
lvCancel.Text = "CANCEL";
lvCancel.BackColor = Color.Tan;
lvCancel.Location = new System.Drawing.Point(110, 335);
lvCancel.Click += new System.EventHandler(this.grdCancel_Click1);
frmPopup.Controls.Add(lvCancel);
frmPopup.ShowDialog();
}
catch (Exception ex)
{
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
docempmapping doc = new docempmapping();
DocEmpMappingDB docDB = new DocEmpMappingDB();
try
{
string[] docmts = txtDocument.Text.Split('-');
string[] emply = txtEmployee.Text.Split('-');
string[] snremply = txtSnrEmployee.Text.Split('-');
doc.DocumentID = docmts[1];
doc.DocumentName = docmts[0];
doc.EmployeeID = emply[1];
doc.EmployeeName = emply[0];
doc.SeniorEmployeeID = snremply[1];
doc.SeniorEmployeeName = snremply[0];
//doc.DocumentID = ((Structures.ComboBoxItem)cmbDocument.SelectedItem).HiddenValue;
//////////doc.DocumentName = cmbDocument.SelectedItem.ToString().Trim().Substring(cmbDocument.SelectedItem.ToString().Trim().IndexOf('-') + 1);
//doc.DocumentName = ((Structures.ComboBoxItem)cmbDocument.SelectedItem).ToString();
//doc.EmployeeName = cmbEmployee.SelectedItem.ToString().Trim().Substring(0, cmbEmployee.SelectedItem.ToString().Trim().IndexOf('-'));
//doc.EmployeeID = cmbEmployee.SelectedItem.ToString().Trim().Substring(cmbEmployee.SelectedItem.ToString().Trim().IndexOf('-') + 1);
//doc.SeniorEmployeeName = cmbSeniorEmployee.SelectedItem.ToString().Trim().Substring(0, cmbSeniorEmployee.SelectedItem.ToString().Trim().IndexOf('-'));
//doc.SeniorEmployeeID = cmbSeniorEmployee.SelectedItem.ToString().Trim().Substring(cmbSeniorEmployee.SelectedItem.ToString().Trim().IndexOf('-') + 1);
}
catch (Exception)
{
doc.DocumentID = "";
doc.DocumentName = "";
doc.EmployeeName = "";
doc.EmployeeID = "";
doc.SeniorEmployeeName = "";
doc.SeniorEmployeeID = "";
}
doc.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 (docDB.updateDocEmpMapping(doc, prevdoc))
{
MessageBox.Show("DocEmpMapping Status updated");
closeAllPanels();
ListDocEmpMapping();
}
else
{
MessageBox.Show("Failed to update DocEmpMapping Status");
}
}
else if (btnText.Equals("Save"))
{
if (docDB.validateDocument(doc))
{
if (docDB.insertDocEmpMapping(doc))
{
MessageBox.Show("DocEmpMapping data Added");
closeAllPanels();
ListDocEmpMapping();
}
else
{
MessageBox.Show("Failed to Insert DocEmpMapping");
}
}
else
{
MessageBox.Show("DocEmpMapping Data Validation failed");
}
}
}
}
catch (Exception)
{
MessageBox.Show("Failed Adding / Editing User Data");
}
}
