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(); } } }