public async Task <int> InsertTaskAsync(OneTimeTasks task, bool isUserPerformed = false) { string query = "INSERT INTO `OneTimeTasks`" + "(`Type`,`Comments`,`Duration`,`CreatedUser`,`CreatedDateTime`,`IsDelete`,`Effectivedate`) " + "VALUES (@Type,@Comments,@Duration,@CreatedUser,@CreatedDateTime,@IsDelete,@Effectivedate);"; IEnumerable <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@Type", task.Type), new KeyValuePair <string, object>("@Comments", task.Comments), new KeyValuePair <string, object>("@Duration", task.Duration), new KeyValuePair <string, object>("@CreatedUser", task.CreatedUser), new KeyValuePair <string, object>("@Effectivedate", TimeConverterMethods.ConvertDateTimeToTimeStamp(task.Effectivedate)), new KeyValuePair <string, object>("@CreatedDateTime", TimeConverterMethods.ConvertDateTimeToTimeStamp(task.CreatedDateTime)), new KeyValuePair <string, object>("@IsDelete", 0) }; int id = await SqliteConnector.ExecuteInsertQueryAsync(query, parameters, true); query = "UPDATE `OneTimeTasks` SET `ReferenceNumber`=@ReferenceNumber WHERE `Id`=@Id"; parameters = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@ReferenceNumber", id.ToString("OTASK000000")), new KeyValuePair <string, object>("@Id", id) }; await SqliteConnector.ExecuteNonQueryAsync(query, parameters, true); return(id); }
public async Task <OneTimeTasks> InsertTaskAsync(OneTimeTasks task, bool isUserPerformed = false) { await _insertTaskSemaphoreSlim.WaitAsync(); try { UserEntity userEntity = await _userModel.GetUserDetailsAsync(); task.CreatedUser = userEntity.Id; int tId = await _taskModel.InsertTaskAsync(task, isUserPerformed); task = await _taskModel.GetTaskByIdAsync(tId); IList <OneTimeTasks> tasks = OneTimeTasks.ToList(); tasks.Add(task); OneTimeTasks = tasks; CurrentUser = userEntity; return(task); } catch (Exception k) { applicationErrorLog.ErrorLog("Task", "Insert one time task", k.ToString()); return(task); } finally { _insertTaskSemaphoreSlim.Release(); } }
public OneTImeTaskBinder(OneTimeTasks taskEntity) { ReferenceNumber = taskEntity.ReferenceNumber; Comments = taskEntity.Comments; Duration = taskEntity.Duration.ToString(); Effectivedate = taskEntity.Effectivedate; Type = taskEntity.Type == 1 ? ContentTaskTypesEnum.Appointment.ToString() : ContentTaskTypesEnum.Task.ToString(); }
public ManageTaskUserControl(Action <ContentItemEnum> changeContent, OneTimeTasks transactionEntity, ScheduledTasks schtrans) : this(changeContent) { _onetimetaskEntity = transactionEntity; if (schtrans != null) { _schtaskEntity = schtrans; } }
private void dataGridView_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { OneTImeTaskBinder transactionBinder = _OneTImeTaskBinder[e.RowIndex]; OneTimeTasks onetimetasks = _applicationService.OneTimeTasks.First(t => t.ReferenceNumber == transactionBinder.ReferenceNumber); _changeContentMainFormAction(ContentItemEnum.ManageTask, onetimetasks); } }
public async Task <OneTimeTasks> UpdateTaskAsync(OneTimeTasks task) { await _taskModel.UpdateTaskAsync(task); UserEntity userEntity = await _userModel.GetUserDetailsAsync(); IEnumerable <OneTimeTasks> tasks = await _taskModel.GetTaskAsync(); OneTimeTasks = tasks; CurrentUser = userEntity; return(task); }
public async Task DeleteTaskAsync(int id) { _taskModel.DeleteTaskAsync(id); OneTimeTasks task = await _taskModel.GetTaskByIdAsync(id); UserEntity userEntity = await _userModel.GetUserDetailsAsync(); IList <OneTimeTasks> tasks = OneTimeTasks.ToList(); OneTimeTasks deletedTask = tasks.First(tp => tp.Id == id); deletedTask.IsDelete = true; OneTimeTasks = tasks; CurrentUser = userEntity; }
public ManageTaskUserControl(Action <ContentItemEnum> changeContentMainFormAction) { _changeContentMainFormAction = changeContentMainFormAction; _applicationService = MyFinance.Entities.MyFinanceApplication.DependancyContainer.GetInstance <IApplicationService>(); _onetimetaskEntity = null; InitializeComponent(); comboBoxRepeat.DataSource = Enum.GetValues(typeof(ContentRepeatItemEnum)); taskTypeComboBox.SelectedIndex = 0; comboBoxType.SelectedIndex = 0; comboBoxRepeat.SelectedIndex = 1; dateTimePickerTo.MinDate = DateTime.Today.AddDays(1); dateTimePickerForm.MinDate = DateTime.Today; dateTimePickerEffective.MinDate = DateTime.Today.AddDays(1); referenceNumberPanel.Visible = false; }
public async Task <int> UpdateTaskAsync(OneTimeTasks task) { string query = "UPDATE `OneTimeTasks` " + "SET `Type`=@Type,`Comments`=@Comments,`Duration`=@Duration,`Effectivedate`=@Effectivedate " + "WHERE `Id` = @Id"; IEnumerable <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@Type", task.Type), new KeyValuePair <string, object>("@Comments", task.Comments), new KeyValuePair <string, object>("@Duration", task.Duration), new KeyValuePair <string, object>("@Effectivedate", TimeConverterMethods.ConvertDateTimeToTimeStamp(task.Effectivedate)), new KeyValuePair <string, object>("@Id", task.Id), }; return(await SqliteConnector.ExecuteNonQueryAsync(query, parameters, true)); }
private void SetTaskEntity(OneTimeTasks onetimetaskEntity = null) { try { _onetimetaskEntity = onetimetaskEntity ?? new OneTimeTasks() { Duration = 0D, ReferenceNumber = "", Comments = "", }; if (_onetimetaskEntity.Id == 0) { referenceNumberPanel.Visible = false; } else { referenceNumberPanel.Visible = true; referenceNumberTextBox.Text = _onetimetaskEntity.ReferenceNumber; } durationErrorLabel.Text = ""; amountNumericUpDown.Text = _onetimetaskEntity.Duration.ToString(); taskTypeComboBox.SelectedIndex = _onetimetaskEntity.Type; remarksTextBox.Text = _onetimetaskEntity.Comments; dateTimePickerEffective.Value = _onetimetaskEntity.Effectivedate; remarksTextBox.Text = _onetimetaskEntity.Comments; remarksErrorLabel.Text = ""; comboBoxType.Enabled = false; dateTimePickerForm.Enabled = true; } catch (Exception k) { applicationErrorLog.ErrorLog("Task", "setting one time tasks to UI", k.ToString()); } }
private async void actionsUserControl_SaveButtonOnClick(object sender, EventArgs e) { if (IsFormDataValid()) { tableLayoutPanel.Enabled = false; actionsUserControl.IsEnabledButtons = false; int id = 0; if (_onetimetaskEntity != null) { id = _onetimetaskEntity.Id; } else if (_schtaskEntity != null) { id = _schtaskEntity.Id; } string remarks = remarksTextBox.Text; int taskId = comboBoxType.SelectedIndex; double duration = double.Parse(amountNumericUpDown.Text); DateTime Effectivedate = dateTimePickerEffective.Value; if (taskId == 0) { //single time tasks OneTimeTasks taskEntity = new OneTimeTasks() { Id = id, Duration = duration, Comments = remarks, Effectivedate = Effectivedate, IsDelete = false, Type = taskTypeComboBox.SelectedIndex, CreatedDateTime = DateTime.Now }; if (id == 0) { await _applicationService.InsertTaskAsync(taskEntity, true); } else { await _applicationService.UpdateTaskAsync(taskEntity); } } else { //Scheduled tasks DateTime dtNextDate = DateTime.Now; string SelectedType = this.comboBoxRepeat.GetItemText(this.comboBoxRepeat.SelectedItem).Trim(); if (SelectedType == ContentRepeatItemEnum.Daily.ToString()) { dtNextDate = dateTimePickerForm.Value.AddDays(1); } else if (SelectedType == ContentRepeatItemEnum.Weekly.ToString()) { dtNextDate = dateTimePickerForm.Value.AddDays(7); } else if (SelectedType == ContentRepeatItemEnum.Monthly.ToString()) { dtNextDate = dateTimePickerForm.Value.AddDays(30); } else { dtNextDate = dateTimePickerForm.Value.AddYears(1); } ScheduledTasks taskSheduledEntity = new ScheduledTasks() { Id = id, Duration = duration, Comments = remarks, Effectivedate = Effectivedate, IsDelete = false, Type = comboBoxType.SelectedIndex, CreatedDateTime = DateTime.Now, RepeatType = SelectedType, StartDateTime = dateTimePickerForm.Value, EndDateTime = dateTimePickerTo.Value, IsActive = checkBoxActive.Checked, }; if (id == 0) { await _applicationService.InsertSheduledTasktAsync(taskSheduledEntity); } else { await _applicationService.UpdateSheduledTaskListAsync(taskSheduledEntity); } } _changeContentMainFormAction(ContentItemEnum.Task); } }