public IDAL.VO.EsameVO GetEsameById(string esamidid)
{
Stopwatch tw = new Stopwatch();
tw.Start();
IDAL.VO.EsameVO esam = null;
try
{
long esamidid_ = long.Parse(esamidid);
hlt_esameradio esam_ = hltCC.hlt_esameradio.Single(t => t.esameidid == esamidid_);
log.Info(string.Format("Entity Framework Query Executed! Retrieved 1 record!"));
esam = EsameMapper.EsamMapper(esam_);
log.Info(string.Format("Record mapped to {0}", esam.GetType().ToString()));
}
catch (Exception ex)
{
log.Info(string.Format("Entity Framework 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(esam);
}
public int DeleteEsame(IDAL.VO.EsameVO data)
{
Stopwatch tw = new Stopwatch();
tw.Start();
int result = 0;
try
{
hlt_esameradio data_ = EsameMapper.EsamMapper(data);
hltCC.Entry(data_).State = System.Data.EntityState.Deleted;
result = hltCC.SaveChanges();
log.Info(string.Format("Entity Framework Query Executed! Deleted {0} record!", result));
}
catch (Exception ex)
{
log.Info(string.Format("Entity Framework Query Executed! Deleted 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(result);
}
public int DeleteEsame(string esamidid)
{
Stopwatch tw = new Stopwatch();
tw.Start();
int result = 0;
try
{
long esamidid_ = long.Parse(esamidid);
hlt_esameradio data_ = hltCC.hlt_esameradio.Where(s => s.esameidid == esamidid_).FirstOrDefault <hlt_esameradio>();
hltCC.Entry(data_).State = System.Data.EntityState.Deleted;
result = hltCC.SaveChanges();
log.Info(string.Format("Entity Framework Query Executed! Deleted {0} record!", result));
}
catch (Exception ex)
{
log.Info(string.Format("Entity Framework Query Executed! Deleted 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(result);
}
public int AddEsame(Dictionary <string, object> data)
{
Stopwatch tw = new Stopwatch();
tw.Start();
int result = 0;
try
{
hlt_esameradio esam = new hlt_esameradio();
foreach (KeyValuePair <string, object> d_ in data)
{
string origPName = d_.Key;
object val = d_.Value;
string destPName = origPName;
System.Reflection.PropertyInfo prop = esam.GetType().GetProperty(destPName);
if (prop != null)
{
prop.SetValue(esam, Convert.ChangeType(val, prop.PropertyType), null);
}
}
hltCC.hlt_esameradio.Add(esam);
result = hltCC.SaveChanges();
log.Info(string.Format("Entity Framework Query Executed! Added {0} record!", result));
}
catch (Exception ex)
{
log.Info(string.Format("Entity Framework Query Executed! Added 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(result);
}
public int UpdateEsameByPk(IDAL.VO.EsameVO data, string esamidid)
{
Stopwatch tw = new Stopwatch();
tw.Start();
int result = 0;
try
{
long esamidid_ = long.Parse(esamidid);
hlt_esameradio esam = hltCC.hlt_esameradio.First(t => t.esameidid == esamidid_);
hlt_esameradio data_ = EsameMapper.EsamMapper(data);
foreach (System.Reflection.PropertyInfo prop in data_.GetType().GetProperties())
{
if (esam.GetType().GetProperty(prop.Name) != null)
{
object val = prop.GetValue(data_, null);
esam.GetType().GetProperty(prop.Name).SetValue(esam, Convert.ChangeType(val, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType), null);
}
}
result = hltCC.SaveChanges();
log.Info(string.Format("Entity Framework Query Executed! Updated {0} record!", result));
}
catch (Exception ex)
{
log.Info(string.Format("Entity Framework Query Executed! Updated 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(result);
}