private bool DeleteMedicalTestParameters(Entities.MedicalTestParameters medicalTestParameters, DbTransaction dbTransaction)
{
var isDeleted = false;
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.DeleteMedicalTestParameters))
{
database.AddInParameter(dbCommand, "@medical_test_parameter_id", DbType.Int32, medicalTestParameters.MedicalTestParameterId);
database.AddInParameter(dbCommand, "@deleted_by", DbType.Int32, medicalTestParameters.DeletedBy);
database.AddInParameter(dbCommand, "@deleted_by_ip", DbType.String, medicalTestParameters.DeletedByIP);
database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0);
var result = database.ExecuteNonQuery(dbCommand, dbTransaction);
if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value)
{
isDeleted = Convert.ToBoolean(database.GetParameterValue(dbCommand, "@return_value"));
}
}
}
catch (Exception e)
{
throw e;
}
return(isDeleted);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Entities.MedicalTestParameters> GetMedicalTestParameterDetailsByTestId(Int32 medicalTestId)
{
var medicalTestParameters = new List <Entities.MedicalTestParameters>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetMedicalTestParametersByTestId))
{
database.AddInParameter(dbCommand, "@medical_test_id", DbType.Int32, medicalTestId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var medicalTestParameter = new Entities.MedicalTestParameters()
{
MedicalTestParameterId = DRE.GetNullableInt32(reader, "medical_test_parameter_id", null),
MedicalTestId = DRE.GetNullableInt32(reader, "medical_test_id", 0),
TestParameterName = DRE.GetNullableString(reader, "test_parameter_name", null),
TestParameterDesc = DRE.GetNullableString(reader, "test_parameter_desc", null),
TestParameterSequence = DRE.GetNullableDecimal(reader, "test_parameter_sequence", null),
MinimumValue = DRE.GetNullableDecimal(reader, "minimum_value", null),
MaximumValue = DRE.GetNullableDecimal(reader, "maximum_value", null),
NormalValue = DRE.GetNullableDecimal(reader, "normal_value", null),
UnitOfMeasurementId = DRE.GetNullableInt32(reader, "unit_of_measurement_id", null),
UnitCode = DRE.GetNullableString(reader, "unit_code", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
medicalTestParameters.Add(medicalTestParameter);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(medicalTestParameters);
}
private Int32 AddMedicalTestParameters(Entities.MedicalTestParameters medicalTestParameters, DbTransaction dbTransaction)
{
var medicalTestParameterId = 0;
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.InsertMedicalTestParameters))
{
database.AddInParameter(dbCommand, "@medical_test_parameter_id", DbType.Int32, medicalTestParameters.MedicalTestParameterId);
database.AddInParameter(dbCommand, "@medical_test_id", DbType.Int32, medicalTestParameters.MedicalTestId);
database.AddInParameter(dbCommand, "@test_parameter_name", DbType.String, medicalTestParameters.TestParameterName);
database.AddInParameter(dbCommand, "@test_parameter_desc", DbType.String, medicalTestParameters.TestParameterDesc);
database.AddInParameter(dbCommand, "@test_parameter_sequence", DbType.Decimal, medicalTestParameters.TestParameterSequence);
database.AddInParameter(dbCommand, "@minimum_value", DbType.Decimal, medicalTestParameters.MinimumValue);
database.AddInParameter(dbCommand, "@maximum_value", DbType.Decimal, medicalTestParameters.MaximumValue);
database.AddInParameter(dbCommand, "@normal_value", DbType.Decimal, medicalTestParameters.NormalValue);
database.AddInParameter(dbCommand, "@unit_of_measurement_id", DbType.Int32, medicalTestParameters.UnitOfMeasurementId);
database.AddInParameter(dbCommand, "@created_by", DbType.Int32, medicalTestParameters.CreatedBy);
database.AddInParameter(dbCommand, "@created_by_ip", DbType.String, medicalTestParameters.CreatedByIP);
database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0);
medicalTestParameterId = database.ExecuteNonQuery(dbCommand, dbTransaction);
if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value)
{
medicalTestParameterId = Convert.ToInt32(database.GetParameterValue(dbCommand, "@return_value"));
}
}
}
catch (Exception e)
{
throw e;
}
return(medicalTestParameterId);
}
/// <summary>
///
/// </summary>
/// <param name="medicalTest"></param>
/// <returns></returns>
public Int32 SaveMedicalTestParameters(Entities.MedicalTestParameters medicalTestParameters, DbTransaction dbTransaction)
{
var medicalTestParameterId = 0;
if (medicalTestParameters.MedicalTestId == null || medicalTestParameters.MedicalTestParameterId == 0)
{
medicalTestParameterId = AddMedicalTestParameters(medicalTestParameters, dbTransaction);
}
else if (medicalTestParameters.ModifiedBy != null || medicalTestParameters.ModifiedBy > 0)
{
medicalTestParameterId = UpdateMedicalTestParameters(medicalTestParameters, dbTransaction);
}
else if (medicalTestParameters.IsDeleted == true)
{
var result = DeleteMedicalTestParameters(medicalTestParameters, dbTransaction);
if (result)
{
medicalTestParameterId = (int)medicalTestParameters.MedicalTestParameterId;
}
}
return(medicalTestParameterId);
}