public JsonResult getEcozone(string Dev) { try { var code = Dev.Split('~'); var DevName = code[0]; var EcoName = code[1]; JavaScriptSerializer serializer = new JavaScriptSerializer(); ApplicationDbContext context = new ApplicationDbContext(); //DeveloperDetailsViewModel samp = new DeveloperDetailsViewModel(); ReportTable DeveloperList = new ReportTable(); List <devdetails> samp = new List <devdetails>(); DeveloperDetails1 devd = new DeveloperDetails1(); var userid = User.Identity.GetUserId(); string zoneGroup = context.Users.SingleOrDefault(m => m.Id == userid).ZoneGroup; var ZoneGroupId = db.ZoneGroup.FirstOrDefault(x => x.ZoneGroupCode == zoneGroup).ZoneGroupId.ToString(); var ZoneCode = db.Zone.Where(x => x.ZoneGroup == ZoneGroupId).Select(x => x.ZoneCode).ToString(); if (Dev.Length >= 4) { var dev = db.Database.SqlQuery <DeveloperDetails>("SELECT DISTINCT Dev_Comp_Code, Zone_Code from AdminFees left join Zones on AdminFees.Zone_Code = Zones.ZoneCode where AdminFees.Developer = '" + DevName + "' AND AdminFees.Ecozone = '" + EcoName + "'").ToList().Take(1); return(Json(dev)); } } catch { } return(Json(null)); }
//JSON RESULT FOR DEVELOPER public JsonResult GetDevelopers(string Dev) { //var Devlist = db.AdminFee.Select(m => m.Developer).Distinct().ToList(); //try //{ JavaScriptSerializer serializer = new JavaScriptSerializer(); ApplicationDbContext context = new ApplicationDbContext(); //DeveloperDetailsViewModel samp = new DeveloperDetailsViewModel(); ReportTable DeveloperList = new ReportTable(); List <devdetails> samp = new List <devdetails>(); DeveloperDetails1 devd = new DeveloperDetails1(); var userid = User.Identity.GetUserId(); string zoneGroup = context.Users.SingleOrDefault(m => m.Id == userid).ZoneGroup; var ZoneGroupId = db.ZoneGroup.FirstOrDefault(x => x.ZoneGroupCode == zoneGroup).ZoneGroupId.ToString(); var ZoneCode = db.Zone.Where(x => x.ZoneGroup == ZoneGroupId).Select(x => x.ZoneCode).ToString(); if (Dev.Length >= 4) { var dev = db.Database.SqlQuery <DeveloperDetails>("SELECT DISTINCT Dev_Comp_Code, Developer, Zone_Code, Ecozone from AdminFees left join Zones on AdminFees.Zone_Code = Zones.ZoneCode where AdminFees.Developer like '%" + Dev + "%'").ToList(); //foreach (var items in dev) //{ // devdetails temp = new devdetails(); // //samp.DeveloperId1.Add(items.DeveloperId); // temp.Dev_Comp_Code=items.Dev_Comp_Code; // temp.Developer=items.Developer; // temp.Ecozone=items.Ecozone; // temp.Zone_Code=items.Zone_Code; // samp.Add(temp); //} devd.dev = samp; //db.Database.SqlQuery<DeveloperDetails>("SELECT DISTINCT Dev_Comp_Code, Developer, Zone_Code, Ecozone from AdminFees left join Zones on AdminFees.Zone_Code = Zones.ZoneCode where AdminFees.Developer like '%" + Dev + "%'").ToList(); //var devs = db.AdminFee.Select(o => o.Zone_Code == ZoneCode && o.Developer.Contains(Dev)).ToList(); //var devs = from af in db.AdminFee // join z in db.Zone on af.Zone_Code equals z.ZoneCode // where z.ZoneGroup == ZoneGroupId && af.Developer.Contains(Dev) // select af; //devs.ToList(); //var devs1 = devs.Contains(Dev).ToString().Take(15); //foreach (var item in devs1) //{ // //var devs = db.Database.SqlQuery<AdminFee>("select AdminFees.* from AdminFees left join Zones on AdminFees.Zone_Code = Zones.ZoneCode where Zones.ZoneGroup = '" + ZoneGroupId + "'").ToList(); // DeveloperList.DeveloperName.Add(item.ToString()); // //DeveloperList.DeveloperName.Add(db.AdminFee.Where(x => x.Zone_Code == item.ZoneCode).FirstOrDefault().Developer); // //catch (Exception ex) { } //} ////var a = DeveloperList; //try //{ // //var Devlist1 = DeveloperList.DeveloperName.Contains(Dev).ToString().Take(15); // return Json(devs); //} //catch { } return(Json(dev)); } //} //catch { } return(Json(null)); }