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