public void UpdateDsmTarget(int dsmId, int userId, int monthId) { var dsmDseMap = _mapRepo.Find(x => x.DsmId == dsmId && x.UserId == userId && x.MonthId == monthId).ToList(); var dseIds = dsmDseMap.Select(x => x.DseId); var targets = _targetRepo.Find(x => dseIds.Contains(x.DealerManpowerId) && x.MonthId == monthId).GroupBy(x => x.ProductVarientId); foreach (var target in targets) { var dsmTarget = _targetRepo.First( x => x.MonthId == monthId && x.ProductVarientId == target.Key && x.MonthId == monthId&&x.DealerManpowerId==dsmId); if (dsmTarget == null) { var dsmTarget1 = new Target(); dsmTarget1.MonthId = monthId; dsmTarget1.ProductVarientId = target.Key; dsmTarget1.DealerManpowerId = dsmId; dsmTarget1.Actual = target.Sum(x => x.Actual); dsmTarget1.Target1 = target.Sum(x => x.Target1); dsmTarget1.Target2 = target.Sum(x => x.Target2); AddTarget(dsmTarget1); } else { dsmTarget.Actual = target.Sum(x => x.Actual); dsmTarget.Target1 = target.Sum(x => x.Target1); dsmTarget.Target2 = target.Sum(x => x.Target2); } } _targetRepo.SaveChanges(); }
/// <summary> /// Create a new Target object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="monthId">Initial value of the MonthId property.</param> /// <param name="dealerManpowerId">Initial value of the DealerManpowerId property.</param> /// <param name="actual">Initial value of the Actual property.</param> /// <param name="objectInfo">Initial value of the ObjectInfo property.</param> /// <param name="target1">Initial value of the Target1 property.</param> /// <param name="target2">Initial value of the Target2 property.</param> /// <param name="productVarientId">Initial value of the ProductVarientId property.</param> public static Target CreateTarget(global::System.Int32 id, global::System.Int32 monthId, global::System.Int32 dealerManpowerId, global::System.Int32 actual, ObjectInfo objectInfo, global::System.Int32 target1, global::System.Int32 target2, global::System.Int32 productVarientId) { Target target = new Target(); target.Id = id; target.MonthId = monthId; target.DealerManpowerId = dealerManpowerId; target.Actual = actual; target.ObjectInfo = StructuralObject.VerifyComplexObjectIsNotNull(objectInfo, "ObjectInfo"); target.Target1 = target1; target.Target2 = target2; target.ProductVarientId = productVarientId; return target; }
/// <summary> /// Deprecated Method for adding a new object to the Targets EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToTargets(Target target) { base.AddObject("Targets", target); }
public void AddTarget(Target target) { _targetRepo.Add(target); _targetRepo.SaveChanges(); }
public void UpdateTarget(Target target) { var oldTarget = GetTarget(target.Id); oldTarget.DealerManpowerId = target.DealerManpowerId; oldTarget.Description = target.Description; oldTarget.MonthId = target.MonthId; oldTarget.ProductVarientId = target.ProductVarientId; oldTarget.Target1 = target.Target1; oldTarget.Target2 = target.Target2; _targetRepo.SaveChanges(); }
public void UpdateDsmTarget(int dsmId, int userId, int monthId, int productId = 0) { var dsmDseMap = _mapRepo.Find(x => x.DsmId == dsmId && x.UserId == userId && x.MonthId == monthId && x.ObjectInfo.DeletedDate == null).ToList(); var dseIds = dsmDseMap.Select(x => x.DseId); var dsm = _manPowerRepo.Fetch().Single(x => x.Id == dsmId); var varients = _vaRepository.Fetch().Where(x => x.ProductId == dsm.ProductId).Select(x => x.Id).ToList(); if (!dseIds.Any()) { var dsmTargets = _targetRepo.Fetch().Where(x => x.MonthId == monthId && x.DealerManpowerId == dsmId); foreach (var dsmTarget in dsmTargets) { dsmTarget.Actual = 0; dsmTarget.Target1 = 0; dsmTarget.Target2 = 0; } } var productTargets = _targetRepo.Find(x => dseIds.Contains(x.DealerManpowerId) && x.MonthId == monthId).GroupBy(x => x.ProductVarientId); foreach (var productTarget in productTargets) { if (varients.Contains(productTarget.Key) || dsm.Product.IsCommon) { var dsmTarget = _targetRepo.Fetch().FirstOrDefault( x => x.MonthId == monthId && x.ProductVarientId == productTarget.Key && x.DealerManpowerId == dsmId); if (dsmTarget == null) { var dsmTarget1 = new Target(); dsmTarget1.MonthId = monthId; dsmTarget1.ProductVarientId = productTarget.Key; dsmTarget1.DealerManpowerId = dsmId; dsmTarget1.Actual = productTarget.Sum(x => x.Actual); dsmTarget1.Target1 = productTarget.Sum(x => x.Target1); dsmTarget1.Target2 = productTarget.Sum(x => x.Target2); AddTarget(dsmTarget1); } else { dsmTarget.Actual = productTarget.Sum(x => x.Actual); dsmTarget.Target1 = productTarget.Sum(x => x.Target1); dsmTarget.Target2 = productTarget.Sum(x => x.Target2); } } } _targetRepo.SaveChanges(); }
public bool SaveActuals(List<Target> targets) { Target target; foreach (var temp in targets) { if (temp.Id == 0) { target = new Target { MonthId = temp.MonthId, Actual = temp.Actual, DealerManpowerId = temp.DealerManpowerId, ProductVarientId = temp.ProductVarientId, Target1 = 0, Target2 = 0, }; _targetRepo.Add(target); } else { target = _targetRepo.Fetch().Single(x => x.Id == temp.Id); { target.Actual = temp.Actual; } } } _targetRepo.SaveChanges(); return true; }