/// <summary> /// Fills controls for updation /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvRemainder_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { if (dgvRemainder.CurrentRow != null) { if (dgvRemainder.CurrentRow.Cells["reminderId"].Value != null) { if (dgvRemainder.CurrentRow.Cells["reminderId"].Value.ToString() != string.Empty) { decReminderId = Convert.ToDecimal(dgvRemainder.CurrentRow.Cells["reminderId"].Value.ToString()); ReminderSP spreminder = new ReminderSP(); ReminderInfo infoReminder = new ReminderInfo(); infoReminder = spreminder.RemainderView(decReminderId); txtFromDate.Text = infoReminder.FromDate.ToString("dd-MMM-yyyy"); txtToDate.Text = infoReminder.ToDate.ToString("dd-MMM-yyyy"); //dtpFromDate.Value = infoReminder.FromDate; //dtpToDate.Value = infoReminder.ToDate; txtRemindAbout.Text = infoReminder.RemindAbout; txtFromDate.Focus(); btnSave.Text = "Update"; btnDelete.Enabled = true; } } } } catch (Exception ex) { MessageBox.Show("PREM12:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public async Task LoadAsync(IDictionary <XName, object> readWriteValues) { reminders.Clear(); hasReactivationReminder = false; object reminderBookmarks; if (readWriteValues != null && readWriteValues.TryGetValue(WorkflowNamespace.Bookmarks, out reminderBookmarks)) { foreach (Bookmark reminderBookmark in (reminderBookmarks as List <Bookmark>)) { reminders[CreateReminderName(reminderBookmark)] = new ReminderInfo(reminderBookmark, ReminderState.RegisteredAndSaved); } } foreach (string reminderName in await instance.GetRemindersAsync()) { if (reminderName == WorkflowNamespace.ReminderNameForReactivation) { hasReactivationReminder = true; } else if (reminderName.StartsWith(WorkflowNamespace.ReminderPrefixForBookmarks) && // there can be other reminders !reminders.ContainsKey(reminderName)) { await instance.UnregisterReminderAsync(reminderName); } } await UnregisterReactivationReminderIfNotRequired(); }
public void RegisterOrUpdateReminder(Bookmark bookmark, TimeSpan dueTime) { string reminderName = CreateReminderName(bookmark); ReminderInfo reminderInfo; ReminderState reminderState; if (reminders.TryGetValue(reminderName, out reminderInfo)) { reminderState = reminderInfo.ReminderState; } else { reminderState = ReminderState.NonExistent; } switch (reminderState) { case ReminderState.NonExistent: case ReminderState.RegisterAndSave: case ReminderState.Unregister: reminders[reminderName] = new ReminderInfo(bookmark, ReminderState.RegisterAndSave, DateTime.UtcNow + dueTime); break; case ReminderState.ReregisterAndResave: case ReminderState.SaveAndUnregister: reminders[reminderName] = new ReminderInfo(bookmark, ReminderState.ReregisterAndResave, DateTime.UtcNow + dueTime); break; //case ReminderState.RegisteredButNotSaved: //case ReminderState.RegisteredButNotResaved: //case ReminderState.RegisteredAndSaved: default: throw new InvalidOperationException($"Reminder '{reminderName}' can't be registered in state '{reminderState}'."); } }
public bool RemainderEdit(ReminderInfo remainderinfo) { bool trueOrfalse = false; try { trueOrfalse = spReminder.RemainderEdit(remainderinfo); } catch (Exception ex) { MessageBox.Show("RM3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(trueOrfalse); }
public ReminderInfo RemainderView(decimal remainder) { ReminderInfo infoReminder = new ReminderInfo(); try { infoReminder = spReminder.RemainderView(remainder); } catch (Exception ex) { MessageBox.Show("ROI2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(infoReminder); }
public void AddReminder(DateTime dateToRemind, IUser user, string message) { if (_timer == null) { StartTimerAsync(); } var reminderInfo = new ReminderInfo() { User = user, Message = message }; ReminderInfos.Add(dateToRemind, reminderInfo); }
public Reminder StartDialogue(NumberOfReminders numberOfReminders) { ReminderInfo reminderInfo = new ReminderInfo(); Console.WriteLine(introduction); reminderInfo.Reminder = Console.ReadLine(); Console.WriteLine($"How long should I wait to remind you about it?"); Console.WriteLine("Hours?"); reminderInfo.Hours = Int32.Parse(Console.ReadLine()); Console.WriteLine("Minutes?"); reminderInfo.Minutes = Int32.Parse(Console.ReadLine()); Console.WriteLine("Seconds?"); reminderInfo.Seconds = Int32.Parse(Console.ReadLine()); Console.WriteLine($"Excellent! I'll remind you in {reminderInfo.Hours} hours, {reminderInfo.Minutes} minutes, and {reminderInfo.Seconds} seconds!"); reminder = new Reminder(reminderInfo, numberOfReminders); return(reminder); }
/// <summary> /// Function to Update values in Remainder Table /// </summary> /// <param name="remainderinfo"></param> /// <returns></returns> public bool RemainderEdit(ReminderInfo remainderinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("ReminderEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@reminderId", SqlDbType.Decimal); sprmparam.Value = remainderinfo.ReminderId; sprmparam = sccmd.Parameters.Add("@fromDate", SqlDbType.DateTime); sprmparam.Value = remainderinfo.FromDate; sprmparam = sccmd.Parameters.Add("@toDate", SqlDbType.DateTime); sprmparam.Value = remainderinfo.ToDate; sprmparam = sccmd.Parameters.Add("@remindAbout", SqlDbType.VarChar); sprmparam.Value = remainderinfo.RemindAbout; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = remainderinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = remainderinfo.Extra2; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = remainderinfo.ExtraDate; int inEffectedRows = sccmd.ExecuteNonQuery(); if (inEffectedRows > 0) { return(true); } else { return(false); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } finally { sqlcon.Close(); } }
public static List <ReminderInfo> All(string type) { using SQLiteCommand cmd = GlobalFunction.OpenDbConnection(); List <ReminderInfo> reminderList = new List <ReminderInfo>(); cmd.CommandText = "SELECT * FROM reminders"; using SQLiteDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { ReminderInfo reminder = new ReminderInfo() { ReminderId = rdr.GetInt32(0), CreationDate = rdr.GetInt32(1), ReminderDate = rdr.GetInt32(2), Description = rdr.GetString(3) }; reminderList.Add(reminder); } return(reminderList); }
/// <summary> /// Function for Save /// </summary> public void SaveFunction() { try { ReminderSP spReminder = new ReminderSP(); ReminderInfo infoReminder = new ReminderInfo(); infoReminder.FromDate = dtpFromDate.Value; infoReminder.ToDate = dtpToDate.Value; infoReminder.RemindAbout = txtRemindAbout.Text.Trim(); infoReminder.Extra1 = string.Empty; infoReminder.Extra2 = string.Empty; infoReminder.ExtraDate = DateTime.Now; if (spReminder.ReminderAdd(infoReminder)) { Messages.SavedMessage(); } } catch (Exception ex) { MessageBox.Show("PREM2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public ReminderInfo RemainderView(decimal remainder) { ReminderInfo remainderinfo = new ReminderInfo(); SqlDataReader sdrreader = null; try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("ReminderView", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam2 = new SqlParameter(); sprmparam2 = sccmd.Parameters.Add("@reminderId", SqlDbType.Decimal); sprmparam2.Value = remainder; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { remainderinfo.FromDate = DateTime.Parse(((DbDataReader)sdrreader)["fromDate"].ToString()); remainderinfo.ToDate = DateTime.Parse(((DbDataReader)sdrreader)["toDate"].ToString()); remainderinfo.RemindAbout = ((DbDataReader)sdrreader)["remindAbout"].ToString(); remainderinfo.Extra1 = ((DbDataReader)sdrreader)["extra1"].ToString(); remainderinfo.Extra2 = ((DbDataReader)sdrreader)["extra2"].ToString(); remainderinfo.ExtraDate = DateTime.Parse(((DbDataReader)sdrreader)["extraDate"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); base.sqlcon.Close(); } return(remainderinfo); }
/// <summary> /// Fills controls for updation /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvRemainder_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { RemainderBll bllRemainder = new RemainderBll(); try { if (dgvRemainder.CurrentRow != null) { if (dgvRemainder.CurrentRow.Cells["reminderId"].Value != null) { if (dgvRemainder.CurrentRow.Cells["reminderId"].Value.ToString() != string.Empty) { decReminderId = Convert.ToDecimal(dgvRemainder.CurrentRow.Cells["reminderId"].Value.ToString()); ReminderInfo infoReminder = new ReminderInfo(); infoReminder = bllRemainder.RemainderView(decReminderId); dtpFromDate.Value = infoReminder.FromDate; dtpToDate.Value = infoReminder.ToDate; txtRemindAbout.Text = infoReminder.RemindAbout; txtFromDate.Focus(); btnSave.Text = "Update"; btnDelete.Enabled = true; } } } } catch (Exception ex) { MessageBox.Show("PREM12:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function for Save /// </summary> public void SaveFunction() { try { RemainderBll bllRemainder = new RemainderBll(); ReminderInfo infoReminder = new ReminderInfo(); infoReminder.FromDate = dtpFromDate.Value; infoReminder.ToDate = dtpToDate.Value; infoReminder.RemindAbout = txtRemindAbout.Text.Trim(); infoReminder.Extra1 = PublicVariables._decCurrentUserId.ToString(); infoReminder.Extra2 = string.Empty; infoReminder.ExtraDate = DateTime.Now; if (bllRemainder.ReminderAdd(infoReminder)) { Messages.SavedMessage(); } } catch (Exception ex) { MessageBox.Show("PREM2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public async Task LoadAsync(IDictionary<XName, object> readWriteValues) { reminders.Clear(); hasReactivationReminder = false; object reminderBookmarks; if (readWriteValues != null && readWriteValues.TryGetValue(WorkflowNamespace.Bookmarks, out reminderBookmarks)) foreach (Bookmark reminderBookmark in (reminderBookmarks as List<Bookmark>)) reminders[CreateReminderName(reminderBookmark)] = new ReminderInfo(reminderBookmark, ReminderState.RegisteredAndSaved); foreach (string reminderName in await instance.GetRemindersAsync()) if (reminderName == WorkflowNamespace.ReminderNameForReactivation) hasReactivationReminder = true; else if (reminderName.StartsWith(WorkflowNamespace.ReminderPrefixForBookmarks) // there can be other reminders && !reminders.ContainsKey(reminderName)) await instance.UnregisterReminderAsync(reminderName); await UnregisterReactivationReminderIfNotRequired(); }
public void RegisterOrUpdateReminder(Bookmark bookmark, TimeSpan dueTime) { string reminderName = CreateReminderName(bookmark); ReminderInfo reminderInfo; ReminderState reminderState; if (reminders.TryGetValue(reminderName, out reminderInfo)) reminderState = reminderInfo.ReminderState; else reminderState = ReminderState.NonExistent; switch (reminderState) { case ReminderState.NonExistent: case ReminderState.RegisterAndSave: case ReminderState.Unregister: reminders[reminderName] = new ReminderInfo(bookmark, ReminderState.RegisterAndSave, DateTime.UtcNow + dueTime); break; case ReminderState.ReregisterAndResave: case ReminderState.SaveAndUnregister: reminders[reminderName] = new ReminderInfo(bookmark, ReminderState.ReregisterAndResave, DateTime.UtcNow + dueTime); break; //case ReminderState.RegisteredButNotSaved: //case ReminderState.RegisteredButNotResaved: //case ReminderState.RegisteredAndSaved: default: throw new InvalidOperationException($"Reminder '{reminderName}' can't be registered in state '{reminderState}'."); } }
public Reminder(ReminderInfo reminderInfo, NumberOfReminders numberOfReminders) { this.text = reminderInfo.Reminder; this.interval = new TimeSpan(reminderInfo.Hours, reminderInfo.Minutes, reminderInfo.Seconds); this.numberOfReminders = numberOfReminders; }