public List <Organization> DisplayDirectory()
{
directory_dbEntities context = new directory_dbEntities();
List <Organization> organization = context.Organizations.ToList();
return(organization);
}
public Organization DisplayDetail(int id)
{
directory_dbEntities context = new directory_dbEntities();
var organizations = context.Organizations.Where(b => b.id == id).FirstOrDefault();
return(organizations);
}
public IEnumerable <Organization> GetOrganizations(string searchString, string sortOrder)
{
directory_dbEntities context = new directory_dbEntities();
IEnumerable <Organization> organizations = from s in context.Organizations
select s;
organizations = FilterOrganizations(organizations, searchString);
organizations = SortDirectory(organizations, sortOrder);
return(organizations);
}
public void RemoveCompany(int id)
{
directory_dbEntities db = new directory_dbEntities();
Organization organization = new Organization();
organization = db.Organizations.Where(b => b.id == id).FirstOrDefault();
organization.id = id;
db.Organizations.Remove(organization);
db.SaveChanges();
}
public ActionResult Login(string userName, string password)
{
directory_dbEntities db = new directory_dbEntities();
DBUser user = new DBUser();
user = db.DBUsers.Where(b => b.userName == "portfolio" && b.password == "P@ssw0rd").FirstOrDefault();
if (user.userName == userName && user.password == password)
{
Session["sessionID"] = "true";
return(RedirectToAction("Add", "Admin"));
}
else
{
ViewBag.Message = "Login Unsuccessful! Please try again.";
return(View());
}
}
public void AddCompany(string company, string last, string first, string phoneNum, string addr, string cityName, string prov, string ctry,
string pc, string lat, string longit)
{
directory_dbEntities db = new directory_dbEntities();
Organization organization = new Organization();
//make sure organization is not already there. query database and compare two properties....
organization.companyName = company;
organization.lastName = last;
organization.firstName = first;
organization.phone = phoneNum;
organization.address = addr;
organization.city = cityName;
organization.province = prov;
organization.country = ctry;
organization.postalCode = pc;
organization.latitude = lat;
organization.longitude = longit;
db.Organizations.Add(organization);
db.SaveChanges();
}
public ActionResult Index(string sortOrder, string currentFilter, string searchString, int?page)
{
directory_dbEntities context = new directory_dbEntities();
BusinessDirectory bd = new BusinessDirectory();
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
bd.DisplayDirectory();
IEnumerable <Organization> organizations = bd.GetOrganizations(searchString, sortOrder);
ViewBag.CurrentFilter = searchString;
ViewBag.CurrentSort = sortOrder;
if (String.IsNullOrEmpty(sortOrder))
{
ViewBag.NameSortParm = BusinessDirectory.ORG;
}
else
{
ViewBag.NameSortParm = "";
}
if (sortOrder == BusinessDirectory.CONTACT)
{
ViewBag.DateSortParm = BusinessDirectory.CONTACT_DESC;
}
else
{
ViewBag.DateSortParm = BusinessDirectory.CONTACT;
}
if (sortOrder == BusinessDirectory.ADDRESS)
{
ViewBag.DateSortParm = BusinessDirectory.ADDRESS_DESC;
}
else
{
ViewBag.DateSortParm = BusinessDirectory.ADDRESS;
}
if (sortOrder == BusinessDirectory.CITY)
{
ViewBag.DateSortParm = BusinessDirectory.CITY_DESC;
}
else
{
ViewBag.DateSortParm = BusinessDirectory.CITY;
}
if (sortOrder == BusinessDirectory.PROV)
{
ViewBag.DateSortParm = BusinessDirectory.PROV_DESC;
}
else
{
ViewBag.DateSortParm = BusinessDirectory.PROV;
}
if (sortOrder == BusinessDirectory.COUNTRY)
{
ViewBag.DateSortParm = BusinessDirectory.COUNTRY_DESC;
}
else
{
ViewBag.DateSortParm = BusinessDirectory.COUNTRY;
}
const int PAGE_SIZE = 10;
int pageNumber = (page ?? 1);
// Truncate results to fit in the view provided.
organizations = organizations.ToPagedList(pageNumber, PAGE_SIZE);
return(View(organizations));
}
