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