public ActionResult DashboardLevel4(string Type, string Region, string Zone) { if (string.IsNullOrWhiteSpace(Type)) { Type = "FAS"; } FASViewModel vm = new FASViewModel(); vm.DateFrom = user.DateFrom; vm.DateTo = user.DateTo; vm.SelectedCompanies.Add(user.CompCode.ToString()); if (!string.IsNullOrEmpty(Region)) { Region region = FASRepo.GetRegion(int.Parse(Region)); ViewBag.Region = region.Name; vm.SelectedRegions.Add(Region); } if (!string.IsNullOrEmpty(Zone)) { Zone zone = FASRepo.GetZone(Zone); ViewBag.Zone = zone.Name; vm.SelectedZones.Add(Zone); } var k = FASRepo.GetTerritoryBoxes(Type, FASRepo.GetWhereClause(vm, Type, 1, user.UserID), user.UserID); return(View(k)); }
public ActionResult Details(FASViewModel vm) { if (vm.SelectedCompanies == null) { vm.SelectedCompanies = new List <string>(); } if (vm.SelectedRegions == null) { vm.SelectedRegions = new List <string>(); } if (vm.SelectedTerritories == null) { vm.SelectedTerritories = new List <string>(); } if (vm.SelectedZones == null) { vm.SelectedZones = new List <string>(); } vm.Companies = CompanyRepo.GetCompanies(user.UserID); vm.Regions = FASRepo.GetRegions(1, vm.SelectedCompanies.Select(x => x.ToString()).ToList(), user.UserID); vm.Zones = FASRepo.GetZones(1, vm.SelectedCompanies.Select(x => x.ToString()).ToList(), vm.SelectedRegions.Select(x => x.ToString()).ToList(), user.UserID); vm.Territories = FASRepo.GeTerritories(1, vm.Companies.Select(x => x.Compcode.ToString()).ToList(), vm.SelectedRegions.Select(x => x.ToString()).ToList(), vm.SelectedZones.Select(x => x.ToString()).ToList(), user.UserID); ViewBag.WhereClause = FASRepo.GetWhereClause(vm, "FAS", 1, user.UserID); var list = FASRepo.GetDetails("FAS", FASRepo.GetWhereClause(vm, "FAS", 1, user.UserID), user.UserID); ViewBag.ListDetails = list; return(View(vm)); }
public ActionResult DashboardLevel2(string Type) { if (string.IsNullOrWhiteSpace(Type)) { Type = "FAS"; } FASViewModel vm = new FASViewModel(); vm.DateFrom = user.DateFrom; vm.DateTo = user.DateTo; vm.SelectedCompanies.Add(user.CompCode.ToString()); var k = FASRepo.GetRegionBoxes(Type, FASRepo.GetWhereClause(vm, Type, 1, user.UserID), user.UserID); return(View(k)); }
public ActionResult ActivityDetails() { ActivityDetails_VM displayVM = new ActivityDetails_VM(); FASViewModel vm = new FASViewModel(); vm.SelectedCompanies.Add(user.CompCode.ToString()); vm.DateFrom = user.DateFrom; vm.DateTo = user.DateTo; try { displayVM.FASBox = FASRepo.GetCompanyCount("FAS", FASRepo.GetWhereClause(vm, "FAS", 1, user.UserID), user.UserID).First(); displayVM.DemoBox = FASRepo.GetCompanyCount("Demo", FASRepo.GetWhereClause(vm, "Demo", 1, user.UserID), user.UserID).First(); displayVM.FDBox = FASRepo.GetCompanyCount("F/D", FASRepo.GetWhereClause(vm, "F/D", 1, user.UserID), user.UserID).First(); } catch (Exception ex) { //displayVM = new ActivityDetails_VM(); } return(View(displayVM)); }
public string GetWhereClause(FASViewModel vm, string Type, int SessionGroupType, int UserID) { if (vm.DateFrom == null) { vm.DateFrom = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-") + "01"); } if (vm.DateTo == null) { vm.DateTo = DateTime.Now; } string Where = $"Where ( T.Compcode in ({string.Join(",", vm.SelectedCompanies)}) ) "; if (vm.SelectedRegions != null && vm.SelectedRegions.Where(x => !string.IsNullOrWhiteSpace(x)).ToList().Count > 0) { Where += $" AND T.Regionid in ({string.Join(",", vm.SelectedRegions)})"; } if (vm.SelectedZones == null || vm.SelectedZones.Count == 0) { if (SessionGroupType == 1) { Where += $" AND (T.Zoneid in ( SELECT distinct [Zoneid] FROM zone WHERE [Compcode] in ({string.Join(",", vm.SelectedCompanies)})) ) "; } else { Where += $" AND (T.Zoneid in ( SELECT distinct [Zoneid] FROM Viewuserzoneregion WHERE [Compcode] in ({string.Join(",", vm.SelectedCompanies)}) AND Uid = {UserID}) ) "; } } else { Where += $" AND ( T.zoneid in ({string.Join(",",vm.SelectedZones)}) )"; } if (vm.SelectedTerritories != null && vm.SelectedTerritories.Count > 0) { Where += $" AND ( T.Territoryid in ({string.Join(",", vm.SelectedTerritories)}) )"; } if (vm.SelectedDistricts != null && vm.SelectedDistricts.Count > 0) { Where += $" AND isnull(D.VID,0) = {vm.SelectedDistricts.First()} "; } if (vm.SelectedVillages != null && vm.SelectedVillages.Count > 0) { Where += $" AND V.VID = {vm.SelectedVillages.First()}"; } if (vm.SelectedFarmers != null && vm.SelectedFarmers.Count > 0) { Where += $" AND F.VID = {string.Join(",", vm.SelectedFarmers.First())}"; } if (vm.SelectedStatus != null && vm.SelectedStatus.Count > 0) { Where += $" AND H.VStatus = {vm.SelectedStatus.First()}"; } if (vm.SelectedCrops != null && vm.SelectedCrops.Count > 0) { Where += $" AND CR.CropID = {vm.SelectedCrops.First()}"; } if (vm.SelectedCategories != null && vm.SelectedCategories.Count > 0) { Where += $" AND ( P.Categoryid in ({string.Join(",", vm.SelectedCategories)}) )"; } if (vm.SelectedProducts != null && vm.SelectedProducts.Count > 0) { Where += $" AND ( P.Productid in ({string.Join(",", vm.SelectedProducts)}) )"; } if (vm.SelectedSpecs != null && vm.SelectedSpecs.Count > 0) { Where += $" AND ( P.Specid in ({string.Join(",", vm.SelectedTerritories)}) )"; } if (Type == "FAS") { Where += $" AND (H.VisitDate between '{((DateTime)vm.DateFrom).ToString("yyyy-MM-dd")}' and '{((DateTime)vm.DateTo).ToString("yyyy-MM-dd")}' )"; } else if (Type == "Demo") { Where += $" AND (H.TrialDate between '{((DateTime)vm.DateFrom).ToString("yyyy-MM-dd")}' and '{((DateTime)vm.DateTo).ToString("yyyy - MM - dd")}' )"; } else if (Type == "F/D") { Where += $" AND (H.FDDate between '{((DateTime)vm.DateFrom).ToString("yyyy-MM-dd")}' and '{((DateTime)vm.DateTo).ToString("yyyy-MM-dd")}' )"; } //Where += $" AND (H.VisitDate between '{((DateTime)vm.DateFrom).ToString("yyyy-MM-dd")}' and '{((DateTime)vm.DateTo).ToString("yyyy-MM-dd")}' )"; if (vm.AcreageTo != 0 && vm.AcrageFrom != 0) { Where += $" AND (H.TotAcreage between {vm.AcrageFrom} and {vm.AcreageTo} )"; } return(Where); }
public ActionResult Details(string Type, string Region, string Zone, string Territory) { if (string.IsNullOrWhiteSpace(Type)) { Type = "FAS"; } FASViewModel vm = new FASViewModel(); vm.SelectedCompanies = new List <string>(); vm.Companies = CompanyRepo.GetCompanies(user.UserID); vm.SelectedCompanies = new List <string>(); vm.SelectedCompanies.Add(user.CompCode.ToString()); vm.Regions = FASRepo.GetRegions(1, vm.SelectedCompanies, user.UserID); vm.SelectedRegions = new List <string>(); if (!string.IsNullOrEmpty(Region)) { Region region = FASRepo.GetRegion(int.Parse(Region)); ViewBag.Region = region.Name; vm.SelectedRegions.Add(Region); } if (vm.SelectedRegions.Count != 0) { vm.Zones = FASRepo.GetZones(1, vm.SelectedCompanies, vm.SelectedRegions, user.UserID); } else { vm.Zones = FASRepo.GetZones(1, vm.SelectedCompanies, vm.Regions.Select(x => x.ID.ToString()).ToList(), user.UserID); } vm.SelectedZones = new List <string>(); if (!string.IsNullOrEmpty(Zone)) { Zone zone = FASRepo.GetZone(Zone); ViewBag.Zone = zone.Name; vm.SelectedZones.Add(Zone); } if (vm.SelectedZones.Count != 0) { if (vm.SelectedRegions.Count != 0) { vm.Territories = FASRepo.GeTerritories(1, vm.SelectedCompanies, vm.SelectedRegions, vm.SelectedZones, user.UserID); } else { vm.Territories = FASRepo.GeTerritories(1, vm.SelectedCompanies, vm.Regions.Select(x => x.ID.ToString()).ToList(), vm.SelectedZones, user.UserID); } } else { vm.Territories = FASRepo.GeTerritories(1, vm.SelectedCompanies, vm.Regions.Select(x => x.ID.ToString()).ToList(), vm.Zones.Select(x => x.ID.ToString()).ToList(), user.UserID); } vm.SelectedTerritories = new List <string>(); if (!string.IsNullOrEmpty(Territory)) { Territory territory = FASRepo.GetTerritory(Territory); ViewBag.Territory = territory.Name; vm.SelectedTerritories.Add(Territory); } vm.DateFrom = user.DateFrom; vm.DateTo = user.DateTo; var list = FASRepo.GetDetails(Type, FASRepo.GetWhereClause(vm, Type, 1, user.UserID), user.UserID); ViewBag.ListDetails = list; return(View(vm)); }