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");
}
