public List <RecordModel> GetRecords()
{
SqlConnection connection = null;
SqlCommand command = null;
SqlDataReader reader = null;
List <RecordModel> records = null;
try
{
connection = PACS_DaoUtility.CreateConnection();
command = PACS_DaoUtility.CreateCommand(connection, "GetRecords", CommandType.StoredProcedure);
PACS_DaoUtility.OpenConnection(connection);
reader = command.ExecuteReader();
if (reader.HasRows)
{
records = new List <RecordModel>();
while (reader.Read())
{
RecordModel record = new RecordModel
{
MRN = reader["MRN"].ToString(),
PatientFirstName = reader["PatientFirstName"].ToString(),
PatientLastName = reader["PatientLastName"].ToString(),
ReferringPhysicianName = reader["ReferringPhysicianName"].ToString(),
//CheckInDate = reader["CheckInDate"].ToString(),
CheckInDate = DateTime.Parse(reader["CheckInDate"].ToString()),
ModalityName = reader["ModalityType"].ToString()
};
records.Add(record);
}
}
reader.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
PACS_DaoUtility.CloseConnection(connection);
}
return(records);
}
public SqlDataAdapter GetDataFromDAL(string uMRN, string uFirstName, string uLastName, string uReferrringPhysician, DateTime uCheckInDate, string uModalityName)
{
SqlConnection connection = null;
SqlCommand command = null;
SqlDataAdapter reader = null;
try
{
connection = PACS_DaoUtility.CreateConnection();
command = PACS_DaoUtility.CreateCommand(connection, "GetSearchRecords", CommandType.StoredProcedure);
//command = DaoUtility.CreateCommand(connection, "update products set productname=@name, productdescription=@desc, price=@price where productid=@id", CommandType.Text);
SqlParameter pmMRN = PACS_DaoUtility.CreateParameter("@MRN", uMRN, SqlDbType.VarChar);
SqlParameter pmFirstName = PACS_DaoUtility.CreateParameter("@PatientFirstName", uFirstName, SqlDbType.VarChar);
SqlParameter pmLastName = PACS_DaoUtility.CreateParameter("@PatientLastName", uLastName, SqlDbType.VarChar);
SqlParameter pmReferringPhysician = PACS_DaoUtility.CreateParameter("@ReferringPhysicianName", uReferrringPhysician, SqlDbType.VarChar);
SqlParameter pmCheckInDate = PACS_DaoUtility.CreateParameter("@CheckInDate", uCheckInDate, SqlDbType.VarChar);
SqlParameter pmModalityName = PACS_DaoUtility.CreateParameter("@ModalityName", uModalityName, SqlDbType.VarChar);
command.Parameters.Add(pmMRN);
command.Parameters.Add(pmLastName);
command.Parameters.Add(pmCheckInDate);
command.Parameters.Add(pmModalityName);
command.Parameters.Add(pmReferringPhysician);
command.Parameters.Add(pmFirstName);
PACS_DaoUtility.OpenConnection(connection);
reader = new SqlDataAdapter(command);
}
catch (Exception ex)
{
throw ex;
}
return(reader);
}
//public SqlDataAdapter GetDataForFirstName(string uFirstName)
//{
// SqlConnection connection = null;
// SqlCommand command = null;
// SqlDataAdapter reader = null;
// //SqlDataReader reader = null;
// //List<Record> records = null;
// try
// {
// connection = DaoUtility.CreateConnection();
// command = DaoUtility.CreateCommand(connection, "GetSearchRecords", CommandType.StoredProcedure);
// SqlParameter pmFirstName = DaoUtility.CreateParameter("@FirstName", uFirstName, SqlDbType.VarChar);
// command.Parameters.Add(pmFirstName);
// DaoUtility.OpenConnection(connection);
// reader = new SqlDataAdapter(command);
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.ToString());
// }
// return reader;
//}
public int UpdateRecord(RecordModel record)
{
SqlConnection connection = null;
SqlCommand command = null;
int status = 0;
try
{
connection = PACS_DaoUtility.CreateConnection();
/*
* command = DaoUtility.CreateCommand(connection, "update PACS_Table set MRN=@paramMRN, PatientInitials=@PatientInitials, PatientFirstName=@PatientFirstName,PatientMiddleName=@PatientMiddleName,CheckInDate=@CheckInDate,CheckInTime=@CheckInTime, PatientBloodGroup=@PatientBloodGroup,PatientGender=@PatientGender,PatientDOB=@PatientDOB,ModalityReferCode=@ModalityReferCode,ExamType=@ExamType,ReferringPhysicianName=@ReferringPhysicianName,Allergies=@Allergies,DiabetesType=@DiabetesType,DescriptionAttribute=@Description where productid=@id", CommandType.Text);
*/
string query = "UpdateRecords";
command = PACS_DaoUtility.CreateCommand(connection, query, CommandType.StoredProcedure);
SqlParameter paramMRN =
PACS_DaoUtility.CreateParameter("@MRN", record.MRN, SqlDbType.VarChar);
SqlParameter paramPatientInitials =
PACS_DaoUtility.CreateParameter("@PatientInitials", record.PatientInitials, SqlDbType.VarChar);
SqlParameter paramPatientFirstName =
PACS_DaoUtility.CreateParameter("@PatientFirstName", record.PatientFirstName, SqlDbType.VarChar);
SqlParameter paramPatientMiddleName =
PACS_DaoUtility.CreateParameter("@PatientMiddleName", record.PatientMiddleName, SqlDbType.VarChar);
SqlParameter paramPatientLastName =
PACS_DaoUtility.CreateParameter("@PatientLastName", record.PatientLastName, SqlDbType.VarChar);
SqlParameter paramPatientCheckInDate =
PACS_DaoUtility.CreateParameter("@PatientCheckInDate", record.CheckInDate, SqlDbType.DateTime);
SqlParameter paramPatientCheckInTime =
PACS_DaoUtility.CreateParameter("@PatientCheckInTime", record.CheckInTime, SqlDbType.DateTime);
SqlParameter paramPatientBloodGroup =
PACS_DaoUtility.CreateParameter("@PatientBloodGroup", record.PatientBloodGroup, SqlDbType.VarChar);
SqlParameter paramPatientGender =
PACS_DaoUtility.CreateParameter("@PatientGender", record.PatientGender, SqlDbType.VarChar);
SqlParameter paramPatientDOB =
PACS_DaoUtility.CreateParameter("@PatientDOB", record.PatientDOB, SqlDbType.DateTime);
SqlParameter paramModalityReferCode =
PACS_DaoUtility.CreateParameter("@ModalityName", record.ModalityName, SqlDbType.VarChar);
SqlParameter paramExamType =
PACS_DaoUtility.CreateParameter("@ExamType", record.ExamType, SqlDbType.VarChar);
SqlParameter paramReferringPhysicianName =
PACS_DaoUtility.CreateParameter("@ReferringPhysicianName", record.ReferringPhysicianName, SqlDbType.VarChar);
SqlParameter paramPerformingPhysicianName =
PACS_DaoUtility.CreateParameter("@PerformingPhysicianName", record.PerformingPhysicianName, SqlDbType.VarChar);
SqlParameter paramAllergies =
PACS_DaoUtility.CreateParameter("@Allergies", record.Allergies, SqlDbType.VarChar);
SqlParameter paramDiabetesType =
PACS_DaoUtility.CreateParameter("@DiabetesType", record.DiabetesType, SqlDbType.VarChar);
SqlParameter paramDescription =
PACS_DaoUtility.CreateParameter("@Description", record.Description, SqlDbType.VarChar);
command.Parameters.Add(paramMRN);
command.Parameters.Add(paramPatientInitials);
command.Parameters.Add(paramPatientFirstName);
command.Parameters.Add(paramPatientMiddleName);
command.Parameters.Add(paramPatientLastName);
command.Parameters.Add(paramPatientCheckInDate);
command.Parameters.Add(paramPatientCheckInTime);
command.Parameters.Add(paramPatientBloodGroup);
command.Parameters.Add(paramPatientGender);
command.Parameters.Add(paramPatientDOB);
command.Parameters.Add(paramModalityReferCode);
command.Parameters.Add(paramExamType);
command.Parameters.Add(paramReferringPhysicianName);
command.Parameters.Add(paramPerformingPhysicianName);
command.Parameters.Add(paramAllergies);
command.Parameters.Add(paramDiabetesType);
command.Parameters.Add(paramDescription);
PACS_DaoUtility.OpenConnection(connection);
status = command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
PACS_DaoUtility.CloseConnection(connection);
}
return(status);
}
public int AddRecords(RecordModel record)
{
SqlConnection connection = null;
SqlCommand command = null;
int status = 0;
try
{
connection = PACS_DaoUtility.CreateConnection();
string query = "InsertRecord";
command = PACS_DaoUtility.CreateCommand(connection, query, CommandType.StoredProcedure);
SqlParameter paramMRN =
PACS_DaoUtility.CreateParameter("@MRN", record.MRN, SqlDbType.VarChar);
SqlParameter paramPatientInitials =
PACS_DaoUtility.CreateParameter("@PatientInitials", record.PatientInitials, SqlDbType.VarChar);
SqlParameter paramPatientFirstName =
PACS_DaoUtility.CreateParameter("@PatientFirstName", record.PatientFirstName, SqlDbType.VarChar);
SqlParameter paramPatientMiddleName =
PACS_DaoUtility.CreateParameter("@PatientMiddleName", record.PatientMiddleName, SqlDbType.VarChar);
SqlParameter paramPatientLastName =
PACS_DaoUtility.CreateParameter("@PatientLastName", record.PatientLastName, SqlDbType.VarChar);
SqlParameter paramPatientCheckInDate =
PACS_DaoUtility.CreateParameter("@PatientCheckInDate", record.CheckInDate, SqlDbType.DateTime);
SqlParameter paramPatientCheckInTime =
PACS_DaoUtility.CreateParameter("@PatientCheckInTime", record.CheckInTime, SqlDbType.DateTime);
SqlParameter paramPatientBloodGroup =
PACS_DaoUtility.CreateParameter("@PatientBloodGroup", record.PatientBloodGroup, SqlDbType.VarChar);
SqlParameter paramPatientGender =
PACS_DaoUtility.CreateParameter("@PatientGender", record.PatientGender, SqlDbType.VarChar);
SqlParameter paramPatientDOB =
PACS_DaoUtility.CreateParameter("@PatientDOB", record.PatientDOB, SqlDbType.DateTime);
SqlParameter paramModalityReferCode =
PACS_DaoUtility.CreateParameter("@ModalityName", record.ModalityName, SqlDbType.VarChar);
SqlParameter paramExamType =
PACS_DaoUtility.CreateParameter("@ExamType", record.ExamType, SqlDbType.VarChar);
SqlParameter paramReferringPhysicianName =
PACS_DaoUtility.CreateParameter("@ReferringPhysicianName", record.ReferringPhysicianName, SqlDbType.VarChar);
SqlParameter paramPerformingPhysicianName =
PACS_DaoUtility.CreateParameter("@PerformingPhysicianName", record.PerformingPhysicianName, SqlDbType.VarChar);
if (record.Allergies == null)
{
record.Allergies = "";
}
SqlParameter paramAllergies =
PACS_DaoUtility.CreateParameter("@Allergies", record.Allergies, SqlDbType.VarChar);
if (record.DiabetesType == null)
{
record.DiabetesType = "";
}
SqlParameter paramDiabetesType =
PACS_DaoUtility.CreateParameter("@DiabetesType", record.DiabetesType, SqlDbType.VarChar);
if (record.Description == null)
{
record.Description = "";
}
SqlParameter paramDescription =
PACS_DaoUtility.CreateParameter("@Description", record.Description, SqlDbType.VarChar);
command.Parameters.Add(paramMRN);
command.Parameters.Add(paramPatientInitials);
command.Parameters.Add(paramPatientFirstName);
command.Parameters.Add(paramPatientMiddleName);
command.Parameters.Add(paramPatientLastName);
command.Parameters.Add(paramPatientCheckInDate);
command.Parameters.Add(paramPatientCheckInTime);
command.Parameters.Add(paramPatientBloodGroup);
command.Parameters.Add(paramPatientGender);
command.Parameters.Add(paramPatientDOB);
command.Parameters.Add(paramModalityReferCode);
command.Parameters.Add(paramExamType);
command.Parameters.Add(paramReferringPhysicianName);
command.Parameters.Add(paramPerformingPhysicianName);
command.Parameters.Add(paramAllergies);
command.Parameters.Add(paramDiabetesType);
command.Parameters.Add(paramDescription);
/* Changes*/
PACS_DaoUtility.OpenConnection(connection);
status = command.ExecuteNonQuery();
/*End changes*/
}
catch (Exception ex)
{
throw ex;
}
finally
{
PACS_DaoUtility.CloseConnection(connection);
}
return(status);
}
