private void btnSearch_Click(object sender, EventArgs e)
{
var en = new ManageDoctorEntity();
var re = new ManageDoctorRepo();
en.Id = txtId.Text;
en.Name = txtName.Text;
en.Phone = txtPhone.Text;
re.Search(en, mgvDoctor);
}
public void Update(ManageDoctorEntity en)
{
var sql = "update doctor set name = '" + en.Name + "', age = '" + en.Age + "', sex = '" + en.Sex + "',reference = '" + en.Reference + "',address = '" + en.Address + "',phone = '" + en.Phone + "',speciality = '" + en.Speciality + "',available= '" + en.Available + "',time = '" + en.Time + "' where id = '" + en.Id + "'; ";
var ex = DataAccess.ExecuteQuery(sql);
if (ex == 1)
{
MessageBox.Show("Updated");
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
var en = new ManageDoctorEntity();
var re = new ManageDoctorRepo();
en.Id = txtDid.Text;
en.Name = txtDname.Text;
en.Age = txtDage.Text;
en.Sex = txtDsex.Text;
en.Reference = txtDreference.Text;
en.Speciality = txtDspeciality.Text;
en.Available = txtDavailable.Text;
en.Address = txtDaddress.Text;
en.Phone = txtDphone.Text;
en.Time = dtpTime.Value.ToString("hh:mm tt");
re.Update(en);
}
public void Search(ManageDoctorEntity en, MetroGrid mgv)
{
var sql = "select id,name,age,sex,reference,speciality,available,time,address,phone from doctor where id = '" + en.Id + "' or name = '" + en.Name + "' or phone = '" + en.Phone + "'; ";
DataAccess.PopulateGridView(mgv, sql);
}