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