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