public void ShowLotNumbers()
{ //Takes Care of Loading the DataGridView with all Active Quotes
dgActiveWOR.DataSource = null;
Classes.DataAccess.ExecutiveDataAccess db = new Classes.DataAccess.ExecutiveDataAccess();
activeLotNumbers = db.GetLotNumbers();
dgActiveWOR.DataSource = activeLotNumbers;
dgActiveWOR.Columns["LotID"].Visible = false;
dgActiveWOR.Columns["OrderQuantity"].Visible = false;
dgActiveWOR.Columns["PartDescription"].Visible = false;
dgActiveWOR.Columns["KitDueDate"].Visible = false;
dgActiveWOR.Columns["MasterDueDate"].Visible = false;
dgActiveWOR.Columns["TurnTime"].Visible = false;
dgActiveWOR.Columns["Turnkey"].Visible = false;
dgActiveWOR.Columns["Consigned"].Visible = false;
dgActiveWOR.Columns["JobComments"].Visible = false;
dgActiveWOR.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dgActiveWOR.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void btnReset_Click(object sender, EventArgs e)
{
string message = "Are you re-setting the Super Hot Priority Level for Job Number: " + dgActiveWOR.Rows[quoteRow].Cells[1].Value.ToString() + " / " + dgActiveWOR.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.ExecutiveDataAccess db = new Classes.DataAccess.ExecutiveDataAccess();
//Set SuperHot = True
db.resetSuperHot(dgActiveWOR.Rows[quoteRow].Cells[1].Value.ToString(), dgActiveWOR.Rows[quoteRow].Cells[2].Value.ToString());
//Refresh
ShowLotNumbers();
}
}
