DocumentationMemoryAssistant
using System;
using System.Collections.Generic;
using System.Linq;
using System.Windows.Forms;
using ReminderData;
using System.Configuration;
namespace MemoryAssistant
{
public partial class Form1 : Form
{
//List enumUnits = new List() { "Months", "Years" };
//string ConnectionString = @"Provider=SQLNCLI11;Data Source = DESKTOP - 0J5PE19\SQLEXPRESS;Integrated Security = SSPI; Initial Catalog = Reminders";
//string ConnectionString = @"Server=DESKTOP-0J5PE19\SQLEXPRESS;Database=Reminders;Trusted_Connection=True";
string ConnectionString = ConfigurationManager.AppSettings["connString"];
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'dataSet1.Events' table. You can move, or remove it, as needed.
//this.eventsTableAdapter.Fill(this.dataSet1.Events);
List Events = new List();
Reminder rem = new Reminder();
Events = rem.DueEvents(ConnectionString);
dataGridView1.DataSource = Events;
HideFields();
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
txtKey.Text = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
txtDescription.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
string[] dateParts = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString().Split(' ');
txtDateStart.Text = dateParts[0];
dateParts = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString().Split(' ');
txtDateEnd.Text = dateParts[0];
dateParts = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString().Split(' ');
txtDateRemind.Text = dateParts[0];
chkDone.Checked = bool.Parse(dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString());
chkRenew.Checked = bool.Parse(dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString());
txtRenewUnit.Text = dataGridView1.Rows[e.RowIndex].Cells[7].Value.ToString();
txtRenewNo.Text = dataGridView1.Rows[e.RowIndex].Cells[8].Value.ToString();
btnUpdate.Text = "Update";
ShowFields();
}
private void btnNew_Click(object sender, EventArgs e)
{
ClearData();
btnUpdate.Text = "Save";
ShowFields();
}
private void ClearData()
{
txtKey.Text = "";
txtDescription.Text = "";
txtDateStart.Text = "";
txtDateEnd.Text = "";
txtDateRemind.Text = "";
chkDone.Checked = false;
chkRenew.Checked = false;
txtRenewUnit.Text = "";
txtRenewNo.Text = "";
}
private void btnUpdate_Click(object sender, EventArgs e)
{
List sqlData = new List();
sqlData.Add(txtKey.Text);
sqlData.Add(txtDescription.Text);
string[] dateParts = txtDateStart.Text.Split('/');
sqlData.Add(dateParts[2] + "-" + dateParts[1] + "-" + dateParts[0]);
dateParts = txtDateEnd.Text.Split('/');
sqlData.Add(dateParts[2] + "-" + dateParts[1] + "-" + dateParts[0]);
dateParts = txtDateRemind.Text.Split('/');
sqlData.Add(dateParts[2] + "-" + dateParts[1] + "-" + dateParts[0]);
sqlData.Add(chkDone.Checked.ToString());
sqlData.Add(chkRenew.Checked.ToString());
sqlData.Add(txtRenewUnit.Text);
sqlData.Add(txtRenewNo.Text);
Reminder rem = new Reminder();
if (btnUpdate.Text == "Save")
{
txtError.Text = rem.InsertSqlData(ConnectionString, sqlData);
}
else
{
List renewSqlData = new List();
if (chkRenew.Checked == true && chkDone.Checked == true)
{
renewSqlData = sqlData.ToList();
if (txtRenewUnit.Text == "Months")
{
renewSqlData[2] = DateTime.Parse(sqlData[2]).AddMonths(Int32.Parse(sqlData[8])).ToString("yyyy-MM-dd");
renewSqlData[3] = DateTime.Parse(sqlData[3]).AddMonths(Int32.Parse(sqlData[8])).ToString("yyyy-MM-dd");
renewSqlData[4] = DateTime.Parse(sqlData[4]).AddMonths(Int32.Parse(sqlData[8])).ToString("yyyy-MM-dd");
renewSqlData[5] = "0";
}
else if (txtRenewUnit.Text == "Years")
{
renewSqlData[2] = DateTime.Parse(sqlData[2]).AddYears(Int32.Parse(sqlData[8])).ToString("yyyy-MM-dd");
renewSqlData[3] = DateTime.Parse(sqlData[3]).AddYears(Int32.Parse(sqlData[8])).ToString("yyyy-MM-dd");
renewSqlData[4] = DateTime.Parse(sqlData[4]).AddYears(Int32.Parse(sqlData[8])).ToString("yyyy-MM-dd");
renewSqlData[5] = "0";
}
}
txtError.Text = rem.UpdateSqlData(ConnectionString, sqlData, renewSqlData);
}
UpdateDataGrid();
ClearData();
btnUpdate.Text = "Update";
HideFields();
}
private void btnExit_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void btnSelect_Click(object sender, EventArgs e)
{
UpdateDataGrid();
}
private void UpdateDataGrid()
{
Reminder rem = new Reminder();
if (rdoAll.Checked == true)
{
List Events = new List();
Events = rem.AllEvents(ConnectionString);
dataGridView1.DataSource = Events;
}
else if (rdoOpen.Checked == true)
{
List Events = new List();
Events = rem.OpenEvents(ConnectionString);
dataGridView1.DataSource = Events;
}
else
{
List Events = new List();
Events = rem.DueEvents(ConnectionString);
dataGridView1.DataSource = Events;
}
}
private void rdoOpen_CheckedChanged(object sender, EventArgs e)
{
Reminder rem = new Reminder();
if (rdoOpen.Checked == true)
{
List Events = new List();
Events = rem.OpenEvents(ConnectionString);
dataGridView1.DataSource = Events;
}
}
private void rdoDue_CheckedChanged(object sender, EventArgs e)
{
if (rdoDue.Checked == true)
{
Reminder rem = new Reminder();
List Events = new List();
Events = rem.DueEvents(ConnectionString);
dataGridView1.DataSource = Events;
}
}
private void rdoAll_CheckedChanged(object sender, EventArgs e)
{
if (rdoAll.Checked == true)
{
Reminder rem = new Reminder();
List Events = new List();
Events = rem.AllEvents(ConnectionString);
dataGridView1.DataSource = Events;
}
}
private void HideFields()
{
lblKey.Visible = false;
lblDescription.Visible = false;
lblDone.Visible = false;
lblDateStart.Visible = false;
lblDateEnd.Visible = false;
lblDateRemind.Visible = false;
lblRenew.Visible = false;
lblRenewUnit.Visible = false;
lblRenewNo.Visible = false;
txtKey.Visible = false;
txtDescription.Visible = false;
chkDone.Visible = false;
txtDateStart.Visible = false;
txtDateEnd.Visible = false;
txtDateRemind.Visible = false;
chkRenew.Visible = false;
txtRenewUnit.Visible = false;
txtRenewNo.Visible = false;
txtError.Visible = false;
btnUpdate.Visible = false;
}
private void ShowFields()
{
lblKey.Visible = true;
lblDescription.Visible = true;
lblDone.Visible = true;
lblDateStart.Visible = true;
lblDateEnd.Visible = true;
lblDateRemind.Visible = true;
lblRenew.Visible = true;
lblRenewUnit.Visible = true;
lblRenewNo.Visible = true;
txtKey.Visible = true;
txtDescription.Visible = true;
chkDone.Visible = true;
txtDateStart.Visible = true;
txtDateEnd.Visible = true;
txtDateRemind.Visible = true;
chkRenew.Visible = true;
txtRenewUnit.Visible = true;
txtRenewNo.Visible = true;
btnUpdate.Visible = true;
}
// Empty paragraphs
private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
}
private void label6_Click(object sender, EventArgs e)
{
}
private void textBox3_TextChanged(object sender, EventArgs e)
{
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
}
}