public MaintenanceInhalantDrug()
{
_id = -1;
_drug = new DropdownValue();
_breathingBagSize = new DropdownValue();
_breathingSystem = new DropdownValue();
_checked = false;
}
public AnestheticPlanPremedication()
{
_id = -1;
_route = new DropdownValue();
_sedativedrug = new DropdownValue();
_sedativedosage = -1;
_opioiddrug = new DropdownValue();
_opioiddosage = -1;
_anticholinergicdrug = new DropdownValue();
_anticholinergicdosage = -1;
_ketaminedosage = -1;
}
public ClinicalFindings()
{
_id = -1;
_anesthesiaConcerns = new List<AnesthesiaConcern>();
_priorAnesthesia = new PriorAnesthesia();
_cardiacAuscultation = new DropdownValue();
_pulseQuality = new DropdownValue();
_respiratoryAuscultation = new DropdownValue();
_physicalStatusClassification = new DropdownValue();
_mucousMembraneColor = new DropdownValue();
_capillaryRefillTime = new DropdownValue();
}
public PatientInformation()
{
_student = new ASFUser();
_clinician = new ASFUser();
_procedure = new DropdownValue();
_temperament = new DropdownValue();
_preOperationPainAssessment = new DropdownValue();
_postOperationPainAssessment = new DropdownValue();
_ageInMonths = -1;
_ageInYears = -1;
_cageOrStallNumber = -1;
_dateSeenOn = DateTime.Now;
}
public ActionResult AddDropdownValue(DropdownValue dropdown)
{
Dictionary<string, object> dict = new Dictionary<string, object>();
try
{
service.CreateDropdownType(dropdown);
dict["success"] = true;
}
catch (Exception e)
{
dict["success"] = false;
dict["message"] = e.Message;
dict["source"] = e.StackTrace;
}
return Json(dict);
}
public void SaveDropdownValue(DropdownValue val)
{
service.UpdateDropdownType(val);
}
public AnesthesiaConcern()
{
_id = -1;
_concern = new DropdownValue();
}
public AnestheticPlanInjection()
{
_id = -1;
_route = new DropdownValue();
_drug = new DropdownValue();
}
public void CreateDropdownType(DropdownValue val)
{
using (SqlConnection conn = new SqlConnection(connString))
{
string sql = @"INSERT INTO dbo.Dropdown_Types (
CategoryId, Label, OtherFlag, Description, Concentration, MaxDosage
) VALUES (
@CategoryId, @Label, @OtherFlag, @Description, @Concentration, @MaxDosage
)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@CategoryId", SqlDbType.Int).Value = val.Category.Id;
cmd.Parameters.Add("@Label", SqlDbType.NVarChar).Value = val.Label;
cmd.Parameters.Add("@OtherFlag", SqlDbType.Char).Value = val.OtherFlag;
if (val.Description == null)
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = DBNull.Value;
else
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = val.Description;
if (val.MaxDosage == -1)
cmd.Parameters.Add("@MaxDosage", SqlDbType.Float).Value = DBNull.Value;
else
cmd.Parameters.Add("@MaxDosage", SqlDbType.Float).Value = val.MaxDosage;
if (val.Concentration == -1)
cmd.Parameters.Add("@Concentration", SqlDbType.Float).Value = DBNull.Value;
else
cmd.Parameters.Add("@Concentration", SqlDbType.Float).Value = val.Concentration;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
finally
{
conn.Close();
}
}
}
public Monitoring()
{
_id = -1;
_equipment = new DropdownValue();
}
public OtherAnestheticDrug()
{
_id = -1;
_drug = new DropdownValue();
}
public IVFluidType()
{
_id = -1;
_fluidType = new DropdownValue();
}
public MaintenanceInjectionDrug()
{
_id = -1;
_routeOfAdministration = new DropdownValue();
_drug = new DropdownValue();
}
public Procedure()
{
_id = -1;
_procedureInformation = new DropdownValue();
}
public DrugInformation()
{
_id = -1;
_drug = new DropdownValue();
}
public AnestheticPlanInhalant()
{
_id = -1;
_drug = new DropdownValue();
}
public void CreateDropdownType(DropdownValue val)
{
service.CreateDropdownType(val);
}
public void DeleteDropdownValue(DropdownValue val)
{
service.DeleteDropdownType(val);
}
public CurrentMedication()
{
_id = -1;
_medication = new DropdownValue();
}
public IntraoperativeAnalgesia()
{
_id = -1;
_analgesia = new DropdownValue();
}
public void DeleteDropdownType(DropdownValue val)
{
using (SqlConnection conn = new SqlConnection(connString))
{
string sql = @"DELETE FROM dbo.Dropdown_Types
WHERE
Id = @Id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = val.Id;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
finally
{
conn.Close();
}
}
}
public MaintenanceOther()
{
_id = -1;
_intraoperativeAnalgesia = new DropdownValue();
_iVFluidType = new DropdownValue();
}
public void UpdateDropdownType(DropdownValue val)
{
using (SqlConnection conn = new SqlConnection(connString))
{
string sql = @"UPDATE dbo.Dropdown_Types SET
Label = @Label, Description = @Description, Concentration = @Concentration, MaxDosage = @MaxDosage
WHERE
Id = @Id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = val.Id;
cmd.Parameters.Add("@Label", SqlDbType.NVarChar).Value = val.Label;
if (val.Description == null)
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = DBNull.Value;
else
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = val.Description;
if (val.MaxDosage == -1)
cmd.Parameters.Add("@MaxDosage", SqlDbType.Float).Value = DBNull.Value;
else
cmd.Parameters.Add("@MaxDosage", SqlDbType.Float).Value = val.MaxDosage;
if (val.Concentration == -1)
cmd.Parameters.Add("@Concentration", SqlDbType.Float).Value = DBNull.Value;
else
cmd.Parameters.Add("@Concentration", SqlDbType.Float).Value = val.Concentration;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
finally
{
conn.Close();
}
}
}