public List <TagDTO> GetTags()
{
using (TagEFRepository TagRep = new TagEFRepository(""))
{
List <Tag> Tags = TagRep.Context.Tags.ToList();
List <TagDTO> LstTagDto = new List <TagDTO>();
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <Tag, TagDTO>()
.ForMember(dest => dest.IdTag, opt => opt.MapFrom(src => src.IdTag))
.ForMember(dest => dest.Description, opt => opt.MapFrom(src => (((bool)(src.Description == "")) ? src.Description : ((bool)(src.Description.Length < 200)) ? src.Description : src.Description.Substring(0, 200) + "...")))
.ForMember(dest => dest.Enabled, opt => opt.MapFrom(src => (((bool)src.Enabled) ? "YES" : "NO")));
});
//var config = new MapperConfiguration(cfg =>
//{
// cfg.CreateMap<Tag, TagDTO>()
// .ForMember(dest => dest.IdTag, opt => opt.MapFrom(src => src.Id))
// .ForMember(dest => dest.Description, opt => opt.MapFrom(src => src.Description))
// .ForMember(dest => dest.Enabled, opt => opt.MapFrom(src => (((bool)src.Enabled) ? "YES" : "NO")));
//});
IMapper mapper = config.CreateMapper();
LstTagDto = mapper.Map <List <Tag>, List <TagDTO> >(Tags);
//foreach (User Usr in Users)
//{
// List<Audit> LstAud = Usr.Audits.ToList();
// Role Rol = Usr.Role;
//}
return(LstTagDto);
}
}
public void DeleteEntity(Int32 IdEntity)
{
using (TagEFRepository TagRep = new TagEFRepository(""))
{
var entity = new Tag {
IdTag = IdEntity
};
TagRep.Context.Entry(entity).State = EntityState.Deleted;
TagRep.Context.SaveChanges();
}
}
public Tag GetSelectedTag(int IdEntity)
{
Tag Ent = null;
using (TagEFRepository Rep = new TagEFRepository(""))
{
Ent = Rep.Context.Tags.Where(x => x.IdTag == IdEntity).FirstOrDefault();
}
return(Ent);
}
public Tag InsertTag()
{
Tag NewTag = new Tag();
NewTag.TagName = TxtNomeTag.Text;
NewTag.Machine = TxtMachine.Text;
NewTag.Enabled = Convert.ToBoolean(CboEnable.SelectedValue);
NewTag.Description = TxtDescription.Text;
NewTag.Node = TxtNode.Text;
NewTag.Device = TxtDevice.Text;
NewTag.ValueType = TxtValueType.Text;
NewTag.IdTagValue = Convert.ToInt32(CboTagValue.SelectedValue);
NewTag.Alarm = Convert.ToInt32(CboAlarm.SelectedValue);
using (TagEFRepository TagRep = new TagEFRepository(""))
{
TagRep.Context.Tags.Add(NewTag);
TagRep.Context.SaveChanges();
}
return(NewTag);
}
public Tag InsertTag(Tag CurrTag)
{
Tag NewTag = new Tag();
NewTag.TagName = CurrTag.TagName;
NewTag.Machine = CurrTag.Machine;
NewTag.Enabled = true;
NewTag.Description = CurrTag.Description;
NewTag.Node = CurrTag.Node;
NewTag.Device = CurrTag.Device;
NewTag.ValueType = CurrTag.ValueType;
NewTag.IdTagValue = Convert.ToInt32(CurrTag.IdTagValue);
NewTag.Alarm = Convert.ToInt32(CurrTag.Alarm);
using (TagEFRepository TagRep = new TagEFRepository(""))
{
TagRep.Context.Tags.Add(NewTag);
TagRep.Context.SaveChanges();
}
return(NewTag);
}
public Tag UpdateTag(int Id)
{
Tag result = null;
using (TagEFRepository TagRep = new TagEFRepository(""))
{
result = TagRep.Context.Tags.SingleOrDefault(x => x.IdTag == Id);
if (result != null)
{
result.TagName = TxtNomeTag.Text;
result.Machine = TxtMachine.Text;
result.Enabled = Convert.ToBoolean(CboEnable.SelectedValue);
result.Description = TxtDescription.Text;
result.Node = TxtNode.Text;
result.Device = TxtDevice.Text;
result.ValueType = TxtValueType.Text;
result.IdTagValue = Convert.ToInt32(CboTagValue.SelectedValue);
result.Alarm = Convert.ToInt32(CboAlarm.SelectedValue);
TagRep.Context.SaveChanges();
}
}
return(result);
}
protected void BtnConfirmDeleting_Click(object sender, EventArgs e)
{
try
{
Int32 IdToDelete = Convert.ToInt32(HydIdToDelete.Value);
TagEFRepository rep = new TagEFRepository("");
Tag TagToStoreInAudit = rep.SelectEntity(IdToDelete);
DeleteEntity(IdToDelete);
AuditPageManager ObjPageManager = new AuditPageManager();
ObjPageManager.InsertAudit(LoginUsr, "Tag deleted: " + TagToStoreInAudit.TagName + ", Machine: " + TagToStoreInAudit.Machine);
BindRepeater();
DivDelete.Attributes.Add("Class", "ParentDivDeleting Disattivato");
}
catch (Exception ex)
{
PrintError(ex);
}
}