private Int32 AddDrugDispenseDrugUtilisationDetails(Entities.PrecautionsList drugDispenseDrugUtilisation, DbTransaction dbTransaction) { var drugDispenseDrugUtilisationId = 0; try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.InsertPrescriptionsDrugUtilisation)) { database.AddInParameter(dbCommand, "@prescription_utilisation_id", DbType.Int32, drugDispenseDrugUtilisation.DrugUtilisationId); database.AddInParameter(dbCommand, "@Precautions_id", DbType.Int32, drugDispenseDrugUtilisation.DrugDispenseId); database.AddInParameter(dbCommand, "@drug_id", DbType.Int32, drugDispenseDrugUtilisation.DrugId); database.AddInParameter(dbCommand, "@dispense_qty", DbType.String, drugDispenseDrugUtilisation.DispenseQty); database.AddInParameter(dbCommand, "@Dosage", DbType.String, drugDispenseDrugUtilisation.Dosage); database.AddInParameter(dbCommand, "@created_by", DbType.Int32, drugDispenseDrugUtilisation.CreatedBy); database.AddInParameter(dbCommand, "@created_by_ip", DbType.String, drugDispenseDrugUtilisation.CreatedByIP); database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0); drugDispenseDrugUtilisationId = database.ExecuteNonQuery(dbCommand, dbTransaction); if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value) { drugDispenseDrugUtilisationId = Convert.ToInt32(database.GetParameterValue(dbCommand, "@return_value")); } } } catch (Exception e) { throw e; } return(drugDispenseDrugUtilisationId); }
private bool DeleteDrugDispenseDrugUtilisationDetails(Entities.PrecautionsList drugDispenseDrugUtilisation, DbTransaction dbTransaction) { bool IsDrugUtilisationDeleted = false; try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.DeletePrescriptionsDrugUtilisation)) { database.AddInParameter(dbCommand, "@drug_utilisation_id", DbType.Int32, drugDispenseDrugUtilisation.DrugUtilisationId); database.AddInParameter(dbCommand, "@deleted_by", DbType.Int32, drugDispenseDrugUtilisation.DeletedBy); database.AddInParameter(dbCommand, "@deleted_by_ip", DbType.String, drugDispenseDrugUtilisation.DeletedByIP); database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0); var result = database.ExecuteNonQuery(dbCommand, dbTransaction); if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value) { IsDrugUtilisationDeleted = Convert.ToBoolean(database.GetParameterValue(dbCommand, "@return_value")); } } } catch (Exception e) { throw e; } return(IsDrugUtilisationDeleted); }
//public List<Entities.PrecautionsList> GetDrugUtilisationByDrugDispenseId(Int32 drugDispenseId) //{ // ///var drugDetails = new PrecautionsList(); // return GetDrugUtilisationByDrugDispenseId(drugDispenseId); //} public List <Entities.PrecautionsList> GetDrugUtilisationByDrugDispenseId(Int32 drugDispenseId) { var drugDispenseDrugUtilisations = new List <Entities.PrecautionsList>(); try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetDrugDispenseDrugUtilisationDetailsByDrugDispenseId)) { database.AddInParameter(dbCommand, "@drug_dispense_id", DbType.Int32, drugDispenseId); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var drugUtilisation = new Entities.PrecautionsList() { DrugUtilisationId = DRE.GetNullableInt32(reader, "drug_utilisation_id", null), DrugDispenseId = DRE.GetNullableInt32(reader, "drug_dispense_id", null), DrugId = DRE.GetNullableInt32(reader, "drug_id", null), DrugCode = DRE.GetNullableInt32(reader, "drug_code", null), DrugName = DRE.GetNullableString(reader, "drug_name", null), DispenseQty = Convert.ToString(DRE.GetNullableDecimal(reader, "dispense_qty", null)), BalanceQty = DRE.GetNullableDecimal(reader, "balance_qty", null), PurchaseRate = DRE.GetNullableDecimal(reader, "purchase_rate", null), Amount = DRE.GetNullableDecimal(reader, "amount", null) }; drugDispenseDrugUtilisations.Add(drugUtilisation); } } } } catch (Exception e) { throw e; } return(drugDispenseDrugUtilisations); }
public List <Entities.PrecautionsList> GetUtilisationByDrugDispenseId(Int32 drugDispenseId) { var drugDispenseDrugUtilisations = new List <Entities.PrecautionsList>(); try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetPrescriptionsDrugUtilisationDetailsByDrugDispenseId)) { database.AddInParameter(dbCommand, "@drug_dispense_id", DbType.Int32, drugDispenseId); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var drugUtilisation = new Entities.PrecautionsList() { DrugUtilisationId = DRE.GetNullableInt32(reader, "prescription_utilisation_id", null), DrugDispenseId = DRE.GetNullableInt32(reader, "Precautions_id", null), DrugId = DRE.GetNullableInt32(reader, "drug_id", null), DrugCode = DRE.GetNullableInt32(reader, "drug_code", null), DrugName = DRE.GetNullableString(reader, "drug_name", null), DispenseQty = DRE.GetNullableString(reader, "dispense_qty", null), Dosage = DRE.GetNullableString(reader, "Dosage", null), }; drugDispenseDrugUtilisations.Add(drugUtilisation); } } } } catch (Exception e) { throw e; } return(drugDispenseDrugUtilisations); }
public Int32 SaveDrugDispenseDrugUtilisation(Entities.PrecautionsList drugDispenseDrugUtilisation, DbTransaction dbTransaction) { var drugUtilisationId = 0; if (drugDispenseDrugUtilisation.DrugUtilisationId == null || drugDispenseDrugUtilisation.DrugUtilisationId == 0) { drugUtilisationId = AddDrugDispenseDrugUtilisationDetails(drugDispenseDrugUtilisation, dbTransaction); } else if (drugDispenseDrugUtilisation.ModifiedBy != null || drugDispenseDrugUtilisation.ModifiedBy > 0) { drugUtilisationId = UpdateDrugDispenseDrugUtilisationDetails(drugDispenseDrugUtilisation, dbTransaction); } else if (drugDispenseDrugUtilisation.IsDeleted == true) { var result = DeleteDrugDispenseDrugUtilisationDetails(drugDispenseDrugUtilisation, dbTransaction); if (result) { drugUtilisationId = (int)drugDispenseDrugUtilisation.DrugUtilisationId; } } return(drugUtilisationId); }