public int Update(XRayReport xRayReport)
{
UpdateCommand.Parameters["@ID"].Value = xRayReport.ID;
UpdateCommand.Parameters["@PatientID"].Value = xRayReport.PatientID;
UpdateCommand.Parameters["@PatientName"].Value = xRayReport.PatientName;
UpdateCommand.Parameters["@DOB"].Value = xRayReport.DOB;
UpdateCommand.Parameters["@Sex"].Value = xRayReport.Sex;
UpdateCommand.Parameters["@ImagePath"].Value = xRayReport.ImagePath;
UpdateCommand.Parameters["@XRayReportDate"].Value = xRayReport.XRayReportDate;
UpdateCommand.Parameters["@SkeletonAndSoftTissue"].Value = xRayReport.SkeletonAndSoftTissue;
UpdateCommand.Parameters["@CardiacShadow"].Value = xRayReport.CardiacShadow;
UpdateCommand.Parameters["@HilarandLymphaticGlands"].Value = xRayReport.HilarandLymphaticGlands;
UpdateCommand.Parameters["@HemidiaphragmsAndCostophrenicAngles"].Value = xRayReport.HemidiaphragmsAndCostophrenicAngles;
UpdateCommand.Parameters["@LungFields"].Value = xRayReport.LungFields;
UpdateCommand.Parameters["@EvidenceofTB"].Value = xRayReport.EvidenceofTB;
UpdateCommand.Parameters["@Evidenceofold"].Value = xRayReport.Evidenceofold;
UpdateCommand.Parameters["@EvidenceSuspicious"].Value = xRayReport.EvidenceSuspicious;
UpdateCommand.Parameters["@ConsultantRadiologist"].Value = xRayReport.ConsultantRadiologist;
UpdateCommand.Parameters["@Remark"].Value = xRayReport.Remark;
UpdateCommand.Parameters["@Status"].Value = xRayReport.Status;
int returnValue = -1;
try
{
UpdateCommand.Connection.Open();
returnValue = UpdateCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
Logger.Write(ex);
}
finally
{
UpdateCommand.Connection.Close();
}
return(returnValue);
}
private XRayReport DataTableToEntity(DataTable dt)
{
XRayReport xRayReport = new XRayReport();
if (Null.IsNotNull(dt) == true && dt.Rows.Count > 0)
{
if (Null.IsNotNull(dt.Rows[0]))
{
DataRow dr = dt.Rows[0];
if (Null.IsNotNull(dr["ID"]))
{
xRayReport.ID = Convert.ToInt32(dr["ID"]);
}
else
{
xRayReport.ID = 0;
}
if (Null.IsNotNull(dr["PatientID"]))
{
xRayReport.PatientID = Convert.ToInt32(dr["PatientID"]);
}
else
{
xRayReport.PatientID = 0;
}
if (Null.IsNotNull(dr["PatientName"]))
{
xRayReport.PatientName = Convert.ToString(dr["PatientName"]);
}
else
{
xRayReport.PatientName = string.Empty;
}
if (Null.IsNotNull(dr["DOB"]))
{
xRayReport.DOB = Convert.ToDateTime(dr["DOB"]);
}
else
{
xRayReport.DOB = DateTime.Now;
}
if (Null.IsNotNull(dr["Sex"]))
{
xRayReport.Sex = Convert.ToString(dr["Sex"]);
}
else
{
xRayReport.Sex = string.Empty;
}
if (Null.IsNotNull(dr["ImagePath"]))
{
xRayReport.ImagePath = Convert.ToString(dr["ImagePath"]);
}
else
{
xRayReport.ImagePath = string.Empty;
}
if (Null.IsNotNull(dr["XRayReportDate"]))
{
xRayReport.XRayReportDate = Convert.ToDateTime(dr["XRayReportDate"]);
}
else
{
xRayReport.XRayReportDate = DateTime.Now;
}
if (Null.IsNotNull(dr["SkeletonAndSoftTissue"]))
{
xRayReport.SkeletonAndSoftTissue = Convert.ToString(dr["SkeletonAndSoftTissue"]);
}
else
{
xRayReport.SkeletonAndSoftTissue = string.Empty;
}
if (Null.IsNotNull(dr["CardiacShadow"]))
{
xRayReport.CardiacShadow = Convert.ToString(dr["CardiacShadow"]);
}
else
{
xRayReport.CardiacShadow = string.Empty;
}
if (Null.IsNotNull(dr["HilarandLymphaticGlands"]))
{
xRayReport.HilarandLymphaticGlands = Convert.ToString(dr["HilarandLymphaticGlands"]);
}
else
{
xRayReport.HilarandLymphaticGlands = string.Empty;
}
if (Null.IsNotNull(dr["HemidiaphragmsAndCostophrenicAngles"]))
{
xRayReport.HemidiaphragmsAndCostophrenicAngles = Convert.ToString(dr["HemidiaphragmsAndCostophrenicAngles"]);
}
else
{
xRayReport.HemidiaphragmsAndCostophrenicAngles = string.Empty;
}
if (Null.IsNotNull(dr["LungFields"]))
{
xRayReport.LungFields = Convert.ToString(dr["LungFields"]);
}
else
{
xRayReport.LungFields = string.Empty;
}
if (Null.IsNotNull(dr["EvidenceofTB"]))
{
xRayReport.EvidenceofTB = Convert.ToString(dr["EvidenceofTB"]);
}
else
{
xRayReport.EvidenceofTB = string.Empty;
}
if (Null.IsNotNull(dr["Evidenceofold"]))
{
xRayReport.Evidenceofold = Convert.ToString(dr["Evidenceofold"]);
}
else
{
xRayReport.Evidenceofold = string.Empty;
}
if (Null.IsNotNull(dr["EvidenceSuspicious"]))
{
xRayReport.EvidenceSuspicious = Convert.ToString(dr["EvidenceSuspicious"]);
}
else
{
xRayReport.EvidenceSuspicious = string.Empty;
}
if (Null.IsNotNull(dr["ConsultantRadiologist"]))
{
xRayReport.ConsultantRadiologist = Convert.ToString(dr["ConsultantRadiologist"]);
}
else
{
xRayReport.ConsultantRadiologist = string.Empty;
}
if (Null.IsNotNull(dr["Remark"]))
{
xRayReport.Remark = Convert.ToString(dr["Remark"]);
}
else
{
xRayReport.Remark = string.Empty;
}
if (Null.IsNotNull(dr["Status"]))
{
xRayReport.Status = Convert.ToString(dr["Status"]);
}
else
{
xRayReport.Status = string.Empty;
}
}
}
return(xRayReport);
}
