public void Update(ManageReceptionistEntity en)
{
var sql = "update receptionist set name = '" + en.Name + "', age ='" + en.Age + "', sex = '" + en.Sex + "',reference = '" + en.Reference + "',address = '" + en.Address + "',phone = '" + en.Phone + "' where id = '" + en.Id + "'; ";
var ex = DataAccess.ExecuteQuery(sql);
if (ex == 1)
{
MessageBox.Show("Updated");
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
var en = new ManageReceptionistEntity();
var re = new ManageReceptionistRepo();
en.Id = txtId.Text;
en.Name = txtName.Text;
en.Phone = txtPhone.Text;
re.Search(en, mgvReceptionist);
mgvReceptionist.ClearSelection();
}
private void btnRupdate_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure?", "Confirmation", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
else
{
var en = new ManageReceptionistEntity();
var re = new ManageReceptionistRepo();
en.Id = txtRid.Text;
en.Name = txtRname.Text;
en.Age = txtRage.Text;
en.Sex = txtRsex.Text;
en.Reference = txtRreference.Text;
en.Address = txtRaddress.Text;
en.Phone = txtRphone.Text;
re.Update(en);
}
}
public void Search(ManageReceptionistEntity en, MetroGrid mgv)
{
var sql = "select id,name,age,sex,reference,address,phone from receptionist where id = '" + en.Id + "' or name = '" + en.Name + "' or phone = '" + en.Phone + "'; ";
DataAccess.PopulateGridView(mgv, sql);
}
