private void btnOK_Click(object sender, EventArgs e)
{
//Create a new db connection
Classes.DataAccess.EngineeringDataAccess db = new Classes.DataAccess.EngineeringDataAccess();
//Set WORLotReleased = True
db.releaseWorkOrder(ucPerformEngineeringTask.WORText, ucPerformEngineeringTask.LotText);
if (ckParts.Checked == true)
{
//Set PartsRequired
db.setPartsRequired(ucPerformEngineeringTask.WORText, ucPerformEngineeringTask.LotText);
}
if (ckPCBs.Checked == true)
{
//Set PCBRequired
db.setPCBRequired(ucPerformEngineeringTask.WORText, ucPerformEngineeringTask.LotText);
}
if (ckStencils.Checked == true)
{
//Set StencilsRequired
db.setStencilsRequired(ucPerformEngineeringTask.WORText, ucPerformEngineeringTask.LotText);
}
this.Close();
}
//Physical Events-----------------------------------------------------------------------------------------------
private void btnRequestMasterReview_Click(object sender, EventArgs e)
{
string message = "Would you like to request a Master Review for Job Number " + dgActiveQuotes.Rows[quoteRow].Cells[1].Value.ToString() + "/" + dgActiveQuotes.Rows[quoteRow].Cells[2].Value.ToString() + "?";
string caption = "Are you sure?";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(message, caption, buttons);
if (result == System.Windows.Forms.DialogResult.Yes)
{
//Create a new db connection
Classes.DataAccess.EngineeringDataAccess db = new Classes.DataAccess.EngineeringDataAccess();
//Set MasterReviewRequest to True, MasterReviewInProgress and MasterReviewComplete to False
db.requestMasterReview(dgActiveQuotes.Rows[quoteRow].Cells[1].Value.ToString(), dgActiveQuotes.Rows[quoteRow].Cells[2].Value.ToString());
//Load Temp Lot Task for status calc
Classes.LotTask tempLotTask = new Classes.LotTask();
tempLotTask.JobWOR = Int32.Parse(dgActiveQuotes.Rows[quoteRow].Cells[1].Value.ToString());
tempLotTask.Lot = Int32.Parse(dgActiveQuotes.Rows[quoteRow].Cells[2].Value.ToString());
//Update Quote Current Status
Classes.StatusCalculation getStatus = new Classes.StatusCalculation();
getStatus.CalculateStatus(tempLotTask);
//Refresh
ShowLotNumbers();
}
}
private void btnEnd_Click(object sender, EventArgs e)
{
//Grab an Instance of SalesDataAccess
Classes.DataAccess.EngineeringDataAccess db = new Classes.DataAccess.EngineeringDataAccess();
//Prepare currentTask
Classes.LotTask currentTask = new Classes.LotTask();
currentTask.JobWOR = Int32.Parse(dgTaskView[0, activeRow].Value.ToString());
currentTask.Lot = Int32.Parse(dgTaskView[1, activeRow].Value.ToString());
switch (dgTaskView[3, activeRow].Value.ToString())
{
case "BOM Validation In Progress":
//Set BOMValidationComplete=True, BOMValidationRequest=False, BOMValidationInProgress=False; Eventually, Time-Tracking will happen here too...
db.UpdateBOMValidationComplete(currentTask);
break;
case "Master Creation In Progress":
//Change the MasterInProgress Flag to True and Time-Stamp LotTimeTracking.MasterEnd
db.UpdateMasterComplete(currentTask);
break;
case "Quote Review In Progress":
//Update QuoteReviewComplete Flag to True and Time-stamp LotTimeTracking.QuoteReviewEnd
db.UpdateQuoteReviewComplete(currentTask);
break;
case "Pre-Bid Review In Progress":
//Update PreBidComplete Flag to True
db.UpdatePreBidComplete(currentTask);
break;
}
//Re-Calculate the JobStatus
//Classes.StatusCalculation getStatus = new Classes.StatusCalculation();
//getStatus.CalculateStatus(currentTask);
//Update the GridView
populate(null, null);
//Reset Buttons
btnStart.Enabled = false;
btnStart.Visible = true;
btnStart.Text = "Start";
btnEnd.Enabled = false;
btnEnd.Visible = false;
btnEnd.Text = "End";
}
public void ShowLotNumbers()
{ //Takes Care of Loading the DataGridView with all Active Quotes
dgActiveQuotes.DataSource = null;
Classes.DataAccess.EngineeringDataAccess db = new Classes.DataAccess.EngineeringDataAccess();
activeLotNumbers = db.GetLotNumbers();
dgActiveQuotes.DataSource = activeLotNumbers;
dgActiveQuotes.Columns["LotID"].Visible = false;
dgActiveQuotes.Columns["OrderQuantity"].Visible = false;
dgActiveQuotes.Columns["PartDescription"].Visible = false;
dgActiveQuotes.Columns["JobDueDate"].Visible = false;
dgActiveQuotes.Columns["MasterDueDate"].Visible = false;
dgActiveQuotes.Columns["TurnTime"].Visible = false;
dgActiveQuotes.Columns["Consigned"].Visible = false;
dgActiveQuotes.Columns["JobComments"].Visible = false;
dgActiveQuotes.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dgActiveQuotes.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void loadTasks()
{
//Task View Stuff
dgTaskView.Enabled = false;
//Get Current Selection Location
if (dgTaskView.CurrentCell != null)
{
if (dgTaskView.CurrentCell.ColumnIndex > 0)
{
TaskActiveRow = dgTaskView.CurrentCell.RowIndex;
TaskActiveColumn = dgTaskView.CurrentCell.ColumnIndex;
}
}
//Load Task View
Classes.DataAccess.EngineeringDataAccess dbEng = new Classes.DataAccess.EngineeringDataAccess();
TaskRequests = dbEng.GetEngineeringTaskList();
dgTaskView.DataSource = TaskRequests;
//Format Task View Data Grid
dgTaskView.Columns["Owner"].Visible = false;
dgTaskView.Columns["SuperHot"].Visible = false;
//Re-Select Current Cell
try
{
dgTaskView.CurrentCell = dgTaskView.Rows[TaskActiveRow].Cells[TaskActiveColumn];
}
catch { }
dgTaskView.Enabled = true;
dgTaskView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dgTaskView.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
