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