private void btnDelete_Click(object sender, EventArgs e)
{
var en = new UpdateAppointmentEntity();
var re = new UpdateAppointmentRepo();
en.AppNo = this.mgvUpdateAppoinment.CurrentRow.Cells["id"].Value.ToString();
re.Delete(en);
}
public void Delete(UpdateAppointmentEntity en)
{
var sql = "delete from appointment where id ='" + en.AppNo + "'; ";
int ex = DataAccess.ExecuteQuery(sql);
if (ex == 1)
{
MessageBox.Show("Deleted Successful");
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
var re = new UpdateAppointmentRepo();
var en = new UpdateAppointmentEntity();
en.Name = txtName.Text;
en.Doctor = txtDoctor.Text;
en.AppNo = txtAppointment.Text;
re.Search(mgvUpdateAppoinment, en);
}
public void Update(UpdateAppointmentEntity en, MetroGrid mgv)
{
var sql = "update appointment set name = '" + en.Name + "', age = '" + en.Age + "', sex = '" + en.Sex + "', reference = '" + en.Reference + "',doctor = '" + en.Doctor + "', date = '" + en.Date + "',time = '" + en.Time + "' where id = '" + en.AppNo + "';";
int exe = DataAccess.ExecuteQuery(sql);
if (exe == 1)
{
MessageBox.Show("Updated");
}
var query = "select * from appointment where id = '" + en.AppNo + "';";
DataAccess.PopulateGridView(mgv, query);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
var en = new UpdateAppointmentEntity();
var re = new UpdateAppointmentRepo();
en.Name = mgvUpdateAppoinment.CurrentRow.Cells["name"].Value.ToString();
en.Age = int.Parse(mgvUpdateAppoinment.CurrentRow.Cells["age"].Value.ToString());
en.Sex = mgvUpdateAppoinment.CurrentRow.Cells["sex"].Value.ToString();
en.Reference = mgvUpdateAppoinment.CurrentRow.Cells["reference"].Value.ToString();
en.Date = mgvUpdateAppoinment.CurrentRow.Cells["date"].Value.ToString();
en.AppNo = mgvUpdateAppoinment.CurrentRow.Cells["id"].Value.ToString();
en.Time = mgvUpdateAppoinment.CurrentRow.Cells["time"].Value.ToString();
en.Doctor = mgvUpdateAppoinment.CurrentRow.Cells["doctor"].Value.ToString();
re.Update(en, mgvUpdateAppoinment);
}
public void Search(MetroGrid mgv, UpdateAppointmentEntity entity)
{
var sql = "select * from appointment where name = '" + entity.Name + "' or id = '" + entity.AppNo + "' or doctor = '" + entity.Doctor + "'";
DataAccess.PopulateGridView(mgv, sql);
}
