private void buttonEdit_Click(object sender, EventArgs e)
{
try
{
if (listViewTimers.SelectedItems.Count == 0)
{
MessageBox.Show("You have not selected an item.");
return;
}
NewTimer dlg = new NewTimer();
ListViewItem itm = listViewTimers.SelectedItems[0];
TimerType selected = (TimerType)itm.Tag;
dlg.m_pmoNum = selected.pmo_num;
dlg.m_desc = selected.desc;
if (dlg.ShowDialog() == DialogResult.OK)
{
//itm.Text = dlg.m_pmoNum;
//itm.SubItems[0].Text = dlg.m_desc;
string sql = string.Format("UPDATE [timer_types] SET description = '{0}' where pmo_number = '{1}'", dlg.m_desc, dlg.m_pmoNum);
LocalSqllite.ExecSQLCommand(sql);
PopulateList();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void buttonAdd_Click(object sender, EventArgs e)
{
try
{
NewTimer dlg = new NewTimer();
if (dlg.ShowDialog() == DialogResult.OK)
{
ListViewItem item = new ListViewItem();
item.Text = dlg.m_pmoNum;
item.SubItems.Add(dlg.m_desc);
listViewTimers.Items.Add(item);
string sql = string.Format("INSERT INTO [timer_types] (pmo_number, description) VALUES ('{0}', '{1}')", dlg.m_pmoNum, dlg.m_desc);
LocalSqllite.ExecSQLCommand(sql);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void buttonAdd_Click(object sender, EventArgs e)
{
try
{
NewTimer dlg = new NewTimer();
if (dlg.ShowDialog() == DialogResult.OK)
{
ListViewItem item = new ListViewItem();
item.Text = dlg.m_pmoNum;
item.SubItems.Add(dlg.m_desc);
listViewTimers.Items.Add(item);
string sql = string.Format("INSERT INTO [timer_types] (pmo_number, description) VALUES ('{0}', '{1}')", dlg.m_pmoNum, dlg.m_desc);
LocalSqllite.ExecSQLCommand(sql);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void buttonEdit_Click(object sender, EventArgs e)
{
try
{
if (listViewTimers.SelectedItems.Count == 0)
{
MessageBox.Show("You have not selected an item.");
return;
}
NewTimer dlg = new NewTimer();
ListViewItem itm = listViewTimers.SelectedItems[0];
TimerType selected = (TimerType)itm.Tag;
dlg.m_pmoNum = selected.pmo_num;
dlg.m_desc = selected.desc;
if (dlg.ShowDialog() == DialogResult.OK)
{
//itm.Text = dlg.m_pmoNum;
//itm.SubItems[0].Text = dlg.m_desc;
string sql = string.Format("UPDATE [timer_types] SET description = '{0}' where pmo_number = '{1}'", dlg.m_desc, dlg.m_pmoNum);
LocalSqllite.ExecSQLCommand(sql);
PopulateList();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}