private void btnDelete_Click(object sender, EventArgs e) { var en = new DoctorUpdateAppEntity(); var re = new DoctorUpdateAppRepo(); en.AppNo = this.mgvUpdateAppoinment.CurrentRow.Cells["id"].Value.ToString(); re.Delete(en); }
public void Delete(DoctorUpdateAppEntity 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 DoctorUpdateAppRepo(); var en = new DoctorUpdateAppEntity(); en.Name = txtName.Text; en.Doctor = txtDoctor.Text; en.AppNo = txtAppointment.Text; re.Search(mgvUpdateAppoinment, en); }
public void Update(DoctorUpdateAppEntity 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 DoctorUpdateAppEntity(); var re = new DoctorUpdateAppRepo(); 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, DoctorUpdateAppEntity entity) { var sql = "select * from appointment where name = '" + entity.Name + "' or id = '" + entity.AppNo + "' or doctor = '" + entity.Doctor + "'"; DataAccess.PopulateGridView(mgv, sql); }