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 IDAL.VO.RichiestaLISVO GetRichiestaById(string esamidid)
{
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 = "esamidid",
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)
{
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 static IDAL.VO.RichiestaLISVO RichMapper(IBLL.DTO.RichiestaLISDTO dto)
{
IDAL.VO.RichiestaLISVO rich = null;
try
{
Mapper.Initialize(cfg => cfg.CreateMap <IBLL.DTO.RichiestaLISDTO, IDAL.VO.RichiestaLISVO>());
Mapper.AssertConfigurationIsValid();
rich = Mapper.Map <IDAL.VO.RichiestaLISVO>(dto);
}
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(rich);
}
public static IDAL.VO.RichiestaLISVO RichMapper(DataRow row)
{
IDAL.VO.RichiestaLISVO esam = new IDAL.VO.RichiestaLISVO();
esam.esamidid = row["esamidid"] != DBNull.Value ? (int)row["esamidid"] : (int?)null;
esam.esameven = row["esameven"] != DBNull.Value ? (int)row["esameven"] : (int?)null;
esam.esamdapr = row["esamdapr"] != DBNull.Value ? (DateTime)row["esamdapr"] : (DateTime?)null;
esam.esamorpr = row["esamorpr"] != DBNull.Value ? (DateTime)row["esamorpr"] : (DateTime?)null;
esam.esamurge = row["esamurge"] != DBNull.Value ? (short)row["esamurge"] : (short?)null;
esam.esamrout = row["esamrout"] != DBNull.Value ? (string)row["esamrout"] : null;
esam.esamesec = row["esamesec"] != DBNull.Value ? (string)row["esamesec"] : null;
esam.esamtipo = row["esamtipo"] != DBNull.Value ? (int)row["esamtipo"] : (int?)null;
esam.esampren = row["esampren"] != DBNull.Value ? (DateTime)row["esampren"] : (DateTime?)null;
esam.esamrico = row["esamrico"] != DBNull.Value ? (int)row["esamrico"] : (int?)null;
esam.esamconf = row["esamconf"] != DBNull.Value ? (int)row["esamconf"] : (int?)null;
esam.esamdmod = row["esamdmod"] != DBNull.Value ? (string)row["esamdmod"] : null;
esam.hl7_stato = row["hl7_stato"] != DBNull.Value ? (string)row["hl7_stato"] : null;
esam.hl7_msg = row["hl7_msg"] != DBNull.Value ? (string)row["hl7_msg"] : null;
return(esam);;
}
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);
}
public int SetRichiesta(IDAL.VO.RichiestaLISVO data)
{
int result = 0;
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
string table = this.RichiestaLISTabName;
try
{
string connectionString = this.GRConnectionString;
string esamidid = data.esamidid.HasValue ? data.esamidid.Value.ToString() : null;
List <string> autoincrement = new List <string>()
{
"esamidid"
};
if (esamidid == null)
{
// INSERT NUOVA
result = DBSQL.InsertOperation(connectionString, table, data, autoincrement);
log.Info(string.Format("Inserted {0} new records!", result));
}
else
{
// UPDATE
Dictionary <string, DBSQL.QueryCondition> conditions = new Dictionary <string, DBSQL.QueryCondition>()
{
{ "id",
new DBSQL.QueryCondition()
{
Key = "esamidid",
Value = esamidid,
Op = DBSQL.Op.Equal,
Conj = DBSQL.Conj.None,
} },
};
result = DBSQL.UpdateOperation(connectionString, table, data, conditions, new List <string>()
{
"esamidid"
});
log.Info(string.Format("Updated {0} records!", result));
}
}
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 static IDAL.VO.RichiestaLISVO RichMapper(DataRow row)
{
IDAL.VO.RichiestaLISVO rich = new IDAL.VO.RichiestaLISVO();
rich.id = row["id"] != DBNull.Value ? (long)row["id"] : (long?)null;
rich.richidid = row["richidid"] != DBNull.Value ? (string)row["richidid"] : null;
rich.evendata = row["evendata"] != DBNull.Value ? (DateTime)row["evendata"] : (DateTime?)null;
rich.prendata = row["prendata"] != DBNull.Value ? (DateTime)row["prendata"] : (DateTime?)null;
rich.hl7_stato = row["hl7_stato"] != DBNull.Value ? (string)row["hl7_stato"] : null;
rich.hl7_msg = row["hl7_msg"] != DBNull.Value ? (string)row["hl7_msg"] : null;
rich.quesmed = row["quesmed"] != DBNull.Value ? (string)row["quesmed"] : null;
rich.urgente = row["urgente"] != DBNull.Value ? (int)row["urgente"] : (int?)null;
rich.paziidunico = row["paziidunico"] != DBNull.Value ? (long)row["paziidunico"] : (long?)null;
rich.paziid = row["paziid"] != DBNull.Value ? (string)row["paziid"] : null;
rich.pazinome = row["pazinome"] != DBNull.Value ? (string)row["pazinome"] : null;
rich.pazicogn = row["pazicogn"] != DBNull.Value ? (string)row["pazicogn"] : null;
rich.pazidata = row["pazidata"] != DBNull.Value ? (DateTime)row["pazidata"] : (DateTime?)null;
rich.pazicofi = row["pazicofi"] != DBNull.Value ? (string)row["pazicofi"] : null;
rich.pazisess = row["pazisess"] != DBNull.Value ? (string)row["pazisess"] : null;
rich.paziNaNa_cod = row["paziNaNa_cod"] != DBNull.Value ? (string)row["paziNaNa_cod"] : null;
rich.paziPrNa_cod = row["paziPrNa_cod"] != DBNull.Value ? (string)row["paziPrNa_cod"] : null;
rich.paziCoNa_cod = row["paziCoNa_cod"] != DBNull.Value ? (string)row["paziCoNa_cod"] : null;
rich.paziNaNa_txt = row["paziNaNa_txt"] != DBNull.Value ? (string)row["paziNaNa_txt"] : null;
rich.paziPrNa_txt = row["paziPrNa_txt"] != DBNull.Value ? (string)row["paziPrNa_txt"] : null;
rich.paziCoNa_txt = row["paziCoNa_txt"] != DBNull.Value ? (string)row["paziCoNa_txt"] : null;
rich.paziCoNa_cap = row["paziCoNa_cap"] != DBNull.Value ? (string)row["paziCoNa_cap"] : null;
rich.paziNaRe_cod = row["paziNaRe_cod"] != DBNull.Value ? (string)row["paziNaRe_cod"] : null;
rich.paziPrRe_cod = row["paziPrRe_cod"] != DBNull.Value ? (string)row["paziPrRe_cod"] : null;
rich.paziCoRe_cod = row["paziCoRe_cod"] != DBNull.Value ? (string)row["paziCoRe_cod"] : null;
rich.paziNaRe_txt = row["paziNaRe_txt"] != DBNull.Value ? (string)row["paziNaRe_txt"] : null;
rich.paziPrRe_txt = row["paziPrRe_txt"] != DBNull.Value ? (string)row["paziPrRe_txt"] : null;
rich.paziCoRe_txt = row["paziCoRe_txt"] != DBNull.Value ? (string)row["paziCoRe_txt"] : null;
rich.paziCoRe_cap = row["paziCoRe_cap"] != DBNull.Value ? (string)row["paziCoRe_cap"] : null;
rich.paziNaDo_cod = row["paziNaDo_cod"] != DBNull.Value ? (string)row["paziNaDo_cod"] : null;
rich.paziPrDo_cod = row["paziPrDo_cod"] != DBNull.Value ? (string)row["paziPrDo_cod"] : null;
rich.paziCoDo_cod = row["paziCoDo_cod"] != DBNull.Value ? (string)row["paziCoDo_cod"] : null;
rich.paziNaDo_txt = row["paziNaDo_txt"] != DBNull.Value ? (string)row["paziNaDo_txt"] : null;
rich.paziPrDo_txt = row["paziPrDo_txt"] != DBNull.Value ? (string)row["paziPrDo_txt"] : null;
rich.paziCoDo_txt = row["paziCoDo_txt"] != DBNull.Value ? (string)row["paziCoDo_txt"] : null;
rich.paziCoDo_cap = row["paziCoDo_cap"] != DBNull.Value ? (string)row["paziCoDo_cap"] : null;
rich.paziNaRf_cod = row["paziNaRf_cod"] != DBNull.Value ? (string)row["paziNaRf_cod"] : null;
rich.paziPrRf_cod = row["paziPrRf_cod"] != DBNull.Value ? (string)row["paziPrRf_cod"] : null;
rich.paziCoRf_cod = row["paziCoRf_cod"] != DBNull.Value ? (string)row["paziCoRf_cod"] : null;
rich.paziNaRf_txt = row["paziNaRf_txt"] != DBNull.Value ? (string)row["paziNaRf_txt"] : null;
rich.paziPrRf_txt = row["paziPrRf_txt"] != DBNull.Value ? (string)row["paziPrRf_txt"] : null;
rich.paziCoRf_txt = row["paziCoRf_txt"] != DBNull.Value ? (string)row["paziCoRf_txt"] : null;
rich.paziCoRf_cap = row["paziCoRf_cap"] != DBNull.Value ? (string)row["paziCoRf_cap"] : null;
rich.paziCoRe_via = row["paziCoRe_via"] != DBNull.Value ? (string)row["paziCoRe_via"] : null;
rich.paziCoDo_via = row["paziCoDo_via"] != DBNull.Value ? (string)row["paziCoDo_via"] : null;
rich.paziCoRf_via = row["paziCoRf_via"] != DBNull.Value ? (string)row["paziCoRf_via"] : null;
rich.pazitele = row["pazitele"] != DBNull.Value ? (string)row["pazitele"] : null;
rich.paziAsl_cod = row["paziAsl_cod"] != DBNull.Value ? (string)row["paziAsl_cod"] : null;
rich.paziAsl_txt = row["paziAsl_txt"] != DBNull.Value ? (string)row["paziAsl_txt"] : null;
rich.paziteam = row["paziteam"] != DBNull.Value ? (string)row["paziteam"] : null;
rich.mediid = row["mediid"] != DBNull.Value ? (string)row["mediid"] : null;
rich.medinome = row["medinome"] != DBNull.Value ? (string)row["medinome"] : null;
rich.medicogn = row["medicogn"] != DBNull.Value ? (string)row["medicogn"] : null;
rich.medicofi = row["medicofi"] != DBNull.Value ? (string)row["medicofi"] : null;
rich.repaid = row["repaid"] != DBNull.Value ? (string)row["repaid"] : null;
rich.repanome = row["repanome"] != DBNull.Value ? (string)row["repanome"] : null;
rich.accedatetime = row["accedatetime"] != DBNull.Value ? (DateTime)row["accedatetime"] : (DateTime?)null;
rich.tiporicovero = row["tiporicovero"] != DBNull.Value ? (string)row["tiporicovero"] : null;
rich.episodioid = row["episodioid"] != DBNull.Value ? (long)row["episodioid"] : (long?)null;
return(rich);;
}
