internal void UpdateReminders(ReminderBL reminderBL)
{
try
{
using (SqlConnection openCon = new SqlConnection("Data Source=justin\\sqlexpress;Initial Catalog=Reminders;Integrated Security=True;"))
{
using (SqlCommand remindercmd = new SqlCommand())
{
remindercmd.Connection = openCon;
remindercmd.Parameters.Add("@ReminderId", SqlDbType.Int, 50).Value = reminderBL.ReminderId;
remindercmd.Parameters.Add("@ReminderName", SqlDbType.VarChar, 50).Value = reminderBL.ReminderName;
remindercmd.Parameters.Add("@ReminderDescription", SqlDbType.VarChar, 1000).Value = reminderBL.ReminderDescription;
remindercmd.Parameters.Add("@ReminderDate", SqlDbType.DateTime, 30).Value = reminderBL.ReminderDate;
remindercmd.Parameters.Add("@ShowBefore", SqlDbType.Int, 30).Value = reminderBL.ShowBefore;
remindercmd.Parameters.Add("@ReminderPriority", SqlDbType.Int, 30).Value = reminderBL.ReminderPriority;
remindercmd.CommandType = CommandType.StoredProcedure;
remindercmd.CommandText = "dbo.UpdateReminder";
openCon.Open();
remindercmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
}
}
private void Form1_Load(object sender, EventArgs e)
{
timer1.Enabled = true;
timer1.Start();
ReminderBL reminderobj = new ReminderBL();
dataGridView1.DataSource = reminderobj.LoadReminders();
}
private void btnSubmit_Click(object sender, EventArgs e)
{
ReminderBL reminderobj = new ReminderBL();
reminderobj.ReminderName = txtReminderName.Text;
reminderobj.ReminderDescription = rtxtReminderDescription.Text;
reminderobj.ReminderDate = dtmReminderDate.Value;
reminderobj.ReminderPriority = 1;
reminderobj.ShowBefore = Convert.ToInt32(nupReminderMinutes.Value);
reminderobj.SaveReminders();
dataGridView1.DataSource = reminderobj.LoadReminders();
}
private void timer1_Tick(object sender, EventArgs e)
{
timer1.Stop();
ReminderBL reminderobj = new ReminderBL();
DataTable dt = reminderobj.GetReminderOnTime();
for (int i = 0; i < dt.Rows.Count; i++)
{
string remindername = Convert.ToString(dt.Rows[i]["ReminderName"]);
string reminderdesc = Convert.ToString(dt.Rows[i]["ReminderDescription"]);
string reminderdate = Convert.ToString(dt.Rows[i]["ReminderDate"]);
ShowReminders showreminderPopUp = new ShowReminders(remindername, reminderdesc, reminderdate);
showreminderPopUp.Show();
}
timer1.Start();
}
public frmReminder()
{
InitializeComponent();
BL = new CRM.BusinessLayer.ReminderBL();
}
