public int Update(ValidationRule validationRule) { using (var model = new gb_dvsstagingEntities()) { val_validationrule val_Rule = model.val_validationrule.First(x => x.Id == validationRule.Id); val_Rule.ValidationSettingId = validationRule.ValidationSettingId; val_Rule.RuleName = validationRule.RuleName; val_Rule.PropertyName = validationRule.PropertyName; val_Rule.PropertyXPath = validationRule.PropertyName.Replace(".", "/"); val_Rule.OperatorId = validationRule.OperatorId; val_Rule.ParameterId = validationRule.ParameterId; val_Rule.UpdatedBy = "Admin"; val_Rule.UpdatedOn = DateTime.UtcNow; val_Rule.IsTime = validationRule.IsTime; val_Rule.IsForAllNodes = validationRule.IsForAllNodes; SetValueByParameter(validationRule, val_Rule); model.Entry(val_Rule).State = EntityState.Modified; model.SaveChanges(); return(val_Rule.Id); } }
public void BulkUpdate(IList <ArrivalMessage> arrivalMessages) { lock (thisLock) { using (var model = new gb_dvsstagingEntities()) { model.Database.CommandTimeout = 300; foreach (ArrivalMessage arrivaleMessageIterator in arrivalMessages) { var val_message = model.dvs_arrivalmessage.Find(arrivaleMessageIterator.Id, arrivaleMessageIterator.ProductId); if (val_message != null) { var arrivalMessage = arrivaleMessageIterator; CopyFromTo(ref arrivalMessage, ref val_message); model.Entry(val_message).State = EntityState.Modified; } } model.SaveChanges(); } } }
public int Update(ValidationSetting validationSetting) { using (var model = new gb_dvsstagingEntities()) { val_validationsetting val_Setting = model.val_validationsetting.First(x => x.Id == validationSetting.Id); val_Setting.Name = validationSetting.Name; val_Setting.Description = validationSetting.Description; val_Setting.PriorityId = validationSetting.PriorityId; val_Setting.ProductId = validationSetting.ProductId; val_Setting.Expression = validationSetting.Expression; val_Setting.UpdatedBy = "Admin"; val_Setting.UpdatedOn = DateTime.UtcNow; val_Setting.IsSlackEnabled = validationSetting.IsSlackEnabled; val_Setting.SlackChannel = validationSetting.SlackChannel; model.Entry(val_Setting).State = EntityState.Modified; model.SaveChanges(); return(val_Setting.Id); } }
public void Update(ProductTree productTree) { lock (thisLock) { string xmlText; using (var textWriter = new StringWriter()) { new XmlSerializer(typeof(TreeNode)).Serialize(textWriter, productTree.Tree.core.data); xmlText = textWriter.ToString(); } using (var model = new gb_dvsstagingEntities()) { var productTreeModel = model.dvs_producttree.Find(productTree.Id); productTreeModel.ProductId = productTree.ProductId; productTreeModel.XmlText = xmlText; productTreeModel.UpdatedOn = DateTime.UtcNow; model.Entry(productTreeModel).State = System.Data.Entity.EntityState.Modified; model.SaveChanges(); } } }
public void Update(ArrivalMessage arrivalMessage) { lock (thisLock) { using (var model = new gb_dvsstagingEntities()) { var val_message = model.dvs_arrivalmessage.Find(arrivalMessage.Id, arrivalMessage.ProductId); CopyFromTo(ref arrivalMessage, ref val_message); model.Entry(val_message).State = EntityState.Modified; model.SaveChanges(); } } }
public void Delete(int id) { using (var model = new gb_dvsstagingEntities()) { var setting = model.val_validationrule.FirstOrDefault(s => s.Id == id); if (setting == null) { return; } setting.IsActive = false; setting.UpdatedOn = DateTime.UtcNow; setting.UpdatedBy = "Admin"; model.Entry(setting).State = EntityState.Modified; model.SaveChanges(); } }