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); }