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