public SearchFilterVm search(SearchFilterVm input)
{
int keywordInt = int.Parse(input.keyword ?? "0");
using (var db = new MainDb())
{
var query = db.contactInfos
.OrderByDescending(b => b.created)
.Where(e => (input.isActive == null || e.isActive == input.isActive) &&
(e.firstName.Contains(input.keyword) || e.lastName.Contains(input.keyword) || string.IsNullOrEmpty(input.keyword) ||
e.contactInfoId == keywordInt ||
e.address.Contains(input.keyword) ||
e.city.Contains(input.keyword) ||
e.state.Contains(input.keyword)
));
if (input.paging != null)
{
input.paging.totalCount = query.Count();
query = query
.Skip(input.paging.skip)
.Take(input.paging.rowCount);
}
input.result = query.ToList <object>();
return(input);
}
}
public SearchFilterVm search(SearchFilterVm input)
{
using (var db = new MainDb())
{
var query = db.memberRoleLookups
.Include(r => r.memberRoleType)
.OrderByDescending(b => b.created)
.Where(e => (input.isActive == null || e.isActive == input.isActive) &&
(e.memberRoleTypeId.ToString().Contains(input.keyword) || string.IsNullOrEmpty(input.keyword))
);
if (input.paging != null)
{
input.paging.totalCount = query.Count();
query = query
.Skip(input.paging.skip)
.Take(input.paging.rowCount);
}
input.result = query.ToList <object>();
return(input);
}
}
public SearchFilterVm search(SearchFilterVm input)
{
using (var db = new MainDb())
{
var query = db.clientOrganizationLookups
.Include(c => c.client)
.Include(d => d.organization)
.OrderByDescending(b => b.created)
.Where(e => (input.isActive == null || e.isActive == input.isActive) &&
(e.organization.name.Contains(input.keyword) || string.IsNullOrEmpty(input.keyword))
);
if (input.paging != null)
{
input.paging.totalCount = query.Count();
query = query
.Skip(input.paging.skip)
.Take(input.paging.rowCount);
}
input.result = query.ToList <object>();
return(input);
}
}
public SearchFilterVm organizationListExportForCertainOrg(int id, SearchFilterVm input)
{
using (var db = new MainDb())
{
var query = db.organizations
.Include(i => i.contactInfo)
.Where(e => (e.organizationId == id));
if (query.Count() > 0)
{
List <int> members = new List <int>();
foreach (OrganizationVo org in query)
{
members = OrganizationManager.getCountofMembersInOrg(org);
org.totalAmountofMembers = members.Count;
}
}
input.result = query.ToList <object>();
if (input.result.Count() != 0)
{
var items = new List <object>();
items.Add(
new
{
h1 = "Organization Name",
h2 = "Fee Amount",
h3 = "Has Paid Fee",
h4 = "Contact Name",
h5 = "Contact Work Phone",
h6 = "Contact Email",
h7 = "Total Members in Organization"
});
var item2 = query.AsEnumerable().Select(i =>
new
{
Name = i.name,
Fee_Amount = (i.feeAmount == null ? 0 : i.feeAmount),
HasPaidFee = (i.hasPaidFee == null ? "N/A" : (i.hasPaidFee == true ? "Yes" : "No")),
Contact_Name = i.contactInfo.firstName + " " + i.contactInfo.lastName,
Work_Phone = i.contactInfo.workPhone,
Email = (i.contactInfo == null ? "" : i.contactInfo.email ?? ""),
Total_Members = i.totalAmountofMembers
}).ToList <object>();
foreach (var i in item2)
{
items.Add(i);
}
input.result = items;
}
return(input);
}
}
public SearchFilterVm searchForOrgOverviewMembers(int orgID, SearchFilterVm input)
{
int keywordInt = 0;
int.TryParse(input.keyword, out keywordInt);
if (keywordInt < 0)
{
keywordInt = 0;
}
List <int> clientsOrgLookupIDs;
ContactInfoVo contact;
List <ContactInfoVo> query = new List <ContactInfoVo>();
using (var db = new MainDb())
{
clientsOrgLookupIDs = db.clientOrganizationLookups
.Where(e => (e.organizationId == orgID))
.Select(e => e.clientId)
.ToList();
if (clientsOrgLookupIDs.Count() > 0)
{
foreach (int i in clientsOrgLookupIDs)
{
contact = db.clients
.Where(c => (c.clientId == i))
.Select(c => c.contactInfo).FirstOrDefault();
query.Add(contact);
}
}
if (query.Count() > 0)
{
foreach (ContactInfoVo con in query)
{
con.feeAmount = db.clients
.Where(c => (c.contactInfoId == con.contactInfoId))
.Select(c => c.feeAmount).FirstOrDefault();
}
}
}
var query1 = query.AsQueryable();
if (input.paging != null)
{
input.paging.totalCount = query1.Count();
query1 = query1
.Skip(input.paging.skip)
.Take(input.paging.rowCount);
}
input.result = query1.ToList <object>();
return(input);
}
public FileResult Export(SearchFilterVm input = null)
{
if (this.ModelState.IsValid)
{
input.paging = null;
input = organizationManager.organizationListExport(input);
var file = ImportExportHelper.exportToCsv(input.result, false);
return(File(file.FullName, "Application/octet-stream", file.Name));
}
return(null);
}
public FileResult Export(SearchFilterVm input = null)
{
if (this.ModelState.IsValid)
{
input.paging = null;
input = businessServiceTypeManager.search(input);
var file = ImportExportHelper.exportToCsv(input.result);
return(File(file.FullName, "Application/octet-stream", file.Name));
}
return(null);
}
public SearchFilterVm searchForOrgOverview(SearchFilterVm input)
{
int keywordInt = 0;
int.TryParse(input.keyword, out keywordInt);
if (keywordInt < 0)
{
keywordInt = 0;
}
using (var db = new MainDb())
{
var query = db.organizations
.Include(i => i.contactInfo)
.OrderByDescending(b => b.created)
.Where(e => (input.isActive == null || e.isActive == input.isActive) &&
(e.name.Contains(input.keyword) || string.IsNullOrEmpty(input.keyword) ||
e.contactInfo.firstName.Contains(input.keyword) ||
e.contactInfo.lastName.Contains(input.keyword) ||
e.contactInfo.address.Contains(input.keyword) ||
e.organizationId == keywordInt ||
e.contactInfoId == keywordInt ||
e.feeAmount == keywordInt ||
e.contactInfo.address.Contains(input.keyword) ||
e.contactInfo.city.Contains(input.keyword)
));
if (query.Count() > 0)
{
List <int> members = new List <int>();
foreach (OrganizationVo org in query)
{
members = OrganizationManager.getCountofMembersInOrg(org);
org.totalAmountofMembers = members.Count;
}
}
if (input.paging != null)
{
input.paging.totalCount = query.Count();
query = query
.Skip(input.paging.skip)
.Take(input.paging.rowCount);
}
input.result = query.ToList <object>();
return(input);
}
}
public void searchTest()
{
var vo = new SearchFilterVm();
vo.keyword = "one";
var res = businessManager.search(vo);
if (res != null)
{
Assert.IsTrue(true);
}
else
{
Assert.IsTrue(false);
}
}
public ActionResult Index(SearchFilterVm input = null, Paging paging = null)
{
if (input == null)
{
input = new SearchFilterVm();
}
input.paging = paging;
if (this.ModelState.IsValid)
{
if (input.submitButton != null)
{
input.paging.pageNumber = 1;
}
input = clientOrganizationLookupManager.search(input);
return(View(input));
}
return(View(input));
}
public ActionResult Index(SearchFilterVm input = null, Paging paging = null)
{
if (input == null)
{
input = new SearchFilterVm();
}
input.paging = paging;
if (this.ModelState.IsValid)
{
if (input.submitButton != null)
{
input.paging.pageNumber = 1;
}
input = businessServiceTypeManager.search(input);
return(View(input));
}
return(View(input));
}
public ActionResult Index(SearchFilterVm input = null, Paging paging = null)
{
if (input == null)
{
input = new SearchFilterVm();
}
input.paging = paging;
if (this.ModelState.IsValid)
{
ViewBag.Title = "Properties";
if (input.submitButton != null)
{
input.paging.pageNumber = 1;
}
input = propertyManager.search(input);
return(View(input));
}
return(View(input));
}
public ActionResult Index(SearchFilterVm input = null, Paging paging = null)
{
ViewBag.Title = "Organizations Overview";
if (input == null)
{
input = new SearchFilterVm();
}
input.paging = paging;
if (this.ModelState.IsValid)
{
if (input.submitButton != null)
{
input.paging.pageNumber = 1;
}
input = organizationManager.searchForOrgOverview(input);
return(View(input));
}
return(View(input));
}
public SearchFilterVm search(SearchFilterVm input)
{
int keywordInt = 0;
int.TryParse(input.keyword, out keywordInt);
if (keywordInt < 0)
{
keywordInt = 0;
}
using (var db = new MainDb())
{
var query = db.members
.Include(i => i.contactInfo)
.Include(a => a.memberRoleLookupses.Select(c => c.memberRoleType))
.OrderByDescending(b => b.created)
.Where(e => (input.isActive == null || e.isActive == input.isActive) &&
(e.username.Contains(input.keyword) || string.IsNullOrEmpty(input.keyword) ||
e.memberId == keywordInt ||
e.contactInfoId == keywordInt ||
e.contactInfo.address.Contains(input.keyword) ||
e.contactInfo.city.Contains(input.keyword) ||
e.contactInfo.firstName.Contains(input.keyword) ||
e.contactInfo.lastName.Contains(input.keyword)
));
if (input.paging != null)
{
input.paging.totalCount = query.Count();
query = query
.Skip(input.paging.skip)
.Take(input.paging.rowCount);
}
input.result = query.ToList <object>();
return(input);
}
}
public SearchFilterVm search(SearchFilterVm input)
{
int keywordInt = 0;
int.TryParse(input.keyword, out keywordInt);
if (keywordInt < 0)
{
keywordInt = 0;
}
using (var db = new MainDb())
{
var query = db.organizations
.Include(i => i.contactInfo)
.Where(e => ((input.isActive == null || e.isActive == input.isActive) &&
(e.name.Contains(input.keyword) || string.IsNullOrEmpty(input.keyword))) ||
e.contactInfo.firstName.Contains(input.keyword) ||
e.contactInfo.lastName.Contains(input.keyword) ||
e.contactInfo.address.Contains(input.keyword) ||
e.organizationId == keywordInt ||
e.contactInfoId == keywordInt ||
e.feeAmount == keywordInt ||
e.contactInfo.address.Contains(input.keyword) ||
e.contactInfo.city.Contains(input.keyword)
);
query = query
.OrderByDescending(b => b.created);
if (input.paging != null)
{
input.paging.totalCount = query.Count();
query = query
.Skip(input.paging.skip)
.Take(input.paging.rowCount);
}
input.result = query.ToList <object>();
return(input);
}
}
public ActionResult Index(int id, SearchFilterVm input = null, Paging paging = null)
{
ViewBag.Title = "Organizations Overview Members";
ViewBag.TotalMembers = OrganizationManager.getCountofMembersInOrgByID(id).Count();
ViewBag.orgName = OrganizationManager.getOrgNameByID(id);
if (input == null)
{
input = new SearchFilterVm();
}
input.paging = paging;
if (this.ModelState.IsValid)
{
if (input.submitButton != null)
{
input.paging.pageNumber = 1;
}
input = organizationManager.searchForOrgOverviewMembers(id, input);
return(View(input));
}
return(View(input));
}
public SearchFilterVm search(SearchFilterVm input)
{
using (var db = new MainDb())
{
var query = db.businessCategoryTypes
.OrderByDescending(b => b.created)
.Where(e => (input.isActive == null || e.isActive == input.isActive) &&
(e.name.Contains(input.keyword) || string.IsNullOrEmpty(input.keyword))
);
if (input.paging != null)
{
input.paging.totalCount = query.Count();
query = query
.Skip(input.paging.skip)
.Take(input.paging.rowCount);
}
input.result = query.ToList <object>();
return(input);
}
}
public SearchFilterVm search(SearchFilterVm input)
{
using (var db = new MainDb())
{
var query = db.referrals
.Include(a => a.surveyAnswerses)
.OrderByDescending(b => b.created)
.Where(e => (input.isActive == null || e.isActive == input.isActive)
// && (e.accepted.Contains(input.keyword) || string.IsNullOrEmpty(input.keyword))
);
if (input.paging != null)
{
input.paging.totalCount = query.Count();
query = query
.Skip(input.paging.skip)
.Take(input.paging.rowCount);
}
input.result = query.ToList <object>();
return(input);
}
}
public SearchFilterVm search(SearchFilterVm input)
{
int keywordInt = 0;
int.TryParse(input.keyword, out keywordInt);
using (var db = new MainDb())
{
var query = db.clients
.Include(i => i.contactInfo)
//.Include(o => o.clientOrganizationLookupses)
.Include(a => a.clientOrganizationLookupses.Select(c => c.organization))
.Where(e => (input.isActive == null || e.isActive == input.isActive) && (e.contactInfo != null));
switch (input.searchField)
{
default:
case SearchField.All:
query = query
.Where(e =>
string.IsNullOrEmpty(input.keyword) ||
e.contactInfo.firstName.Contains(input.keyword) ||
e.contactInfo.lastName.Contains(input.keyword) ||
e.contactInfo.address.Contains(input.keyword) ||
e.contactInfo.city.Contains(input.keyword) ||
e.contactInfo.state.Contains(input.keyword) ||
e.contactInfo.homePhone.Contains(input.keyword) ||
e.contactInfo.workPhone.Contains(input.keyword) ||
(keywordInt > 0 && e.clientId == keywordInt));
break;
case SearchField.FirstName:
query = query
.Where(e =>
string.IsNullOrEmpty(input.keyword) ||
e.contactInfo.firstName.Contains(input.keyword));
break;
case SearchField.LastName:
query = query
.Where(e =>
string.IsNullOrEmpty(input.keyword) ||
e.contactInfo.lastName.Contains(input.keyword));
break;
case SearchField.MemberID:
query = query
.Where(e =>
keywordInt > 0 &&
e.clientId == keywordInt);
break;
}
query = query
.OrderByDescending(b => b.created);
if (input.paging != null)
{
input.paging.totalCount = query.Count();
query = query
.Skip(input.paging.skip)
.Take(input.paging.rowCount);
}
input.result = query.ToList <object>();
return(input);
}
}
//
public SearchFilterVm organizationListExport(SearchFilterVm input)
{
int keywordInt = 0;
int.TryParse(input.keyword, out keywordInt);
if (keywordInt < 0)
{
keywordInt = 0;
}
using (var db = new MainDb())
{
var query = db.organizations
.Include(i => i.contactInfo)
.OrderByDescending(b => b.created)
.Where(e => (input.isActive == null || e.isActive == input.isActive) &&
(e.name.Contains(input.keyword) || string.IsNullOrEmpty(input.keyword) ||
e.contactInfo.firstName.Contains(input.keyword) ||
e.contactInfo.lastName.Contains(input.keyword) ||
e.contactInfo.address.Contains(input.keyword) ||
e.organizationId == keywordInt ||
e.contactInfoId == keywordInt ||
e.feeAmount == keywordInt ||
e.contactInfo.address.Contains(input.keyword) ||
e.contactInfo.city.Contains(input.keyword)
));
if (query.Count() > 0)
{
List <int> members = new List <int>();
foreach (OrganizationVo org in query)
{
members = OrganizationManager.getCountofMembersInOrg(org);
org.totalAmountofMembers = members.Count;
}
}
input.result = query.ToList <object>();
if (input.result.Count() != 0)
{
var items = new List <object>();
items.Add(
new
{
h1 = "Organization Name",
h2 = "Fee Amount",
h3 = "Has Paid Fee",
h4 = "Contact Name",
h5 = "Contact Work Phone",
h6 = "Contact Email",
h7 = "Total Members in Organization"
});
var item2 = query.AsEnumerable().Select(i =>
new
{
Name = i.name,
Fee_Amount = (i.feeAmount == null ? 0 : i.feeAmount),
HasPaidFee = (i.hasPaidFee == null ? "N/A" : (i.hasPaidFee == true ? "Yes" : "No")),
Contact_Name = i.contactInfo.firstName + " " + i.contactInfo.lastName,
Work_Phone = i.contactInfo.workPhone,
Email = (i.contactInfo == null ? "" : i.contactInfo.email ?? ""),
Total_Members = i.totalAmountofMembers
}).ToList <object>();
foreach (var i in item2)
{
items.Add(i);
}
input.result = items;
}
return(input);
}
}
//
public SearchFilterVm clientListExport(SearchFilterVm input)
{
int keywordInt = 0;
int.TryParse(input.keyword, out keywordInt);
using (var db = new MainDb())
{
var query = db.clients
.Include(i => i.contactInfo)
//.Include(o => o.clientOrganizationLookupses)
.Include(a => a.clientOrganizationLookupses.Select(c => c.organization))
.OrderByDescending(b => b.created)
.Where(e => (input.isActive == null || e.isActive == input.isActive)
&&
(e.contactInfo != null && (
string.IsNullOrEmpty(input.keyword) == true ||
e.contactInfo.firstName.Contains(input.keyword) ||
e.contactInfo.lastName.Contains(input.keyword)
|| e.contactInfo.address.Contains(input.keyword) ||
e.contactInfo.city.Contains(input.keyword) ||
e.contactInfo.state.Contains(input.keyword) ||
e.contactInfo.homePhone.Contains(input.keyword) ||
e.contactInfo.workPhone.Contains(input.keyword)
|| (keywordInt > 0 && e.clientId == keywordInt)
)));
input.result = query.ToList <object>();
if (input.result.Count() != 0)
{
var items = new List <object>();
items.Add(
new
{
h1 = "ID",
h2 = "Client Name",
h3 = "Address",
h4 = "Work Phone",
h5 = "Fee Has Paid",
h6 = "Organization"
});
var item1 = query.Select(i =>
new
{
ID = i.clientId,
Client_Name = i.contactInfo.firstName + " " + i.contactInfo.lastName,
Address = i.contactInfo.address + ", " + i.contactInfo.city
+ " " + i.contactInfo.state + " " + i.contactInfo.zip,
Work_Phone = i.contactInfo.workPhone,
HasPaidFee = (i.hasPaidFee == null ? "N/A" : (i.hasPaidFee == true ? "Yes" : "No")),
Organization = i.clientOrganizationLookupses.Select(c => c.organization.name).ToList()
}).ToList <dynamic>();
foreach (var j in item1)
{
items.Add((object)
new
{
ID = j.ID,
Client_Name = j.Client_Name,
Address = j.Address,
Work_Phone = j.Work_Phone,
HasPaidFee = j.HasPaidFee,
Organization = string.Join(", ", j.Organization)
});
}
input.result = items;
}
return(input);
}
}
public SearchFilterVm search(SearchFilterVm input)
{
DateTime listingDate = new DateTime();
listingDate = DateTime.Today.Date;
if (input.listingDate != null)
{
switch (input.listingDate)
{
case 0: //last 1 day
listingDate = listingDate.Subtract(new TimeSpan(1, 0, 0, 0, 0));
break;
case 1: //last 3 days
listingDate = listingDate.Subtract(new TimeSpan(3, 0, 0, 0, 0));
break;
case 2: //last 7 days
listingDate = listingDate.Subtract(new TimeSpan(7, 0, 0, 0, 0));
break;
case 3: //2 weeks
listingDate = listingDate.Subtract(new TimeSpan(14, 0, 0, 0, 0));
break;
case 4: // last month
listingDate = listingDate.Subtract(new TimeSpan(31, 0, 0, 0, 0));
break;
case 5: // last Two month
listingDate = listingDate.Subtract(new TimeSpan(62, 0, 0, 0, 0));
break;
}
}
List <int> listofIDs = new List <int>();
List <int> listofLTypeIDs = new List <int>();
if (input.propertyTypeIdFilter != null) // -23-24-25
{
var listofIDsString = input.propertyTypeIdFilter.Split('-').ToList();
listofIDs = listofIDsString.Skip(1).Select(int.Parse).ToList();;
}
if (input.propertyListingTypeIdFilter != null) // -23-24-25
{
var listofIDsString = input.propertyListingTypeIdFilter.Split('-').ToList();
listofLTypeIDs = listofIDsString.Skip(1).Select(int.Parse).ToList();;
}
using (var db = new MainDb())
{
var query = db.properties
.Include(r => r.propertyType)
.Include(t => t.propertyListingType)
//.Include(s => s.site)
.Include(i => i.cityType)
.Include(o => o.countryType)
.Include(u => u.stateType)
//.Include(w => w.entryStatusType)
.OrderByDescending(b => b.created)
.Where(e => (input.isActive == null || e.isActive == input.isActive) &&
((e.title.Contains(input.keyword) || string.IsNullOrEmpty(input.keyword)) ||
(e.title.Contains(input.keyword) || e.description.Contains(input.keyword) || string.IsNullOrEmpty(input.keyword))) &&
(input.filter_zip == null || e.zip == input.filter_zip)
//&& (input.filter_cityTypeId == null || e.cityTypeId == input.filter_cityTypeId)
&& (input.propertyTypeIdFilter == null || listofIDs.Contains(e.propertyTypeId.Value)) &&
(input.propertyListingTypeIdFilter == null || listofLTypeIDs.Contains(e.propertyListingTypeId.Value))
//&& (e.bedroomTypeId == input.bedroomTypeId || input.bedroomTypeId == null)
//&& (e.bathroomTypeId == input.bathroomTypeId || input.bathroomTypeId == null)
//&& ((e.price >= input.startingPrice || input.startingPrice == null)
//&& (e.price <= input.endingPrice || input.endingPrice == null))
//&& (input.acceptsSection8TypeId == null || e.acceptsSection8TypeId == input.acceptsSection8TypeId)
//&& (input.isPetAllowedTypeId == null || e.isPetAllowedTypeId == input.isPetAllowedTypeId)
/*
* && (input.showPendingOnly == null || input.showPendingOnly == false || e.entryStatusType.name.Equals(EntryStatusTypeStrings.csPending))
* && (input.siteId == null || e.siteId == input.siteId)
* //&& (input.entryStatusTypeId == null || e.entryStatusType.entryStatusTypeId == input.entryStatusTypeId)
* && (input.listingDate ==null || DateTime.Compare(e.startDate, listingDate) >= 0)
*/
);
//input.paging.totalCount = query.Count();
input.result = query
.OrderBy(b => b.title)
.Skip(input.paging.skip)
.Take(input.paging.rowCount)
.ToList().ToList <object>();
return(input);
}
}
