public void SaveMaintenanceOther(MaintenanceOther drugs)
{
if (service.UpdateMaintenanceOther(drugs) == 0)
service.CreateMaintenanceOther(drugs);
}
public void CreateMaintenanceOther(MaintenanceOther maintOther)
{
using (SqlConnection conn = new SqlConnection(connString))
{
string sql = @"INSERT INTO dbo.Maintenance_Other_To_Patient (
PatientId, OtherAnestheticDrugs, IntraoperativeAnalgesiaId, IVFluidTypeId
) VALUES (
@PatientId, @OtherAnestheticDrugs, @IntraoperativeAnalgesiaId, @IVFluidTypeId
)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@PatientId", SqlDbType.Int).Value = maintOther.PatientId;
if (maintOther.OtherAnestheticDrug == null)
cmd.Parameters.Add("@OtherAnestheticDrugs", SqlDbType.NVarChar).Value = DBNull.Value;
else
cmd.Parameters.Add("@OtherAnestheticDrugs", SqlDbType.NVarChar).Value = maintOther.OtherAnestheticDrug;
if (maintOther.IntraoperativeAnalgesia.Id == -1)
cmd.Parameters.Add("@IntraoperativeAnalgesiaId", SqlDbType.Int).Value = DBNull.Value;
else
cmd.Parameters.Add("@IntraoperativeAnalgesiaId", SqlDbType.Int).Value = maintOther.IntraoperativeAnalgesia.Id;
if (maintOther.IVFluidType.Id == -1)
cmd.Parameters.Add("@IVFluidTypeId", SqlDbType.Int).Value = DBNull.Value;
else
cmd.Parameters.Add("@IVFluidTypeId", SqlDbType.Decimal).Value = maintOther.IVFluidType.Id;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
finally
{
conn.Close();
}
}
}
public MaintenanceOther GetMaintenanceOther(int patientId, params MaintenanceOther.LazyComponents[] lazyComponents)
{
MaintenanceOther maintOther = new MaintenanceOther();
using (SqlConnection conn = new SqlConnection(connString))
{
string sql = BuildMaintenanceOtherSQL();
string from = @"FROM dbo.Maintenance_Other_To_Patient AS a";
string where = @" WHERE a.PatientId = @PatientId ";
foreach (MaintenanceOther.LazyComponents a in lazyComponents)
{
if (a == MaintenanceOther.LazyComponents.LOAD_INTRAOP_WITH_DETAILS)
{
sql += @", e.CategoryId as 'e.CategoryId', e.Label as 'e.Label', e.OtherFlag as 'e.OtherFlag', e.Description as 'e.Description',
e.Concentration as 'e.Concentration' ";
from += @" LEFT OUTER JOIN dbo.Dropdown_Types as e ON a.IntraoperativeAnalgesiaId = e.Id ";
}
else if (a == MaintenanceOther.LazyComponents.LOAD_IV_WITH_DETAILS)
{
sql += @", f.CategoryId as 'f.CategoryId', f.Label as 'f.Label', f.OtherFlag as 'f.OtherFlag', f.Description as 'f.Description',
f.Concentration as 'f.Concentration' ";
from += @" LEFT OUTER JOIN dbo.Dropdown_Types as f ON a.IVFluidTypeId = f.Id ";
}
}
sql = sql + from + where;
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@PatientId", SqlDbType.Int).Value = patientId;
try
{
conn.Open();
SqlDataReader read = cmd.ExecuteReader();
while (read.Read())
{
maintOther = new MaintenanceOtherCallback().ProcessRow(read, lazyComponents);
}
}
catch (Exception e)
{
throw e;
}
finally
{
conn.Close();
}
}
return maintOther;
}
public int UpdateMaintenanceOther(MaintenanceOther maintOther)
{
int returnNum = 0;
using (SqlConnection conn = new SqlConnection(connString))
{
string sql = @"UPDATE dbo.Maintenance_Other_To_Patient SET
OtherAnestheticDrugs = @OtherAnestheticDrugs, IntraoperativeAnalgesiaId = @IntraoperativeAnalgesiaId, IVFluidTypeId = @IVFluidTypeId
WHERE
PatientId = @PatientId";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@PatientId", SqlDbType.Int).Value = maintOther.PatientId;
if (maintOther.OtherAnestheticDrug == null)
cmd.Parameters.Add("@OtherAnestheticDrugs", SqlDbType.NVarChar).Value = DBNull.Value;
else
cmd.Parameters.Add("@OtherAnestheticDrugs", SqlDbType.NVarChar).Value = maintOther.OtherAnestheticDrug;
if (maintOther.IntraoperativeAnalgesia.Id == -1)
cmd.Parameters.Add("@IntraoperativeAnalgesiaId", SqlDbType.Int).Value = DBNull.Value;
else
cmd.Parameters.Add("@IntraoperativeAnalgesiaId", SqlDbType.Int).Value = maintOther.IntraoperativeAnalgesia.Id;
if (maintOther.IVFluidType.Id == -1)
cmd.Parameters.Add("@IVFluidTypeId", SqlDbType.Int).Value = DBNull.Value;
else
cmd.Parameters.Add("@IVFluidTypeId", SqlDbType.Decimal).Value = maintOther.IVFluidType.Id;
try
{
conn.Open();
returnNum = cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
finally
{
conn.Close();
}
}
return returnNum;
}
public Maintenance()
{
_maintenanceInjectionDrug = new MaintenanceInjectionDrug();
_maintenanceInhalantDrug = new MaintenanceInhalantDrug();
_maintenanceOther = new MaintenanceOther();
}