public IBLL.DTO.PazienteDTO GetPazienteById(string id) { Stopwatch tw = new Stopwatch(); tw.Start(); log.Info(string.Format("Starting ...")); IBLL.DTO.PazienteDTO pazi = null; try { IDAL.VO.PazienteVO pazi_ = this.dal.GetPazienteById(id); pazi = PazienteMapper.PaziMapper(pazi_); log.Info(string.Format("{0} {1} mapped to {2}", LibString.ItemsNumber(pazi), LibString.TypeName(pazi_), LibString.TypeName(pazi))); } catch (Exception ex) { string msg = "An Error occured! Exception detected!"; log.Info(msg); log.Error(msg + "\n" + ex.Message); } tw.Stop(); log.Info(string.Format("Completed! Elapsed time {0}", LibString.TimeSpanToTimeHmsms(tw.Elapsed))); return(pazi); }
public IBLL.DTO.PazienteDTO AddPaziente(IBLL.DTO.PazienteDTO data) { Stopwatch tw = new Stopwatch(); tw.Start(); log.Info(string.Format("Starting ...")); IBLL.DTO.PazienteDTO toReturn = null; try { data.paziidid = null; IDAL.VO.PazienteVO data_ = PazienteMapper.PaziMapper(data); log.Info(string.Format("{0} {1} mapped to {2}", LibString.ItemsNumber(data_), LibString.TypeName(data), LibString.TypeName(data_))); IDAL.VO.PazienteVO stored = dal.NewPaziente(data_); log.Info(string.Format("{0} {1} items added and got back!", LibString.ItemsNumber(stored), LibString.TypeName(stored))); toReturn = PazienteMapper.PaziMapper(stored); log.Info(string.Format("{0} {1} mapped to {2}", LibString.ItemsNumber(toReturn), LibString.TypeName(stored), LibString.TypeName(toReturn))); } catch (Exception ex) { string msg = "An Error occured! Exception detected!"; log.Info(msg); log.Error(msg + "\n" + ex.Message); } tw.Stop(); log.Info(string.Format("Completed! Elapsed time {0}", LibString.TimeSpanToTimeHmsms(tw.Elapsed))); return(toReturn); }
public List <IBLL.DTO.PazienteDTO> GetPazienteBy5IdentityFields(string pazicogn, string pazinome, string pazisess, DateTime pazidata, string pazicofi) { Stopwatch tw = new Stopwatch(); tw.Start(); log.Info(string.Format("Starting ...")); List <IBLL.DTO.PazienteDTO> pazis = null; try { List <IDAL.VO.PazienteVO> pazis_ = this.dal.GetPazienteBy5IdentityFields(pazicogn, pazinome, pazisess, pazidata, pazicofi); pazis = PazienteMapper.PaziMapper(pazis_); log.Info(string.Format("{0} {1} mapped to {2}", LibString.ItemsNumber(pazis), LibString.TypeName(pazis_), LibString.TypeName(pazis))); } catch (Exception ex) { string msg = "An Error occured! Exception detected!"; log.Info(msg); log.Error(msg + "\n" + ex.Message); } tw.Stop(); log.Info(string.Format("Completed! Elapsed time {0}", LibString.TimeSpanToTimeHmsms(tw.Elapsed))); return(pazis); }
public IDAL.VO.PazienteVO GetPazienteById(string pazidid) { Stopwatch tw = new Stopwatch(); tw.Start(); log.Info(string.Format("Starting ...")); IDAL.VO.PazienteVO pazi = null; try { string connectionString = this.GRConnectionString; string table = this.PazienteTabName; Dictionary <string, DBSQL.QueryCondition> conditions = new Dictionary <string, DBSQL.QueryCondition>() { { "id", new DBSQL.QueryCondition() { Key = "PAZIIDID", Op = DBSQL.Op.Equal, Value = pazidid, Conj = DBSQL.Conj.None } } }; DataTable data = DBSQL.SelectOperation(connectionString, table, conditions); log.Info(string.Format("DBSQL Query Executed! Retrieved {0} record!", LibString.ItemsNumber(data))); if (data != null) { if (data.Rows.Count == 1) { pazi = PazienteMapper.PaziMapper(data.Rows[0]); log.Info(string.Format("{0} Records mapped to {1}", LibString.ItemsNumber(pazi), LibString.TypeName(pazi))); } } } catch (Exception ex) { string msg = "An Error occured! Exception detected!"; log.Info(msg); log.Error(msg + "\n" + ex.Message); } tw.Stop(); log.Info(string.Format("Completed! Elapsed time {0}", LibString.TimeSpanToTimeHmsms(tw.Elapsed))); return(pazi); }
public IDAL.VO.PazienteVO NewPaziente(IDAL.VO.PazienteVO data) { IDAL.VO.PazienteVO result = null; Stopwatch tw = new Stopwatch(); tw.Start(); log.Info(string.Format("Starting ...")); string table = this.AnalisiTabName; try { string connectionString = this.GRConnectionString; List <string> pk = new List <string>() { "PAZIIDID" }; List <string> autoincrement = new List <string>() { "PaZiIdiD" }; // INSERT NUOVA DataTable res = DBSQL.InsertBackOperation(connectionString, table, data, pk, autoincrement); if (res != null) { if (res.Rows.Count > 0) { result = PazienteMapper.PaziMapper(res.Rows[0]); log.Info(string.Format("Inserted new record with ID: {0}!", result.paziidid)); } } } catch (Exception ex) { string msg = "An Error occured! Exception detected!"; log.Info(msg); log.Error(msg + "\n" + ex.Message); } tw.Stop(); log.Info(string.Format("Completed! Elapsed time {0}", LibString.TimeSpanToTimeHmsms(tw.Elapsed))); return(result); }
public IDAL.VO.PazienteVO GetPazienteById(string pazidid) { Stopwatch tw = new Stopwatch(); tw.Start(); IDAL.VO.PazienteVO pazi = null; try { string connectionString = this.HLTDesktopConnectionString; string query = "SELECT * FROM AnagraficaPazienti WHERE seriale = @seriale"; Dictionary <string, object> pars = new Dictionary <string, object>(); pars["seriale"] = pazidid; log.Info(string.Format("Query: {0}", query)); log.Info(string.Format("Params: {0}", string.Join(";", pars.Select(x => x.Key + "=" + x.Value).ToArray()))); DataTable data = DAL.DBSQL.ExecuteQueryWithParams(connectionString, query, pars); log.Info(string.Format("Query Executed! Retrieved {0} records!", data.Rows.Count)); if (data != null && data.Rows.Count == 1) { DataRow row = data.Rows[0]; pazi = PazienteMapper.PaziMapper(row); log.Info(string.Format("Record mapped to {0}", pazi.GetType().ToString())); } } catch (Exception ex) { string msg = "An Error occured! Exception detected!"; log.Info(msg); log.Error(msg + "\n" + ex.Message); } tw.Stop(); log.Info(string.Format("Completed! Elapsed time {0}", LibString.TimeSpanToTimeHmsms(tw.Elapsed))); return(pazi); }
public IBLL.DTO.PazienteDTO GetPazienteById(string id) { IDAL.VO.PazienteVO dalRes = this.dal.GetPazienteById(id); return(PazienteMapper.PaziMapper(dalRes)); }
public List <IDAL.VO.PazienteVO> GetPazienteBy5IdentityFields(string pazicogn, string pazinome, string pazisess, DateTime pazidata, string pazicofi) { Stopwatch tw = new Stopwatch(); tw.Start(); log.Info(string.Format("Starting ...")); List <IDAL.VO.PazienteVO> pazis = null; try { string connectionString = this.GRConnectionString; string table = this.PazienteTabName; Dictionary <string, DBSQL.QueryCondition> conditions = new Dictionary <string, DBSQL.QueryCondition>() { { "cognome", new DBSQL.QueryCondition() { Key = "PAZICOGN", Op = DBSQL.Op.Equal, Value = pazicogn, Conj = DBSQL.Conj.And } }, { "nome", new DBSQL.QueryCondition() { Key = "PAZINOME", Op = DBSQL.Op.Equal, Value = pazinome, Conj = DBSQL.Conj.And } }, { "dataNascita", new DBSQL.QueryCondition() { Key = "PAZIDATA", Op = DBSQL.Op.Equal, Value = pazidata, Conj = DBSQL.Conj.And } }, { "codFiscale", new DBSQL.QueryCondition() { Key = "PAZICOFI", Op = DBSQL.Op.Equal, Value = pazicofi, Conj = DBSQL.Conj.And } }, { "sesso", new DBSQL.QueryCondition() { Key = "PAZISESS", Op = DBSQL.Op.Equal, Value = pazisess, Conj = DBSQL.Conj.None } } }; DataTable data = DBSQL.SelectOperation(connectionString, table, conditions); log.Info(string.Format("DBSQL Query Executed! Retrieved {0} record!", LibString.ItemsNumber(data))); if (data != null) { pazis = PazienteMapper.PaziMapper(data); log.Info(string.Format("{0} Records mapped to {1}", LibString.ItemsNumber(pazis), LibString.TypeName(pazis))); } } catch (Exception ex) { string msg = "An Error occured! Exception detected!"; log.Info(msg); log.Error(msg + "\n" + ex.Message); } tw.Stop(); log.Info(string.Format("Completed! Elapsed time {0}", LibString.TimeSpanToTimeHmsms(tw.Elapsed))); return(pazis); }