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