private void button1_Click(object sender, EventArgs e) { DbCalls db = new DbCalls(); WindowsFormsApplication1.Call w = new WindowsFormsApplication1.Call(); try { w.Id = int.Parse(textBox1.Text); if (db.CallExist(w.Id) == true) { DialogResult dialogResult = MessageBox.Show("Are You Sure To Delete Call?", "Delete", MessageBoxButtons.YesNoCancel); if (dialogResult == DialogResult.Yes) { db.DeleteCall(w); MessageBox.Show("Call was deleted Successfully"); } } else { MessageBox.Show("Call with similar ID was not found , try again", "Error"); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }
private void button1_Click(object sender, EventArgs e) { DbCalls db = new DbCalls(); try { WindowsFormsApplication1.Call w = new WindowsFormsApplication1.Call(); w.Id = int.Parse(textBox1.Text); if (comboBox1.SelectedIndex == 0) { dataGridView1.DataSource = db.SearchCallByCallId(w.Id).Tables[0]; } else if (comboBox1.SelectedIndex == 1) { dataGridView1.DataSource = db.SearchCallByWorkerId(w.Id).Tables[0]; } else { dataGridView1.DataSource = db.SearchCallByClientId(w.Id).Tables[0]; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }
private void button1_Click(object sender, EventArgs e) { WindowsFormsApplication1.Call w = new WindowsFormsApplication1.Call(); DbCalls db = new DbCalls(); w.Id = int.Parse(textBox1.Text); w.CallDate = textBox3.Text; w.CallTime = textBox2.Text; w.WorkerId = int.Parse(textBox4.Text); w.ClientId = int.Parse(textBox5.Text); w.Description = textBox6.Text; db.UpdateCall(w); MessageBox.Show("Successfully updated Call"); }
private void button3_Click(object sender, EventArgs e) { WindowsFormsApplication1.Call w = new WindowsFormsApplication1.Call(); DbCalls db = new DbCalls(); DataSet ds = new DataSet(); try { w.Id = int.Parse(textBox1.Text); textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); textBox4.Clear(); textBox5.Clear(); textBox6.Clear(); if (db.CallExist(w.Id) == true) { ds = db.getCallInfo(w); textBox1.Text = ds.Tables[0].Rows[0]["CallCode"].ToString(); textBox3.Text = ds.Tables[0].Rows[0]["CallDate"].ToString(); textBox2.Text = ds.Tables[0].Rows[0]["CallTime"].ToString(); textBox4.Text = ds.Tables[0].Rows[0]["WorkerId"].ToString(); textBox5.Text = ds.Tables[0].Rows[0]["ClientId"].ToString(); textBox6.Text = ds.Tables[0].Rows[0]["Description"].ToString(); } else { textBox1.Text = "Id does not exist"; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { DbCalls db = new DbCalls(); WindowsFormsApplication1.Call w = new WindowsFormsApplication1.Call(); try { w.Id = int.Parse(textBox1.Text); w.CallDate = textBox3.Text; w.CallTime = textBox2.Text; w.WorkerId = int.Parse(textBox4.Text); w.ClientId = int.Parse(textBox5.Text); w.Description = textBox6.Text; DbWorker wdb = new DbWorker(); DbClients cdb = new DbClients(); if (!wdb.WorkerExist(w.WorkerId)) { MessageBox.Show("Invalid Worker", "Error"); return; } if (!cdb.ClientExist(w.ClientId)) { MessageBox.Show("Invalid Client", "Error"); return; } } catch (Exception exception) { MessageBox.Show("Invalid parameters", "Error"); return; } db.insertCall(w); MessageBox.Show("add workstation Success"); }