public async Task <IActionResult> Edit(int id, [Bind("Id,Title,IsSpecial,IsTour,IsBustour,IsCruise,CategoryId")] FiltersModel filtersModel)
{
if (id != filtersModel.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(filtersModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!FiltersModelExists(filtersModel.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["CategoryId"] = new SelectList(_context.Categories, "Id", "Id", filtersModel.CategoryId);
return(View(filtersModel));
}
public Models(int numPipelines = 1)
{
NumPipelines = numPipelines;
CheckDeviceCapabilities();
SharedModel = new SharedModel();
Images = new ImagesModel(SharedModel.ScaleShader);
TextureCache = new TextureCache(Images);
pixelValueShader = new PixelValueShader(SharedModel);
polarConvertShader = new ConvertPolarShader(SharedModel.QuadShader);
Export = new ExportModel(SharedModel);
Filter = new FiltersModel(Images);
//Gif = new GifModel(sharedModel.QuadShader);
Progress = new ProgressModel();
for (int i = 0; i < numPipelines; ++i)
{
pipelines.Add(new ImagePipeline(i));
pipelines.Last().PropertyChanged += PipeOnPropertyChanged;
}
Pipelines = pipelines;
stats = new StatisticsModel(SharedModel);
thumbnail = new ThumbnailModel(SharedModel.QuadShader);
// pipeline controller
pipelineController = new PipelineController(this);
}
public IActionResult FiltersItems([FromBody] FiltersModel model)
{
string path = "";
string data = "";
IARresponse = BadRequest();
try
{
ds = db.GetItemsByFilters(model);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
path = _hostingEnvironment.WebRootPath + "/images/Products/ProductsCategory/ProductsSubCategory/itemimg/" + row["cat_img"].ToString();
byte[] b = System.IO.File.ReadAllBytes(path);
data = "data:image/png;base64," + Convert.ToBase64String(b);
row["cat_img"] = data;
}
}
}
IARresponse = Ok(new { res = ds });
}
catch (Exception ex)
{
IARresponse = BadRequest(new { error = ex.Message });
}
return(IARresponse);
}
public List <Product> Filtr(FiltersModel filters, string category) //Filtruje i zwraca listę produktów.
{
string subcategory = (string)HttpContext.Current.Session["subcategory"] ?? null; //Sprawdza czy podkategoria nie została wybrana.
IEnumerable <Object> products = GetDbSet(category); //Pobiera repozytorium
if (subcategory != null) //Jeśli podkategoria została wybrana
{
products = products.Where($"Brand == {subcategory}");
}
if (filters.PriceMin != 0) //Jeśli cena min. została ustalona
{
products = products.Where($"Price >= {filters.PriceMin}");
}
if (filters.PriceMax != 0) //Jeśli cena max została ustalona.
{
products = products.Where($"Price <= {filters.PriceMax}");
}
if (filters.Filters != null) //Jeśli wybrano dodatkowe filtry.
{
List <int> a = filters.Filters.Where <FiltersProperties>(x => x.Value != null).Select <FiltersProperties, int>(x => filters.Filters.IndexOf(x)).ToList(); //Pobiera indexy filtrów, które zostały wybrane.
foreach (int i in a)
{
products = products.Where($"{filters.Filters[i].PropertyName} == {filters.Filters[i].Value}"); //Filtruje repozytorium
}
}
var Id = (IEnumerable <int>)products.Select($"Product_ID"); //Pobiera ID przefiltrowanych produktów.
return(Sort(items.Where(x => Id.Contains(x.ProductID)).ToList(), HttpContext.Current.Session["sort"]?.ToString())); //Zwraca posortowane repozytorium produktów.
}
private void BindGridViewGender(string search)
{
List <VMGender> vmg = new List <VMGender>();
{
VMGender vm = new VMGender();
vm.ID = 0;
vm.GenderName = "Male";
vmg.Add(vm);
}
{
VMGender vm = new VMGender();
vm.ID = 1;
vm.GenderName = "Female";
vmg.Add(vm);
}
FiltersModel fm = Session["FiltersModel"] as FiltersModel;
List <VMGender> _View = new List <VMGender>();
List <VMGender> _TempView = new List <VMGender>();
User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
_View = vmg;
//_View = _View.Where(aa => aa. == true).ToList();
GridViewGender.DataSource = _View.Where(aa => aa.GenderName.ToUpper().Contains(search.ToUpper())).ToList();
GridViewGender.DataBind();
}
private void BindGridViewDepartment(string search)
{
FiltersModel fm = Session["FiltersModel"] as FiltersModel;
List <ViewDepartment> _View = new List <ViewDepartment>();
List <ViewDepartment> _TempView = new List <ViewDepartment>();
User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
QueryBuilder qb = new QueryBuilder();
string query = qb.QueryForCompanyView(LoggedInUser);
DataTable dt = qb.GetValuesfromDB("select * from ViewDepartment " + query + " ORDER BY DeptName ASC");
_View = dt.ToList <ViewDepartment>();
if (fm.CompanyFilter.Count > 0)
{
foreach (var comp in fm.CompanyFilter)
{
short _compID = Convert.ToInt16(comp.ID);
_TempView.AddRange(_View.Where(aa => aa.CompID == _compID).ToList());
}
_View = _TempView.ToList();
}
if (fm.DivisionFilter.Count > 0)
{
_TempView.Clear();
foreach (var div in fm.DivisionFilter)
{
short _divID = Convert.ToInt16(div.ID);
_TempView.AddRange(_View.Where(aa => aa.DivID == _divID).ToList());
}
_View = _TempView.ToList();
}
GridViewDepartment.DataSource = _View.Where(aa => aa.DeptName.ToUpper().Contains(search.ToUpper())).ToList();
GridViewDepartment.DataBind();
}
private List <CriteriaFoAngular> GetInitialValuesFromFilters(FiltersModel fm)
{
List <CriteriaFoAngular> populateData = new List <CriteriaFoAngular>();
// CriteriaFoAngular cfa = new CriteriaFoAngular();
if (fm.CompanyFilter.Count > 0)
{
populateData.Add(new CriteriaFoAngular("C", "Company"));
}
if (fm.LocationFilter.Count > 0)
{
populateData.Add(new CriteriaFoAngular("L", "Location"));
}
if (fm.SectionFilter.Count > 0)
{
populateData.Add(new CriteriaFoAngular("E", "Section"));
}
if (fm.ShiftFilter.Count > 0)
{
populateData.Add(new CriteriaFoAngular("S", "Shift"));
}
if (fm.DepartmentFilter.Count > 0)
{
populateData.Add(new CriteriaFoAngular("D", "Department"));
}
return(populateData);
}
public ActionResult ReportInterface()
{
var filters = new FiltersModel();
List <Company> allCompanies = dataContext.Company.ToList();
Company firstCompany = new Company();
firstCompany.Id = 0;
firstCompany.CompanyName = "Select a company";
allCompanies.Insert(0, firstCompany);
List <Contract> allContracts = dataContext.Contract.ToList();
Contract firstContract = new Contract();
firstContract.Id = 0;
firstContract.ContractName = "Select a contract type";
allContracts.Insert(0, firstContract);
List <User> allUsers = dataContext.User.Distinct().ToList();
User firstUser = new DAL.User();
firstUser.Id = 0;
firstUser.Name = "Select a user";
allUsers.Insert(0, firstUser);
filters.CompanyList = allCompanies;
filters.UserList = allUsers;
filters.ContractList = allContracts;
return(View(filters));
}
protected static SubmitContext GetSubmitContext(FiltersModel filters = null)
{
var output = new SubmitContext()
{
CoreMetaData = new List <SubmissionMetaDataModel>(),
SourceMetaData = new List <SubmissionMetaDataModel>(),
Filters = filters
};
foreach (var dataType in FieldTypes)
{
for (int i = 0; i < 5; i++)
{
output.CoreMetaData.Add(new SubmissionMetaDataModel(Guid.NewGuid().ToString())
{
Type = dataType,
Value = Guid.NewGuid().ToString()
});
output.SourceMetaData.Add(new SubmissionMetaDataModel(Guid.NewGuid().ToString())
{
Type = dataType,
Value = Guid.NewGuid().ToString()
});
}
}
return(output);
}
public ActionResult ListOrders(TableRequestModel request, FiltersModel model)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
var orders = entities.Orders.Expand(o => o.Customer).Expand(o => o.Shipper).Expand(o => o.Order_Details);
return(TableResult.From(orders).Build <OrderTable>(request));
}
public IHttpActionResult GetFilters()
{
FiltersModel model = new FiltersModel()
{
Authors = db.Authors.Select(b => new AuthorModel
{
ID = b.ID.ToString(),
Name = b.Name + " " + b.Surname
}),
Genges = db.Genres.Select(b => new GenreModel
{
ID = b.ID.ToString(),
Name = b.Name
}),
PublishingHouses = db.PublishingHomes.Select(b => new PublishingHomeModel
{
ID = b.ID.ToString(),
Name = b.Name
})
};
if (model == null)
{
return(NotFound());
}
return(Ok(model));
}
private void BindGridViewSection(string search)
{
FiltersModel fm = Session["FiltersModel"] as FiltersModel;
List <ViewSection> _View = new List <ViewSection>();
List <ViewSection> _TempView = new List <ViewSection>();
User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
QueryBuilder qb = new QueryBuilder();
string query = qb.QueryForSectionRptFilters(LoggedInUser);
DataTable dt = qb.GetValuesfromDB("select * from ViewSection " + query);
_View = dt.ToList <ViewSection>().AsQueryable().SortBy("DeptName").ToList();
if (fm.DepartmentFilter.Count > 0)
{
_TempView.Clear();
foreach (var Sec in fm.DepartmentFilter)
{
short _SecID = Convert.ToInt16(Sec.ID);
_TempView.AddRange(_View.Where(aa => aa.SectionID == _SecID).ToList());
}
_View = _TempView.ToList();
}
GridViewSection.DataSource = _View.Where(aa => aa.SectionName.ToUpper().Contains(search.ToUpper()) || aa.DeptName.ToUpper().Contains(search.ToUpper())).ToList();
GridViewSection.DataBind();
}
public ActionResult GetInitialValues()
{
FiltersModel fm = Session["FiltersModel"] as FiltersModel;
var getInitialValues = GetInitialValuesFromFilters(fm);
return(Json(getInitialValues, JsonRequestBehavior.AllowGet));
}
public ActionResult <IEnumerable <AdvertModel> > GetByFilters([FromBody] FiltersModel filtersModel)
{
List <Advert> adverts = advertRepository.GetWithFilters(filtersModel.Animal, filtersModel.CountPeople, filtersModel.MinCost, filtersModel.MaxCost);
return(adverts
.Select(s => new AdvertModel(s))
.ToList());
}
public static string DeleteSingleFilter(string id, string parentid)
{
FiltersModel fml = new FiltersModel();
fml = HttpContext.Current.Session["FiltersModel"] as FiltersModel;
fml = WMSLibrary.Filters.DeleteSingleFilter(fml, id, parentid);
return(DateTime.Now.ToString());
}
internal static FiltersModel Init()
{
if (filterModel == null)
{
filterModel = new FiltersModel();
}
return(filterModel);
}
public static IEnumerable <object[]> ExcludedFilterAndIncludedFilter_WorkTogetherTestData()
{
var connectorTypeId = Guid.NewGuid();
var excludeFieldName = "folderPath";
var includeFieldName = "subject";
var excludeSourceFieldName = GetSourceFieldName(connectorTypeId, excludeFieldName, nameof(String));
var includeSourceFieldName = GetSourceFieldName(connectorTypeId, includeFieldName, nameof(String));
var filter = new FiltersModel()
{
Excluded = new SearchTreeNodeModel()
{
BoolOperator = FilterConstants.FilterBooleanOperators.Or,
SearchTerm = null,
Children = new List <SearchTreeNodeModel>()
{
GetSearchTreeNodeModel(excludeSourceFieldName, "inbox", FilterConstants.StringFieldOperators.Contains),
GetSearchTreeNodeModel(excludeSourceFieldName, "sent", FilterConstants.StringFieldOperators.Contains)
,
}
},
Included = new SearchTreeNodeModel()
{
BoolOperator = null,
SearchTerm = GetSearchTermModel(includeSourceFieldName, "meeting", FilterConstants.StringFieldOperators.Contains),
Children = null
}
};
// Item in one of the excluded folders and does not match include - Expect item to be filtered
var test1 = GetSubmitContext(filter);
AddOrUpdateSourceMetadata(test1, excludeFieldName, "inbox");
AddOrUpdateSourceMetadata(test1, includeFieldName, Guid.NewGuid().ToString());
yield return(new object[] { test1, true });
// Item in one of the excluded folders and matches include - Expect item to be filtered
var test2 = GetSubmitContext(filter);
AddOrUpdateSourceMetadata(test2, excludeFieldName, "sent");
AddOrUpdateSourceMetadata(test2, includeFieldName, "meeting");
yield return(new object[] { test2, true });
// Item not in one of the excluded folders and does not match include - Expect item to be filtered
var test3 = GetSubmitContext(filter);
AddOrUpdateSourceMetadata(test3, excludeFieldName, "Sandstorm");
AddOrUpdateSourceMetadata(test3, includeFieldName, "PROJECT ON HOLD");
yield return(new object[] { test3, true });
// Item not in one of the excluded folders and does match include - Expect item to not be filtered
var test4 = GetSubmitContext(filter);
AddOrUpdateSourceMetadata(test4, excludeFieldName, "Sandstorm");
AddOrUpdateSourceMetadata(test4, includeFieldName, "Project Sandstorm - Crisis Management Meeting");
yield return(new object[] { test4, false });
}
private void SaveCompanyIDs()
{
WMSLibrary.Filters filtersHelper = new WMSLibrary.Filters();
FiltersModel modelTemp = Session["FiltersModel"] as FiltersModel;
WMSLibrary.FiltersModel FM = filtersHelper.SyncGridViewIDs(GridViewCompany, modelTemp, "Company");
Session["FiltersModel"] = FM;
//fml = Session["FiltersModel"] as FiltersModel;
}
protected void btnStepSix_Click(object sender, EventArgs e)
{
FiltersModel fm = Session["FiltersModel"] as FiltersModel;
//if (MyHelper.UserHasValuesInSession(fm))
//{
Response.Redirect("~/Reports/Filters/AttendanceReport.aspx");
//}
}
private void SaveSectionsIDs()
{
WMSLibrary.Filters filtersHelper = new WMSLibrary.Filters();
FiltersModel modelTemp = Session["FiltersModel"] as FiltersModel;
WMSLibrary.FiltersModel FM = filtersHelper.SyncGridViewIDs(GridViewSection, modelTemp, "Section");
Session["FiltersModel"] = FM;
//fml = Session["FiltersModel"] as FiltersModel;
}
public ActionResult ListOrders(TableRequestModel request, FiltersModel model)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
var orders = entities.Orders.Expand(o => o.Customer).Expand(o => o.Shipper).Expand(o => o.Order_Details);
var table = TableResult.From(orders).Build <OrderTable>(request);
table.Overrides.HideColumn(order => order.ShipRegion);
return(table);
}
private dynamic ConvertToModel(IDictionary <string, string> filters)
{
object model = Activator.CreateInstance(FiltersModel);
var properties = FiltersModel.GetProperties();
foreach (var property in properties.Where(p => p.PropertyType.IsGenericType && p.PropertyType.GetGenericTypeDefinition() == typeof(PageFilter <>)))
{
var targetType = property.PropertyType.GetGenericArguments()[0];
string propertyName = property.Name.ToLowerInvariant();
var aliasAttribute = property.GetCustomAttributes(typeof(AliasAttribute), false).FirstOrDefault() as AliasAttribute;
if (aliasAttribute != null)
{
propertyName = aliasAttribute.Name;
}
var pageFilterType = typeof(PageFilter <>).MakeGenericType(targetType);
object targetValue = UninitializePageFilterTypeActivator.CreateUnitializedObject(targetType);
string stringValue = string.Empty;
string notSelectedValue = string.Empty;
Exception exception = null;
if (!filters.ContainsKey(propertyName) || string.IsNullOrWhiteSpace(filters[propertyName]))
{
object pageFilterNotSet = Activator.CreateInstance(pageFilterType, new[] { targetValue, false, null, string.Empty, string.Empty });
property.SetValue(model, pageFilterNotSet, null);
continue;
}
stringValue = filters[propertyName];
try
{
targetValue = PageFilterTypeConverter.Convert(stringValue, targetType);
}
catch (Exception ex)
{
exception = ex;
}
if (exception == null)
{
var notSelectedValueAttribute =
property.GetCustomAttributes(typeof(NotSelectedValueAttribute), false).FirstOrDefault() as NotSelectedValueAttribute;
if (notSelectedValueAttribute != null)
{
notSelectedValue = notSelectedValueAttribute.NotSelectedValue;
}
}
object pageFilter = Activator.CreateInstance(pageFilterType, new[] { targetValue, exception == null, exception, stringValue, notSelectedValue });
property.SetValue(model, pageFilter, null);
}
return(model);
}
protected void btnStepSix_Click(object sender, EventArgs e)
{
SaveDateSession();
SaveEmployeeIDs();
FiltersModel fm = Session["FiltersModel"] as FiltersModel;
if (MyHelper.UserHasValuesInSession(fm))
{
Response.Redirect("~/Reports/Filters/StepSixFilter.aspx");
}
}
private void BindGridViewShift(string search)
{
FiltersModel fm = Session["FiltersModel"] as FiltersModel;
List <Shift> _View = new List <Shift>();
QueryBuilder qb = new QueryBuilder();
DataTable dt = qb.GetValuesfromDB("select * from Shift ");
_View = dt.ToList <Shift>();
GridViewShift.DataSource = _View.Where(aa => aa.ShiftName.ToUpper().Contains(search.ToUpper())).ToList();
GridViewShift.DataBind();
}
public async Task <IActionResult> Index(FiltersModel filters)
{
var user = await GetCurrentUserAsync();
var items = this._toDoItemRepository.GetAll(user.Id, filters.FilterText);
var model = new IndexViewModel();
model.Items = items.Select(a => new ToDoItemViewModel(a));
model.Filters = filters;
return(View(model));
}
public ActionResult CreateBook()
{
BookFilterModel filters = new BookFilterModel();
FiltersModel jsonModel = new FiltersModel();
using (var client = new HttpClient())
{
client.BaseAddress = BaseUrl;
//HTTP GET
var responseTask = client.GetAsync("/api/value/getfilters");
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
var readTask = result.Content.ReadAsAsync <FiltersModel>();
readTask.Wait();
jsonModel = readTask.Result;
}
}
if (jsonModel != null)
{
filters = new BookFilterModel
{
Authors = jsonModel.Authors.ToList().Select(
t => new SelectListItem()
{
Value = t.ID,
Text = t.Name
}
).ToList(),
Genres = jsonModel.Genges.ToList().Select(
t => new SelectListItem()
{
Value = t.ID,
Text = t.Name
}
).ToList(),
PublishingHouses = jsonModel.PublishingHouses.ToList().Select(
t => new SelectListItem()
{
Value = t.ID,
Text = t.Name
}
).ToList()
};
}
return(View("CreateBook", filters));
}
public async Task <IActionResult> Create([Bind("Id,Title,IsSpecial,IsTour,IsBustour,IsCruise,CategoryId")] FiltersModel filtersModel)
{
if (ModelState.IsValid)
{
_context.Add(filtersModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CategoryId"] = new SelectList(_context.Categories, "Id", "Id", filtersModel.CategoryId);
return(View(filtersModel));
}
public ActionResult ListOrdersForFilters(TableRequestModel request, FiltersModel model)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
IQueryable <Order> orders =
entities.Orders.Expand(o => o.Customer).Expand(o => o.Shipper).Expand(o => o.Order_Details);
if (!String.IsNullOrEmpty(model.SelectedCustomerId))
{
orders = orders.Where(o => o.CustomerID == model.SelectedCustomerId);
}
return(TableResult.From(orders).Build <OrderFilterTable>(request));
}
public PartialViewResult Filtr(string category, FiltersModel filters = null) //Filtruje i wyświetla listę produktów.
{
ShowItemModel model = new ShowItemModel(); //Nowy model widoku.
filters = filters ?? new FiltersModel(); //Użyte filtry.
model.Product = productRepository.Filtr(filters, category); //Pobiera repozytorium produktów dla odpowiedniej kategorii i je filtruje.
model.DetailsInfo = productRepository.GetDetailsInfo(category); //Pobiera nazwy wybranych szczegółów dla danej kategorii.
model.Units = productRepository.GetDetailsUnits(category); //Pobiera jednostki do szczegółów.
return(PartialView("ProductPartial", model)); //Wygenerowanie widoku z przekazaniem modelu.
}
public static bool UserHasValuesInSession(FiltersModel fm)
{
bool check = false;
if (fm.CompanyFilter.Count > 0)
{
check = true;
}
if (fm.LocationFilter.Count > 0)
{
check = true;
}
if (fm.DivisionFilter.Count > 0)
{
check = true;
}
if (fm.CityFilter.Count > 0)
{
check = true;
}
if (fm.RegionFilter.Count > 0)
{
check = true;
}
if (fm.ShiftFilter.Count > 0)
{
check = true;
}
if (fm.WingFilter.Count > 0)
{
check = true;
}
if (fm.SectionFilter.Count > 0)
{
check = true;
}
if (fm.TypeFilter.Count > 0)
{
check = true;
}
if (fm.CrewFilter.Count > 0)
{
check = true;
}
if (fm.EmployeeFilter.Count > 0)
{
check = true;
}
return(check);
}
public ActionResult ListOrdersForFilters(TableRequestModel request, FiltersModel model)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
IQueryable<Order> orders =
entities.Orders.Expand(o => o.Customer).Expand(o => o.Shipper).Expand(o => o.Order_Details);
if (!String.IsNullOrEmpty(model.SelectedCustomerId))
{
orders = orders.Where(o => o.CustomerID == model.SelectedCustomerId);
}
return TableResult.From(orders).Build<OrderFilterTable>(request);
}
public ActionResult ListOrders(TableRequestModel request, FiltersModel model)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
var orders = entities.Orders.Expand(o => o.Customer).Expand(o => o.Shipper).Expand(o => o.Order_Details);
var table =TableResult.From(orders).Build<OrderTable>(request);
table.Overrides.HideColumn(order => order.ShipRegion);
return table;
}
public ActionResult ListOrders(TableRequestModel request, FiltersModel model)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
var orders = entities.Orders.Expand(o => o.Customer).Expand(o => o.Shipper).Expand(o => o.Order_Details);
return TableResult.From(orders).Build<OrderTable>(request);
}
