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