public List <IBLL.DTO.RichiestaLISDTO> GetRichiesteByEpisodio(string episid) { Stopwatch tw = new Stopwatch(); tw.Start(); log.Info(string.Format("Starting ...")); List <IBLL.DTO.RichiestaLISDTO> richs = null; try { List <IDAL.VO.RichiestaLISVO> dalRes = this.dal.GetRichiesteByEpisodio(episid); richs = RichiestaLISMapper.RichMapper(dalRes); log.Info(string.Format("{0} VOs mapped to {1}", LibString.ItemsNumber(richs), LibString.TypeName(richs))); } 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(richs); }
public IBLL.DTO.RichiestaLISDTO AddRichiestaLIS(IBLL.DTO.RichiestaLISDTO data) { Stopwatch tw = new Stopwatch(); tw.Start(); log.Info(string.Format("Starting ...")); IBLL.DTO.RichiestaLISDTO toReturn = null; try { data.id = null; IDAL.VO.RichiestaLISVO data_ = RichiestaLISMapper.RichMapper(data); log.Info(string.Format("{0} {1} mapped to {2}", LibString.ItemsNumber(data_), LibString.TypeName(data), LibString.TypeName(data_))); IDAL.VO.RichiestaLISVO stored = dal.NewRichiesta(data_); log.Info(string.Format("{0} {1} items added and got back!", LibString.ItemsNumber(stored), LibString.TypeName(stored))); toReturn = RichiestaLISMapper.RichMapper(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 IBLL.DTO.RichiestaLISDTO GetRichiestaLISById(string id) { Stopwatch tw = new Stopwatch(); tw.Start(); log.Info(string.Format("Starting ...")); IBLL.DTO.RichiestaLISDTO rich = null; try { IDAL.VO.RichiestaLISVO rich_ = this.dal.GetRichiestaById(id); rich = RichiestaLISMapper.RichMapper(rich_); log.Info(string.Format("{0} {1} mapped to {2}", LibString.ItemsNumber(rich), LibString.TypeName(rich_), LibString.TypeName(rich))); } 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(rich); }
public List <IDAL.VO.RichiestaLISVO> GetRichiesteByEven(string evenidid) { Stopwatch tw = new Stopwatch(); tw.Start(); log.Info(string.Format("Starting ...")); string table = this.RichiestaLISTabName; List <IDAL.VO.RichiestaLISVO> richs = null; try { string connectionString = this.GRConnectionString; long evenidid_ = long.Parse(evenidid); Dictionary <string, DBSQL.QueryCondition> conditions = new Dictionary <string, DBSQL.QueryCondition>() { { "esameven", new DBSQL.QueryCondition() { Key = "esameven", Op = DBSQL.Op.Equal, Value = evenidid_, 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) { richs = RichiestaLISMapper.RichMapper(data); if (richs != null && richs.Count > 0) { log.Info(string.Format("{0} Records mapped to {1}", LibString.ItemsNumber(richs), LibString.TypeName(richs))); } } } catch (Exception ex) { log.Info(string.Format("DBSQL Query Executed! Retrieved 0 record!")); 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(richs); }
public IDAL.VO.RichiestaLISVO GetRichiestaByIdExt(string richid) { Stopwatch tw = new Stopwatch(); tw.Start(); log.Info(string.Format("Starting ...")); IDAL.VO.RichiestaLISVO rich = null; try { string connectionString = this.GRConnectionString; string table = this.RichiestaLISTabName; Dictionary <string, DBSQL.QueryCondition> conditions = new Dictionary <string, DBSQL.QueryCondition>() { { "id", new DBSQL.QueryCondition() { Key = "richidid", Op = DBSQL.Op.Equal, Value = richid, 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) { rich = RichiestaLISMapper.RichMapper(data.Rows[0]); log.Info(string.Format("{0} Records mapped to {1}", LibString.ItemsNumber(rich), LibString.TypeName(rich))); } } } catch (Exception ex) { log.Info(string.Format("DBSQL Query Executed! Retrieved 0 record!")); 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(rich); }
public IDAL.VO.RichiestaLISVO NewRichiesta(IDAL.VO.RichiestaLISVO data) { IDAL.VO.RichiestaLISVO result = null; Stopwatch tw = new Stopwatch(); tw.Start(); log.Info(string.Format("Starting ...")); string table = this.RichiestaLISTabName; try { string connectionString = this.GRConnectionString; List <string> pk = new List <string>() { "ESAMIDID" }; List <string> autoincrement = new List <string>() { "eSamIdiD" }; // INSERT NUOVA DataTable res = DBSQL.InsertBackOperation(connectionString, table, data, pk, autoincrement); if (res != null) { if (res.Rows.Count > 0) { result = RichiestaLISMapper.RichMapper(res.Rows[0]); log.Info(string.Format("Inserted new record with ID: {0}!", result.esamidid)); } } } 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 IBLL.DTO.RichiestaLISDTO UpdateRichiestaLIS(IBLL.DTO.RichiestaLISDTO data) { Stopwatch tw = new Stopwatch(); tw.Start(); log.Info(string.Format("Starting ...")); int stored = 0; IBLL.DTO.RichiestaLISDTO toReturn = null; string id = data.id.ToString(); try { if (id == null || GetRichiestaLISById(id) == null) { string msg = string.Format("No record found with the id {0}! Updating is impossible!", id); log.Info(msg); log.Error(msg); return(null); } IDAL.VO.RichiestaLISVO data_ = RichiestaLISMapper.RichMapper(data); log.Info(string.Format("{0} {1} mapped to {2}", LibString.ItemsNumber(data_), LibString.TypeName(data), LibString.TypeName(data_))); stored = dal.SetRichiesta(data_); toReturn = GetRichiestaLISById(id); log.Info(string.Format("{0} {1} items added and {2} {3} retrieved back!", stored, LibString.TypeName(data_), LibString.ItemsNumber(toReturn), 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); }