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