public int UpdateEsameById(IBLL.DTO.EsameDTO data, string esamidid)
{
Stopwatch tw = new Stopwatch();
tw.Start();
int result = 0;
try
{
IDAL.VO.EsameVO data_ = EsameMapper.EsamMapper(data);
log.Info(string.Format("1 {0} mapped to {1}", data.GetType().ToString(), data_.GetType().ToString()));
result = dal.UpdateEsameByPk(data_, 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 List <IBLL.DTO.EsameDTO> GetEsamiByEpis(string episidid)
{
Stopwatch tw = new Stopwatch();
tw.Start();
List <IBLL.DTO.EsameDTO> esams = null;
try
{
List <IDAL.VO.EsameVO> dalRes = this.dal.GetEsamiByEpis(episidid);
esams = EsameMapper.EsamMapper(dalRes);
log.Info(string.Format("{0} VO mapped to {1}", esams.Count, esams.First().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(esams);
}
public IBLL.DTO.EsameDTO GetEsameById(string esamidid)
{
Stopwatch tw = new Stopwatch();
tw.Start();
IBLL.DTO.EsameDTO esam = null;
try
{
IDAL.VO.EsameVO dalRes = this.dal.GetEsameById(esamidid);
esam = EsameMapper.EsamMapper(dalRes);
log.Info(string.Format("1 VO mapped to {0}", esam.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(esam);
}
public List <IBLL.DTO.EsameDTO> GetEsamiByIds(List <string> esamidids)
{
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
List <IBLL.DTO.EsameDTO> anals = null;
try
{
List <IDAL.VO.EsameVO> esams_ = dal.GetEsamiByIds(esamidids);
anals = EsameMapper.EsamMapper(esams_);
log.Info(string.Format("{0} {1} mapped to {2}", LibString.ItemsNumber(anals), LibString.TypeName(esams_), LibString.TypeName(anals)));
}
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(anals);
}
public IBLL.DTO.EsameDTO UpdateEsame(IBLL.DTO.EsameDTO data)
{
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
int stored = 0;
IBLL.DTO.EsameDTO toReturn = null;
try
{
IDAL.VO.EsameVO data_ = EsameMapper.EsamMapper(data);
log.Info(string.Format("{0} {1} mapped to {2}", LibString.ItemsNumber(data_), LibString.TypeName(data), LibString.TypeName(data_)));
stored = dal.SetEsame(data_);
toReturn = GetEsameById(data.radioidid.ToString());
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 List <IBLL.DTO.EsameDTO> GetEsamiByRichiesta(string richidid)
{
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
List <IBLL.DTO.EsameDTO> esams = null;
try
{
List <IDAL.VO.EsameVO> dalRes = dal.GetEsamiByRichiesta(richidid);
esams = EsameMapper.EsamMapper(dalRes);
log.Info(string.Format("{0} VOs mapped to {1}", LibString.ItemsNumber(esams), LibString.TypeName(esams)));
}
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(esams);
}
public List <IBLL.DTO.EsameDTO> AddEsami(List <IBLL.DTO.EsameDTO> data)
{
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
List <IBLL.DTO.EsameDTO> toReturn = null;
try
{
data.ForEach(p => p.radioidid = null);
List <IDAL.VO.EsameVO> data_ = EsameMapper.EsamMapper(data);
log.Info(string.Format("{0} {1} mapped to {2}", LibString.ItemsNumber(data_), LibString.TypeName(data), LibString.TypeName(data_)));
List <IDAL.VO.EsameVO> stored = dal.NewEsami(data_);
log.Info(string.Format("{0} {1} items added and got back!", LibString.ItemsNumber(stored), LibString.TypeName(stored)));
toReturn = EsameMapper.EsamMapper(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 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 List <IDAL.VO.EsameVO> GetEsamiByEpis(string episidid)
{
Stopwatch tw = new Stopwatch();
tw.Start();
List <IDAL.VO.EsameVO> esams = null;
try
{
var L2EQuery = from e in hltCC.hlt_esameradio join r in hltCC.hlt_ricradiologica on e.esamerichid equals r.objectid where r.idepisodio.Equals(episidid) select e;
List <hlt_esameradio> esams_ = L2EQuery.ToList();
log.Info(string.Format("Entity Framework Query Executed! Retrieved {0} record!", esams_.Count));
esams = EsameMapper.EsamMapper(esams_);
log.Info(string.Format("{0} Records mapped to {1}", esams.Count, esams.First().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(esams);
}
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 List <IDAL.VO.EsameVO> GetEsamiByRich(string richidid)
{
Stopwatch tw = new Stopwatch();
tw.Start();
List <IDAL.VO.EsameVO> esams = null;
try
{
List <hlt_esameradio> esams_ = hltCC.hlt_esameradio.Where(t => t.esamerichid == richidid).ToList();
log.Info(string.Format("Entity Framework Query Executed! Retrieved {0} record!", esams_.Count));
esams = EsameMapper.EsamMapper(esams_);
log.Info(string.Format("{0} Records mapped to {1}", esams.Count, esams.First().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(esams);
}
public List <IDAL.VO.EsameVO> GetEsamiByIds(List <string> esamidids)
{
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
List <IDAL.VO.EsameVO> esams = null;
try
{
string connectionString = this.GRConnectionString;
string table = this.EsameTabName;
Dictionary <string, DBSQL.QueryCondition> conditions = new Dictionary <string, DBSQL.QueryCondition>();
int i = 0;
foreach (string esamidid in esamidids)
{
long esamidid_ = long.Parse(esamidid);
DBSQL.QueryCondition tmp = new DBSQL.QueryCondition()
{
Key = "radioidid",
Op = DBSQL.Op.Equal,
Value = esamidid_,
Conj = i < esamidids.Count - 1 ? DBSQL.Conj.Or : DBSQL.Conj.None
};
conditions.Add("id" + i, tmp);
i++;
}
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)
{
esams = EsameMapper.EsamMapper(data);
log.Info(string.Format("{0} Records mapped to {1}", LibString.ItemsNumber(esams), LibString.TypeName(esams)));
}
}
}
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(esams);
}
// NO ENTITYFRAMEWORK
public IDAL.VO.EsameVO GetEsameById(string esamidid)
{
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
IDAL.VO.EsameVO esam = null;
try
{
string connectionString = this.CCConnectionString;
long esamidid_ = long.Parse(esamidid);
string table = this.EsameTabName;
Dictionary <string, DBSQL.QueryCondition> conditions = new Dictionary <string, DBSQL.QueryCondition>()
{
{
"id",
new DBSQL.QueryCondition()
{
Key = "esameidid",
Op = DBSQL.Op.Equal,
Value = esamidid_,
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)
{
esam = EsameMapper.EsamMapper(data.Rows[0]);
log.Info(string.Format("{0} Records mapped to {1}", LibString.ItemsNumber(esam), LibString.TypeName(esam)));
}
}
}
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(esam);
}
public IDAL.VO.EsameVO NewEsame(IDAL.VO.EsameVO data)
{
IDAL.VO.EsameVO result = null;
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
string table = this.EsameTabName;
try
{
string connectionString = this.GRConnectionString;
List <string> pk = new List <string>()
{
"RADIOIDID"
};
List <string> autoincrement = new List <string>()
{
"RaDiOIdiD"
};
// INSERT NUOVA
DataTable res = DBSQL.InsertBackOperation(connectionString, table, data, pk, autoincrement);
if (res != null)
{
if (res.Rows.Count > 0)
{
result = EsameMapper.EsamMapper(res.Rows[0]);
log.Info(string.Format("Inserted new record with ID: {0}!", result.radioidid));
}
}
}
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 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);
}
public List <IDAL.VO.EsameVO> NewEsami(List <IDAL.VO.EsameVO> data)
{
List <IDAL.VO.EsameVO> results = null;
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
string table = this.EsameTabName;
try
{
string connectionString = this.GRConnectionString;
List <string> pk = new List <string>()
{
"RADIOIDID"
};
List <string> autoincrement = new List <string>()
{
"rAdIoIdiD"
};
// INSERT NUOVA
DataTable res = DBSQL.MultiInsertBackOperation(connectionString, table, data, pk, autoincrement);
if (res != null && res.Rows.Count > 0)
{
results = EsameMapper.EsamMapper(res);
}
if (results != null)
{
if (results.Count > 0)
{
string tmp = "";
int o = 0;
foreach (IDAL.VO.EsameVO tmp_ in results)
{
tmp += tmp_.radioidid.Value.ToString();
if (o < results.Count - 1)
{
tmp += ", ";
}
o++;
}
log.Info(string.Format("Inserted {0} new records with IDs: {1}!", LibString.ItemsNumber(results), tmp));
}
}
else
{
log.Info(string.Format("No records Inserted!"));
}
}
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(results);
}