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));
}
