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