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