public void Delete(UpdateTestEntity en)
{
var sql = "delete from test where id ='" + en.TestId + "'; ";
int ex = DataAccess.ExecuteQuery(sql);
if (ex >= 1)
{
MessageBox.Show(" Deleted ");
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
var en = new UpdateTestEntity();
var re = new UpdateTestRepo();
en.PatientName = txtName.Text;
en.TestId = txtTestNo.Text;
en.Date = dtpDate.Value.ToString("yyyy-MM-dd");
re.Search(mgvUpdateTest, en);
}
public void Update(UpdateTestEntity en, MetroGrid mgv)
{
var sql = "update test set name = '" + en.PatientName + "', age = '" + en.Age + "', sex = '" + en.Sex + "', reference = '" + en.Reference + "', date = '" + en.Date + "' where id = '" + en.TestId + "';";
int exe = DataAccess.ExecuteQuery(sql);
if (exe >= 1)
{
MessageBox.Show("Updated");
}
var query = "select * from test where id = '" + en.TestId + "';";
DataAccess.PopulateGridView(mgv, query);
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure?", "Confirmation", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
else
{
var en = new UpdateTestEntity();
var re = new UpdateTestRepo();
en.TestId = mgvUpdateTest.CurrentRow.Cells["id"].Value.ToString();
re.Delete(en);
re.LoadAll(mgvUpdateTest);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure?", "Confirmation", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
else
{
var en = new UpdateTestEntity();
var re = new UpdateTestRepo();
en.TestId = mgvUpdateTest.CurrentRow.Cells["id"].Value.ToString();
en.PatientName = mgvUpdateTest.CurrentRow.Cells["name"].Value.ToString();
en.Age = int.Parse(mgvUpdateTest.CurrentRow.Cells["age"].Value.ToString());
en.Sex = mgvUpdateTest.CurrentRow.Cells["sex"].Value.ToString();
en.Reference = mgvUpdateTest.CurrentRow.Cells["reference"].Value.ToString();
en.Date = DateTime.Parse(mgvUpdateTest.CurrentRow.Cells["date"].Value.ToString()).ToString("yyyy-MM-dd");
re.Update(en, mgvUpdateTest);
}
}
public void Search(MetroGrid mgv, UpdateTestEntity entity)
{
var sql = "select * from test where name = '" + entity.PatientName + "' or id = '" + entity.TestId + "' or date = '" + entity.Date + "'; ";
DataAccess.PopulateGridView(mgv, sql);
}
