public ActionResult CsmUser(int id)
{
var csm = _userService.GetUser(id);
ViewBag.UserName = csm.Name;
if (User.IsInRole("CSM"))
{
Session["BreadcrumbList"] = Utils.HtmlExtensions.SetBreadcrumbs((List<BreadcrumbModel>)Session["BreadcrumbList"], string.Format("/User/CsmUser/{0}", id), "Home");
}
else
{
Session["BreadcrumbList"] = Utils.HtmlExtensions.SetBreadcrumbs((List<BreadcrumbModel>)Session["BreadcrumbList"], string.Format("/User/CsmUser/{0}", id), "CSM");
}
var currentDate = DateTime.Now;
var currentMonth = _masterService.FindAndCreateMonth(currentDate.ToString("MMMM"), currentDate.Year);
var currentYear = new DateTime(currentDate.Year, 1, 1);
var yearMonths = _masterService.FindMonths(year: currentDate.Year).ToList();
var existMonths = new List<Month>();
var products = _masterService.GetAllProducts().OrderBy(x => x.Id).ToList();
var productMonthManPower = products.ToDictionary(x => x.Id, x => 0);
var allProductMonthManPower = products.ToDictionary(x => x.Id, x => 0);
var janMonthManpowers = products.ToDictionary(x => x.Id, x => 0);
for (int i = 1; i < currentDate.Month + 1; i++)
{
var month = new DateTime(currentDate.Year, i, 15);
var existMonth =
yearMonths.SingleOrDefault(x => x.Name.Equals(month.ToString("MMMM")) && x.Year == month.Year);
if (existMonth == null)
existMonth = new Month { Name = month.ToString("MMMM"), Year = month.Year };
existMonths.Add(existMonth);
}
var janMonth = existMonths.Single(x => x.Name == "January");
var monthCharts = new Dictionary<string, GraphModel>();
foreach (var yearMonth in existMonths)
{
var currentmonth = DateTime.Parse(string.Format("1 {0} {1}", yearMonth.Name, yearMonth.Year));
var nextMonth = currentmonth.AddMonths(1);
if (yearMonth.Id != 0)
{
var monthlyManPowerTarget = _manpowerTargetService.FindUserManpowerMonthTarget(new List<int> { id }, new List<int> { yearMonth.Id });
var totalManPower = _manpowerService.FindAllUserManpowers(new List<int> { id }, string.Empty).ToList();
var monthlyManPower =
totalManPower.Where(
x =>
x.ObjectInfo.CreatedDate.Ticks < nextMonth.Ticks &&
(x.Profile.DateOfLeaving == null ||
x.Profile.DateOfLeaving.Value.Ticks >= currentmonth.Ticks)).ToList();
var groupProductMonthManPower = monthlyManPower.GroupBy(x => x.ProductId).ToList();
foreach (var product in products)
{
var monthProductManpower = groupProductMonthManPower.SingleOrDefault(x => x.Key == product.Id);
if (yearMonth.Name != currentDate.ToString("MMMM"))
{
productMonthManPower[product.Id] = productMonthManPower[product.Id] + (monthProductManpower != null ? monthProductManpower.Count() : 0);
}
if (yearMonth.Name == "January")
{
janMonthManpowers[product.Id] = janMonthManpowers[product.Id] + (monthProductManpower != null ? monthProductManpower.Count() : 0);
}
allProductMonthManPower[product.Id] = allProductMonthManPower[product.Id] +
(monthProductManpower != null ? monthProductManpower.Count() : 0);
}
var manPoersIds = totalManPower.Where(x => x.Type == "DSE").Select(x => x.Id);
var monthlyActualSales = _targetService.FindMonthlyTarget(manPoersIds, yearMonth.Id);
var graphModel = new GraphModel
{
ActualManPower = monthlyManPower.Count(),
PlanManPower = monthlyManPowerTarget.Sum(x => x.Planned),
Retail = monthlyActualSales.Sum(x => x.Actual)
};
monthCharts.Add(yearMonth.Name, graphModel);
}
else
{
monthCharts.Add(yearMonth.Name, new GraphModel());
}
}
var dealers = _userDealerMapService.FindDealers(new List<int> { id });
var trainingLevels = Enumeration.GetAll<TrainingLevel>().ToList();
var reportList = new List<ReportManpowerModel>();
foreach (var dealer in dealers)
{
var targets =
_manpowerTargetService.FindDealerManpowerTargets(new List<int> { dealer.Id }, new List<int> { id },
currentMonth.Id).ToList();
var manpowers = _manpowerService.FindAllDealerManpowers(new List<int> { dealer.Id }, new List<int> { id }).ToList();
var targetList = products.Select(product => new TotalManpower
{
Plan = targets.Where(x => x.ProductId == product.Id).Sum(x => x.Planned),
Actual = manpowers.Count(x => x.ProductId == product.Id)
}).ToList();
var trainingLevelList = trainingLevels.ToList().Select(level => new ManpowerTrainingLevel
{
Level = level.Value,
LevelCount = manpowers.Count(x => x.Profile.TrainingLevel == level.Value)
}).ToList();
reportList.Add(new ReportManpowerModel
{
User = dealer.Name,
UserUrl = string.Format("/Dealer/Dealer?dealerId={0}&csmId={1}", dealer.Id, id),
Manpowers = targetList,
TrainingLevels = trainingLevelList
});
}
var productStatList = new List<ProductStateModel>();
int totalNonExistManpower = 0, totalEmployee = 0;
int totalActuals = 0, months = 1;
foreach (var product in products)
{
var productManpower = _manpowerService.FindAllProductUserManpowers(new List<int> { id }, new List<int> { product.Id }).ToList();
var productNonExitMnapowers = productManpower.Any() ? productManpower.Count(x => x.Profile.DateOfLeaving != null && x.Profile.DateOfLeaving.Value.Ticks > currentYear.Ticks) : 0;
var noofManpowerProductMonth = allProductMonthManPower.Single(x => x.Key == product.Id).Value;
totalEmployee = totalEmployee + noofManpowerProductMonth;
totalNonExistManpower = totalNonExistManpower + productNonExitMnapowers;
var dseManPowerIds = productManpower.Where(x => x.Type == "DSE").Select(x => x.Id).ToList();
productManpower.RemoveAll(x => x.ObjectInfo.DeletedDate != null || x.Profile.DateOfLeaving != null);
var manpowerIds = productManpower.Select(x => x.Id).ToList();
var compmaps = _competencyProfileMapService.FindAllManpowerComap(manpowerIds);
var actualManpowers = productManpower.Any() ? productManpower.Where(x => compmaps.Any(y => y.DealerManpowerId == x.Id)).ToList() : null;
List<Target> monthTargets;
monthTargets = _targetService.FindMonthlyTarget(dseManPowerIds, janMonth.Id).ToList();
var noOfMonths = monthTargets.GroupBy(x => x.MonthId).Count();
var productActuals = monthTargets.Sum(x => x.Actual);
totalActuals = totalActuals + productActuals;
months = Math.Max(months, noOfMonths);
productStatList.Add(new ProductStateModel
{
Product = product.Name,
Competency = actualManpowers != null && actualManpowers.Any() ? actualManpowers.Sum(x => x.CompetencyProfileMaps.Average(y => y.Score)) / actualManpowers.Count() * 20 : 0,
Productivity = noOfMonths != 0 && janMonthManpowers[product.Id] != 0 ? Math.Round((double)productActuals / janMonthManpowers[product.Id], 2) : 0,
Attrition = allProductMonthManPower[product.Id] != 0 ? (productNonExitMnapowers / (allProductMonthManPower[product.Id] / (double)currentDate.Month)) * 100 : 0,
TotalCompetency = actualManpowers != null && actualManpowers.Any() ? actualManpowers.Sum(x => x.CompetencyProfileMaps.Average(y => y.Score)) * 20 : 0,
TotalManpowers = actualManpowers != null && actualManpowers.Any() ? actualManpowers.Count() : 0 // used for division
});
}
foreach (var productStatModel in productStatList)
{
productStatModel.GrossCompetency = productStatList.Sum(x => x.TotalManpowers) != 0 ? productStatList.Sum(x => x.TotalCompetency) / productStatList.Sum(x => x.TotalManpowers) : 0;
}
var model = new CsmUserViewModel
{
ReportManpower = new ReportManpowerViewModel
{
ReportManpowers = reportList.OrderBy(x => x.User),
Products = products.Select(x => x.Name),
TrainingLevels = trainingLevels.Select(x => x.Value),
},
ProductStatistics = productStatList,
MonthGaphModel = monthCharts,
Attrition = totalEmployee != 0 ? (totalNonExistManpower / (totalEmployee / (double)currentDate.Month)) * 100 : 0,
Productivity = totalActuals / (double)janMonthManpowers.Sum(x => x.Value)
};
ViewBag.List = Session["BreadcrumbList"];
ViewBag.Role = "CSM";
ViewBag.CsmId = id;
ViewBag.Title = string.Format("{0}({1})", csm.Name, csm.Role);
return View(model);
}
public ActionResult Dealer(int dealerId, int csmId)
{
Session["BreadcrumbList"] = Utils.HtmlExtensions.SetBreadcrumbs((List<BreadcrumbModel>)Session["BreadcrumbList"], string.Format("/Dealer/Dealer?dealerId={0}&csmId={1}", dealerId, csmId), "Dealer");
var currentDate = DateTime.Now;
var currentMonth = masterService.FindAndCreateMonth(currentDate.ToString("MMMM"), currentDate.Year);
var manpowerUsers = manpowerService.FindDealerManpowers(x => x.DealerId == dealerId && x.UserId == csmId);
var products = masterService.GetAllProducts().OrderBy(x => x.Id);
var trainingLevels = Enumeration.GetAll<TrainingLevel>();
var reportList = new List<ReportManpowerModel>();
var targets = manpowerTargetService.FindDealerManpowerTargets(x => x.DealerId == dealerId && x.UserId == csmId);
var targetList = new List<TotalManpower>();
foreach (var product in products) {
targetList.Add(new TotalManpower {
Plan = targets.Where(x => x.ProductId == product.Id).Sum(x => x.Planned),
Actual = manpowerUsers.Count(x => x.ProductId == product.Id)
});
}
var trainingLevelList = new List<ManpowerTrainingLevel>();
foreach (var level in trainingLevels) {
trainingLevelList.Add(new ManpowerTrainingLevel {
Level = level.Value,
LevelCount = manpowerUsers.Count(x => x.Profile.TrainingLevel == level.Value)
});
}
reportList.Add(new ReportManpowerModel {
Manpowers = targetList,
TrainingLevels = trainingLevelList
});
var productStatList = new List<ProductStatModel>();
foreach (var product in products) {
var productVarientIds = masterService.FindProductVarient(x => x.ProductId == product.Id).Select(x => x.Id);
var manpowers = manpowerService.FindDealerManpowers(x => x.UserId == csmId && x.DealerId == dealerId && x.ProductId == product.Id);
var exitMnapowers = manpowers.Count(x => x.Profile.DateOfLeaving != null);
var averageEmployee = masterService.FindAverageEmployee(currentDate.AddMonths(-1));
var manpowerIds = manpowers.Select(x => x.Id);
var actualManpowers = manpowers.Any() ? manpowers.Where(x => x.CompetencyProfileMaps.Any()) : null;
var dealerTargets =
targetService.FindTargets(
x => x.MonthId == currentMonth.Id && productVarientIds.Contains(x.ProductVarientId) && manpowerIds.Contains(x.DealerManpowerId));
productStatList.Add(new ProductStatModel {
Product = product.Name,
Competency = actualManpowers != null && actualManpowers.Any() ? Math.Round(actualManpowers.Average(x => x.CompetencyProfileMaps.Average(y => y.Score)), 2) : 0,
Productivity = dealerTargets.Any() ? Math.Round(dealerTargets.Average(x => x.Actual), 2) : 0,
Attrition = exitMnapowers / (averageEmployee > 0 ? averageEmployee : 1)
});
}
var model = new CsmUserViewModel {
ReportManpower = new ReportManpowerViewModel {
ReportManpowers = reportList,
Products = products.Select(x => x.Name),
TrainingLevels = trainingLevels.Select(x => x.Value)
},
ProductStatistics = productStatList
};
ViewBag.DealerId = dealerId;
ViewBag.CsmId = csmId;
ViewBag.List = Session["BreadcrumbList"];
ViewBag.UserName = masterService.GetDealer(dealerId).Name;
return View(model);
}
