static void Main(string[] args) { DataAccessLayer.LISDAL dal = new DataAccessLayer.LISDAL(); BusinessLogicLayer.LISBLL bll = new BusinessLogicLayer.LISBLL(dal); IBLL.DTO.EpisodioDTO epis = bll.GetEpisodioById("697798"); }
public string ScheduleNewRequest(EventoDTO even, PrestazioneDTO pres, RichiestaLISDTO esam, List <AnalisiDTO> anals, ref string errorString) { Stopwatch tw = new Stopwatch(); tw.Start(); log.Info(string.Format("Starting ...")); string hl7_stato = IBLL.HL7StatesRichiestaLIS.Idle; string evenIdStr = null; string esamIdStr = null; string presIdStr = null; EventoDTO evenInserted = null; PrestazioneDTO presInserted = null; RichiestaLISDTO esamInserted = null; List <AnalisiDTO> analsInserted = null; if (errorString == null) { errorString = ""; } try { if (even == null || esam == null || anals == null || (anals != null && anals.Count == 0)) { throw new Exception("Error! Request a null or void insertion of EVEN and/or ESAM and/or ANAL."); } // Validation Even!!!! if (!bll.ValidateEven(even, ref errorString)) { string msg = "Validation Even Failure! Check the error string for figuring out the issue!"; log.Info(msg + "\r\n" + errorString); log.Error(msg + "\r\n" + errorString); throw new Exception(msg); } // Check if Epis exists!!!! log.Info(string.Format("Checking EPIS '{0}' exists ...", even.evenepis)); EpisodioDTO epis = bll.GetEpisodioById(even.evenepis.ToString()); if (epis == null) { string msg = string.Format("EPIS Checking Failure! EPIS '{0}' not Found!", even.evenepis); log.Info(msg); log.Error(msg); throw new Exception(msg); } epis = null; log.Info(string.Format("Checking EPIS '{0}' succeded!", even.evenepis)); // Create Even log.Info(string.Format("EVEN Insertion ...")); even.evenidid = null; evenInserted = bll.AddEvento(even); if (evenInserted == null) { throw new Exception("Error during EVEN writing into the DB."); } log.Info(string.Format("EVEN Inserted. Got {0} EVENIDID!", evenInserted.evenidid)); evenIdStr = evenInserted.evenidid.ToString(); pres.preseven = evenInserted.evenidid; log.Info(string.Format("PRES foreign key PRESEVEN updated!")); // Validation Pres!!!! if (!bll.ValidatePres(pres, ref errorString)) { string msg = "Validation Pres Failure! Check the error string for figuring out the issue!"; log.Info(msg + "\r\n" + errorString); log.Error(msg + "\r\n" + errorString); throw new Exception(msg); } pres.hl7_stato = hl7_stato; // Create Pres log.Info(string.Format("PRES Insertion ...")); presInserted = bll.AddPrestazione(pres); if (presInserted == null) { throw new Exception("Error during PRES writing into the DB."); } log.Info(string.Format("PRES Inserted. Got {0} PRESIDID!", presInserted.presidid)); presIdStr = presInserted.presidid.ToString(); esam.esameven = evenInserted.evenidid; // Validation Esam!!!! if (!bll.ValidateEsam(esam, ref errorString)) { string msg = "Validation Esam Failure! Check the error string for figuring out the issue!"; log.Info(msg + "\r\n" + errorString); log.Error(msg + "\r\n" + errorString); throw new Exception(msg); } log.Info(string.Format("ESAM foreign key ESAMEVEN updated!")); esam.hl7_stato = hl7_stato; // Create Esam log.Info(string.Format("ESAM Insertion ...")); esamInserted = bll.AddRichiestaLIS(esam); if (esamInserted == null) { throw new Exception("Error during ESAM writing into the DB."); } log.Info(string.Format("ESAM Inserted. Got {0} ESAMIDID!", esamInserted.esamidid)); esamIdStr = esamInserted.esamidid.ToString(); anals.ForEach(p => { p.analesam = int.Parse(esamIdStr); p.hl7_stato = hl7_stato; }); // Validation Anals!!!! if (!bll.ValidateAnals(anals, ref errorString)) { string msg = "Validation Anals Failure! Check the error string for figuring out the issue!"; log.Info(msg + "\r\n" + errorString); log.Error(msg + "\r\n" + errorString); throw new Exception(msg); } // Create Anals log.Info(string.Format("Insertion of {0} ANAL requested. Processing ...", anals.Count)); analsInserted = bll.AddAnalisis(anals); if ((analsInserted == null) || (analsInserted != null && analsInserted.Count != anals.Count)) { throw new Exception("Error during ANALs writing into the DB."); } log.Info(string.Format("Inserted {0} ANAL successfully!", analsInserted.Count)); // Log Total Number Of Records Inserted! 1 for Esam, 1 for PRES and n for ANAL(s) log.Info(string.Format("Inserted {0} records successfully!", analsInserted.Count + 1 + 1)); } catch (Exception ex) { string msg = "An Error occured! Exception detected!"; log.Info(msg); log.Error(msg + "\n" + ex.Message); if (errorString == "") { errorString = msg + "\r\n" + ex.Message; } else { errorString += "\r\n" + msg + "\r\n" + ex.Message; } int evenRB = 0; int presRB = 0; int esamRB = 0; int analsRB = 0; log.Info(string.Format("Rolling Back of the Insertions due an error occured ...")); // Rolling Back if (evenIdStr != null) { evenRB = bll.DeleteEventoById(evenIdStr); log.Info(string.Format("Rolled Back {0} EVEN record. EVENIDID was {1}!", evenRB, evenIdStr)); } if (presIdStr != null) { presRB = bll.DeletePrestazioneById(presIdStr); log.Info(string.Format("Rolled Back {0} PRES record. PRESIDID was {1}!", presRB, presIdStr)); } if (esamIdStr != null) { esamRB = bll.DeleteRichiestaLISById(esamIdStr); log.Info(string.Format("Rolled Back {0} ESAM record. ESAMIDID was {1}!", esamRB, esamIdStr)); analsRB = bll.DeleteAnalisiByRichiesta(esamIdStr); log.Info(string.Format("Rolled Back {0} ANAL records. ANALESAM was {1}!", analsRB, esamIdStr)); } log.Info(string.Format("Rolled Back {0} records of {1} requested!", evenRB + presRB + esamRB + analsRB, anals.Count + 1 + 1 + 1)); esamIdStr = null; } tw.Stop(); log.Info(string.Format("Completed! Elapsed time {0}", LibString.TimeSpanToTimeHmsms(tw.Elapsed))); if (errorString == "") { errorString = null; } return(esamIdStr); }