public static AspNetUser GetAspNetUserID(string AspNetUserID)
{
using (DOAMEntities db = new DOAMEntities())
{
return(db.AspNetUsers.Find(AspNetUserID));
}
}
public static List <SP_AfficherUserRoles_Result> Get()
{
using (DOAMEntities db = new DOAMEntities())
{
return(db.SP_AfficherUserRoles().ToList());
}
}
public static MetaData GetMetaDataID(int?MetaDataID)
{
using (DOAMEntities db = new DOAMEntities())
{
return(db.MetaDatas.Find(MetaDataID));
}
}
public static MimeType GetMimeTypeID(int?MimeTypeID)
{
using (DOAMEntities db = new DOAMEntities())
{
return(db.MimeTypes.Find(MimeTypeID));
}
}
public static AssetType GetAssetTypeID(int?AssetTypeID)
{
using (DOAMEntities db = new DOAMEntities())
{
return(db.AssetTypes.Find(AssetTypeID));
}
}
public static AssetMetaData GetAssetMetaDataID(int?AssetMetaDataID)
{
using (DOAMEntities db = new DOAMEntities())
{
return(db.AssetMetaDatas.Find(AssetMetaDataID));
}
}
public static AspNetUserClaim GetAspNetUserClaimID(int?AspNetUserClaimID)
{
using (DOAMEntities db = new DOAMEntities())
{
return(db.AspNetUserClaims.Find(AspNetUserClaimID));
}
}
public static AssetTypeSupportedMetaData Get(int?AssetTypeID)
{
using (DOAMEntities db = new DOAMEntities())
{
return(db.AssetTypeSupportedMetaDatas.Find(AssetTypeID));
}
}
public static string GetMetaDataName(int?Id)
{
using (DOAMEntities db = new DOAMEntities())
{
var Tag = db.MetaDatas.Find(Id);
return(Tag.Title);
}
}
public static List <MetaData> GetMetaDatas()
{
using (DOAMEntities db = new DOAMEntities())
{
var metaData = db.MetaDatas.Include(m => m.MetaDataGroup);
return(metaData.ToList());
}
}
public static void AddAssetMetaData(AssetMetaData AssetmetaData)
{
using (DOAMEntities db = new DOAMEntities())
{
db.AssetMetaDatas.Add(AssetmetaData);
db.SaveChanges();
}
}
public static List <AspNetUser> GetAspNetUsers()
{
using (DOAMEntities db = new DOAMEntities())
{
var aspNetUser = db.AspNetUsers.Include(a => a.AspNetRoles);
return(aspNetUser.ToList());
}
}
public static string GetGroupNameMetaData(int id)
{
using (DOAMEntities db = new DOAMEntities())
{
var groupeName = db.MetaDataGroups.Find(id);
return(groupeName.GroupName);
}
}
public static void AddMetaData(MetaData metaData)
{
using (DOAMEntities db = new DOAMEntities())
{
db.MetaDatas.Add(metaData);
db.SaveChanges();
}
}
public static void Update(AssetTypeSupportedMetaData assetTag)
{
using (DOAMEntities db = new DOAMEntities())
{
db.Entry(assetTag).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public static void Create(AssetTypeSupportedMetaData assetT)
{
using (DOAMEntities db = new DOAMEntities())
{
db.AssetTypeSupportedMetaDatas.Add(assetT);
db.SaveChanges();
}
}
public static List <AssetTypeSupportedMetaData> Get()
{
using (DOAMEntities db = new DOAMEntities())
{
var assetTypeSupported = db.AssetTypeSupportedMetaDatas.Include(a => a.AssetType).Include(a => a.MetaData);
return(assetTypeSupported.ToList());
}
}
public static void UpdateAssetType(AssetType assetType)
{
using (DOAMEntities db = new DOAMEntities())
{
db.Entry(assetType).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public static void AddAssetType(AssetType assetType)
{
using (DOAMEntities db = new DOAMEntities())
{
db.AssetTypes.Add(assetType);
db.SaveChanges();
}
}
public static string GetAssetTypeName(int AssetTypeID)
{
using (DOAMEntities db = new DOAMEntities())
{
var typeLabel = db.AssetTypes.Find(AssetTypeID);
return(typeLabel.TypeLabel);
}
}
public static void UpdateMetaData(MetaData metaData)
{
using (DOAMEntities db = new DOAMEntities())
{
db.Entry(metaData).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public static List <AspNetRole> GetAspNetRoles()
{
using (DOAMEntities db = new DOAMEntities())
{
var aspNetRole = db.AspNetRoles;
return(aspNetRole.ToList());
}
}
public static List <AspNetUserClaim> GetAspNetUsersClaims()
{
using (DOAMEntities db = new DOAMEntities())
{
var aspNetUserClaim = db.AspNetUserClaims.Include(a => a.AspNetUser);
return(aspNetUserClaim.ToList());
}
}
public static void AddAspNetRole(AspNetRole aspNetRole)
{
using (DOAMEntities db = new DOAMEntities())
{
db.AspNetRoles.Add(aspNetRole);
db.SaveChanges();
}
}
public static void AddAspNetUserClaim(AspNetUserClaim aspNetUserClaim)
{
using (DOAMEntities db = new DOAMEntities())
{
db.AspNetUserClaims.Add(aspNetUserClaim);
db.SaveChanges();
}
}
public static void AddAspNetUser(AspNetUser aspNetUser)
{
using (DOAMEntities db = new DOAMEntities())
{
db.AspNetUsers.Add(aspNetUser);
db.SaveChanges();
}
}
public static string GetMetaDataName(int?MetaDataID)
{
using (DOAMEntities db = new DOAMEntities())
{
var metaDataName = db.MetaDatas.Find(MetaDataID);
return(metaDataName.Title);
}
}
public static string GetTagLabel(int?TagID)
{
using (DOAMEntities db = new DOAMEntities())
{
var Tag = db.Tags.Find(TagID);
return(Tag.Label);
}
}
public static void UpdateAspNetUser(AspNetUser aspNetUser)
{
using (DOAMEntities db = new DOAMEntities())
{
db.Entry(aspNetUser).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public static List <AssetMetaData> GetAssetMetaDatas()
{
using (DOAMEntities db = new DOAMEntities())
{
var AssetmetaData = db.AssetMetaDatas.Include(a => a.Asset).Include(a => a.MetaData);
return(AssetmetaData.ToList());
}
}
