public void RegisterEmployeeDoctor(RegisterEmployeeDoctorBO objRegisterEmployeeDoctorBO)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlCommand cmd = new SqlCommand("spRegisterDoctor", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@doctorEmpId", objRegisterEmployeeDoctorBO.doctorEmpId);
cmd.Parameters.Add("@doctorLicenseNumber", objRegisterEmployeeDoctorBO.doctorLicenseNumber);
cmd.Parameters.Add("@doctorDepartment", objRegisterEmployeeDoctorBO.doctorDepartment);
cmd.Parameters.Add("@doctorDegree", objRegisterEmployeeDoctorBO.doctorDegree);
cmd.Parameters.Add("@doctorUniversityName", objRegisterEmployeeDoctorBO.doctorUniversityName);
cmd.Parameters.Add("@doctorUniversityCity", objRegisterEmployeeDoctorBO.doctorUniversityCity);
cmd.Parameters.Add("@doctorUniversityState", objRegisterEmployeeDoctorBO.doctorUniversityState);
cmd.Parameters.Add("@doctorUniversityCountry", objRegisterEmployeeDoctorBO.doctorUniversityCountry);
cmd.Parameters.Add("@doctorExperience", objRegisterEmployeeDoctorBO.doctorExperience);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public void RegisterEmployeeDoctor(int doctorEmpId, string doctorLicenseNumber,
int doctorDepartment, int doctorDegree, string doctorUniversityName,
string doctorUniversityCity, string doctorUniversityState, string doctorUniversityCountry,
int doctorExperience)
{
RegisterEmployeeDoctorBO objRegisterEmployeeDoctorBO = new RegisterEmployeeDoctorBO();
objRegisterEmployeeDoctorBO.doctorEmpId = doctorEmpId;
objRegisterEmployeeDoctorBO.doctorLicenseNumber = doctorLicenseNumber;
objRegisterEmployeeDoctorBO.doctorDepartment = doctorDepartment;
objRegisterEmployeeDoctorBO.doctorDegree = doctorDegree;
objRegisterEmployeeDoctorBO.doctorUniversityName = doctorUniversityName;
objRegisterEmployeeDoctorBO.doctorUniversityCity = doctorUniversityCity;
objRegisterEmployeeDoctorBO.doctorUniversityState = doctorUniversityState;
objRegisterEmployeeDoctorBO.doctorUniversityCountry = doctorUniversityCountry;
objRegisterEmployeeDoctorBO.doctorExperience = doctorExperience;
RegisterEmployeeDoctorDL objRegisterEmployeeDoctorDL = new RegisterEmployeeDoctorDL();
objRegisterEmployeeDoctorDL.RegisterEmployeeDoctor(objRegisterEmployeeDoctorBO);
}
public void RegisterEmployeeDoctor(RegisterEmployeeDoctorBO objRegisterEmployeeDoctorBO)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlCommand cmd = new SqlCommand("spRegisterDoctor", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@doctorEmpId", objRegisterEmployeeDoctorBO.doctorEmpId);
cmd.Parameters.Add("@doctorLicenseNumber", objRegisterEmployeeDoctorBO.doctorLicenseNumber);
cmd.Parameters.Add("@doctorDepartment", objRegisterEmployeeDoctorBO.doctorDepartment);
cmd.Parameters.Add("@doctorDegree", objRegisterEmployeeDoctorBO.doctorDegree);
cmd.Parameters.Add("@doctorUniversityName", objRegisterEmployeeDoctorBO.doctorUniversityName);
cmd.Parameters.Add("@doctorUniversityCity", objRegisterEmployeeDoctorBO.doctorUniversityCity);
cmd.Parameters.Add("@doctorUniversityState", objRegisterEmployeeDoctorBO.doctorUniversityState);
cmd.Parameters.Add("@doctorUniversityCountry", objRegisterEmployeeDoctorBO.doctorUniversityCountry);
cmd.Parameters.Add("@doctorExperience", objRegisterEmployeeDoctorBO.doctorExperience);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public void RegisterEmployeeDoctor(int doctorEmpId, string doctorLicenseNumber,
int doctorDepartment, int doctorDegree, string doctorUniversityName,
string doctorUniversityCity, string doctorUniversityState, string doctorUniversityCountry,
int doctorExperience)
{
RegisterEmployeeDoctorBO objRegisterEmployeeDoctorBO = new RegisterEmployeeDoctorBO();
objRegisterEmployeeDoctorBO.doctorEmpId = doctorEmpId;
objRegisterEmployeeDoctorBO.doctorLicenseNumber = doctorLicenseNumber;
objRegisterEmployeeDoctorBO.doctorDepartment = doctorDepartment;
objRegisterEmployeeDoctorBO.doctorDegree = doctorDegree;
objRegisterEmployeeDoctorBO.doctorUniversityName = doctorUniversityName;
objRegisterEmployeeDoctorBO.doctorUniversityCity = doctorUniversityCity;
objRegisterEmployeeDoctorBO.doctorUniversityState = doctorUniversityState;
objRegisterEmployeeDoctorBO.doctorUniversityCountry = doctorUniversityCountry;
objRegisterEmployeeDoctorBO.doctorExperience = doctorExperience;
RegisterEmployeeDoctorDL objRegisterEmployeeDoctorDL = new RegisterEmployeeDoctorDL();
objRegisterEmployeeDoctorDL.RegisterEmployeeDoctor(objRegisterEmployeeDoctorBO);
}
