private void btnSend_Click(object sender, RoutedEventArgs e) { int intcentiveBf = 0, incentiveAf = 0; double workHrsBf = 0, workHrsAf = 0; Int32.TryParse(txtIncentiveBefore.Text.ToString(), out intcentiveBf); Int32.TryParse(txtIncentiveAfter.Text.ToString(), out incentiveAf); Double.TryParse(txtWorkHrsBefore.Text.ToString(), out workHrsBf); Double.TryParse(txtWorkHrsAfter.Text.ToString(), out workHrsAf); string reason = ""; reason = txtReason.Text.Trim(); CieControlIncentiveModel insertModel = new CieControlIncentiveModel() { WorkHrsBefore = workHrsBf, WorkHrsAfter = workHrsAf, LineId = line.LineId, Reason = reason, RequestTime = date, IncentiveBefore = intcentiveBf, IncentiveAfter = incentiveAf }; if (CieControlIncentiveController.Insert(insertModel) == false) { MessageBox.Show("Error !!", "Infor", MessageBoxButton.OK, MessageBoxImage.Error); return; } MessageBox.Show("Sent !", "Infor", MessageBoxButton.OK, MessageBoxImage.Information); }
private void threadAccept_DoWork(object sender, DoWorkEventArgs e) { object[] arguments = e.Argument as object[]; CieControlIncentiveModel acceptModel = arguments[0] as CieControlIncentiveModel; DateTime acceptedTime = DateTime.Now; e.Result = CieControlIncentiveController.Update(acceptModel.LineId, acceptModel.RequestTime, acceptedTime); }
private void btnAccept_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("Confirm?", "Confirm", MessageBoxButton.OKCancel, MessageBoxImage.Question) == MessageBoxResult.OK) { acceptModel = dgvRequest.CurrentItem as CieControlIncentiveModel; if (acceptModel != null && threadAccept.IsBusy == false) { this.Cursor = Cursors.Wait; object[] arguments = { acceptModel }; threadAccept.RunWorkerAsync(arguments); } } }
public static bool Insert(CieControlIncentiveModel model) { var @WorkHrsBefore = new SqlParameter("@WorkHrsBefore", model.WorkHrsBefore); var @WorkHrsAfter = new SqlParameter("@WorkHrsAfter", model.WorkHrsAfter); var @IncentiveBefore = new SqlParameter("@IncentiveBefore", model.IncentiveBefore); var @IncentiveAfter = new SqlParameter("@IncentiveAfter", model.IncentiveAfter); var @LineId = new SqlParameter("@LineId", model.LineId); var @RequestTime = new SqlParameter("@RequestTime", model.RequestTime); var @Reason = new SqlParameter("@Reason", model.Reason); SaovietCheckInEntities db = new SaovietCheckInEntities(); if (db.ExecuteStoreCommand("EXEC spm_InsertCieControlIncentive @WorkHrsBefore, @WorkHrsAfter, @IncentiveBefore, @IncentiveAfter, @LineId, @RequestTime, @Reason", @WorkHrsBefore, @WorkHrsAfter, @IncentiveBefore, @IncentiveAfter, @LineId, @RequestTime, @Reason) >= 1) { return(true); } return(false); }