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