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 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();
}
}
}
}
public ActionResult Edit([Bind(Include = "ID,EmailAddress,Password,Port,Host,EnabledSSL,TemplateID,CreatedAt,UpdatedAt,Active")] MailConfig mailConfig)
{
try
{
var validateName = _mailConfigService.GetAll().FirstOrDefault
(x => x.EmailAddress == mailConfig.EmailAddress && x.ID != mailConfig.ID);
if (validateName != null)
{
ModelState.AddModelError("EmailAddress", "Email Address already exists");
}
if (ModelState.IsValid)
{
string password = MailHelper.Encrypt(mailConfig.Password);
mailConfig.Password = password;
mailConfig.UpdatedAt = DateTime.Now;
db.Entry(mailConfig).State = EntityState.Modified;
db.SaveChanges();
SetAlert("Update Mail Config success", "success");
return(RedirectToAction("Index"));
}
}catch (Exception e)
{
SetAlert("Update Mail Config error", "error");
}
return(View(mailConfig));
}
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 virtual void Update(T entity)
{
dbSet.Attach(entity);
dataContext.Entry(entity).State = EntityState.Modified;
}