/// <summary>
/// Updates the given relation of Lab_Orders_have_Lab_Tests
/// </summary>
/// <param name="relation">The Lab_Orders_have_Lab_Tests to update</param>
/// <returns>Whether or not the update succeeded</returns>
public static bool UpdateLab_Orders_have_Lab_Tests(Lab_Orders_have_Lab_Tests relation)
{
int rowsUpdated;
String updateStatement = @"UPDATE Lab_Orders_have_Lab_Tests
SET testPerformed = @testPerformed, results = @results , IsNormal = @IsNormal
WHERE labOrderID = @labOrderID AND labTestCode = @labTestCode" ;
using (SqlConnection connection = GetSQLConnection.GetConnection())
{
using (SqlCommand command = new SqlCommand(updateStatement, connection))
{
connection.Open();
if (relation.LabOrderID == null)
{
command.Parameters.AddWithValue("@labOrderID", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@labOrderID", relation.LabOrderID);
}
if (relation.LabTestCode == null)
{
command.Parameters.AddWithValue("@labTestCode", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@labTestCode", relation.LabTestCode);
}
command.Parameters.AddWithValue("@testPerformed", relation.TestPerformed);
command.Parameters.AddWithValue("@results", relation.Results);
command.Parameters.AddWithValue("@IsNormal", relation.IsNormal);
rowsUpdated = command.ExecuteNonQuery();
}
}
if (rowsUpdated < 1)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// Insert a new Lab_Orders_have_Lab_Tests relation into the db
/// </summary>
/// <param name="relation">The Lab_Orders_have_Lab_Tests to insert</param>
/// <returns>Whether or not the insert succeeded</returns>
public static bool InsertLab_Orders_have_Lab_Tests(Lab_Orders_have_Lab_Tests relation)
{
Object obj = null;
String insertStatement = @"INSERT INTO Lab_Orders_have_Lab_Tests (labOrderID, labTestCode, testPerformed, results , isNormal)
VALUES (@labOrderID, @labTestCode, @testPerformed, @results ,@isNormal)" ;
using (SqlConnection connection = GetSQLConnection.GetConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand(insertStatement, connection))
{
if (relation.LabOrderID == null)
{
command.Parameters.AddWithValue("@labOrderID", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@labOrderID", relation.LabOrderID);
}
if (relation.LabTestCode == null)
{
command.Parameters.AddWithValue("@labTestCode", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@labTestCode", relation.LabTestCode);
}
if (relation.TestPerformed == null)
{
command.Parameters.AddWithValue("@testPerformed", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@testPerformed", relation.TestPerformed);
}
if (relation.Results == null)
{
command.Parameters.AddWithValue("@results", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@results", relation.Results);
}
if (relation.IsNormal == null)
{
command.Parameters.AddWithValue("@IsNormal", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@IsNormal", relation.IsNormal);
}
obj = command.ExecuteScalar();
}
}
if (obj == null)
{
return(false);
}
else
{
return(true);
}
}
