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); } }
public List <Entities.DrugDispenseDrugReturn> GetDrugDispenseDetailsByPatientId(Int32 patientId) { var drugDetails = new DrugDispenseDrugReturn(); return(drugDetails.GetDrugDispenseDetailsByPatientId(patientId)); }