public Doctor Doctor(int id) { aGateway.command.CommandText = "SELECT * FROM Doctor_tbl WHERE ID='" + id+ "'"; aGateway.sqlConnection.Open(); SqlDataReader reader = aGateway.command.ExecuteReader(); Doctor aDoctor = new Doctor(); while (reader.Read()) { aDoctor.ID = Convert.ToInt16(reader["ID"].ToString()); aDoctor.CenterID = Convert.ToInt16(reader["CenterID"].ToString()); aDoctor.Name = reader["Name"].ToString(); } reader.Close(); aGateway.sqlConnection.Close(); return aDoctor; }
protected void saveDoctorButton_Click(object sender, EventArgs e) { Doctor newDoctor = new Doctor(); DAL.DAO.Center newCenter = (DAL.DAO.Center)Session["CenterInfoDetails"]; newDoctor.CenterID = newCenter.ID; newDoctor.Name = nameOfDoctorTextBox.Text; newDoctor.Degree = degreeOfDoctorTextBox.Text; newDoctor.Specialization = specializationOfDoctorTextBox.Text; if (aCenterManager.SaveDoctorInfo(newDoctor) == true) { labelNotification.Text = "Doctor Information Saved Successfully"; labelNotification.ForeColor = Color.Green; nameOfDoctorTextBox.Text = degreeOfDoctorTextBox.Text = specializationOfDoctorTextBox.Text = null; } else { labelNotification.Text = "Doctor Information can't save"; labelNotification.ForeColor = Color.Red; } }
public bool SaveDoctorInfo(Doctor newDoctor) { return aCenterGateway.SaveNewDoctorInfo(newDoctor); }
public bool SaveNewDoctorInfo(Doctor newDoctor) { string query = "INSERT INTO Doctor_tbl(Name,Degree,Specialization,CenterID)VALUES('" + newDoctor.Name + "','" + newDoctor.Degree + "','" + newDoctor.Specialization + "','" + newDoctor.CenterID + "')"; aGateway.command.CommandText = query; aGateway.sqlConnection.Open(); aGateway.command.ExecuteNonQuery(); aGateway.sqlConnection.Close(); return true; }
public List<Doctor> GetAllDoctorByCenterID(int CenterID) { aGateway.command.CommandText = "SELECT * FROM Doctor_tbl WHERE CenterID='" + CenterID + "'"; aGateway.sqlConnection.Open(); SqlDataReader reader = aGateway.command.ExecuteReader(); List<Doctor> doctorList = new List<Doctor>(); if (reader != null) while (reader.Read()) { Doctor aDoctor=new Doctor(); aDoctor.ID = Convert.ToInt16(reader["ID"].ToString()); aDoctor.CenterID = Convert.ToInt16(reader["CenterID"].ToString()); aDoctor.Name = reader["Name"].ToString(); doctorList.Add(aDoctor); } reader.Close(); aGateway.sqlConnection.Close(); return doctorList; }