public DTOFilter getFilter() { var filter = new DTOFilter("atama", "id"); //var subFilter = new DTOFilter("atama", "closedtask"); if (id != null) { filter.fieldFilters.Add(id); } if (task != null) { filter.fieldFilters.Add(task); } if (task2 != null) { filter.fieldFilters.Add(task2); } if (personel != null) { filter.fieldFilters.Add(personel); } if (personel2 != null) { filter.fieldFilters.Add(personel2); } if (tasktype2 != null) { filter.fieldFilters.Add(tasktype2); } if (tasktype != null) { filter.fieldFilters.Add(tasktype); } return(filter); }
public DTOFilter getFilter() { using (var db = new KOCSAMADLSEntities()) { DTOFilter filter = new DTOFilter("campaigns", "id"); if (hasCategoryFilter()) { filter.fieldFilters.Add(category); } if (hasSubcategoryFilter()) { filter.fieldFilters.Add(subcategory); } if (hasCampaignFilter()) { filter.fieldFilters.Add(campaign); } if (deleted != null) { filter.fieldFilters.Add(deleted); } if (hasProductsFilter()) { var subFilter = new DTOFilter("vcampaignproducts", "cid"); var psubFilter = new DTOFilter("product_service", "productid"); psubFilter.fieldFilters.Add(products); subFilter.subTables.Add("pid", psubFilter); filter.subTables.Add("id", subFilter); } return(filter); } }
public DTOFilter getFilter() { var filter = new DTOFilter("block", "blockid"); var subFilter = new DTOFilter("site", "siteid"); if (block != null) { filter.fieldFilters.Add(block); } if (sitename != null || region != null) { if (sitename != null) { subFilter.fieldFilters.Add(sitename); } filter.subTables.Add("siteid", subFilter); } if (region != null) { subFilter.fieldFilters.Add(region); } if (telocadia != null) { filter.fieldFilters.Add(telocadia); } if (locationid != null) { filter.fieldFilters.Add(locationid); } return(filter); }
public DTOFilter getFilter() { if (objecttype.value.ToString() == "1000") { var filter = new DTOFilter("site", "siteid"); filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "category", op = 2, value = objecttype.value }); return(filter); } else if (objecttype.value.ToString() == "2000") { var filter = new DTOFilter("block", "blockid"); filter.fieldFilters.Add(objecttype); return(filter); } else if (objecttype.value.ToString() == "3000") { var filter = new DTOFilter("customer", "customerid"); filter.fieldFilters.Add(objecttype); return(filter); } else { var filter = new DTOFilter("personel", "personelid"); filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "category", op = 2, value = objecttype.value }); return(filter); } }
public DTOFilter getFilter() { var filter = new DTOFilter("taskstatematches", "id"); if (taskstatematches != null) { filter.fieldFilters.Add(taskstatematches); } if (task != null) { var subFilter = new DTOFilter("task", "taskid"); if (task != null) { subFilter.fieldFilters.Add(task); } filter.subTables.Add("taskid", subFilter); } if (taskstate != null) { var subFilter = new DTOFilter("taskstatepool", "taskstateid"); subFilter.fieldFilters.Add(taskstate); filter.subTables.Add("stateid", subFilter); } return(filter); }
public DTOFilter getFilter() { var filter = new DTOFilter("atama", "id"); if (id != null) { filter.fieldFilters.Add(id); } if (task != null) { filter.fieldFilters.Add(task); } if (personel != null) { filter.fieldFilters.Add(personel); } if (personeloff != null) { filter.fieldFilters.Add(personeloff); } if (taskclosed != null) { filter.fieldFilters.Add(taskclosed); } if (tasktype != null) { filter.fieldFilters.Add(tasktype); } if (tasktypeclosed != null) { filter.fieldFilters.Add(tasktypeclosed); } return(filter); }
public DTOFilter getFilter() { var filter = new DTOFilter("customer", "customerid"); if (customerid != null) { filter.fieldFilters.Add(customerid); } if (block != null) { filter.fieldFilters.Add(block); } if (flatNo != null) { filter.fieldFilters.Add(flatNo); } if (siteid != null) { filter.fieldFilters.Add(siteid); } if (deleted != null) { filter.fieldFilters.Add(deleted); } return(filter); }
public DTOFilter getFilter() { var filter = new DTOFilter("taskqueue", "taskorderno"); var csbFilter = csbRequest.getFilter(); filter.subTables["attachedobjectid"] = csbFilter; return(filter); }
public DTOFilter getFilter() { DTOFilter filter = new DTOFilter("personel", "personelid"); if (personel != null) { filter.fieldFilters.Add(personel); } return(filter); }
public DTOFilter getFilter() { var filter = new DTOFilter("il", "kimlikNo"); if (adres.fieldName.ToString() == "ilKimlikNo") { filter = new DTOFilter("ilce", "kimlikNo"); filter.fieldFilters.Add(adres); return(filter); } else if (adres.fieldName.ToString() == "ilceKimlikNo") // ilçe kimlik no seçilince mahalleler listelenmeli { filter = new DTOFilter("bucak", "kimlikNo"); filter.fieldFilters.Add(adres); return(filter); } else if (adres.fieldName.ToString() == "bucakKimlikNo") // ilçe kimlik no seçilince mahalleler listelenmeli { filter = new DTOFilter("mahalleKoy", "kimlikNo"); filter.fieldFilters.Add(adres); return(filter); } else if (adres.fieldName.ToString() == "mahalleKoyBaglisiKimlikNo") { if (subAdres.fieldName.ToString() == "yolKimlikNo") //mahalle ve cadde seçildiğinde binaların kapı numaraları listelenmeli { filter = new DTOFilter("bina", "kimlikNo"); filter.fieldFilters.Add(adres); filter.fieldFilters.Add(subAdres); return(filter); } else if (subAdres.fieldName.ToString() == "binaKimlikNo")//mahalle ve binakimlik numarası seçince daireler listelenmeli(bağımsız bölümler) { filter = new DTOFilter("daire", "kimlikNo"); filter.fieldFilters.Add(adres); filter.fieldFilters.Add(subAdres); return(filter); } else // sadece mahalle seçilince mahalledeki caddeler listelenmeli { filter = new DTOFilter("cadde", "kimlikNo"); filter.fieldFilters.Add(adres); return(filter); } } else { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "ad", op = 6, value = "" }); return(filter); } }
public DTOFilter getFilter() { var filter = new DTOFilter("site", "siteid"); if (sitename != null) { filter.fieldFilters.Add(sitename); } if (region != null) { filter.fieldFilters.Add(region); } return(filter); }
public DTOFilter getFilter() { var filter = new DTOFilter("document", "documentid"); if (documentname != null) { filter.fieldFilters.Add(documentname); } if (documentdescription != null) { filter.fieldFilters.Add(documentdescription); } return(filter); }
public DTOFilter getFilter() { var filter = new DTOFilter("product_service", "productid"); if (product != null) { filter.fieldFilters.Add(product); } if (category != null) { filter.fieldFilters.Add(category); } return(filter); }
public DTOFilter getFilter() { DTOFilter filter = new DTOFilter("stockcard", "stockid"); if (stockcard != null) { filter.fieldFilters.Add(stockcard); } if (category != null) { filter.fieldFilters.Add(category); } return(filter); }
public DTOFilter getFilter() { var filter = new DTOFilter("taskstatepool", "taskstateid"); if (taskstate != null) { filter.fieldFilters.Add(taskstate); } if (statetype != null) { filter.fieldFilters.Add(statetype); } return(filter); }
public DTOFilter getFilter() { var filter = new DTOFilter("customer", "customerid"); if (customername != null) { filter.fieldFilters.Add(customername); } if (tc != null) { filter.fieldFilters.Add(tc); } return(filter); }
public DTOFilter getFilter() { using (var db = new KOCSAMADLSEntities()) { DTOFilter filter = new DTOFilter("customer", "customerid"); // Ad Soyad Ayrımı Yapılacak if (customer != null) { filter.fieldFilters.Add(customer); } if (superonline != null) { filter.fieldFilters.Add(superonline); } if (hasIssFilter()) { var subFilter = new DTOFilter("issStatus", "id"); subFilter.fieldFilters.Add(iss); filter.subTables.Add("iss", subFilter); } if (hasCustomerstatusFilter()) { var subFilter = new DTOFilter("customer_status", "ID"); subFilter.fieldFilters.Add(customerstatus); filter.subTables.Add("customerstatus", subFilter); } if (hasIlFilter()) { var subFilter = new DTOFilter("il", "kimlikNo"); if (il != null) { subFilter.fieldFilters.Add(il); } filter.subTables.Add("ilKimlikNo", subFilter); } if (hasIlceFilter()) { var subFilter = new DTOFilter("ilce", "kimlikNo"); if (ilce != null) { subFilter.fieldFilters.Add(ilce); } filter.subTables.Add("ilceKimlikNo", subFilter); } return(filter); } }
public DTOFilter getFilter() { DTOFilter filter = new DTOFilter("taskstatematches", "id"); if (hasTaskFilter() || hasTypeFilter() || hasObjecttypeFilter() || hasPersoneltypeFilter()) { var subFilter = new DTOFilter("task", "taskid"); if (task != null) { subFilter.fieldFilters.Add(task); } filter.subTables.Add("taskid", subFilter); } if (hasTypeFilter()) { var subFilter = new DTOFilter("tasktypes", "TaskTypeId"); if (taskType != null) { subFilter.fieldFilters.Add(taskType); } filter.subTables["taskid"].subTables.Add("tasktype", subFilter); } if (hasObjecttypeFilter()) { var subFilter = new DTOFilter("objecttypes", "typeid"); subFilter.fieldFilters.Add(objecttype); filter.subTables["taskid"].subTables.Add("attachableobjecttype", subFilter); } if (hasPersoneltypeFilter()) { var subFilter = new DTOFilter("objecttypes", "typeid"); subFilter.fieldFilters.Add(personeltype); filter.subTables["taskid"].subTables.Add("attachablepersoneltype", subFilter); } if (hasTaskstateFilter()) { var subFilter = new DTOFilter("taskstatepool", "taskstateid"); subFilter.fieldFilters.Add(taskstate); filter.subTables.Add("stateid", subFilter); } return(filter); }
public DTOFilter getFilter() { var filter = new DTOFilter("SL", "SLID"); if (SLID != null) { filter.fieldFilters.Add(SLID); } if (SLName != null) { filter.fieldFilters.Add(SLName); } if (KocSTask != null) { filter.fieldFilters.Add(KocSTask); } if (KocETask != null) { filter.fieldFilters.Add(KocETask); } if (KocMaxTime != null) { filter.fieldFilters.Add(KocMaxTime); } if (BasyiSTask != null) { filter.fieldFilters.Add(BasyiSTask); } if (BayiETask != null) { filter.fieldFilters.Add(BayiETask); } if (BayiMaxTime != null) { filter.fieldFilters.Add(BayiMaxTime); } return(filter); }
public DTOFilter getFilter() { var filter = new DTOFilter("taskqueue", "taskorderno"); var csbFilter = csbRequest.getFilter(); if (hasTaskFilter()) { var taskFilter = taskRequest.getFilter(); if (taskRequest.hasTaskFilter() || taskRequest.hasTypeFilter()) { filter.subTables.Add("taskid", taskFilter.subTables["taskid"]); } if (taskRequest.hasTaskstateFilter()) { if (taskRequest.taskstate.op != 8) { filter.subTables.Add("status", taskFilter.subTables["stateid"]); } else { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "status", op = 8 }); } } } if (personelRequest.personel != null) { if (personelRequest.personel.op == 8) { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "attachedpersonelid", op = 8 }); } else { filter.subTables.Add("attachedpersonelid", personelRequest.getFilter()); } } if (assistantPersonel != null) { filter.subTables.Add("assistant_personel", assistantPersonelRequest.getFilter()); } if (updatedBy != null) { filter.subTables.Add("updatedby", updatedByRequest.getFilter()); } if (attachmentDate != null) { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "attachmentdate", op = 5, value = attachmentDate }); } if (appointmentDate != null) { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "appointmentdate", op = 5, value = appointmentDate }); } if (consummationDate != null) { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "consummationdate", op = 5, value = consummationDate }); } if (taskOrderNo != null) { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "taskorderno", op = 2, value = taskOrderNo }); } //hasCSBFilter her zaman en sonda olmalı. öncesine filtreler eklenecek if (hasCSBFilter()) { filter.subTables["attachedobjectid"] = csbFilter; } return(filter); }
public DTOFilter getFilter() { using (var db = new CRMEntities()) { DTOFilter filter = new DTOFilter("customer", "customerid"); // Ad Soyad Ayrımı Yapılacak if (customer != null) { //new DTOFieldFilter { fieldName = "category", op = 2, value = objecttype.value } filter.fieldFilters.Add(customer); } if (hasIssFilter()) { var subFilter = new DTOFilter("issStatus", "id"); subFilter.fieldFilters.Add(iss); filter.subTables.Add("iss", subFilter); } if (hasCustomerstatusFilter()) { var subFilter = new DTOFilter("customer_status", "ID"); subFilter.fieldFilters.Add(customerstatus); filter.subTables.Add("customerstatus", subFilter); } if (hasBlockFilter() || hasSiteFilter()) { var subFilter = new DTOFilter("block", "blockid"); if (block != null) { subFilter.fieldFilters.Add(block); } if (telocordiaid != null) { subFilter.fieldFilters.Add(telocordiaid); } if (sofiberbaslangic != null) { subFilter.fieldFilters.Add(sofiberbaslangic); } filter.subTables.Add("blockid", subFilter); } if (hasSiteFilter()) { var subFilter = new DTOFilter("site", "siteid"); if (region != null) { subFilter.fieldFilters.Add(region); } if (sitedistrict != null) { subFilter.fieldFilters.Add(sitedistrict); } if (site != null) { subFilter.fieldFilters.Add(site); } filter.subTables["blockid"].subTables.Add("siteid", subFilter); } return(filter); } }
public DTOFilter getFilter() { var specialFilters = new string[] { "SATINALMA", "DEPO" }; var filter = new DTOFilter("stockmovement", "movementid"); if (product != null) { var subFilter = new DTOFilter("stockcard", "stockid"); subFilter.fieldFilters.Add(product); filter.subTables.Add("stockcardid", subFilter); } if (movementdate != null) { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "movementdate", op = 5, value = movementdate.value }); } if (serialno != null) { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "serialno", op = 6, value = serialno.value }); } if (fromobjectid != null) { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "fromobject", op = 2, value = fromobjectid.value }); } if (toobjectid != null) { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "toobject", op = 2, value = toobjectid.value }); } if (isconfirmed != null) { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "confirmationdate", op = 8, value = null }); } if (movement != null) { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "movementid", op = 2, value = movement.value }); } if (fromobject != null && fromobject.value != null) { var seachKey = (fromobject.value ?? string.Empty).ToString().ToUpper(CultureInfo.CurrentCulture); //Satınalma if (!string.IsNullOrWhiteSpace(seachKey)) { if (specialFilters[0].Contains(seachKey)) { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "fromobjecttype", op = 2, value = (int)KOCAuthorization.KOCUserTypes.ADSLProcurementAssosiation }); } // Depo else if (specialFilters[1].Contains(seachKey)) { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "fromobjecttype", op = 2, value = (int)KOCAuthorization.KOCUserTypes.ADSLStockRoomAssosiation }); } } // Diğer var subFilterPersonel = new DTOFilter("personel", "personelid"); subFilterPersonel.fieldFilters.Add(new DTOFieldFilter { fieldName = "personelname", op = 6, value = fromobject.value }); filter.subTables.Add("fromobject", subFilterPersonel); var subFilterCustomer = new DTOFilter("customer", "customerid"); // Ad soyad kontrolü yapılacak subFilterCustomer.fieldFilters.Add(new DTOFieldFilter { fieldName = "customername", op = 6, value = fromobject.value }); filter.subTables.Add("fromobject1", subFilterCustomer); } if (toobject != null && !string.IsNullOrWhiteSpace((string)toobject.value)) { var seachKey = (toobject.value ?? string.Empty).ToString().ToUpper(CultureInfo.CurrentCulture); // Depo if (specialFilters[1].Contains(seachKey)) { filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "toobjecttype", op = 2, value = (int)KOCAuthorization.KOCUserTypes.ADSLStockRoomAssosiation }); } // Diğer var subFilterPersonel = new DTOFilter("personel", "personelid"); subFilterPersonel.fieldFilters.Add(new DTOFieldFilter { fieldName = "personelname", op = 6, value = toobject.value }); filter.subTables.Add("toobject", subFilterPersonel); var subFilterCustomer = new DTOFilter("customer", "customerid"); // Ad soyad kontrolü yapılacak subFilterCustomer.fieldFilters.Add(new DTOFieldFilter { fieldName = "customername", op = 6, value = toobject.value }); filter.subTables.Add("toobject1", subFilterCustomer); } return(filter); }