public JsonResult getcompany(string comp, string type) { List <BillingPaymentJsonReturnData> billingPaymentJsonReturnData = new List <BillingPaymentJsonReturnData>(); SearchMainOrderOfPaymentViewModel searchop = new SearchMainOrderOfPaymentViewModel(); if (type == "AdminFee") { if (comp.Length >= 3) { var companies = 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 '%" + comp + "%'").ToList(); return(Json(companies)); } } else { if (comp.Length >= 3) { var newcomp = comp.Replace("'", "''"); var complist = db.Company.SqlQuery("SELECT * FROM COMPANIES WHERE CompanyName like '" + newcomp + "%'").Take(15).ToList(); foreach (var items in complist) { searchop.CompanyID.Add(db.Company.FirstOrDefault(x => x.CompanyID == items.CompanyID).CompanyID.ToString()); searchop.CompanyName.Add(db.Company.FirstOrDefault(x => x.CompanyID == items.CompanyID).CompanyName); searchop.ZoneName.Add(db.Zone.FirstOrDefault(x => x.ZoneCode == items.ZoneCode).ZoneName); } for (int i = 0; i < searchop.CompanyName.Count; i++) { BillingPaymentJsonReturnData billingPaymentJsonReturnDataNew = new BillingPaymentJsonReturnData(); billingPaymentJsonReturnDataNew.CompanyID = Convert.ToInt32(searchop.CompanyID[i]); billingPaymentJsonReturnDataNew.CompanyName = searchop.CompanyName[i].ToString(); billingPaymentJsonReturnDataNew.ZoneName = searchop.ZoneName[i].ToString(); billingPaymentJsonReturnData.Add(billingPaymentJsonReturnDataNew); } return(Json(billingPaymentJsonReturnData)); } } return(Json(null)); }
public JsonResult CompData(string comp, string zone) { List <BillingPaymentJsonReturnData> billingPaymentJsonReturnData = new List <BillingPaymentJsonReturnData>(); SearchMainOrderOfPaymentViewModel searchop = new SearchMainOrderOfPaymentViewModel(); if (zone == null) { var currentUserId = User.Identity.GetUserId(); string zoneGroups = context.Users.FirstOrDefault(m => m.Id == currentUserId).ZoneGroup; var xx = from t1 in db.Company join t2 in db.Zone on t1.ZoneCode equals t2.ZoneCode join t3 in db.ZoneGroup on t2.ZoneGroup equals t3.ZoneGroupId.ToString() where t3.ZoneGroupCode == zoneGroups select t1; if (comp.Length >= 3) { var Fees = xx.Where(x => x.CompanyName.Contains(comp)).Take(50).ToList(); // return Json(Fees); foreach (var items in Fees) { searchop.CompanyCode.Add(db.Company.FirstOrDefault(x => x.CompanyID == items.CompanyID).CompanyCode); searchop.CompanyName.Add(db.Company.FirstOrDefault(x => x.CompanyID == items.CompanyID).CompanyName); searchop.ZoneName.Add(db.Zone.FirstOrDefault(x => x.ZoneCode == items.ZoneCode).ZoneName); searchop.CompanyID.Add(db.Company.FirstOrDefault(x => x.CompanyID == items.CompanyID).CompanyID.ToString()); // searchop.Address.Add(db.Company.FirstOrDefault(x => x.CompanyID == items.CompanyID).Address); } for (int i = 0; i < searchop.CompanyName.Count; i++) { BillingPaymentJsonReturnData billingPaymentJsonReturnDataNew = new BillingPaymentJsonReturnData(); billingPaymentJsonReturnDataNew.CompanyCode = searchop.CompanyCode[i].ToString(); billingPaymentJsonReturnDataNew.CompanyName = searchop.CompanyName[i].ToString(); billingPaymentJsonReturnDataNew.ZoneName = searchop.ZoneName[i].ToString(); billingPaymentJsonReturnDataNew.Companyid = searchop.CompanyID[i].ToString(); // billingPaymentJsonReturnDataNew.CompAdd = searchop.Address[i].ToString(); billingPaymentJsonReturnData.Add(billingPaymentJsonReturnDataNew); } return(Json(billingPaymentJsonReturnData)); } } else { var xx = from t1 in db.Company join t2 in db.Zone on t1.ZoneCode equals t2.ZoneCode join t3 in db.ZoneGroup on t2.ZoneGroup equals t3.ZoneGroupId.ToString() where t3.ZoneGroupCode == zone select t1; if (comp.Length >= 3) { var Fees = xx.Where(x => x.CompanyName.Contains(comp)).Take(10).ToList(); // return Json(Fees); foreach (var items in Fees) { searchop.CompanyCode.Add(db.Company.FirstOrDefault(x => x.CompanyID == items.CompanyID).CompanyCode); searchop.CompanyName.Add(db.Company.FirstOrDefault(x => x.CompanyID == items.CompanyID).CompanyName); searchop.ZoneName.Add(db.Zone.FirstOrDefault(x => x.ZoneCode == items.ZoneCode).ZoneName); searchop.CompanyID.Add(db.Company.FirstOrDefault(x => x.CompanyID == items.CompanyID).CompanyID.ToString()); // searchop.Address.Add(db.Company.FirstOrDefault(x => x.CompanyID == items.CompanyID).Address); } for (int i = 0; i < searchop.CompanyName.Count; i++) { BillingPaymentJsonReturnData billingPaymentJsonReturnDataNew = new BillingPaymentJsonReturnData(); billingPaymentJsonReturnDataNew.CompanyCode = searchop.CompanyCode[i].ToString(); billingPaymentJsonReturnDataNew.CompanyName = searchop.CompanyName[i].ToString(); billingPaymentJsonReturnDataNew.ZoneName = searchop.ZoneName[i].ToString(); billingPaymentJsonReturnDataNew.Companyid = searchop.CompanyID[i].ToString(); // billingPaymentJsonReturnDataNew.CompAdd = searchop.Address[i].ToString(); billingPaymentJsonReturnData.Add(billingPaymentJsonReturnDataNew); } return(Json(billingPaymentJsonReturnData)); } } return(Json(null)); }