public List <Entities.XRayFilmUsed> GetFilmUsedDetailsByXRayIssueId(Int32 xrayIssueId) { var xrayfilmDetails = new XRayFilmUsed(); return(xrayfilmDetails.GetFilmUsedDetailsByXRayIssueId(xrayIssueId)); }
public Int32 SaveXRayIssueDetails(Entities.XRayIssue xrayIssue) { var XRayIssueId = 0; var db = DBConnect.getDBConnection(); using (DbConnection conn = db.CreateConnection()) { conn.Open(); using (DbTransaction dbTransaction = conn.BeginTransaction()) { try { var xrayFilmUsedId = 0; if (xrayIssue != null) { if (xrayIssue.XRayIssueId == null || xrayIssue.XRayIssueId == 0) { XRayIssueId = AddXRayIssueDetails(xrayIssue, dbTransaction); } else if (xrayIssue.ModifiedBy != null || xrayIssue.ModifiedBy > 0) { XRayIssueId = UpdateXRayIssueDetails(xrayIssue, dbTransaction); } else if (xrayIssue.IsDeleted == true) { var result = DeleteXRayIssueDetails(xrayIssue, dbTransaction); if (result) { XRayIssueId = (int)xrayIssue.XRayIssueId; } else { XRayIssueId = -1; } } if (XRayIssueId > 0) { if (xrayIssue.IsDeleted == true) { XRayFilmUsed xRayFilmUsed = new XRayFilmUsed(); var result = xRayFilmUsed.DeleteXRayFilmUsedDetailsByXRayIssueId((int)xrayIssue.XRayIssueId, (int)xrayIssue.DeletedBy, xrayIssue.DeletedByIP, dbTransaction); if (result) { XRayIssueId = (int)xrayIssue.XRayIssueId; } } if (xrayIssue.XRayFilmsUsed != null) { if (xrayIssue.XRayFilmsUsed.Count > 0) { foreach (Entities.XRayFilmUsed xrayFilmUsed in xrayIssue.XRayFilmsUsed) { XRayFilmUsed xRayFilmUsedDB = new XRayFilmUsed(); xrayFilmUsed.XRayIssueId = XRayIssueId; xrayFilmUsedId = xRayFilmUsedDB.SaveXRayFilmUsed(xrayFilmUsed, dbTransaction); if (xrayFilmUsedId < 0) { XRayIssueId = -1; } } } } } } if (XRayIssueId > 0) { dbTransaction.Commit(); } else { dbTransaction.Rollback(); } } catch (Exception ex) { XRayIssueId = -1; dbTransaction.Rollback(); throw ex; } } return(XRayIssueId); } }
public Entities.XRayFilmUsed GetFilmDetailsByDrugId(Int32 drugId) { var filmDetails = new XRayFilmUsed(); return(filmDetails.GetFilmDetailsByDrugId(drugId)); }