private List <Entities.Drug> GetDrugs(IDataReader reader) { var drugs = new List <Entities.Drug>(); while (reader.Read()) { var drugLinkWithDrugRoutes = new DrugsLinkWithDrugRoute(); var drugInfo = new Entities.Drug() { DrugId = DRE.GetNullableInt32(reader, "drug_id", 0), DrugOrXRay = DRE.GetNullableString(reader, "drug_or_xray", "D"), DrugCode = DRE.GetNullableInt32(reader, "drug_code", null), GenericName = DRE.GetNullableString(reader, "generic_name", null), DrugName = DRE.GetNullableString(reader, "drug_name", null), DrugGroupId = DRE.GetNullableInt32(reader, "drug_group_id", null), BrandId = DRE.GetNullableInt32(reader, "brand_id", null), DrugFormulationId = DRE.GetNullableInt32(reader, "drug_formulation_id", null), DrugFormulationCode = DRE.GetNullableString(reader, "drug_formulation_code", null), Strength = DRE.GetNullableString(reader, "strength", null), Unit = DRE.GetNullableString(reader, "unit", null), AdverseEffects = DRE.GetNullableString(reader, "adverse_effects", null), Precautions = DRE.GetNullableString(reader, "precautions", null), Remarks = DRE.GetNullableString(reader, "remarks", null), DrugLinkWithDrugRoutes = drugLinkWithDrugRoutes.GetDrugLinkByDrugId(DRE.GetNullableInt32(reader, "drug_id", 0)) }; drugs.Add(drugInfo); } return(drugs); }
public List <Entities.Drug> SearchDrugsAll() { var drugs = new List <Entities.Drug>(); try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.SearchDrugsAll)) { using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var drugLinkWithDrugRoutes = new DrugsLinkWithDrugRoute(); var drug = new Entities.Drug { DrugId = DRE.GetNullableInt32(reader, "drug_id", 0), DrugOrXRay = DRE.GetNullableString(reader, "drug_or_xray", "D"), DrugCode = DRE.GetNullableInt32(reader, "drug_code", null), GenericName = DRE.GetNullableString(reader, "generic_name", null), DrugName = DRE.GetNullableString(reader, "drug_name", null), DrugGroupId = DRE.GetNullableInt32(reader, "drug_group_id", null), BrandId = DRE.GetNullableInt32(reader, "brand_id", null), DrugFormulationId = DRE.GetNullableInt32(reader, "drug_formulation_id", null), DrugFormulationCode = DRE.GetNullableString(reader, "drug_formulation_code", null), Strength = DRE.GetNullableString(reader, "strength", null), Unit = DRE.GetNullableString(reader, "unit", null), AdverseEffects = DRE.GetNullableString(reader, "adverse_effects", null), Precautions = DRE.GetNullableString(reader, "precautions", null), Remarks = DRE.GetNullableString(reader, "remarks", null), DrugLinkWithDrugRoutes = drugLinkWithDrugRoutes.GetDrugLinkByDrugId(DRE.GetNullableInt32(reader, "drug_id", 0)) }; drugs.Add(drug); } } } } catch (Exception ex) { throw ex; } return(drugs); }
public Int32 SaveDrug(Entities.Drug drug) { var drugId = 0; var db = DBConnect.getDBConnection(); using (DbConnection conn = db.CreateConnection()) { conn.Open(); using (DbTransaction transaction = conn.BeginTransaction()) { try { var drugRouteLinkId = 0; if (drug != null) { if (drug.DrugId == null || drug.DrugId == 0) { drugId = AddDrug(drug, transaction); } else { if (drug.IsDeleted == true) { var result = DeleteDrug(drug, transaction); drugId = Convert.ToInt32(drug.DrugId); } else { if (drug.ModifiedBy > 0 || drug.ModifiedBy != null) { drugId = UpdateDrug(drug, transaction); // If records failed to save if (drugId < 0) { drugId = -1; } } } } if (drugId > 0) { if (drug.IsDeleted == true) { DrugsLinkWithDrugRoute dal = new DrugsLinkWithDrugRoute(); var result = dal.DeleteDrugRoutesLinkByDrugId(drugId, (int)drug.DeletedBy, drug.DeletedByIP, transaction); if (result == true) { drugId = 1; } } // Save Drugs Link with Drug Route if (drug.DrugLinkWithDrugRoutes != null) { if (drug.DrugLinkWithDrugRoutes.Count > 0) { foreach (Entities.DrugLinkWithDrugRoutes drugLinkRoute in drug.DrugLinkWithDrugRoutes) { drugLinkRoute.DrugId = drugId; DrugsLinkWithDrugRoute dal = new DrugsLinkWithDrugRoute(); drugRouteLinkId = dal.SaveDrugLinkWithDrugRoute(drugLinkRoute, transaction); // If records failed to save if (drugRouteLinkId < 0) { drugId = -1; } } } } } } if (drugId > 0) { transaction.Commit(); } else { transaction.Rollback(); } } catch (Exception ex) { drugId = -1; transaction.Rollback(); throw ex; } finally { db = null; } } } return(drugId); }