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();
}
}
