public void SaveMaintenanceInhalantDrugs(MaintenanceInhalantDrug drugs) { service.DeleteMaintenanceInjectionDrug(drugs.PatientId); if (service.UpdateMaintenanceInhalantDrug(drugs) == 0) service.CreateMaintenanceInhalantDrug(drugs); }
public void CreateMaintenanceInhalantDrug(MaintenanceInhalantDrug maintInhalant) { using (SqlConnection conn = new SqlConnection(connString)) { string sql = @"INSERT INTO dbo.Maintenance_Inhalant_Drugs_To_Patient ( PatientId, DrugId, InductionDose, InductionOxygenFlowRate, MaintenanceDose, MaintenanceOxygenFlowRate, BreathingSystemId, BreathingBagSizeId ) VALUES ( @PatientId, @DrugId, @InductionDose, @InductionOxygenFlowRate, @MaintenanceDose, @MaintenanceOxygenFlowRate, @BreathingSystemId, @BreathingBagSizeId )"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@PatientId", SqlDbType.Int).Value = maintInhalant.PatientId; if (maintInhalant.Drug.Id == -1) cmd.Parameters.Add("@DrugId", SqlDbType.Int).Value = DBNull.Value; else cmd.Parameters.Add("@DrugId", SqlDbType.Int).Value = maintInhalant.Drug.Id; if (maintInhalant.InductionPercentage == 0.0M) cmd.Parameters.Add("@InductionDose", SqlDbType.Decimal).Value = DBNull.Value; else cmd.Parameters.Add("@InductionDose", SqlDbType.Decimal).Value = maintInhalant.InductionPercentage; if (maintInhalant.InductionOxygenFlowRate == 0.0M) cmd.Parameters.Add("@InductionOxygenFlowRate", SqlDbType.Decimal).Value = DBNull.Value; else cmd.Parameters.Add("@InductionOxygenFlowRate", SqlDbType.Decimal).Value = maintInhalant.InductionOxygenFlowRate; if (maintInhalant.MaintenancePercentage == 0.0M) cmd.Parameters.Add("@MaintenanceDose", SqlDbType.Decimal).Value = DBNull.Value; else cmd.Parameters.Add("@MaintenanceDose", SqlDbType.Decimal).Value = maintInhalant.MaintenancePercentage; if (maintInhalant.MaintenanceOxygenFlowRate == 0.0M) cmd.Parameters.Add("@MaintenanceOxygenFlowRate", SqlDbType.Decimal).Value = DBNull.Value; else cmd.Parameters.Add("@MaintenanceOxygenFlowRate", SqlDbType.Decimal).Value = maintInhalant.MaintenanceOxygenFlowRate; if (maintInhalant.BreathingSystem.Id == -1) cmd.Parameters.Add("@BreathingSystemId", SqlDbType.Int).Value = DBNull.Value; else cmd.Parameters.Add("@BreathingSystemId", SqlDbType.Int).Value = maintInhalant.BreathingSystem.Id; if (maintInhalant.BreathingBagSize.Id == -1) cmd.Parameters.Add("@BreathingBagSizeId", SqlDbType.Int).Value = DBNull.Value; else cmd.Parameters.Add("@BreathingBagSizeId", SqlDbType.Int).Value = maintInhalant.BreathingBagSize.Id; try { conn.Open(); cmd.ExecuteNonQuery(); } catch (Exception e) { throw e; } finally { conn.Close(); } } }
public MaintenanceInhalantDrug GetMaintenanceInhalantDrugs(int patientId, params MaintenanceInhalantDrug.LazyComponents[] lazyComponents) { MaintenanceInhalantDrug maintInhalantDrugs = new MaintenanceInhalantDrug(); using (SqlConnection conn = new SqlConnection(connString)) { string sql = BuildMaintenanceInhalantDrugSQL(); string from = @"FROM dbo.Maintenance_Inhalant_Drugs_To_Patient AS a"; string where = @" WHERE a.PatientId = @PatientId "; foreach (MaintenanceInhalantDrug.LazyComponents a in lazyComponents) { if (a == MaintenanceInhalantDrug.LazyComponents.LOAD_DRUG_WITH_DETAILS) { sql += @", b.CategoryId as 'b.CategoryId', b.Label as 'b.Label', b.OtherFlag as 'b.OtherFlag', b.Description as 'b.Description', b.Concentration as 'b.Concentration', b.MaxDosage as 'b.MaxDosage' "; from += @" LEFT OUTER JOIN dbo.Dropdown_Types as b ON a.DrugId = b.Id "; } else if (a == MaintenanceInhalantDrug.LazyComponents.LOAD_BREATHING_BAG_SIZE_WITH_DETAILS) { sql += @", c.CategoryId as 'c.CategoryId', c.Label as 'c.Label', c.OtherFlag as 'c.OtherFlag', c.Description as 'c.Description', c.Concentration as 'c.Concentration' "; from += @" LEFT OUTER JOIN dbo.Dropdown_Types as c ON a.BreathingSystemId = c.Id "; } else if (a == MaintenanceInhalantDrug.LazyComponents.LOAD_BREATHING_SYSTEM_WITH_DETAILS) { sql += @", d.CategoryId as 'd.CategoryId', d.Label as 'd.Label', d.OtherFlag as 'd.OtherFlag', d.Description as 'd.Description', d.Concentration as 'd.Concentration' "; from += @" LEFT OUTER JOIN dbo.Dropdown_Types as d ON a.BreathingBagSizeId = d.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()) { maintInhalantDrugs = new MaintenanceInhalantDrugCallback().ProcessRow(read, lazyComponents); } } catch (Exception e) { throw e; } finally { conn.Close(); } } return maintInhalantDrugs; }
public int UpdateMaintenanceInhalantDrug(MaintenanceInhalantDrug maintInhalant) { int returnNum = 0; using (SqlConnection conn = new SqlConnection(connString)) { string sql = @"UPDATE dbo.Maintenance_Inhalant_Drugs_To_Patient SET DrugId = @DrugId, InductionDose = @InductionDose, InductionOxygenFlowRate = @InductionOxygenFlowRate, MaintenanceDose = @MaintenanceDose, MaintenanceOxygenFlowRate = @MaintenanceOxygenFlowRate, BreathingSystemId = @BreathingSystemId, BreathingBagSizeId = @BreathingBagSizeId WHERE PatientId = @PatientId"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@PatientId", SqlDbType.Int).Value = maintInhalant.PatientId; if (maintInhalant.Drug.Id == -1) cmd.Parameters.Add("@DrugId", SqlDbType.Int).Value = DBNull.Value; else cmd.Parameters.Add("@DrugId", SqlDbType.Int).Value = maintInhalant.Drug.Id; if (maintInhalant.InductionPercentage == 0.0M) cmd.Parameters.Add("@InductionDose", SqlDbType.Decimal).Value = DBNull.Value; else cmd.Parameters.Add("@InductionDose", SqlDbType.Decimal).Value = maintInhalant.InductionPercentage; if (maintInhalant.InductionOxygenFlowRate == 0.0M) cmd.Parameters.Add("@InductionOxygenFlowRate", SqlDbType.Decimal).Value = DBNull.Value; else cmd.Parameters.Add("@InductionOxygenFlowRate", SqlDbType.Decimal).Value = maintInhalant.InductionOxygenFlowRate; if (maintInhalant.MaintenancePercentage == 0.0M) cmd.Parameters.Add("@MaintenanceDose", SqlDbType.Decimal).Value = DBNull.Value; else cmd.Parameters.Add("@MaintenanceDose", SqlDbType.Decimal).Value = maintInhalant.MaintenancePercentage; if (maintInhalant.MaintenanceOxygenFlowRate == 0.0M) cmd.Parameters.Add("@MaintenanceOxygenFlowRate", SqlDbType.Decimal).Value = DBNull.Value; else cmd.Parameters.Add("@MaintenanceOxygenFlowRate", SqlDbType.Decimal).Value = maintInhalant.MaintenanceOxygenFlowRate; if (maintInhalant.BreathingSystem.Id == -1) cmd.Parameters.Add("@BreathingSystemId", SqlDbType.Int).Value = DBNull.Value; else cmd.Parameters.Add("@BreathingSystemId", SqlDbType.Int).Value = maintInhalant.BreathingSystem.Id; if (maintInhalant.BreathingBagSize.Id == -1) cmd.Parameters.Add("@BreathingBagSizeId", SqlDbType.Int).Value = DBNull.Value; else cmd.Parameters.Add("@BreathingBagSizeId", SqlDbType.Int).Value = maintInhalant.BreathingBagSize.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(); }