public void deleteTest(testDTO t)
{
s.sqlConnection.Open();
string query = "delete from tests where testId = '" + t.TestId + "'";
s.sqlCommand = new SqlCommand(query, s.sqlConnection);
s.sqlCommand.ExecuteNonQuery();
s.sqlConnection.Close();
}
private void testDataGridView_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e)
{
int testId = Convert.ToInt32(testDataGridView.Rows[e.Row.Index].Cells[0].Value.ToString());
string name = testDataGridView.Rows[e.Row.Index].Cells[1].Value.ToString();
string category = testDataGridView.Rows[e.Row.Index].Cells[2].Value.ToString();
string roomNo = testDataGridView.Rows[e.Row.Index].Cells[3].Value.ToString();
int price = Convert.ToInt32(testDataGridView.Rows[e.Row.Index].Cells[4].Value.ToString());
t = new testDTO(testId, name, category, roomNo, price);
}
public void createTest(testDTO t)
{
s.sqlConnection.Open();
string query = "insert into tests values('" + t.Name + "','"
+ t.Category + "','"
+ t.RoomNo + "','"
+ t.Price + "')";
s.sqlCommand = new SqlCommand(query, s.sqlConnection);
s.sqlCommand.ExecuteNonQuery();
s.sqlConnection.Close();
}
public void updateTest(testDTO t)
{
s.sqlConnection.Open();
string query = "update tests set name = '"
+ t.Name + "', category = '"
+ t.Category + "', roomNo = '"
+ t.RoomNo + "', price = '"
+ t.Price + "' where testId = '"
+ t.TestId + "' ";
s.sqlCommand = new SqlCommand(query, s.sqlConnection);
s.sqlCommand.ExecuteNonQuery();
s.sqlConnection.Close();
}
private void addButton_Click(object sender, EventArgs e)
{
if (testNameBox.Text == "" || testCategoryBox.Text == "" || testPriceBox.Text == "" || roomComboBox.Items.Count == 0)
{
MessageBox.Show("Please give all information");
return;
}
string name = testNameBox.Text;
string category = testCategoryBox.Text;
string roomNo = roomComboBox.SelectedItem.ToString();
int price = Convert.ToInt32(testPriceBox.Text);
testDTO t = new testDTO(name, category, roomNo, price);
testDAO tD = new testDAO();
tD.createTest(t);
clearFields();
}
private void deleteButton_Click(object sender, EventArgs e)
{
if (testDataGridView.SelectedRows.Count == 0)
{
MessageBox.Show("Select a row from table");
return;
}
int idx = testDataGridView.SelectedRows[0].Index;
int testId = Convert.ToInt32(testDataGridView.Rows[idx].Cells[0].Value.ToString());
string name = testDataGridView.Rows[idx].Cells[1].Value.ToString();
string category = testDataGridView.Rows[idx].Cells[2].Value.ToString();
string roomNo = testDataGridView.Rows[idx].Cells[3].Value.ToString();
int price = Convert.ToInt32(testDataGridView.Rows[idx].Cells[4].Value.ToString());
t = new testDTO(testId, name, category, roomNo, price);
tD.deleteTest(t);
loadTestsInfo();
}
private void testDataGridView_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
bool blank = false;
if (testDataGridView.Rows[e.RowIndex].Cells[0].Value.ToString() == "")
{
blank = true;
}
if (testDataGridView.Rows[e.RowIndex].Cells[1].Value.ToString() == "")
{
blank = true;
}
if (testDataGridView.Rows[e.RowIndex].Cells[2].Value.ToString() == "")
{
blank = true;
}
if (testDataGridView.Rows[e.RowIndex].Cells[3].Value.ToString() == "")
{
blank = true;
}
if (blank)
{
loadTestsInfo();
//MessageBox.Show("Error in here");
return;
}
int testId = Convert.ToInt32(testDataGridView.Rows[e.RowIndex].Cells[0].Value.ToString());
string name = testDataGridView.Rows[e.RowIndex].Cells[1].Value.ToString();
string category = testDataGridView.Rows[e.RowIndex].Cells[2].Value.ToString();
string roomNo = testDataGridView.Rows[e.RowIndex].Cells[3].Value.ToString();
int price = Convert.ToInt32(testDataGridView.Rows[e.RowIndex].Cells[4].Value.ToString());
DataSet ds = new DataSet();
roomDAO rD = new roomDAO();
ds = rD.getRooms();
bool flag = false;
foreach (DataRow row in ds.Tables[0].Rows)
{
string rN = row["roomNo"].ToString();
if (roomNo == rN)
{
flag = true;
break;
}
}
if (flag == false)
{
loadTestsInfo();
//MessageBox.Show("went to middle");
return;
}
t = new testDTO(testId, name, category, roomNo, price);
tD.updateTest(t);
loadTestsInfo();
//MessageBox.Show("went to last");
}
