private void BatchTrackingForm_Load(object sender, EventArgs e)
{
try
{
// Data.GlovalVariables.currentBatchName
ResultBatchTrackingExtended batchTrackingResult = new ResultBatchTrackingExtended();
batchTrackingResult = DBTransactions.GetBatchTrackingEvents("BatchNumber = \"" + Data.GlovalVariables.currentBatchName.Trim() + "\"");
if (batchTrackingResult.RecordsCount > 0)
{
ReportButton.Enabled = true;
// Fill out the grid
foreach (BatchTrackingExtended trackingEvent in batchTrackingResult.ReturnValue)
{
string[] row = new string[] { trackingEvent.ID.ToString(), trackingEvent.BatchNumber, trackingEvent.Date.ToString(),
trackingEvent.InitialStatus, trackingEvent.FinalStatus,
trackingEvent.OperatorName, trackingEvent.StationName, trackingEvent.Event };
BatchEventsList.Rows.Add(row);
}
}
else
{
ReportButton.Enabled = false;
}
}
catch (Exception ex)
{
nlogger.Fatal(General.ErrorMessage(ex));
MessageBox.Show(General.ErrorMessage(ex), "Error ...", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void buildPageSizeList()
{
ResultJobPageSizes resultPageSizes = new ResultJobPageSizes();
resultPageSizes = DBTransactions.GetPageSizesByJobID(Data.GlovalVariables.currentJobID);
PageSizesListView.Items.Clear();
if (resultPageSizes.RecordsCount != 0)
{
foreach (JobPageSize jobPageSize in resultPageSizes.ReturnValue)
{
string[] row = { jobPageSize.ID.ToString(), jobPageSize.CategoryName, jobPageSize.High.ToString(), jobPageSize.Width.ToString() };
var listViewItem = new ListViewItem(row);
PageSizesListView.Items.Add(listViewItem);
JobPageSize jobPageSizeItem = new JobPageSize();
jobPageSizeItem.ID = jobPageSize.ID;
jobPageSizeItem.JobID = jobPageSize.JobID;
jobPageSizeItem.CategoryName = jobPageSize.CategoryName;
jobPageSizeItem.Width = jobPageSize.Width;
jobPageSizeItem.High = jobPageSize.High;
originalJobPageSizes.Add(jobPageSizeItem);
}
}
ResetButtons();
}
public void AccesstoUIFunctinality()
{
ConfigurationButton.Enabled = false;
QualityControlButton.Enabled = false;
ExportButton.Enabled = false;
StatusChangeButton.Enabled = false;
VFRSearchButton.Enabled = false;
BatchRegistrationButton.Enabled = false;
// Get User Information to control Accesst to Functionality
if (Environment.UserName.ToUpper() == "ADMINISTRATOR")
{
ConfigurationButton.Enabled = true;
QualityControlButton.Enabled = true;
ExportButton.Enabled = true;
StatusChangeButton.Enabled = true;
VFRSearchButton.Enabled = true;
BatchRegistrationButton.Enabled = true;
}
else
{
ResultUsers resultUsers = new ResultUsers();
List <User> users = new List <User>();
resultUsers = DBTransactions.GetUserByName(Environment.UserName);
users = resultUsers.ReturnValue;
foreach (UIFunctionality functionality in users[0].UIFunctionality)
{
switch (functionality.Description)
{
case "System Configuration":
ConfigurationButton.Enabled = true;
break;
case "Quality Control":
QualityControlButton.Enabled = true;
break;
case "Export":
ExportButton.Enabled = true;
break;
case "Batch Administration":
StatusChangeButton.Enabled = true;
break;
case "VFR Search":
VFRSearchButton.Enabled = true;
break;
case "Batch Registration":
BatchRegistrationButton.Enabled = true;
break;
}
}
}
}
private void Save(string action)
{
try
{
foreach (ListViewItem item in PageSizesListView.Items)
{
// Check for Deletion
if (item.ForeColor == Color.DarkRed)
{
// Delete Record
DBTransactions.DeleteJobPageSize(Convert.ToInt32(item.SubItems[0].Text));
}
// Check for New
if (item.ForeColor == Color.DarkGreen)
{
// Add Record
JobPageSize jobPageZise = new JobPageSize();
jobPageZise.JobID = Data.GlovalVariables.currentJobID;
jobPageZise.CategoryName = item.SubItems[1].Text;
jobPageZise.High = Convert.ToDouble(item.SubItems[2].Text);
jobPageZise.Width = Convert.ToDouble(item.SubItems[3].Text);
DBTransactions.NewJobPageSize(jobPageZise);
}
//Check for Update
if (item.ForeColor == Color.DarkViolet)
{
// Update Record
JobPageSize jobPageZise = new JobPageSize();
jobPageZise.ID = Convert.ToInt32(item.SubItems[0].Text);
jobPageZise.JobID = Data.GlovalVariables.currentJobID;
jobPageZise.CategoryName = item.SubItems[1].Text;
jobPageZise.High = Convert.ToDouble(item.SubItems[2].Text);
jobPageZise.Width = Convert.ToDouble(item.SubItems[3].Text);
DBTransactions.UpdateJobPageSize(jobPageZise);
}
}
if (action == "Save")
{
// Rebuild PageSizesListView
buildPageSizeList();
}
else
{
this.Close();
}
}
catch (Exception ex)
{
nlogger.Fatal(General.ErrorMessage(ex));
MessageBox.Show(General.ErrorMessage(ex), "Error ...", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void FormLoad()
{
UserNameTextBox.Text = "";
UserEmailTextBox.Text = "";
ActiveCheckBox.Checked = false;
UserTitleTextBox.Text = "";
UsersListView.Items.Clear();
AvaliableFunctionalityListView.Items.Clear();
ResultUIFunctionalities uiFunctionalities = new ResultUIFunctionalities();
uiFunctionalities = DBTransactions.GetUIFunctionalities();
foreach (UIFunctionality uiFunctionality in uiFunctionalities.ReturnValue)
{
ListViewItem item = new ListViewItem(new string[] { "", Convert.ToString(uiFunctionality.FunctionalityID), uiFunctionality.Description });
item.Tag = uiFunctionality.FunctionalityID;
AvaliableFunctionalityListView.Items.Add(item);
}
AvaliableFunctionalityListView.Columns[1].Width = 0;
// Load User List View
ResultUsers resultUsers = new ResultUsers();
List <User> users = new List <User>();
resultUsers = DBTransactions.GetUsers();
users = resultUsers.ReturnValue;
string functionalities = "";
foreach (User user in users)
{
if (user.UIFunctionality.Count > 0)
{
List <int> functionalityList = new List <int>();
foreach (UIFunctionality functionality in user.UIFunctionality)
{
functionalityList.Add(functionality.FunctionalityID);
}
functionalities = String.Join(", ", functionalityList.ToArray());
}
else
{
functionalities = "";
}
ListViewItem item = new ListViewItem(new string[] { Convert.ToString(user.UserID), Convert.ToString(user.ActiveFlag), user.UserName, user.Title, user.Email, functionalities });
UsersListView.Items.Add(item);
}
}
private void BatchDocumentViewerForm_Load(object sender, EventArgs e)
{
try
{
// DocsMetadataListView.LabelEdit = true;
ResultBatchDocs resultBatchDocs = new ResultBatchDocs();
BatchNameLabel.Text = Data.GlovalVariables.currentBatchName;
JobTypeLabel.Text = Data.GlovalVariables.currentJobName;
resultBatchDocs = DBTransactions.GetBatchDocuments("BatchName=\"" + Data.GlovalVariables.currentBatchName + "\"");
batchDocs = resultBatchDocs.ReturnValue;
//Data.GlovalVariables.currentBatchName = BatchList.CurrentRow.Cells["BatchNumber"].Value.ToString();
PDFPanel.Dock = DockStyle.Fill;
TIFFPanel.Dock = DockStyle.Fill;
ImageControlGroupBox.Visible = false;
TIFFPanel.Visible = false;
PDFPanel.Visible = false;
if (batchDocs.Count != 0)
{
// Sort Docs by Document ID
batchDocs = batchDocs.OrderBy(s => Convert.ToInt32(s.DocumentID)).ToList();
}
foreach (BatchDocs doc in batchDocs)
{
currentDocID = doc.DocumentID;
DocNumberTextBox.Text = currentDocID.ToString() + " / " + batchDocs.Count().ToString();
PopulateMetadata(doc);
break; // Load one the first Documents of the List
}
}
catch (Exception ex)
{
nlogger.Fatal(General.ErrorMessage(ex));
MessageBox.Show(General.ErrorMessage(ex), "Error ...", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ApplyButton_Click(object sender, EventArgs e)
{
ResultBatches resultBatches = new ResultBatches();
ResultGeneric resultGeneric = new ResultGeneric();
string originalBatchStatus = "";
Batch batch = new Batch();
DialogResult result = DialogResult.No;
string action = "";
DateTime currentDate = DateTime.Now;
ResultUsers resultUsers = new ResultUsers();
List <User> users = new List <User>();
Boolean allowDeletion = false;
Boolean allowRecall = false;
Boolean allowRejection = false;
try
{
// Get User Information to control Accesst to Functionality
resultUsers = DBTransactions.GetUserByName(Environment.UserName);
users = resultUsers.ReturnValue;
foreach (UIFunctionality functionality in users[0].UIFunctionality)
{
switch (functionality.Description)
{
case "Batch Rejection":
allowRejection = true;
break;
case "Batch Recall":
allowRecall = true;
break;
case "Batch Removal":
allowDeletion = true;
break;
}
}
nlogger.Trace(" QC Transaction (Apply Action) for Batch: " + BatchNameTextBox.Text);
resultBatches = DBTransactions.GetBatchesInformation("BatchNumber = \"" + BatchNameTextBox.Text + "\"", ""); // OR BatchAlias = \"" + BatchNumber.Text + "\"", "");
batch = resultBatches.ReturnValue[0];
originalBatchStatus = batch.StatusFlag;
if (RejectedRadioButton.Checked)
{
action = "Rejected";
}
if (RecallRadioButton.Checked)
{
action = "Recall";
}
if (DeleteRadioButton.Checked)
{
action = "Delete";
}
switch (action)
{
case "Rejected":
if (allowRejection)
{
result = MessageBox.Show(this, "Do you want to Reject this Batch : " + BatchNameTextBox.Text + " ?", "Confirmation...", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
batch.RejectedBy = OperatorTextBox.Text;
batch.RejectionReason = RejectCommentsTextBox.Text;
batch.LastTimeRejected = currentDate;
batch.RejectedTimes = batch.RejectedTimes + 1;
batch.StatusFlag = "Rejected";
// Update Batch Information
nlogger.Trace(" Updating Batch information in Database ...");
resultGeneric = DBTransactions.BatchUpdate(batch);
if (resultGeneric.ReturnCode == 0)
{
// Batch Event Tracking
nlogger.Trace(" Adding transaction in Tracking Database Table ...");
DBTransactions.BatchTrackingEvent(batch.BatchNumber, originalBatchStatus, "Rejected", "Batch Rejected", OperatorTextBox.Text);
}
}
}
else
{
result = MessageBox.Show(this, "You are not auhorized to perform this operation.", "Information ...", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
break;
case "Recall":
if (allowRecall)
{
result = MessageBox.Show(this, "Do you want to request a Recall this Batch : " + BatchNameTextBox.Text + " ?", "Confirmation...", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
batch.RecallBy = OperatorTextBox.Text;
batch.RecallReason = RecallCommentsTextBox.Text;
batch.RecallDate = currentDate;
batch.RecallTimes = batch.RecallTimes + 1;
batch.StatusFlag = "Recall";
// Update Batch Information
nlogger.Trace(" Updating Batch information in Database ...");
resultGeneric = DBTransactions.BatchUpdate(batch);
if (resultGeneric.ReturnCode == 0)
{
// Batch Event Tracking
nlogger.Trace(" Adding transaction in Tracking Database Table ...");
DBTransactions.BatchTrackingEvent(batch.BatchNumber, originalBatchStatus, "Recall", "Batch tagged for Recall", OperatorTextBox.Text);
}
}
}
else
{
result = MessageBox.Show(this, "You are not auhorized to perform this operation.", "Information ...", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
break;
case "Delete":
if (allowDeletion)
{
result = MessageBox.Show(this, "Do you want to Delete this Batch : " + BatchNameTextBox.Text + " ?", "Confirmation...", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
// Tag Batch for deletion
batch.StatusFlag = "Waiting for Deletion";
// Update Batch Information
nlogger.Trace(" Updating Batch information in Database ...");
resultGeneric = DBTransactions.BatchUpdate(batch);
if (resultGeneric.ReturnCode == 0)
{
// Batch Event Tracking
nlogger.Trace(" Adding transaction in Tracking Database Table ...");
DBTransactions.BatchTrackingEvent(batch.BatchNumber, originalBatchStatus, "Waiting for Deletion", "Batch tagged for Deletion", OperatorTextBox.Text);
}
MessageBox.Show(this, "This operation is under Construction", "Alert...", MessageBoxButtons.YesNo, MessageBoxIcon.Hand);
}
}
else
{
result = MessageBox.Show(this, "You are not auhorized to perform this operation.", "Information ...", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
break;
}
ResetValues();
DisableButtons();
DisableOptions();
ExitButton.Enabled = true;
}
catch (Exception ex)
{
General.ErrorMessage(ex);
}
}
private void CheckBatchNumber()
{
string batchName = "";
ResultBatches resultBatches = new ResultBatches();
ResultJobsExtended resultJobsExtended = new ResultJobsExtended();
Batch batch = new Batch();
DialogResult result;
string originalBatchStatus = "";
try
{
nlogger.Trace(" Operator entered the following Batch Name: " + BatchNumber.Text);
if (BatchNumber.Text.Length > 0)
{
resultBatches = DBTransactions.GetBatchesInformation("BatchNUmber = \"" + BatchNumber.Text + "\" OR BatchAlias = \"" + BatchNumber.Text + "\"", "");
if (resultBatches.RecordsCount == 0)
{
// Batch not found
nlogger.Trace(" Batch Name " + BatchNumber.Text + " entered could not be found");
result = MessageBox.Show(this, "The Batch Name entered could not be found.", "Info ....", MessageBoxButtons.OK,
MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
else
{
// Batch Found
batch = resultBatches.ReturnValue[0];
resultJobsExtended = DBTransactions.GetJobByName(batch.JobType);
batchName = batch.BatchNumber;
if (BatchNumber.Text == resultBatches.ReturnValue[0].BatchAlias)
{
nlogger.Trace(" Batch Name " + BatchNumber.Text + " entered is an Alias. The corresponding Batch Name is: " + batchName);
result = MessageBox.Show(this, "The number entered is a Batch Alias Name. The corresponing Box Number/Name is: " + batchName, "Info ....", MessageBoxButtons.OK,
MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
ResetValues();
BatchNameTextBox.Text = batchName;
CurrentStatusTextBox.Text = batch.StatusFlag;
originalBatchStatus = batch.StatusFlag;
BatchAliasNameTextBox.Text = batch.BatchAlias;
RecallCommentsTextBox.Text = batch.RecallReason;
RejectCommentsTextBox.Text = batch.RejectionReason;
//Only Batches in the following stages are allowed to be change:
//Waiting for Validation, Waiting for QC, QC on Hold, QC Failed, Rejected, and Waiting for PDF Conversion
if (CurrentStatusTextBox.Text == "Waiting for Validation" || CurrentStatusTextBox.Text == "Waiting for QC" ||
CurrentStatusTextBox.Text == "QC on Hold" || CurrentStatusTextBox.Text == "QC Failed" ||
CurrentStatusTextBox.Text == "Waiting for Approval" || CurrentStatusTextBox.Text == "Waiting for PDF Conversion")
{
EnableButtons();
nlogger.Trace(" Enable / Disable Options based on current Status.");
switch (CurrentStatusTextBox.Text)
{
case "Waiting for Approval":
RejectedRadioButton.Enabled = true;
RecallRadioButton.Enabled = true;
DeleteRadioButton.Enabled = true;
break;
case "Waiting for Validation":
case "Waiting for PDF Conversion":
case "QC on Hold":
case "QC Failed":
case "Waiting for QC":
RejectedRadioButton.Enabled = false;
RecallRadioButton.Enabled = true;
DeleteRadioButton.Enabled = true;
break;
}
}
else
{
RejectedRadioButton.Enabled = false;
RecallRadioButton.Enabled = false;
nlogger.Trace(" Batch Number " + batchName + " can only be set for Deletion.");
result = MessageBox.Show(this, "Batch Number " + batchName + " can only be set for Deletion.", "Message...", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
ApplyButton.Enabled = false;
ClearButton.Enabled = true;
}
catch (Exception ex)
{
General.ErrorMessage(ex);
}
}
private void Save(string action)
{
try
{
foreach (ListViewItem item in UsersListView.Items)
{
// Check for Deletion Request
if (item.ForeColor == Color.DarkRed)
{
// Delete User from the Database
DBTransactions.DeleteUser(Convert.ToInt32(item.SubItems[0].Text));
item.Remove();
}
// Check for New / Update
if (item.ForeColor == Color.DarkGreen || item.ForeColor == Color.DarkViolet)
{
// Add-update user in Databse
User user = new User();
user.UserName = item.SubItems[2].Text;
user.Email = item.SubItems[4].Text;
user.Title = item.SubItems[3].Text;
if (!string.IsNullOrEmpty(item.SubItems[0].Text))
{
user.UserID = Convert.ToInt32(item.SubItems[0].Text);
}
else
{
user.UserID = 0;
}
if (item.SubItems[1].Text == "True")
{
user.ActiveFlag = true;
}
else
{
user.ActiveFlag = false;
}
// Add functionality to the User Data Object
List <int> functionalities = new List <int>();
if (!string.IsNullOrEmpty(item.SubItems[5].Text))
{
functionalities = item.SubItems[5].Text.Split(',').Select(int.Parse).ToList();
user.UIFunctionality = new List <UIFunctionality>();
foreach (int functionality in functionalities)
{
UIFunctionality userFunctionality = new UIFunctionality();
userFunctionality.FunctionalityID = functionality;
user.UIFunctionality.Add(userFunctionality);
}
}
if (item.ForeColor == Color.DarkGreen)
{
// Add User
DBTransactions.NewUser(user);
}
if (item.ForeColor == Color.DarkViolet)
{
// Update User
nlogger.Trace("Updating User Information ..");
nlogger.Trace(" Record: " + JsonConvert.SerializeObject(user, Formatting.Indented));
DBTransactions.UpdateUser(user);
}
item.ForeColor = Color.Black;
item.Font = new System.Drawing.Font(item.Font, System.Drawing.FontStyle.Regular);
}
}
if (action == "Save")
{
// Rebuild PageSizesListView
//buildPageSizeList();
}
else
{
this.Close();
}
}
catch (Exception ex)
{
//nlogger.Fatal(General.ErrorMessage(ex));
MessageBox.Show(General.ErrorMessage(ex), "Error ...", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
