private void AddLotNumber()
{
//make a new access connection
Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
//Create the Lot
db.InsertLotNumber(newLotNumber, newLotStatus, newLotPurchasingStatus, newLotTimeTracking, newPurchasingTimeTracking);
}
private void btnEnd_Click(object sender, EventArgs e)
{
//Grab an Instance of SalesDataAccess
Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
//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());
//Update LotStatus and Time-stamp LotTimeTracking.MasterReviewEnd
db.UpdateReviewMasterComplete(currentTask);
//Re-Calculate the JobStatus
Classes.StatusCalculation getStatus = new Classes.StatusCalculation();
getStatus.CalculateStatus(currentTask);
//Update the GridView
updateData(null, null);
//Reset Buttons
btnStart.Enabled = false;
btnStart.Visible = true;
btnStart.Text = "Start";
btnEnd.Enabled = false;
btnEnd.Visible = false;
btnEnd.Text = "End";
}
//Physical Events-----------------------------------------------------------------------------------------------
private void btnRequestPartsReview_Click(object sender, EventArgs e)
{
string message = "Would you like to request a Parts Review for Job Number " + dgActiveQuotes.Rows[quoteRow].Cells[0].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.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
//Set PartsReviewRequest to True, PartsReviewInProgress and PartsReviewComplete to False
db.requestPartsReview(dgActiveQuotes.Rows[quoteRow].Cells[0].Value.ToString());
//Load Temp Lot Task for status calc
Classes.LotTask tempLotTask = new Classes.LotTask();
tempLotTask.JobWOR = Int32.Parse(dgActiveQuotes.Rows[quoteRow].Cells[0].Value.ToString());
tempLotTask.Lot = 0;
//Update Quote Current Status
Classes.StatusCalculation getStatus = new Classes.StatusCalculation();
getStatus.CalculateStatus(tempLotTask);
//Refresh
ShowActiveQuotes();
}
}
private void ShowCurrentLotNumbers()
{ //Takes Care of Loading the DataGridView with any lot numbers that are registered under the work order
dgNewLots.DataSource = null;
Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
currentLots = db.GetCurrentLotNumbers(lblWorkOrder.Text);
dgNewLots.DataSource = currentLots;
}
private void btnUpdate_Click(object sender, EventArgs e)
{
//Database Connection
Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
//To hold all the information
Classes.DatabaseTables.ActiveQuotes updateQuote = new Classes.DatabaseTables.ActiveQuotes();
//Fill updateQuote
updateQuote.QuoteWOR = Int32.Parse(txtWOR.Text);
updateQuote.Date = tempDate;
updateQuote.Time = tempTime;
updateQuote.PartID = txtPartID.Text;
updateQuote.Customer = txtCustomer.Text;
updateQuote.PartDescription = txtDescription.Text;
if (radioLowConf.Checked)
{
updateQuote.QuoteConfidence = "Low";
}
if (radioMedConf.Checked)
{
updateQuote.QuoteConfidence = "Medium";
}
if (radioHighConf.Checked)
{
updateQuote.QuoteConfidence = "High";
}
updateQuote.QuoteComments = txtComment.Text;
updateQuote.QuoteDueDate = dtDueDate.Text;
if (ckConsigned.Checked == true)
{
updateQuote.Consigned = 1;
}
else
{
updateQuote.Consigned = 0;
}
if (ckTurnkey.Checked == true)
{
updateQuote.Turnkey = 1;
}
else
{
updateQuote.Turnkey = 0;
}
db.UpdateQuote(updateQuote);
btnClear_Click(null, null);
}
//Functions----------------------------------------------------------------------------------
private void updateData(object sender, EventArgs e)
{
dgTaskView.DataSource = null;
Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
MasterReviewRequests = db.GetMasterReviewRequests();
dgTaskView.DataSource = MasterReviewRequests;
dgTaskView.Columns["Owner"].Visible = false;
dgTaskView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dgTaskView.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
//Functions----------------------------------------------------------------------------------
public void updateData(object sender, EventArgs e)
{
dgActiveQuotes.DataSource = null;
Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
quotes = db.GetActiveQuotes();
dgActiveQuotes.DataSource = quotes;
dgActiveQuotes.Columns["QuoteInactive"].Visible = false;
dgActiveQuotes.Columns["POReceived"].Visible = false;
dgActiveQuotes.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dgActiveQuotes.Columns["QuoteComments"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void showActiveQuotes()
{
dgQuoteGrid.DataSource = null;
Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
quotes = db.GetActiveQuotes();
UpdateBinding();
dgQuoteGrid.Columns["QuoteInactive"].Visible = false;
dgQuoteGrid.Columns["POReceived"].Visible = false;
dgQuoteGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dgQuoteGrid.Columns["PartDescription"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
public void ShowActiveQuotes()
{ //Takes Care of Loading the DataGridView with all Active Quotes
dgActiveQuotes.DataSource = null;
Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
activeQuotes = db.GetActiveQuotes();
dgActiveQuotes.DataSource = activeQuotes;
dgActiveQuotes.Columns["QuoteInactive"].Visible = false;
dgActiveQuotes.Columns["POReceived"].Visible = false;
dgActiveQuotes.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dgActiveQuotes.Columns["QuoteComments"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void LoadAllWorkOrders()
{
dgWORGrid.DataSource = null;
Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
WorkOrders = db.GetAllWorkOrders();
dgWORGrid.DataSource = WorkOrders;
dgWORGrid.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgWORGrid.Columns["Date"].Visible = false;
dgWORGrid.Columns["Time"].Visible = false;
dgWORGrid.Columns["PurchaseOrderNumber"].Visible = false;
dgWORGrid.Columns["WorkOrderComplete"].Visible = false;
}
private void refreshLotView()
{
//Refresh Lot Number Grid
dgLotGrid.DataSource = null;
Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
lotNumbers = db.GetCurrentLotNumbers(dgWORGrid.Rows[WORRow].Cells["JobWOR"].Value.ToString());
dgLotGrid.DataSource = lotNumbers;
dgLotGrid.Columns["JobWOR"].Visible = false;
dgLotGrid.Columns["LotID"].Visible = false;
dgLotGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dgLotGrid.Columns["JobComments"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void btnUpdate_Click(object sender, EventArgs e)
{
//Database Connection
Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
//To hold all the information
Classes.DatabaseTables.LotNumbers updateLot = new Classes.DatabaseTables.LotNumbers();
//Fill in new Lot information
updateLot.LotID = lotNumbers[lotRow].LotID;
updateLot.Lot = Int32.Parse(txtLotNumber.Text);
updateLot.OrderQuantity = Int32.Parse(txtOrderQuantity.Text);
updateLot.JobDueDate = dtJobDueDate.Text;
updateLot.MasterDueDate = dtMasterDueDate.Text;
updateLot.KitDueDate = dtKitDueDate.Text;
updateLot.TurnTime = Int32.Parse(txtTurnTime.Text);
if (ckConsigned.Checked == true)
{
updateLot.Consigned = 1;
}
else
{
updateLot.Consigned = 0;
}
if (ckTurnkey.Checked == true)
{
updateLot.Turnkey = 1;
}
else
{
updateLot.Turnkey = 0;
}
updateLot.JobComments = txtJobComments.Text;
//Update Lot Number
db.UpdateLot(updateLot);
refreshLotView();
btnClear_Click(null, null);
}
private void createWOR()
{
//Set Up holder to update the Active Quote PO Status
Classes.DatabaseTables.ActiveQuotes activeQuote = new Classes.DatabaseTables.ActiveQuotes();
//Set Up Holder for the new WOR
Classes.DatabaseTables.WorkOrders newWOR = new Classes.DatabaseTables.WorkOrders();
DateTime rightNow = new DateTime();
rightNow = DateTime.Now;
newWOR.JobWOR = Int32.Parse(SelectedWorkOrder);
newWOR.Date = rightNow.ToString("MM-dd-yyyy");
newWOR.Time = rightNow.ToString("hh:mm:ss tt");
newWOR.PurchaseOrderNumber = txtPONumber.Text;
newWOR.WorkOrderComplete = 0;
//Create Data Access Class
Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
db.InsterWorkOrder(newWOR);
}
//Physical Events-----------------------------------------------------------------------------------------------
private void btnDeActivateQuote_Click(object sender, EventArgs e)
{
string message = "Would you like to De-Activate the Quote for Job Number " + dgActiveQuotes.Rows[quoteRow].Cells[0].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.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
//Set QuoteInactive to True
db.deActivateQuote(dgActiveQuotes.Rows[quoteRow].Cells[0].Value.ToString());
//Refresh
ShowActiveQuotes();
}
}
public void populate(object sender, EventArgs e)
{
dgActiveWORs.Enabled = false;
//Get Current Selection Location
if (dgActiveWORs.CurrentCell != null)
{
if (dgActiveWORs.CurrentCell.ColumnIndex > 0)
{
WORactiveRow = dgActiveWORs.CurrentCell.RowIndex;
WORactiveColumn = dgActiveWORs.CurrentCell.ColumnIndex;
}
}
//Load DataGridView
Classes.DataAccess.DashboardDataAccess db = new Classes.DataAccess.DashboardDataAccess();
engineeringDashboard = db.LoadDashboard(ckQuotes.Checked, ckWORs.Checked);
dgActiveWORs.DataSource = engineeringDashboard;
Classes.StatusCalculation calculatedStatus = new Classes.StatusCalculation();
calculatedStatus.CalculateDashboard(engineeringDashboard);
//Format DataGridView
formatDataGrids();
//Re-set Current Cell
try
{
dgActiveWORs.CurrentCell = dgActiveWORs.Rows[WORactiveRow].Cells[WORactiveColumn];
}
catch { }
dgActiveWORs.Enabled = true;
//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;
}
}
//Task View Handler
dgTaskView.DataSource = null;
Classes.DataAccess.SalesDataAccess dbSales = new Classes.DataAccess.SalesDataAccess();
MasterReviewRequests = dbSales.GetMasterReviewRequests();
dgTaskView.DataSource = MasterReviewRequests;
//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;
}
private void LoadActiveQuote()
{
//New Connection
Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
activeQuotes = db.GetSingleQuote(lblWorkOrder.Text);
}
//Physical Button Events--------------------------------------------------------------
private void btnAdd_Click(object sender, EventArgs e)
{
Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
//Holder to validate the Data
//Create new class to hold the new Active Quote
Classes.DatabaseTables.ActiveQuotes newActiveQuote = new Classes.DatabaseTables.ActiveQuotes();
Classes.DatabaseTables.QuoteStatus newQuoteStatus = new Classes.DatabaseTables.QuoteStatus();
//Fill New Active Quote
newActiveQuote.QuoteWOR = Int32.Parse(txtWOR.Text);
DateTime rightNow = new DateTime();
rightNow = DateTime.Now;
newActiveQuote.Date = rightNow.ToString("MM-dd-yyyy");
newActiveQuote.Time = rightNow.ToString("hh:mm:ss tt");
newActiveQuote.PartID = txtPartID.Text;
newActiveQuote.Customer = txtCustomer.Text;
newActiveQuote.PartDescription = txtDescription.Text;
if (radioLowConf.Checked)
{
newActiveQuote.QuoteConfidence = "Low";
}
if (radioMedConf.Checked)
{
newActiveQuote.QuoteConfidence = "Medium";
}
if (radioHighConf.Checked)
{
newActiveQuote.QuoteConfidence = "High";
}
newActiveQuote.QuoteComments = txtComment.Text;
newActiveQuote.QuoteDueDate = dtDueDate.Text;
if (ckConsigned.Checked == true)
{
newActiveQuote.Consigned = 1;
}
else
{
newActiveQuote.Consigned = 0;
}
if (ckTurnkey.Checked == true)
{
newActiveQuote.Turnkey = 1;
}
else
{
newActiveQuote.Turnkey = 0;
}
//Set Initial Status
newActiveQuote.QuoteInactive = 0;
newActiveQuote.POReceived = 0;
//QuoteStatus Initialization
newQuoteStatus.QuoteWOR = Int32.Parse(txtWOR.Text);
newQuoteStatus.BOMValidationRequest = 0;
newQuoteStatus.BOMValidationInProgress = 0;
newQuoteStatus.BOMValidationComplete = 0;
newQuoteStatus.PartsReviewRequest = 0;
newQuoteStatus.PartsReviewInProgress = 0;
newQuoteStatus.PartsReviewComplete = 0;
newQuoteStatus.PreBidRequest = 0;
newQuoteStatus.PreBidInProgress = 0;
newQuoteStatus.PreBidComplete = 0;
newQuoteStatus.FinalReviewRequest = 0;
newQuoteStatus.FinalReviewInProgress = 0;
newQuoteStatus.FinalReviewComplete = 0;
newQuoteStatus.QuoteSent = 0;
newQuoteStatus.QuoteCurrentStatus = "";
db.InsertNewQuote(newActiveQuote, newQuoteStatus);
btnClear_Click(null, null);
}
