public Destination SaveImageStudy(CaseStudies cs)
{
using (MySqlConnection connection = new MySqlConnection(AppUser.ConnectionString))
{
try
{
connection.Open();
var parameters = new Dictionary <string, object>
{
{ "PatientId", cs.PatientId },
{ "PatientName", cs.PatientName },
{ "ClientId", cs.ClientId.ToString() },
{ "Gender", cs.Gender },
{ "Modality", cs.Modality },
{ "Age", cs.Age },
{ "ImageNumber", cs.ImageNumber },
{ "SeriesNumber", cs.SerialNumber },
{ "StudyId", cs.StudyId },
{ "SOPInstanceUID", cs.SOPInstanceUID },
{ "ScanDate", cs.ScanDate },
{ "StudyDescription", cs.StudyDescription },
{ "AccessionNumber", cs.AccessionNumber }
};
return(connection.QueryFirst <Destination>("SaveImageStudy", parameters, commandType: CommandType.StoredProcedure) ?? new Destination());
}
catch (Exception ex)
{
Logs.WriteToLogFile(ex == null ? "No Exception Details" : ex.InnerException == null ? ex.ToString() : ex.InnerException.Message);
return(new Destination());
}
finally {
connection.Close();
}
}
}
public IActionResult ImageStudy([FromBody] CaseStudies cs)
{
if (!String.IsNullOrEmpty(cs.ScanDate) && !String.IsNullOrEmpty(cs.ScanTime))
{
cs.ScanDate = Convert.ToString(DateTime.Parse(DateTime.ParseExact((cs.ScanDate + cs.ScanTime).Substring(0, 12), "yyyyMMddHHmm", null).ToString("yyyy-MM-dd hh:mm tt")).ToString("yyyy-MM-dd hh:mm:ss"));
}
var modal = da.SaveImageStudy(cs);
if (!string.IsNullOrEmpty(modal.DestinationId))
{
return(StatusCode((int)HttpStatusCode.OK, JsonConvert.SerializeObject(modal)));
}
else
{
return(StatusCode((int)HttpStatusCode.BadRequest, JsonConvert.SerializeObject(modal)));
}
}
