private bool DeleteDrugDispenseReturnDetails(Entities.DrugDispenseReturn drugDispenseReturn, DbTransaction dbTransaction)
{
var IsDrugDispenseReturnDeleted = false;
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.DeleteDrugDispenseReturn))
{
database.AddInParameter(dbCommand, "@drug_dispense_return_id", DbType.Int32, drugDispenseReturn.DrugDispenseReturnId);
database.AddInParameter(dbCommand, "@deleted_by", DbType.Int32, drugDispenseReturn.DeletedBy);
database.AddInParameter(dbCommand, "@deleted_by_ip", DbType.String, drugDispenseReturn.DeletedByIP);
database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0);
var result = database.ExecuteNonQuery(dbCommand, dbTransaction);
if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value)
{
IsDrugDispenseReturnDeleted = Convert.ToBoolean(database.GetParameterValue(dbCommand, "@return_value"));
}
}
}
catch (Exception e)
{
throw e;
}
return(IsDrugDispenseReturnDeleted);
}
private Int32 AddDrugDispenseReturnDetails(Entities.DrugDispenseReturn drugDispenseReturn, DbTransaction dbTransaction)
{
var drugDispenseReturnId = 0;
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.InsertDrugDispenseReturn))
{
database.AddInParameter(dbCommand, "@drug_dispense_return_id", DbType.Int32, drugDispenseReturn.DrugDispenseReturnId);
database.AddInParameter(dbCommand, "@drug_dispense_id", DbType.Int32, drugDispenseReturn.DrugDispenseId);
database.AddInParameter(dbCommand, "@patient_id", DbType.Int32, drugDispenseReturn.PatientId);
database.AddInParameter(dbCommand, "@drug_return_date", DbType.String, drugDispenseReturn.DrugReturnDate);
database.AddInParameter(dbCommand, "@working_period_id", DbType.Int32, drugDispenseReturn.WorkingPeriodId);
database.AddInParameter(dbCommand, "@created_by", DbType.Int32, drugDispenseReturn.CreatedBy);
database.AddInParameter(dbCommand, "@created_by_ip", DbType.String, drugDispenseReturn.CreatedByIP);
database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0);
drugDispenseReturnId = database.ExecuteNonQuery(dbCommand, dbTransaction);
if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value)
{
drugDispenseReturnId = Convert.ToInt32(database.GetParameterValue(dbCommand, "@return_value"));
}
}
}
catch (Exception e)
{
throw e;
}
return(drugDispenseReturnId);
}
public List <Entities.DrugDispenseReturn> GetPastDrugReturnDatesByPatientId(Int32 patientId)
{
var drugDispenseDates = new List <Entities.DrugDispenseReturn>();
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.DrugDispenseReturn()
{
DrugDispenseReturnId = DRE.GetNullableInt32(reader, "drug_dispense_return_id", null),
DrugReturnDate = DRE.GetNullableString(reader, "drug_return_date", null)
};
drugDispenseDates.Add(drugDispenseDate);
}
}
}
}
catch (Exception e)
{
throw e;
}
return(drugDispenseDates);
}
public List <Entities.DrugDispenseReturn> SearchDrguDispenseReturn(Entities.DrugDispenseReturn drugDispenseReturn)
{
var drugDispenseReturns = new List <Entities.DrugDispenseReturn>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.SearchDrugDispenseReturn))
{
database.AddInParameter(dbCommand, "@financial_year", DbType.String, drugDispenseReturn.FinancialYear);
database.AddInParameter(dbCommand, "@first_name", DbType.String, drugDispenseReturn.FirstName);
database.AddInParameter(dbCommand, "@last_name", DbType.String, drugDispenseReturn.LastName);
database.AddInParameter(dbCommand, "@drug_return_from_date", DbType.String, drugDispenseReturn.DrugReturnFromDate);
database.AddInParameter(dbCommand, "@drug_return_to_date", DbType.String, drugDispenseReturn.DrugReturnToDate);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var drugReturn = new DataModel.DrugDispenseDrugReturn();
var drugDispenseDetails = new Entities.DrugDispenseReturn()
{
DrugDispenseReturnId = DRE.GetNullableInt32(reader, "drug_dispense_return_id", null),
DrugDispenseId = DRE.GetNullableInt32(reader, "drug_dispense_id", 0),
DrugReturnNo = DRE.GetNullableInt32(reader, "drug_return_no", null),
DrugReturnDate = DRE.GetNullableString(reader, "drug_return_date", null),
PatientId = DRE.GetNullableInt32(reader, "patient_id", null),
PatientCode = DRE.GetNullableInt32(reader, "patient_code", null),
PatientName = DRE.GetNullableString(reader, "full_name", 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),
DrugDispenseDrugReturns = drugReturn.GetDrugReturnDetailsByDrugDispenseReturnId(DRE.GetInt32(reader, "drug_dispense_return_id"))
};
drugDispenseReturns.Add(drugDispenseDetails);
}
}
}
}
catch (Exception e)
{
throw e;
}
return(drugDispenseReturns);
}
public Int32 SaveDrugDispenseReturnDetails(Entities.DrugDispenseReturn drugDispenseReturn)
{
return(_drugDispenseReturn.SaveDrugDispenseReturnDetails(drugDispenseReturn));
}
public List <Entities.DrugDispenseReturn> SearchDrguDispenseReturn(Entities.DrugDispenseReturn drugDispenseReturn)
{
return(_drugDispenseReturn.SearchDrguDispenseReturn(drugDispenseReturn));
}
public Int32 SaveDrugDispenseReturnDetails(Entities.DrugDispenseReturn drugDispenseReturn)
{
var drugDispenseReturnId = 0;
var db = DBConnect.getDBConnection();
using (DbConnection conn = db.CreateConnection())
{
conn.Open();
using (DbTransaction dbTransaction = conn.BeginTransaction())
{
try
{
var drugDispenseDrugReturnId = 0;
if (drugDispenseReturn != null)
{
if (drugDispenseReturn.DrugDispenseReturnId == null || drugDispenseReturn.DrugDispenseReturnId == 0)
{
drugDispenseReturnId = AddDrugDispenseReturnDetails(drugDispenseReturn, dbTransaction);
}
else if (drugDispenseReturn.ModifiedBy != null || drugDispenseReturn.ModifiedBy > 0)
{
drugDispenseReturnId = UpdateDrugDispenseReturnDetails(drugDispenseReturn, dbTransaction);
}
else if (drugDispenseReturn.IsDeleted == true)
{
var result = DeleteDrugDispenseReturnDetails(drugDispenseReturn, dbTransaction);
if (result)
{
drugDispenseReturnId = (int)drugDispenseReturn.DrugDispenseReturnId;
}
else
{
drugDispenseReturnId = -1;
}
}
if (drugDispenseReturnId > 0)
{
if (drugDispenseReturn.IsDeleted == true)
{
DrugDispenseDrugReturn drugReturnDB = new DrugDispenseDrugReturn();
var result = drugReturnDB.DeleteDrugDispenseDrugReturnDetailsByDrugDispenseReturnId((int)drugDispenseReturn.DrugDispenseReturnId, (int)drugDispenseReturn.DeletedBy, drugDispenseReturn.DeletedByIP, dbTransaction);
if (result)
{
drugDispenseDrugReturnId = (int)drugDispenseReturn.DrugDispenseReturnId;
}
}
if (drugDispenseReturn.DrugDispenseDrugReturns != null)
{
if (drugDispenseReturn.DrugDispenseDrugReturns.Count > 0)
{
foreach (Entities.DrugDispenseDrugReturn drugReturn in drugDispenseReturn.DrugDispenseDrugReturns)
{
DrugDispenseDrugReturn drugReturnDB = new DrugDispenseDrugReturn();
drugReturn.DrugDispenseReturnId = drugDispenseReturnId;
drugDispenseDrugReturnId = drugReturnDB.SaveDrugDispenseDrugReturn(drugReturn, dbTransaction);
if (drugDispenseDrugReturnId < 0)
{
drugDispenseReturnId = -1;
}
}
}
}
}
}
if (drugDispenseReturnId > 0)
{
dbTransaction.Commit();
}
else
{
dbTransaction.Rollback();
}
}
catch (Exception ex)
{
drugDispenseReturnId = -1;
dbTransaction.Rollback();
throw ex;
}
}
return(drugDispenseReturnId);
}
}
