public RISDataManager(string MRN, string PatientInitials, string PatientFirstName, string PatientMiddleName, string PatientLastName, DateTime CheckInDate, DateTime CheckInTime, string PatientBloodGroup, string PatientGender, DateTime PatientDOB, string ModalityName, string ExamType, string ReferringPhysicianName, string PerformingPhysicianName)
{
patientData = new PatientModel()
{
MRN = MRN,
PatientInitials = PatientInitials,
PatientFirstName = PatientFirstName,
PatientMiddleName = PatientMiddleName,
PatientLastName = PatientLastName,
CheckInDate = CheckInDate,
CheckInTime = CheckInTime,
PatientBloodGroup = PatientBloodGroup,
PatientGender = PatientGender,
PatientDOB = PatientDOB
};
modalityData = new ModalityModel()
{
ModalityName = ModalityName,
ExamType = ExamType,
ReferringPhysicianName = ReferringPhysicianName,
PerformingPhysicianName = PerformingPhysicianName
};
dao = new RIS_DataAccessObject();
int status_PatientData = savePatientData();
int status_ModalityData = saveModalityData();
}
public int AddModalityData(ModalityModel modalityModel)
{
SqlConnection connection = null;
SqlCommand command = null;
int status = 0;
try
{
connection = RIS_DaoUtility.CreateConnection();
string query = "InsertModalityData";
command = RIS_DaoUtility.CreateCommand(connection, query, CommandType.StoredProcedure);
SqlParameter paramModalityName =
RIS_DaoUtility.CreateParameter("@pmodalityname", modalityModel.ModalityName, SqlDbType.VarChar);
SqlParameter paramExamType =
RIS_DaoUtility.CreateParameter("@pexamtype", modalityModel.ExamType, SqlDbType.VarChar);
SqlParameter paramReferringPhysicianName =
RIS_DaoUtility.CreateParameter("@preferringphysicianname", modalityModel.ReferringPhysicianName, SqlDbType.VarChar);
SqlParameter paramPerformingPhysicianName =
RIS_DaoUtility.CreateParameter("@pperformingphysicianname", modalityModel.PerformingPhysicianName, SqlDbType.VarChar);
command.Parameters.Add(paramModalityName);
command.Parameters.Add(paramExamType);
command.Parameters.Add(paramReferringPhysicianName);
command.Parameters.Add(paramPerformingPhysicianName);
RIS_DaoUtility.OpenConnection(connection);
status = command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
RIS_DaoUtility.CloseConnection(connection);
}
return(status);
}
public List <ModalityModel> GetModalityData()
{
SqlConnection connection = null;
SqlCommand command = null;
SqlDataReader reader = null;
List <ModalityModel> modalityList = null;
try
{
connection = RIS_DaoUtility.CreateConnection();
command = RIS_DaoUtility.CreateCommand(connection, "GetModalityData", CommandType.StoredProcedure);
RIS_DaoUtility.OpenConnection(connection);
reader = command.ExecuteReader();
if (reader.HasRows)
{
modalityList = new List <ModalityModel>();
while (reader.Read())
{
ModalityModel modalityModel = new ModalityModel
{
ModalityName = reader["ModalityName"].ToString(),
ExamType = reader["ExamType"].ToString(),
ReferringPhysicianName = reader["ReferringPhysicianName"].ToString(),
PerformingPhysicianName = reader["PerformingPhysicianName"].ToString()
};
modalityList.Add(modalityModel);
}
}
reader.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
RIS_DaoUtility.CloseConnection(connection);
}
return(modalityList);
}
