private void ListDocumentReceiver()
{
try
{
grdList.Rows.Clear();
DocumentReceiverDB drdb = new DocumentReceiverDB();
List <documentreceiver> DocumentReceivers = drdb.getDocumentReceiver();
foreach (documentreceiver drrec in DocumentReceivers)
{
grdList.Rows.Add();
grdList.Rows[grdList.Rows.Count - 1].Cells["RowID"].Value = drrec.RowID;
grdList.Rows[grdList.Rows.Count - 1].Cells["DocumentID"].Value = drrec.DocumentID;
grdList.Rows[grdList.Rows.Count - 1].Cells["DocumentName"].Value = drrec.DocumentName;
grdList.Rows[grdList.Rows.Count - 1].Cells["EmployeeID"].Value = drrec.EmployeeID;
grdList.Rows[grdList.Rows.Count - 1].Cells["Employee"].Value = drrec.EmployeeName;
grdList.Rows[grdList.Rows.Count - 1].Cells["OfficeID"].Value = drrec.OfficeID;
grdList.Rows[grdList.Rows.Count - 1].Cells["Office"].Value = drrec.OfficeName;
grdList.Rows[grdList.Rows.Count - 1].Cells["Status"].Value = getDocStatusString(drrec.Status);
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
enableBottomButtons();
pnlDocumentList.Visible = true;
}
private void Main_Load(object sender, EventArgs e)
{
////pnlMainHeader.Focus();
Region = System.Drawing.Region.FromHrgn(Utilities.CreateRoundRectRgn(0, 0, Width, Height, 20, 20));
Button dashBtn = new Button();
dashBtn.Name = "btnDASHBOARD";
dashBtn.Click += new EventHandler(this.MyButtonHandler);
dashBtn.PerformClick();
DocumentReceiverDB drdb = new DocumentReceiverDB();
DocumentReceivers = drdb.getDocumentReceiver().Where(recv => recv.EmployeeID == Login.empLoggedIn && recv.Status == 1).ToList();
SystemParametersDB spdb = new SystemParametersDB();
SystemParameters = spdb.getSystemparameters();
}
private Boolean updateDashBoard(smrn smrn, int stat)
{
Boolean status = true;
try
{
dashboardalarm dsb = new dashboardalarm();
DashboardDB ddsDB = new DashboardDB();
dsb.DocumentID = smrn.DocumentID;
dsb.TemporaryNo = smrn.SMRNNo;
dsb.TemporaryDate = smrn.SMRNDate;
//dsb.DocumentNo = smrn.ProductionPlanNo;
//dsb.DocumentDate = smrn.ProductionPlanDate;
dsb.FromUser = Login.userLoggedIn;
if (stat == 1)
{
dsb.ActivityType = 2;
dsb.ToUser = smrn.ForwardUser;
if (!ddsDB.insertDashboardAlarm(dsb))
{
MessageBox.Show("DashBoard Fail to update");
status = false;
}
}
else if (stat == 2)
{
dsb.ActivityType = 3;
List <documentreceiver> docList = DocumentReceiverDB.getDocumentWiseReceiver(prevsh.DocumentID);
foreach (documentreceiver docRec in docList)
{
dsb.ToUser = docRec.EmployeeID; //To store UserID Form DocumentReceiver for current Document
dsb.DocumentDate = UpdateTable.getSQLDateTime();
if (!ddsDB.insertDashboardAlarm(dsb))
{
MessageBox.Show("DashBoard Fail to update");
status = false;
}
}
}
}
catch (Exception ex)
{
status = false;
}
return(status);
}
private Boolean updateDashBoard(popiheader popih, int stat)
{
Boolean status = true;
try
{
dashboardalarm dsb = new dashboardalarm();
DashboardDB ddsDB = new DashboardDB();
dsb.DocumentID = popih.DocumentID;
dsb.TemporaryNo = popih.TemporaryNo;
dsb.TemporaryDate = popih.TemporaryDate;
dsb.DocumentNo = popih.TrackingNo;
dsb.DocumentDate = popih.TrackingDate;
dsb.FromUser = Login.userLoggedIn;
if (stat == 1)
{
dsb.ActivityType = 2;
dsb.ToUser = popih.ForwardUser;
if (!ddsDB.insertDashboardAlarm(dsb))
{
MessageBox.Show("DashBoard Fail to update");
status = false;
}
}
else if (stat == 2)
{
dsb.ActivityType = 3;
List <documentreceiver> docList = DocumentReceiverDB.getDocumentWiseReceiver(MatDel.DocumentID);
foreach (documentreceiver docRec in docList)
{
dsb.ToUser = docRec.EmployeeID;
dsb.DocumentDate = UpdateTable.getSQLDateTime();
if (!ddsDB.insertDashboardAlarm(dsb))
{
MessageBox.Show("DashBoard Fail to update");
status = false;
}
}
}
}
catch (Exception ex)
{
status = false;
}
return(status);
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
documentreceiver drrec = new documentreceiver();
DocumentReceiverDB drDB = new DocumentReceiverDB();
try
{
string[] docmts = txtDocument.Text.Split('-');
string[] emply = txtEmployee.Text.Split('-');
drrec.DocumentID = docmts[1];
drrec.EmployeeID = emply[1];
drrec.OfficeID = ((Structures.ComboBoxItem)cmbOffice.SelectedItem).HiddenValue;
drrec.OfficeName = ((Structures.ComboBoxItem)cmbOffice.SelectedItem).ToString();
}
catch (Exception)
{
drrec.DocumentID = "";
drrec.DocumentName = "";
drrec.EmployeeName = "";
drrec.EmployeeID = "";
drrec.OfficeID = "";
drrec.OfficeName = "";
}
drrec.Status = getStatusCode(cmbStatus.SelectedItem.ToString());
System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button;
string btnText = btn.Text;
{
if (btnText.Equals("Update"))
{
if (drDB.updateDocumentReceiver(drrec, prevdoc))
{
MessageBox.Show("Document Receiver Status updated");
closeAllPanels();
ListDocumentReceiver();
}
else
{
MessageBox.Show("Failed to update Document Receiver Status");
}
}
else if (btnText.Equals("Save"))
{
if (drDB.validateDocument(drrec))
{
if (drDB.insertDocumentReceiver(drrec))
{
MessageBox.Show("Document Receiver Added");
closeAllPanels();
ListDocumentReceiver();
}
else
{
MessageBox.Show("Failed to Insert Document Receiver");
}
}
else
{
MessageBox.Show("Document Receiver Validation failed");
}
}
}
}
catch (Exception)
{
MessageBox.Show("Failed Adding / Editing Document Receiver");
}
}
