private void button1_Click(object sender, EventArgs e) { DbWorker db = new DbWorker(); try { if (comboBox1.SelectedIndex == 0) { WindowsFormsApplication1.Worker w = new WindowsFormsApplication1.Worker(); w.Id = int.Parse(textBox1.Text); if (db.WorkerExist(w.Id) == true) { dataGridView1.DataSource = db.SearchWorkerById(w.Id).Tables[0]; } } else { dataGridView1.DataSource = db.SearchWorkerByName(textBox3.Text).Tables[0]; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }
private void button3_Click(object sender, EventArgs e) { WindowsFormsApplication1.Worker w = new WindowsFormsApplication1.Worker(); DbWorker db = new DbWorker(); DataSet ds = new DataSet(); try { w.Id = int.Parse(textBox1.Text); if (db.WorkerExist(w.Id) == true) { ds = db.getWorkerInfo(w); textBox1.Text = ds.Tables[0].Rows[0]["WorkerId"].ToString(); textBox3.Text = ds.Tables[0].Rows[0]["FirstName"].ToString(); textBox2.Text = ds.Tables[0].Rows[0]["LastName"].ToString(); textBox4.Text = ds.Tables[0].Rows[0]["Address"].ToString(); textBox5.Text = ds.Tables[0].Rows[0]["Phone"].ToString(); textBox6.Text = ds.Tables[0].Rows[0]["BirthDate"].ToString(); } else { textBox1.Text = "Worker not found "; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { DbWorker db = new DbWorker(); WindowsFormsApplication1.Worker w = new WindowsFormsApplication1.Worker(); try { w.Id = int.Parse(textBox1.Text); if (db.WorkerExist(w.Id) == true) { DialogResult dialogResult = MessageBox.Show("Are You Sure To Delete Worker?", "Delete", MessageBoxButtons.YesNoCancel); if (dialogResult == DialogResult.Yes) { db.DeleteWorker(w); MessageBox.Show("Worker was deleted Successfully"); } } else { MessageBox.Show("Worker with similar ID was not found , try again", "Error"); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }
public DataSet getWorkerInfo(WindowsFormsApplication1.Worker w) { DataSet ds = new DataSet(); string SqlStr = string.Format("select * from Workers where WorkerId={0}", w.Id); ds = ReturnDS(SqlStr); return(ds); }
private void button1_Click(object sender, EventArgs e) { WindowsFormsApplication1.Worker w = new WindowsFormsApplication1.Worker(); DbWorker db = new DbWorker(); w.Id = int.Parse(textBox1.Text); w.FirstName = textBox3.Text; w.LastName = textBox2.Text; w.Address = textBox4.Text; w.Phone = textBox5.Text; w.BirthDate = textBox6.Text; db.UpdateWorker(w); MessageBox.Show("Successfully updated Worker"); }
private void button1_Click(object sender, EventArgs e) { DbWorker db = new DbWorker(); WindowsFormsApplication1.Worker w = new WindowsFormsApplication1.Worker(); try { w.Id = int.Parse(textBox1.Text); w.FirstName = textBox3.Text; w.LastName = textBox2.Text; w.Address = textBox4.Text; w.Phone = textBox5.Text; w.BirthDate = textBox6.Text; } catch (Exception exception) { MessageBox.Show("Invalid parameters", "Error"); return; } db.insertWorker(w); MessageBox.Show("add workstation Success"); }