public void UpdateInfo(AddDoctorEntity en) { var sql = "update doctor set name= '" + en.Name + "', age = '" + en.Age + "', sex = '" + en.Sex + "',reference = '" + en.Reference + "',phone = '" + en.Phone + "', address = '" + en.Address + "',speciality = '" + en.Speciality + "', username = '******', password = '******' ,available = '" + en.Available + "', time = '" + en.Time + "' where id = '" + en.GeneratedId + "'; "; var ex = DataAccess.ExecuteQuery(sql); if (ex == 1) { MessageBox.Show("Updated"); } }
private void btnUpdate_Click(object sender, EventArgs e) { var en = new AddDoctorEntity(); var re = new AddDoctorRepo(); en.GeneratedId = lblId.Text; en.Name = mtxtName.Text; en.Age = int.Parse(mtxtAge.Text); en.Sex = mtxtSex.Text; en.Reference = mtxtReference.Text; en.Address = mtxtAddress.Text; en.Phone = mtxtPhone.Text; en.UserName = mtxtUserName.Text; en.Password = mtxtPassword.Text; en.Speciality = mtxtSpeciality.Text; en.Available = mtxtAvailable.Text; en.Time = mtxtTime.Text; re.UpdateInfo(en); }
public void AddDoctor(AddDoctorEntity en) { try { var sql = "insert into doctor values ('" + en.GeneratedId + "','" + en.Name + "','" + en.Age + "','" + en.Sex + "','" + en.Reference + "','" + en.Address + "','" + en.Phone + "','" + en.Speciality + "','" + en.UserName + "','" + en.Password + "','" + en.Available + "','" + en.Time + "');"; int ex = DataAccess.ExecuteQuery(sql); if (ex == 1) { MessageBox.Show("Saved"); } else { MessageBox.Show("Something went wrong"); } } catch (Exception e) { MessageBox.Show("Exception Occoured"); } }
private void btnSave_Click(object sender, EventArgs e) { var en = new AddDoctorEntity(); var re = new AddDoctorRepo(); if (ValidateToSave() == true) { en.GeneratedId = txtId.Text; en.Name = txtName.Text; en.Age = int.Parse(txtAge.Text); en.Sex = cmbSex.SelectedItem.ToString(); en.Reference = txtReference.Text; en.Speciality = txtSpeciality.Text; en.Address = txtAddress.Text; en.Phone = txtPhoneNo.Text; en.UserName = txtUserName.Text; en.Password = txtPassword.Text; en.Time = dtpTime.Value.ToString("hh:mm tt"); en.Available = Available(); lblId.Text = txtId.Text; mtxtName.Text = txtName.Text; mtxtAge.Text = txtAge.Text; mtxtUserName.Text = txtUserName.Text; mtxtPassword.Text = txtPassword.Text; mtxtSex.Text = cmbSex.SelectedItem.ToString(); mtxtReference.Text = txtReference.Text; mtxtAddress.Text = txtAddress.Text; mtxtPhone.Text = txtPhoneNo.Text; mtxtSpeciality.Text = txtSpeciality.Text; mtxtAvailable.Text = txtAvailable.Text; mtxtTime.Text = dtpTime.Value.ToString("hh:mm tt"); re.AddDoctor(en); pnlDetails.Visible = true; } else { MessageBox.Show("Invalid Input"); } }