//
// GET: /AttProcessors/Create
public ActionResult Create()
{
TAS2013Entities db = new TAS2013Entities();
User LoggedInUser = Session["LoggedUser"] as User;
QueryBuilder qb = new QueryBuilder();
String query = qb.QueryForCompanyViewLinq(LoggedInUser);
ViewBag.PeriodTag = new SelectList(new List<SelectListItem>
{
new SelectListItem { Selected = true, Text = "Daily", Value = "D"},
new SelectListItem { Selected = false, Text = "Monthly", Value = "M"},
new SelectListItem { Selected = false, Text = "Summary", Value = "S"},
}, "Value" , "Text",1);
ViewBag.CriteriaID = new SelectList(new List<SelectListItem>
{
new SelectListItem { Selected = true, Text = "Company", Value = "C"},
new SelectListItem { Selected = false, Text = "Location", Value = "L"},
}, "Value", "Text", 1);
ViewBag.ProcessCats = new SelectList(new List<SelectListItem>
{
new SelectListItem { Selected = true, Text = "Yes", Value = "1"},
new SelectListItem { Selected = false, Text = "No", Value = "0"},
}, "Value", "Text", 1);
ViewBag.CompanyID = new SelectList(db.Companies.Where(query).OrderBy(s=>s.CompName), "CompID", "CompName");
query = qb.QueryForLocationTableSegerationForLinq(LoggedInUser);
ViewBag.LocationID = new SelectList(db.Locations.Where(query).OrderBy(s=>s.LocName), "LocID", "LocName");
ViewBag.CatID = new SelectList(db.Categories.OrderBy(s=>s.CatName), "CatID", "CatName");
return View();
}
public ActionResult Create()
{
ViewBag.DayOff1 = new SelectList(db.DaysNames.OrderBy(s=>s.Name), "ID", "Name");
ViewBag.DayOff2 = new SelectList(db.DaysNames.OrderBy(s=>s.Name), "ID", "Name");
QueryBuilder qb = new QueryBuilder();
User LoggedInUser = Session["LoggedUser"] as User;
string query = qb.QueryForLocationTableSegerationForLinq(LoggedInUser);
ViewBag.LocationID = new SelectList(db.Locations.Where(query).OrderBy(s=>s.LocName), "LocID", "LocName");
ViewBag.RosterType = new SelectList(db.RosterTypes.OrderBy(s=>s.Name), "ID", "Name");
return View();
}
private void BindGridViewLocation(string search)
{
User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
QueryBuilder qb = new QueryBuilder();
string query = qb.QueryForLocationTableSegerationForLinq(LoggedInUser);
List<Location> _View = da.Locations.Where(query).ToList();
GridViewLocation.DataSource = _View.Where(aa => aa.LocName.ToUpper().Contains(search.ToUpper())).ToList();
GridViewLocation.DataBind();
}
// GET: /Location/
public ActionResult Index(string sortOrder, string searchString, string currentFilter, int? page)
{
if (Session["LogedUserFullname"].ToString() != "")
{
ViewBag.CurrentSort = sortOrder;
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
//ViewBag.SiteSortParm = sortOrder == "site" ? "site_desc" : "site";
ViewBag.CitySortParm = sortOrder == "city" ? "city_desc" : "city";
ViewBag.RegionSortParm = sortOrder == "region" ? "region_desc" : "region";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
User LoggedInUser = Session["LoggedUser"] as User;
QueryBuilder qb = new QueryBuilder();
string query = qb.QueryForLocationTableSegerationForLinq(LoggedInUser);
// var locations = qb.GetUserLocationsLinq(locations, LoggedInUser);
var locations = db.Locations.Where(query);
locations = locations.Include(l => l.City).Include(l => l.City.Region);
//
// var locations = dt.ToList<DerivedLocation>();
// var locations = db.Locations.Include(l => l.City).Include(l => l.City.Region);
// String searchParameter = "SELECT [Extent1].[LocID] AS [LocID],[Extent1].[LocName] AS [LocName], [Extent1].[CityID] AS [CityID] FROM [dbo].[Location] AS [Extent1] LEFT OUTER JOIN [dbo].[City] AS [Extent2] ON [Extent1].[CityID] = [Extent2].[CityID] LEFT OUTER JOIN [dbo].[Region] AS [Extent3] ON [Extent2].[RegionID] = [Extent3].[RegionID] WHERE (( CAST(CHARINDEX(UPPER(N"+searchString+"), UPPER([Extent1].[LocName])) AS int)) > 0) OR (( CAST(CHARINDEX(UPPER(N"+searchString+"), UPPER([Extent2].[CityName])) AS int)) > 0) OR (( CAST(CHARINDEX(UPPER(N" + searchString + "), UPPER([Extent3].[RegionName])) AS int)) > 0) ";
if (!String.IsNullOrEmpty(searchString))
{
locations = locations.Where(s => s.LocName.ToUpper().Contains(searchString.ToUpper())
|| s.City.CityName.ToUpper().Contains(searchString.ToUpper())
|| s.City.Region.RegionName.ToUpper().Contains(searchString.ToUpper()));
}
//
switch (sortOrder)
{
case "name_desc":
locations = locations.OrderByDescending(s => s.LocName);
break;
//case "site_desc":
// locations = locations.OrderByDescending(s => s.Site.SiteName);
// break;
//case "site":
// locations = locations.OrderBy(s => s.Site.SiteName);
// break;
case "city_desc":
locations = locations.OrderByDescending(s => s.City.CityName);
break;
case "city":
locations = locations.OrderBy(s => s.City.CityName);
break;
case "region_desc":
locations = locations.OrderByDescending(s => s.City.Region.RegionName);
break;
case "region":
locations = locations.OrderBy(s => s.City.Region.RegionName);
break;
default:
locations = locations.OrderBy(s => s.LocName);
break;
}
int pageSize = 8;
int pageNumber = (page ?? 1);
return View(locations.ToPagedList(pageNumber, pageSize));
}
else
return Redirect(Request.UrlReferrer.ToString());
}
// GET: /City/
public ActionResult Index(string sortOrder, string searchString, string currentFilter, int? page)
{
ViewBag.CurrentSort = sortOrder;
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
User LoggedInUser = Session["LoggedUser"] as User;
QueryBuilder qb = new QueryBuilder();
string query = qb.QueryForLocationTableSegerationForLinq(LoggedInUser);
var locations= db.Locations.Where(query).GroupBy(x => x.CityID).Select(group => group.FirstOrDefault());
List<City> ct = new List<City>();
foreach (var loc in locations)
ct.Add(loc.City);
var cities = ct.AsEnumerable<City>();
if (!String.IsNullOrEmpty(searchString))
{
cities = cities.Where(s => s.CityName.ToUpper().Contains(searchString.ToUpper())
|| s.CityName.ToUpper().Contains(searchString.ToUpper()));
}
switch (sortOrder)
{
case "name_desc":
cities = cities.OrderByDescending(s => s.CityName);
break;
default:
cities = cities.OrderBy(s => s.CityName);
break;
}
int pageSize = 8;
int pageNumber = (page ?? 1);
return View(cities.ToPagedList(pageNumber, pageSize));
//return View(cities.ToList());
}
