private Int32 UpdateDrugDispenseDetails(Entities.DrugDispense drugDispense, DbTransaction dbTransaction) { var drugDispenseId = 0; try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.UpdateDrugDispense)) { database.AddInParameter(dbCommand, "@drug_dispense_id", DbType.Int32, drugDispense.DrugDispenseId); database.AddInParameter(dbCommand, "@drug_dispense_date", DbType.String, drugDispense.DrugDispenseDate); database.AddInParameter(dbCommand, "@working_period_id", DbType.Int32, drugDispense.WorkingPeriodId); database.AddInParameter(dbCommand, "@modified_by", DbType.Int32, drugDispense.ModifiedBy); database.AddInParameter(dbCommand, "@modified_by_ip", DbType.String, drugDispense.ModifiedByIP); database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0); drugDispenseId = database.ExecuteNonQuery(dbCommand, dbTransaction); if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value) { drugDispenseId = Convert.ToInt32(database.GetParameterValue(dbCommand, "@return_value")); } } } catch (Exception e) { throw e; } return(drugDispenseId); }
private bool DeleteDrugDispenseDetails(Entities.DrugDispense drugDispense, DbTransaction dbTransaction) { var IsDrugDispenseDeleted = false; try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.DeleteDrugDispense)) { database.AddInParameter(dbCommand, "@drug_dispense_id", DbType.Int32, drugDispense.DrugDispenseId); database.AddInParameter(dbCommand, "@deleted_by", DbType.Int32, drugDispense.DeletedBy); database.AddInParameter(dbCommand, "@deleted_by_ip", DbType.String, drugDispense.DeletedByIP); database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0); var result = database.ExecuteNonQuery(dbCommand, dbTransaction); if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value) { IsDrugDispenseDeleted = Convert.ToBoolean(database.GetParameterValue(dbCommand, "@return_value")); } } } catch (Exception e) { throw e; } return(IsDrugDispenseDeleted); }
public List <Entities.DrugDispense> GetPastDrugDispenseDatesByPatientId(Int32 patientId) { var drugDispenseDates = new List <Entities.DrugDispense>(); try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetPastDrugDispenseDatesByPatientId)) { database.AddInParameter(dbCommand, "@patient_id", DbType.Int32, patientId); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var drugDispenseDate = new Entities.DrugDispense() { DrugDispenseId = DRE.GetNullableInt32(reader, "drug_dispense_id", null), DrugDispenseDate = DRE.GetNullableString(reader, "drug_dispense_date", null) }; drugDispenseDates.Add(drugDispenseDate); } } } } catch (Exception e) { throw e; } return(drugDispenseDates); }
public List <Entities.DrugDispense> SearchDrguDispense(Entities.DrugDispense drugDispense) { var drugDispenses = new List <Entities.DrugDispense>(); try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.SearchDrugDispense)) { database.AddInParameter(dbCommand, "@financial_year", DbType.String, drugDispense.FinancialYear); database.AddInParameter(dbCommand, "@first_name", DbType.String, drugDispense.FirstName); database.AddInParameter(dbCommand, "@last_name", DbType.String, drugDispense.LastName); database.AddInParameter(dbCommand, "@dispense_from_date", DbType.String, drugDispense.DrugDispenseFromDate); database.AddInParameter(dbCommand, "@dispense_to_date", DbType.String, drugDispense.DrugDispenseToDate); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var drugUtlisation = new DataModel.DrugDispenseDrugUtilisation(); var drugDispenseDetails = new Entities.DrugDispense() { DrugDispenseId = DRE.GetNullableInt32(reader, "drug_dispense_id", 0), DrugDispenseNo = DRE.GetNullableInt32(reader, "drug_dispense_no", null), DrugDispenseDate = DRE.GetNullableString(reader, "drug_dispense_date", null), PatientId = DRE.GetNullableInt32(reader, "patient_id", null), PatientCode = DRE.GetNullableInt32(reader, "patient_code", null), PatientName = DRE.GetNullableString(reader, "full_name", null), EmployerId = DRE.GetNullableInt32(reader, "employer_id", null), EmployerCode = DRE.GetNullableInt32(reader, "employer_code", null), EmployerName = DRE.GetNullableString(reader, "employer_name", null), WorkingPeriodId = DRE.GetNullableInt32(reader, "working_period_id", null), FinancialYear = DRE.GetNullableString(reader, "financial_year", null), DrugDispenseDrugUtilisations = drugUtlisation.GetDrugUtilisationByDrugDispenseId(DRE.GetInt32(reader, "drug_dispense_id")) }; drugDispenses.Add(drugDispenseDetails); } } } } catch (Exception e) { throw e; } return(drugDispenses); }
public Int32 SaveDrugDispenseDetails(Entities.DrugDispense drugDispense) { return(_drugDispense.SaveDrugDispenseDetails(drugDispense)); }
public List <Entities.DrugDispense> SearchDrguDispense(Entities.DrugDispense drugDispense) { return(_drugDispense.SearchDrguDispense(drugDispense)); }
public Int32 SaveDrugDispenseDetails(Entities.DrugDispense drugDispense) { var drugDispenseId = 0; var db = DBConnect.getDBConnection(); using (DbConnection conn = db.CreateConnection()) { conn.Open(); using (DbTransaction dbTransaction = conn.BeginTransaction()) { try { var drugDispenseDrugUtilisationId = 0; if (drugDispense != null) { if (drugDispense.DrugDispenseId == null || drugDispense.DrugDispenseId == 0) { drugDispenseId = AddDrugDispenseDetails(drugDispense, dbTransaction); } else if (drugDispense.ModifiedBy != null || drugDispense.ModifiedBy > 0) { drugDispenseId = UpdateDrugDispenseDetails(drugDispense, dbTransaction); } else if (drugDispense.IsDeleted == true) { var result = DeleteDrugDispenseDetails(drugDispense, dbTransaction); if (result) { drugDispenseId = (int)drugDispense.DrugDispenseId; } else { drugDispenseId = -1; } } if (drugDispenseId > 0) { if (drugDispense.IsDeleted == true) { DrugDispenseDrugUtilisation drugUtilisationDB = new DrugDispenseDrugUtilisation(); var result = drugUtilisationDB.DeleteDrugDispenseDrugUtilisationDetailsByDrugDispenseId((int)drugDispense.DrugDispenseId, (int)drugDispense.DeletedBy, drugDispense.DeletedByIP, dbTransaction); if (result) { drugDispenseDrugUtilisationId = (int)drugDispense.DrugDispenseId; } } if (drugDispense.DrugDispenseDrugUtilisations != null) { if (drugDispense.DrugDispenseDrugUtilisations.Count > 0) { foreach (Entities.DrugDispenseDrugUtilisation drugUtilisation in drugDispense.DrugDispenseDrugUtilisations) { DrugDispenseDrugUtilisation drugUtilisationDB = new DrugDispenseDrugUtilisation(); drugUtilisation.DrugDispenseId = drugDispenseId; drugDispenseDrugUtilisationId = drugUtilisationDB.SaveDrugDispenseDrugUtilisation(drugUtilisation, dbTransaction); if (drugDispenseDrugUtilisationId < 0) { drugDispenseId = -1; } } } } } } if (drugDispenseId > 0) { dbTransaction.Commit(); } else { dbTransaction.Rollback(); } } catch (Exception ex) { drugDispenseId = -1; dbTransaction.Rollback(); throw ex; } } return(drugDispenseId); } }