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);
}
