private void DataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
DataGridViewRow row = dataGridView1.Rows[e.RowIndex];
Dictionary <string, string> data = new Dictionary <string, string>();
int id = Convert.ToInt32(row.Cells[0].Value);
data["name"] = row.Cells[1].Value.ToString();
data["email"] = row.Cells[2].Value.ToString();
data["subject"] = row.Cells[3].Value.ToString();
data["body"] = row.Cells[4].Value.ToString();
data["location"] = row.Cells[5].Value.ToString();
data["date"] = row.Cells[6].Value.ToString();
data["duration"] = row.Cells[7].Value.ToString();
try
{
conn = DatabaseReader.CreateConnection();
if (DatabaseReader.UpdateMeetingData(id, data, conn))
{
MessageBox.Show("Record updated successfully !");
}
else
{
MessageBox.Show("Unable to update record !");
}
}catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
DatabaseReader.Close(conn);
conn = null;
}
}
private void Button1_Click(object sender, EventArgs e)
{
try
{
Dictionary <string, string> data = new Dictionary <string, string>();
data["name"] = textBox1.Text;
data["email"] = textBox2.Text;
data["contact"] = textBox3.Text;
data["address"] = richTextBox1.Text;
data["company"] = textBox4.Text;
conn = DatabaseReader.CreateConnection();
DatabaseReader.CreateContactTable(conn);
if (DatabaseReader.InsertContactData(data, conn))
{
MessageBox.Show("Record added successfully !");
}
else
{
MessageBox.Show("Unable to add record !");
}
}catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
DatabaseReader.Close(conn);
conn = null;
}
}
private void DataGridView1_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e)
{
int id = Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[0].Value);
try
{
conn = DatabaseReader.CreateConnection();
if (DatabaseReader.RemoveData("MeetingTable", id, conn))
{
MessageBox.Show("Row deleted successfully !");
}
else
{
MessageBox.Show("Unable to delete data !");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
DatabaseReader.Close(conn);
conn = null;
}
}
private void button_refresh_Click(object sender, RoutedEventArgs e)
{
DatabaseReader databaseReader = new DatabaseReader();
databaseReader.Connect();
query = databaseReader.Read("SELECT o.id, o.Status, u.address, f.name, oi.quantity, o.total FROM orders o join users u on o.user_id=u.id join order_items oi on oi.order_id=o.id join foods f on f.id = oi.food_id");
databaseReader.Close();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
DatabaseReader databaseReader = new DatabaseReader();
databaseReader.Connect();
query = databaseReader.Read("update orders set Status='W realizacji' where id= " + query[comboBoxOrders.SelectedIndex][0]);
databaseReader.Close();
}
private void button_refresh_Click(object sender, RoutedEventArgs e)
{
DatabaseReader databaseReader = new DatabaseReader();
databaseReader.Connect();
query = databaseReader.Read("select o.id, f.name, oi.quantity, o.Status from orders o join order_items oi on o.id=oi.id join foods f on f.id=oi.food_id");
databaseReader.Close();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
Paragon();
DatabaseReader databaseReader = new DatabaseReader();
databaseReader.Connect();
query = databaseReader.Read("update orders set Status='W dostawie' where id= " + query[comboBoxDelivery.SelectedIndex][0]);
databaseReader.Close();
}
public Delivery()
{
InitializeComponent();
DatabaseReader databaseReader = new DatabaseReader();
databaseReader.Connect();
query = databaseReader.Read("SELECT o.id, o.Status, u.address, f.name, oi.quantity, o.total FROM orders o join users u on o.user_id=u.id join order_items oi on oi.order_id=o.id join foods f on f.id = oi.food_id");
databaseReader.Close();
SetOrdersId();
}
public Cook()
{
InitializeComponent();
DatabaseReader databaseReader = new DatabaseReader();
databaseReader.Connect();
query = databaseReader.Read("select o.id, f.name, oi.quantity, o.Status from orders o join order_items oi on o.id=oi.id join foods f on f.id=oi.food_id");
databaseReader.Close();
SetOrdersId();
}
private void Button1_Click(object sender, EventArgs e)
{
try
{
/*Outlook.AppointmentItem appt = Oapp.CreateItem(Outlook.OlItemType.olAppointmentItem) as Outlook.AppointmentItem;
* appt.Subject = textBox3.Text;
* appt.MeetingStatus = Outlook.OlMeetingStatus.olMeeting;
* appt.Location = textBox2.Text;
* appt.Start = dateTimePicker1.Value;
* appt.Duration = int.Parse(comboBox1.Text);
* appt.Body = richTextBox1.Text;
* Outlook.Recipient recipRequired = appt.Recipients.Add(textBox1.Text);
* recipRequired.Type = (int)Outlook.OlMeetingRecipientType.olRequired;
* appt.Recipients.ResolveAll();
* appt.Display(false);
* this.Close();*/
Dictionary <string, string> data = new Dictionary <string, string>();
data["name"] = textBox1.Text;
data["email"] = textBox2.Text;
data["subject"] = textBox3.Text;
data["body"] = richTextBox1.Text;
data["location"] = textBox4.Text;
data["date"] = dateTimePicker1.Value.Date.ToString();
data["duration"] = comboBox1.SelectedItem.ToString();
conn = DatabaseReader.CreateConnection();
DatabaseReader.CreateMeetingTable(conn);
if (DatabaseReader.InsertMeetingData(data, conn))
{
MessageBox.Show("Record added successfully !");
}
else
{
MessageBox.Show("Unable to add record !");
}
}catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
DatabaseReader.Close(conn);
conn = null;
}
}
public viewMeeting(string date)
{
InitializeComponent();
try
{
conn = DatabaseReader.CreateConnection();
SQLiteDataReader sdr = DatabaseReader.getTodayMeeting(date, conn);
DataTable dt = new DataTable();
dt.Columns.Add("Id");
dt.Columns.Add("Name");
dt.Columns.Add("Email");
dt.Columns.Add("Subject");
dt.Columns.Add("Body");
dt.Columns.Add("Location");
dt.Columns.Add("Date");
dt.Columns.Add("Duration");
while (sdr.Read())
{
DataRow row = dt.NewRow();
row["Id"] = sdr["Id"];
row["Name"] = sdr["Name"];
row["Email"] = sdr["Email"];
row["Subject"] = sdr["Subject"];
row["Location"] = sdr["Location"];
row["Body"] = sdr["Body"];
row["Date"] = sdr["Date"];
row["Duration"] = sdr["Duration"];
dt.Rows.Add(row);
}
sdr.Close();
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].ReadOnly = true;
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
finally
{
DatabaseReader.Close(conn);
conn = null;
}
}
public viewContact()
{
InitializeComponent();
try
{
conn = DatabaseReader.CreateConnection();
SQLiteDataReader sdr = DatabaseReader.ReadData("ContactTable", conn);
DataTable dt = new DataTable();
dt.Columns.Add("Id");
dt.Columns.Add("Name");
dt.Columns.Add("Email");
dt.Columns.Add("Contact");
dt.Columns.Add("Address");
dt.Columns.Add("Company");
while (sdr.Read())
{
DataRow row = dt.NewRow();
row["Id"] = sdr["Id"];
row["Name"] = sdr["Name"];
row["Email"] = sdr["Email"];
row["Contact"] = sdr["Contact"];
row["Address"] = sdr["Address"];
row["Company"] = sdr["Company"];
dt.Rows.Add(row);
}
sdr.Close();
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].ReadOnly = true;
}
catch (Exception e)
{
MessageBox.Show("Unable to fetch data !");
}
finally
{
DatabaseReader.Close(conn);
conn = null;
}
}
public void Close()
{
dbWriter.Close();
dbReader.Close();
init = false;
}