public IBLL.DTO.EventoDTO GetEventoById(string id)
{
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
IBLL.DTO.EventoDTO epis = null;
try
{
IDAL.VO.EventoVO dalRes = this.dal.GetEventoById(id);
epis = EventoMapper.EvenMapper(dalRes);
log.Info(string.Format("{0} VOs mapped to {1}", LibString.ItemsNumber(epis), LibString.TypeName(epis)));
}
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(epis);
}
public IBLL.DTO.EventoDTO AddEvento(IBLL.DTO.EventoDTO data)
{
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
IBLL.DTO.EventoDTO toReturn = null;
try
{
data.evenidid = null;
IDAL.VO.EventoVO data_ = EventoMapper.EvenMapper(data);
log.Info(string.Format("{0} {1} mapped to {2}", LibString.ItemsNumber(data_), LibString.TypeName(data), LibString.TypeName(data_)));
IDAL.VO.EventoVO stored = dal.NewEvento(data_);
log.Info(string.Format("{0} {1} items added and got back!", LibString.ItemsNumber(stored), LibString.TypeName(stored)));
toReturn = EventoMapper.EvenMapper(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 static IBLL.DTO.EventoDTO EvenMapper(IDAL.VO.EventoVO raw)
{
IBLL.DTO.EventoDTO epis = null;
try
{
Mapper.Initialize(cfg => cfg.CreateMap <IDAL.VO.EventoVO, IBLL.DTO.EventoDTO>());
Mapper.AssertConfigurationIsValid();
epis = Mapper.Map <IBLL.DTO.EventoDTO>(raw);
}
catch (AutoMapperConfigurationException ex)
{
log.Error(string.Format("AutoMapper Configuration Error!\n{0}", ex.Message));
}
catch (AutoMapperMappingException ex)
{
log.Error(string.Format("AutoMapper Mapping Error!\n{0}", ex.Message));
}
return(epis);
}
public IBLL.DTO.EventoDTO UpdateEvento(IBLL.DTO.EventoDTO data)
{
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
int stored = 0;
IBLL.DTO.EventoDTO toReturn = null;
string id = data.evenidid.ToString();
try
{
if (id == null || GetEventoById(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.EventoVO data_ = EventoMapper.EvenMapper(data);
log.Info(string.Format("{0} {1} mapped to {2}", LibString.ItemsNumber(data_), LibString.TypeName(data), LibString.TypeName(data_)));
stored = dal.SetEvento(data_);
toReturn = GetEventoById(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);
}
public static IDAL.VO.EventoVO EvenMapper(DataRow row)
{
IDAL.VO.EventoVO even = new IDAL.VO.EventoVO();
even.evenidid = row["evenidid"] != DBNull.Value ? (int)row["evenidid"] : (int?)null;
even.evenepis = row["evenepis"] != DBNull.Value ? (int)row["evenepis"] : (int?)null;
even.eventipo = row["eventipo"] != DBNull.Value ? (int)row["eventipo"] : (int?)null;
even.evenpepr = row["evenpepr"] != DBNull.Value ? (int)row["evenpepr"] : (int?)null;
even.evenperi = row["evenperi"] != DBNull.Value ? (int)row["evenperi"] : (int?)null;
even.evenreri = row["evenreri"] != DBNull.Value ? (int)row["evenreri"] : (int?)null;
even.evenpees = row["evenpees"] != DBNull.Value ? (int)row["evenpees"] : (int?)null;
even.evenrees = row["evenrees"] != DBNull.Value ? (int)row["evenrees"] : (int?)null;
even.evendata = row["evendata"] != DBNull.Value ? (DateTime)row["evendata"] : (DateTime?)null;
even.evenflst = row["evenflst"] != DBNull.Value ? (short)row["evenflst"] : (short?)null;
even.evendasc = row["evendasc"] != DBNull.Value ? (DateTime)row["evendasc"] : (DateTime?)null;
even.evenrepp = row["evenrepp"] != DBNull.Value ? (int)row["evenrepp"] : (int?)null;
even.evencart = row["evencart"] != DBNull.Value ? (int)row["evencart"] : (int?)null;
even.evencaps = row["evencaps"] != DBNull.Value ? (string)row["evencaps"] : null;
even.evendaef = row["evendaef"] != DBNull.Value ? (DateTime)row["evendaef"] : (DateTime?)null;
return(even);
}
