protected void saveButton_Click(object sender, EventArgs e)
{
Doctor aDoctor = new Doctor();
aDoctor.Name = nameTextBox.Text;
aDoctor.Degree = degreeTextBox.Text;
aDoctor.Specialization = specializationTextBox.Text;
aDoctor.CenterID = Convert.ToInt32(Session["center_id"].ToString());
massegeLabel.Text = aDoctorManager.Insert(aDoctor);
}
public string Insert(Doctor aDoctor)
{
if (aDoctor.Name == "")
{
return "Enter A Center Name";
}
else if (aDoctorGateway.Insert(aDoctor) > 0)
return "Saved";
else
return "Try Again";
}
public int Insert(Doctor aDoctor)
{
string query = "insert into doctor_tbl values ('" + aDoctor.Name + "','" + aDoctor.Degree + "','" + aDoctor.Specialization + "','"+aDoctor.CenterID+"')";
SqlConnection aConnection = new SqlConnection(conncetionStr);
SqlCommand aCommand = new SqlCommand(query, aConnection);
aConnection.Open();
int rowAffect = aCommand.ExecuteNonQuery();
aConnection.Close();
return rowAffect;
}
