public void Delete(AssetType assetType, IEnumerable <AssetTypeAttribute> listAssetAttributes)
{
using (var context = new CIMDbContext())
{
using (DbContextTransaction dbTran = context.Database.BeginTransaction())
{
try
{
assetType.Active = false;
assetType.UpdatedAt = DateTime.Now;
context.Entry(assetType).State = EntityState.Modified;
context.SaveChanges();
foreach (var data in listAssetAttributes)
{
data.Active = false;
data.UpdatedAt = DateTime.Now;
context.Entry(data).State = EntityState.Modified;
}
context.SaveChanges();
dbTran.Commit();
}
catch (DbEntityValidationException ex)
{
dbTran.Rollback();
}
}
}
}
/// <summary>
/// Add assetType and AssetAttribute
/// </summary>
/// <param name="assetType"></param>
/// <param name="listAssetAttributes"></param>
public bool Add(AssetType assetType, List <AssetTypeAttribute> listAssetAttributes)
{
using (var context = new CIMDbContext())
{
using (DbContextTransaction dbTran = context.Database.BeginTransaction())
{
try
{
context.AssetTypes.Add(assetType);
context.SaveChanges();
if (listAssetAttributes.Count > 0)
{
var id = assetType.ID;
foreach (var data in listAssetAttributes)
{
data.AssetTypeID = id;
data.Active = true;
context.AssetAttributes.Add(data);
}
context.SaveChanges();
}
dbTran.Commit();
return(true);
}
catch (DbEntityValidationException ex)
{
dbTran.Rollback();
return(false);
}
}
}
}
public ApplicationUser getNameUserReport(int id)
{
using (var context = new CIMDbContext())
{
using (DbContextTransaction dbTran = context.Database.BeginTransaction())
{
ApplicationUser user = new ApplicationUser();
var pic = context.Assets
.Join(context.AssetTypes, ass => ass.AssetTypeID, at => at.ID, (ass, at) => new { ass, at })
.Join(context.Areas, assat => assat.ass.AreaID, ar => ar.ID, (assat, ar) => new { assat, ar })
.Join(context.PICs, assatar => assatar.assat.ass.AreaID, p => p.AreaID, (assatar, p) => new { assatar, p })
.Join(context.PICs, assatarp => assatarp.assatar.assat.ass.AssetTypeID, p1 => p1.AssetTypeID, (assatarp, p1) => new { assatarp, p1 })
.Select(picTemp => new
{
username = picTemp.p1.ApplicationUser.FullName,
email = picTemp.p1.ApplicationUser.Email,
assetID = picTemp.assatarp.assatar.assat.ass.ID
}).Where(n => n.assetID == id).FirstOrDefault();
if (pic != null)
{
user.FullName = pic.username;
user.Email = pic.email;
return(user);
}
else
{
return(context.Users.Where(a => a.Id == 2).SingleOrDefault());
}
}
}
}
public void Add(Asset asset, List <AssetAttributeValue> assetAttributeValues)
{
using (var context = new CIMDbContext())
{
using (DbContextTransaction dbTran = context.Database.BeginTransaction())
{
try
{
asset.Image = Constants.DEFAULT_ASSET_IMAGE;
asset.CreatedAt = DateTime.Now;
asset.UpdatedAt = DateTime.Now;
asset.Active = true;
context.Assets.Add(asset);
context.SaveChanges();
if (assetAttributeValues.Count() != 0)
{
var id = asset.ID;
foreach (var data in assetAttributeValues)
{
data.AssetID = id;
data.Active = true;
context.AssetAttributeValues.Add(data);
}
context.SaveChanges();
}
dbTran.Commit();
}
catch (DbEntityValidationException ex)
{
dbTran.Rollback();
}
}
}
}
public void Update(Asset asset, IEnumerable <AssetAttributeValue> assetAttributeValues)
{
using (var context = new CIMDbContext())
{
using (DbContextTransaction dbTran = context.Database.BeginTransaction())
{
try
{
asset.UpdatedAt = DateTime.Now;
context.Entry(asset).State = EntityState.Modified;
context.SaveChanges();
foreach (var data in assetAttributeValues)
{
data.UpdatedAt = DateTime.Now;
context.Entry(data).State = EntityState.Modified;
}
context.SaveChanges();
dbTran.Commit();
}
catch (DbEntityValidationException ex)
{
dbTran.Rollback();
}
}
}
}
public bool Update(AssetType assetType, IEnumerable <AssetTypeAttribute> listAssetAttributes)
{
using (var context = new CIMDbContext())
{
using (DbContextTransaction dbTran = context.Database.BeginTransaction())
{
try
{
assetType.UpdatedAt = DateTime.Now;
context.Entry(assetType).State = EntityState.Modified;
context.SaveChanges();
foreach (var data in listAssetAttributes)
{
data.AssetTypeID = assetType.ID;
data.UpdatedAt = DateTime.Now;
if (data.ID == 0)
{
context.AssetAttributes.Add(data);
}
else
{
context.Entry(data).State = EntityState.Modified;
}
}
context.SaveChanges();
context.SaveChanges();
dbTran.Commit();
return(true);
}
catch (DbEntityValidationException ex)
{
dbTran.Rollback();
return(false);
}
}
}
}
public ApplicationRoleStore(CIMDbContext context)
: base(context)
{
}
public ApplicationUserStore(CIMDbContext context)
: base(context)
{
}
public CIMDbContext Init()
{
return(dbContext ?? (dbContext = new CIMDbContext()));
}