public IBLL.DTO.LabelDTO GetLabelById(string labeidid)
{
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
IBLL.DTO.LabelDTO labe = null;
try
{
IDAL.VO.LabelVO labe_ = this.dal.GetLabelById(labeidid);
labe = LabelMapper.LabeMapper(labe_);
log.Info(string.Format("{0} {1} mapped to {2}", LibString.ItemsNumber(labe), LibString.TypeName(labe_), LibString.TypeName(labe)));
}
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(labe);
}
public static List <IDAL.VO.LabelVO> LabeMapper(string raw)
{
List <IDAL.VO.LabelVO> data = null;
if (raw != null)
{
try
{
data = new List <IDAL.VO.LabelVO>();
int st = raw.IndexOf("ZET");
string ZETsubstring = raw.Substring(st);
string[] tmp = ZETsubstring.Split(new string[] { "ZET" }, StringSplitOptions.RemoveEmptyEntries);
List <string> res = null;
res = new List <string>(tmp);
res = res.Select(str => str.Replace(Environment.NewLine, "")).ToList();
foreach (string r in res)
{
object[] tmp2 = r.Split('|');
IDAL.VO.LabelVO tmp3 = LabeMapper(tmp2);
data.Add(tmp3);
}
}
catch (Exception)
{
}
}
return(data);
}
public IBLL.DTO.LabelDTO AddLabel(IBLL.DTO.LabelDTO data)
{
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
IBLL.DTO.LabelDTO toReturn = null;
try
{
data.labeidid = null;
IDAL.VO.LabelVO data_ = LabelMapper.LabeMapper(data);
log.Info(string.Format("{0} {1} mapped to {2}", LibString.ItemsNumber(data_), LibString.TypeName(data), LibString.TypeName(data_)));
IDAL.VO.LabelVO stored = dal.NewLabel(data_);
log.Info(string.Format("{0} {1} items added and got back!", LibString.ItemsNumber(stored), LibString.TypeName(stored)));
toReturn = LabelMapper.LabeMapper(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 int SetLabel(IDAL.VO.LabelVO data)
{
int result = 0;
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
string table = this.LabelTabName;
try
{
string connectionString = this.GRConnectionString;
string labeidid = data.labeidid.HasValue ? data.labeidid.Value.ToString() : null;
List <string> autoincrement = new List <string>()
{
"labeidid"
};
if (labeidid == null)
{
// INSERT NUOVA
result = DBSQL.InsertOperation(connectionString, table, data, autoincrement);
log.Info(string.Format("Inserted {0} new records!", result));
}
else
{
long labeidid_ = long.Parse(labeidid);
// UPDATE
Dictionary <string, DBSQL.QueryCondition> conditions = new Dictionary <string, DBSQL.QueryCondition>()
{
{ "id",
new DBSQL.QueryCondition()
{
Key = "labeidid",
Value = labeidid_,
Op = DBSQL.Op.Equal,
Conj = DBSQL.Conj.None,
} },
};
result = DBSQL.UpdateOperation(connectionString, table, data, conditions);
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);
}
// NO ENTITYFRAMEWORK
public IDAL.VO.LabelVO GetLabelById(string labeidid)
{
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
IDAL.VO.LabelVO labe = null;
try
{
string connectionString = this.GRConnectionString;
long labelidid_ = long.Parse(labeidid);
string table = this.LabelTabName;
Dictionary <string, DBSQL.QueryCondition> conditions = new Dictionary <string, DBSQL.QueryCondition>()
{
{
"id",
new DBSQL.QueryCondition()
{
Key = "labeidid",
Op = DBSQL.Op.Equal,
Value = labelidid_,
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)
{
labe = LabelMapper.LabeMapper(data.Rows[0]);
log.Info(string.Format("{0} Records mapped to {1}", LibString.ItemsNumber(labe), LibString.TypeName(labe)));
}
}
}
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(labe);
}
public static IDAL.VO.LabelVO LabeMapper(object[] data)
{
IDAL.VO.LabelVO labe = new IDAL.VO.LabelVO();
try
{
labe.labeesam = long.Parse((string)data[0]);
}
catch (Exception)
{
labe.labeesam = null;
}
labe.labebarcode = data[1] != null ? (string)data[1] : null;
labe.labedesc = data[2] != null ? (string)data[2] : null;
labe.labeidcont = data[3] != null ? (string)data[3] : null;
labe.labeidlab = data[6] != null ? (string)data[6] : null;
//labe.idReq = (string)data[7];
try
{
labe.labeesamacce = DateTime.ParseExact(((string)data[8]), "yyyyMMddHHmm", null);
}
catch (Exception)
{
labe.labeesamacce = null;
}
try
{
labe.labereri = int.Parse((string)data[17]);
}
catch (Exception)
{
labe.labereri = null;
}
labe.labrerinome = data[18] != null ? (string)data[18] : null;
labe.labeacceid = data[19] != null ? (string)data[19] : null;
labe.labemateid = data[20] != null ? (string)data[20] : null;
labe.labeelenanal = data[22] != null ? (string)data[22] : null;
labe.labesectid = data[23] != null ? (string)data[23] : null;
labe.labesectnome = data[24] != null ? (string)data[24] : null;
try
{
labe.labedaorprel = DateTime.ParseExact(((string)data[25]), "yyyyMMddHHmm", null);
}
catch (Exception)
{
labe.labedaorprel = null;
}
return(labe);
}
public IDAL.VO.LabelVO NewLabel(IDAL.VO.LabelVO data)
{
IDAL.VO.LabelVO result = null;
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
string table = this.LabelTabName;
try
{
string connectionString = this.GRConnectionString;
List <string> pk = new List <string>()
{
"LABEIDID"
};
List <string> autoincrement = new List <string>()
{
"labeIdiD"
};
// INSERT NUOVA
DataTable res = DBSQL.InsertBackOperation(connectionString, table, data, pk, autoincrement);
if (res != null)
{
if (res.Rows.Count > 0)
{
result = LabelMapper.LabeMapper(res.Rows[0]);
log.Info(string.Format("Inserted new record with ID: {0}!", result.labeidid));
}
}
}
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 List <IDAL.VO.LabelVO> LabeMapper(DataTable rows)
{
List <IDAL.VO.LabelVO> data = new List <IDAL.VO.LabelVO>();
if (rows != null)
{
if (rows.Rows.Count > 0)
{
foreach (DataRow row in rows.Rows)
{
IDAL.VO.LabelVO tmp = LabeMapper(row);
data.Add(tmp);
}
}
}
return(data);
}
public static IDAL.VO.LabelVO LabeMapper(IBLL.DTO.LabelDTO data)
{
IDAL.VO.LabelVO labe = null;
try
{
Mapper.Initialize(cfg => cfg.CreateMap <IBLL.DTO.LabelDTO, IDAL.VO.LabelVO>());
Mapper.AssertConfigurationIsValid();
labe = Mapper.Map <IDAL.VO.LabelVO>(data);
}
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(labe);
}
public IBLL.DTO.LabelDTO UpdatLabel(IBLL.DTO.LabelDTO data)
{
Stopwatch tw = new Stopwatch();
tw.Start();
log.Info(string.Format("Starting ..."));
int stored = 0;
IBLL.DTO.LabelDTO toReturn = null;
string id = data.labeidid.ToString();
try
{
if (id == null || GetLabelById(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.LabelVO data_ = LabelMapper.LabeMapper(data);
log.Info(string.Format("{0} {1} mapped to {2}", LibString.ItemsNumber(data_), LibString.TypeName(data), LibString.TypeName(data_)));
stored = dal.SetLabel(data_);
toReturn = GetLabelById(data.labeidid.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 static IDAL.VO.LabelVO LabeMapper(DataRow row)
{
IDAL.VO.LabelVO labe = new IDAL.VO.LabelVO();
labe.labeidid = row["LABEIDID"] != DBNull.Value ? (long)row["LABEIDID"] : (long?)null;
labe.labebarcode = row["LABEBARCODE"] != DBNull.Value ? (string)row["LABEBARCODE"] : null;
labe.labeidcont = row["LABEIDCONT"] != DBNull.Value ? (string)row["LABEIDCONT"] : null;
labe.labedesc = row["LABEDESC"] != DBNull.Value ? (string)row["LABEDESC"] : null;
labe.labeidlab = row["LABEIDLAB"] != DBNull.Value ? (string)row["LABEIDLAB"] : null;
labe.labeesam = row["LABEESAM"] != DBNull.Value ? (long)row["LABEESAM"] : (long?)null;
labe.labeesamacce = row["LABEESAMACCE"] != DBNull.Value ? (DateTime)row["LABEESAMACCE"] : (DateTime?)null;
labe.labepaziid = row["LABEPAZIID"] != DBNull.Value ? (long)row["LABEPAZIID"] : (long?)null;
labe.labereri = row["LABERERI"] != DBNull.Value ? (int)row["LABERERI"] : (int?)null;
labe.labrerinome = row["LABRERINOME"] != DBNull.Value ? (string)row["LABRERINOME"] : null;
labe.labeacceid = row["LABEACCEID"] != DBNull.Value ? (string)row["LABEACCEID"] : null;
labe.labemateid = row["LABEMATEID"] != DBNull.Value ? (string)row["LABEMATEID"] : null;
labe.labeelenanal = row["LABEELENANAL"] != DBNull.Value ? (string)row["LABEELENANAL"] : null;
labe.labesectid = row["LABESECTID"] != DBNull.Value ? (string)row["LABESECTID"] : null;
labe.labesectnome = row["LABESECTNOME"] != DBNull.Value ? (string)row["LABESECTNOME"] : null;
labe.labedaorprel = row["LABEDAORPREL"] != DBNull.Value ? (DateTime)row["LABEDAORPREL"] : (DateTime?)null;
return(labe);
}
