public JsonResult GetCompanyList(int listid, string citycircle, string biztype, string title, string name, string Notes)
{
var prospectviewlist = new List <SpgetProspectViewList_Result>();
if (TempData["compnyid"] != null && TempData["compnyid"].ToString() != "")
{
ViewBag.cmpnyid = TempData["compnyid"];
}
var complist = new List <CompanyModel>();
try
{
List <string> titlelist = new List <string>();
Notes = Notes.Replace(" ", "");
if (!string.IsNullOrEmpty(title))
{
if (title == "Manager")
{
titlelist.Add("CEO");
titlelist.Add("EXEC");
titlelist.Add("Manager");
titlelist.Add("HR");
}
else
{
titlelist.Add(title);
}
}
if (listid != 0 && string.IsNullOrEmpty(citycircle) && string.IsNullOrEmpty(biztype) && string.IsNullOrEmpty(title) && string.IsNullOrEmpty(name) && string.IsNullOrEmpty(Notes))
{
var data = context.SpgetProspectViewList(listid).ToList();
prospectviewlist = data;
return(Json(prospectviewlist, JsonRequestBehavior.AllowGet));
}
else if (listid != 0 || !string.IsNullOrEmpty(citycircle) || !string.IsNullOrEmpty(biztype) || !string.IsNullOrEmpty(title))
{
var data = (from com in context.Companies
join con in context.Contacts on com.companyid equals con.companyid into gj
from x in gj.DefaultIfEmpty()
where
com.listid == listid &&
((citycircle == null || citycircle == "") || com.citycircle == citycircle) &&
((biztype == null || biztype == "") || com.biztype == biztype) &&
((title == null || title == "") || titlelist.Contains(x.titlestandard))
&&
((name == null || name == "") || (x.contactfullname.Contains(name)) || (com.name.ToUpper().Contains(name.ToUpper()))) &&
((Notes == null || Notes == "") || x.combinednotes.Trim().Replace("\r", "").Replace("\n", "").Replace(System.Environment.NewLine, "").Replace(" ", "").Contains(Notes))
select new
{
com.companyid,
com.listid,
com.citycircle,
com.biztype,
com.name,
com.addr1,
com.addr2,
com.city,
com.state,
com.zip,
com.weburl,
com.phone,
com.priority,
com.target,
x.combinednotes
}).Distinct().OrderBy(x => x.name).ToList();
foreach (var i in data)
{
CompanyModel objcomp = new CompanyModel();
objcomp.companyid = @i.companyid;
objcomp.listid = @i.listid;
objcomp.citycircle = @i.citycircle;
objcomp.biztype = @i.biztype;
objcomp.name = @i.name;
objcomp.addr1 = @i.addr1;
objcomp.addr2 = @i.addr2;
objcomp.city = @i.city;
objcomp.state = @i.state;
objcomp.zip = @i.zip;
objcomp.weburl = @i.weburl;
objcomp.phone = @i.phone;
if (@i.priority == null)
{
objcomp.priority = false;
}
else
{
objcomp.priority = Convert.ToBoolean(@i.priority);
}
if (@i.target == null)
{
objcomp.priority = false;
}
else
{
objcomp.target = Convert.ToBoolean(@i.target);
}
objcomp.combinednotes = @i.combinednotes;
if (complist.Where(x => x.companyid == objcomp.companyid).Count() == 0)
{
complist.Add(objcomp);
}
}
return(Json(complist, JsonRequestBehavior.AllowGet));
//return View("GetCompanyListNew", complist);
//return RedirectToAction("Index", "ProspectListsAdmin");
}
}
catch (Exception ex)
{
cm.ErrorExceptionLogingByService(ex.ToString(), "ProspectViewList" + ":" + new StackTrace().GetFrame(0).GetMethod().Name, "GetCompanyList", "NA", "NA", "NA", "WEB");
}
return(Json(prospectviewlist, JsonRequestBehavior.AllowGet));
//return View("GetCompanyListNew", prospectviewlist);
}
