public static string GetClickIdName(ServerQueryType queryType)
{
string clickIdName = null;
switch (queryType)
{
case ServerQueryType.ClientArticlesBought:
clickIdName = "article.idarticle";
break;
case ServerQueryType.ClientArticlesDemoed:
clickIdName = "article.idarticle";
break;
case ServerQueryType.AddArticleDemoed:
clickIdName = "article.idarticle";
break;
case ServerQueryType.AddArticleBusiness:
clickIdName = "article.idarticle";
break;
case ServerQueryType.ArticleBoughtBy:
clickIdName = "business.company.idcompany";
break;
}
return clickIdName;
}
public static List<string> GetExtraFields(ServerQueryType type, bool withSearch = false)
{
List<string> fields = new List<string>();
switch(type)
{
case ServerQueryType.ClientDocuments:
fields.Add("document__fileextension");
//fields.Add("document__size");
break;
}
return fields;
}
public List<string> GetTranslatedFields(ServerQueryType queryType)
{
string tableName = LimeHelper.GetTableName(queryType);
List<string> fields = LimeHelper.GetFields(queryType);
List<string> hideFields = LimeHelper.GetHideFields(queryType);
hideFields.Add("id" + tableName);
for(int i = 0; i < hideFields.Count; i++)
{
fields.Remove(hideFields[i]);
}
NavigationCore.ServerTranslator.TranslateEnum TranslatorEnum = NavigationCore.ServerTranslator.TranslateEnum.None;
switch(queryType)
{
case ServerQueryType.CardClientData:
TranslatorEnum = NavigationCore.ServerTranslator.TranslateEnum.CardClient;
break;
}
for(int i = 0; i < fields.Count; i++)
{
fields[i] = GetFieldName(tableName, fields[i]);
if(TranslatorEnum != NavigationCore.ServerTranslator.TranslateEnum.None)
fields[i] = NavigationCore.ServerTranslator.TranslateField(TranslatorEnum, fields[i]);
}
return fields;
}
public static string GetTableName(ServerQueryType _type, bool withSearch = false)
{
string tableName = null;
switch(_type)
{
case ServerQueryType.BusinessRows:
tableName = "businessrow";
break;
case ServerQueryType.CampaignRows:
tableName = "articlecampaignrow";
break;
case ServerQueryType.DemoedArticles:
tableName = "demoarticle";
break;
case ServerQueryType.UploadDemoedArticles:
tableName = "demoarticle";
break;
case ServerQueryType.UploadBusinessRows:
tableName = "businessrow";
break;
case ServerQueryType.UploadContact:
tableName = "person";
break;
case ServerQueryType.UploadTodoData:
tableName = "todo";
break;
case ServerQueryType.UploadBusiness:
tableName = "business";
break;
case ServerQueryType.UploadCompany:
tableName = "company";
break;
case ServerQueryType.UploadActivity:
tableName = "history";
break;
case ServerQueryType.UploadColdClient:
tableName = "coldclient";
break;
case ServerQueryType.UploadFile:
tableName = "document";
break;
case ServerQueryType.ArticleBoughtBy:
tableName = "businessrow";
break;
case ServerQueryType.DataContact:
tableName = "person";
break;
case ServerQueryType.DataOrderType:
tableName = "ordertype";
break;
case ServerQueryType.DataPaymentTerms:
tableName = "paymentterms";
break;
case ServerQueryType.DataCountry:
tableName = "country";
break;
case ServerQueryType.DataTranslation:
tableName = "localize";
break;
case ServerQueryType.DataCompanyCategory:
tableName = "companycategory";
break;
case ServerQueryType.CardClientData:
tableName = "company";
break;
case ServerQueryType.MapsRoute:
tableName = "todo";
break;
case ServerQueryType.MapsNearbyClients:
tableName = "company";
break;
case ServerQueryType.DownloadFile:
tableName = "document";
break;
case ServerQueryType.ArticleResource:
tableName = "resource";
break;
case ServerQueryType.ClientToDo:
tableName = "todo";
break;
case ServerQueryType.ClientHistory:
tableName = "history";
break;
case ServerQueryType.ClientOrderOffers:
case ServerQueryType.CardBusinessData:
tableName = "business";
break;
case ServerQueryType.ClientArticlesBought:
tableName = "businessrow";
break;
case ServerQueryType.ClientArticlesDemoed:
tableName = "demoarticle";
break;
case ServerQueryType.CardArticleData:
tableName = "article";
break;
case ServerQueryType.ClientContacts:
case ServerQueryType.CardContactData:
tableName = "person";
break;
case ServerQueryType.CardActivityData:
tableName = "history";
break;
case ServerQueryType.ActivityPlanning:
case ServerQueryType.CardTodoData:
tableName = "todo";
break;
case ServerQueryType.CardCampaignData:
tableName = "articlecampaign";
break;
case ServerQueryType.MyPagesStatistics:
tableName = "coworker";
break;
case ServerQueryType.MyPagesGoalValues:
tableName = "goalvalue";
break;
case ServerQueryType.ClientDocuments:
tableName = "document";
break;
case ServerQueryType.ClientSearch:
tableName = "company";
break;
case ServerQueryType.ActivityHistory:
tableName = "history";
break;
case ServerQueryType.ActivityAlarms:
tableName = "company";
break;
case ServerQueryType.OrderOfferHistory:
tableName = "business";
break;
case ServerQueryType.OrderOfferUrgents:
tableName = "business";
break;
case ServerQueryType.ArticleCampaigns:
tableName = "articlecampaign";
break;
case ServerQueryType.ArticleSearch:
tableName = "article";
break;
case ServerQueryType.AddArticleDemoed:
if(withSearch)
tableName = "article";
else
tableName = "demoarticle";
break;
case ServerQueryType.AddArticleBusiness:
if(withSearch)
tableName = "article";
else
tableName = "businessrow";
break;
}
return tableName;
}
static string getFieldString(ServerQueryType type, bool withSearch = false)
{
List<string> fields = GetFields(type, withSearch);
string fieldString = "";
if(fields.Count > 0)
{
fieldString = "<fields>";
for(int i = 0; i < fields.Count; i++)
{
bool sortThisField = false;
/*if(type == ServerQueryType.ActivityAlarms)
{
if(fields[i] == "latesthistory")
sortThisField = true;
}
else */if(type == ServerQueryType.AddArticleBusiness)
{
if(fields[i] == "business.orderdate")
sortThisField = true;
}
else if(type == ServerQueryType.AddArticleDemoed)
{
if(fields[i] == "history.date")
sortThisField = true;
}
else if(fields[i] == "timestamp")
{
sortThisField = true;
}
string sortString = "";
if(sortThisField)
sortString = " sortorder=\"desc\" sortindex=\"1\"";
fieldString += "<field" + sortString + ">" + fields[i] + "</field>";
}
fieldString += "</fields>";
}
return fieldString;
}
public static List<string> GetFields(ServerQueryType type, bool withSearch = false)
{
List<string> fields = new List<string>();
string tableName = GetTableName(type, withSearch);
switch(type)
{
case ServerQueryType.DemoedArticles:
fields.Add("article.idarticle");
fields.Add("article.name");
fields.Add("article.articleno");
fields.Add("history.idhistory");
fields.Add("ordered");
break;
case ServerQueryType.CampaignRows:
fields.Add("article.articleno");
fields.Add("article.name");
fields.Add("article.idarticle");
fields.Add("price");
break;
case ServerQueryType.BusinessRows:
fields.Add("name");
fields.Add("quantity");
fields.Add("price");
fields.Add("totalprice");
fields.Add("selected");
fields.Add("article.idarticle");
fields.Add("article.name");
fields.Add("article.articleno");
fields.Add("business.idbusiness");
break;
case ServerQueryType.ArticleBoughtBy:
fields.Add("business.orderdate");
fields.Add("business.company.idcompany");
fields.Add("business.company.name");
fields.Add("business.company.customerno");
fields.Add("business.company.deliverycity");
fields.Add("quantity");
fields.Add("price");
fields.Add("business.person.name");
fields.Add("business.person.phone");
break;
case ServerQueryType.DataContact:
fields.Add("name");
fields.Add("email");
break;
case ServerQueryType.DataOrderType:
fields.Add("code");
fields.Add("name");
break;
case ServerQueryType.DataPaymentTerms:
fields.Add("code");
fields.Add("name");
break;
case ServerQueryType.DataCountry:
fields.Add("code");
fields.Add("name");
break;
case ServerQueryType.DataTranslation:
fields.Add("code");
fields.Add("sv");
fields.Add("en_us");
fields.Add("no");
fields.Add("fi");
break;
case ServerQueryType.DataCompanyCategory:
fields.Add("code");
fields.Add("name");
break;
case ServerQueryType.CardClientData:
fields.Add("name");
fields.Add("phone");
fields.Add("telefax");
fields.Add("www");
fields.Add("email");
fields.Add("invoiceaddress1");
fields.Add("deliveryname");
fields.Add("labelno");
fields.Add("deliveryaddress1");
fields.Add("invoicezipcode");
fields.Add("invoicecity");
fields.Add("deliveryaddress2");
fields.Add("country.name");
fields.Add("deliveryzipcode");
fields.Add("deliverycity");
fields.Add("registrationno");
fields.Add("customerno");
fields.Add("companycategory.name");
fields.Add("district.name");
fields.Add("active");
fields.Add("creditwarning");
fields.Add("gpslong");
fields.Add("gpslat");
break;
case ServerQueryType.MapsRoute:
fields.Add("company.deliveryaddress1");
fields.Add("company.deliverycity");
fields.Add("company.email");
fields.Add("company.name");
fields.Add("company.phone");
fields.Add("company.deliveryzipcode");
fields.Add("starttime");
fields.Add("company.gpslong");
fields.Add("company.gpslat");
break;
case ServerQueryType.MapsNearbyClients:
fields.Add("deliveryaddress1");
fields.Add("deliverycity");
fields.Add("email");
fields.Add("name");
fields.Add("phone");
fields.Add("deliveryzipcode");
fields.Add("gpslong");
fields.Add("gpslat");
break;
case ServerQueryType.DownloadFile:
fields.Add("document");
fields.Add("document__data");
break;
case ServerQueryType.ArticleResource:
fields.Add("name");
fields.Add("link");
fields.Add("article.idarticle");
break;
//case ServerQueryType.ActivityPlanning:
/*fields.Add("starttime");
fields.Add("coworker.name");
fields.Add("subject");
fields.Add("person.name");
fields.Add("company.name");
fields.Add("note");*/
//break;
case ServerQueryType.ClientToDo:
fields.Add("starttime");
fields.Add("endtime");
fields.Add("subject");
fields.Add("person.name");
fields.Add("note");
fields.Add("coworker.name");
break;
case ServerQueryType.ClientHistory:
fields.Add("date");
fields.Add("type");
fields.Add("company.name");
fields.Add("person.name");
fields.Add("note");
fields.Add("business.businessid");
fields.Add("coworker.name");
break;
case ServerQueryType.ClientOrderOffers:
fields.Add("orderdate");
fields.Add("businessid");
fields.Add("company.name");
fields.Add("person.name");
fields.Add("businesstatus");
fields.Add("coworker.name");
fields.Add("businessvalue");
break;
case ServerQueryType.ActivityPlanning:
case ServerQueryType.CardTodoData:
fields.Add("starttime");
fields.Add("endtime");
fields.Add("coworker.name");
fields.Add("coworker.idcoworker");
fields.Add("subject");
fields.Add("person.name");
fields.Add("person.idperson");
fields.Add("company.name");
fields.Add("company.idcompany");
fields.Add("note");
fields.Add("done");
fields.Add("canceled");
break;
case ServerQueryType.CardCampaignData:
fields.Add("headline");
fields.Add("description");
fields.Add("startdate");
fields.Add("enddate");
break;
case ServerQueryType.CardActivityData:
fields.Add("note");
fields.Add("date");
fields.Add("type");
fields.Add("coworker.idcoworker");
break;
case ServerQueryType.CardContactData:
fields.Add("company.name");
fields.Add("company.idcompany");
fields.Add("email");
fields.Add("firstname");
fields.Add("lastname");
fields.Add("misc");
fields.Add("mobilephone");
fields.Add("phone");
fields.Add("position");
fields.Add("active");
break;
case ServerQueryType.CardBusinessData:
fields.Add("businessid");
fields.Add("ordertype");
fields.Add("coworker.name");
fields.Add("coworker.idcoworker");
fields.Add("businesstatus");
fields.Add("marking");
fields.Add("paymentterms");
fields.Add("company.name");
fields.Add("company.idcompany");
fields.Add("person.name");
fields.Add("person.idperson");
fields.Add("email");
fields.Add("note");
fields.Add("deliveryname");
fields.Add("deliveryaddress1");
fields.Add("deliveryaddress2");
fields.Add("deliveryzipcode");
fields.Add("deliverycity");
fields.Add("orderdate");
fields.Add("tenderduedate");
fields.Add("deliverydate");
break;
case ServerQueryType.ClientArticlesBought:
fields.Add("article.idarticle");
fields.Add("business.orderdate");
fields.Add("article.articleno");
fields.Add("article.name");
fields.Add("quantity");
fields.Add("price");
fields.Add("totalprice");
fields.Add("business.coworker.name");
break;
case ServerQueryType.ClientArticlesDemoed:
fields.Add("article.idarticle");
fields.Add("history.date");
fields.Add("article.articleno");
fields.Add("article.name");
fields.Add("history.coworker.name");
break;
case ServerQueryType.CardArticleData:
fields.Add("articleno");
fields.Add("name");
fields.Add("division.name");
fields.Add("active");
fields.Add("vat");
fields.Add("prodgroup");
fields.Add("price1");
fields.Add("price2");
fields.Add("price3");
fields.Add("price4");
fields.Add("price5");
fields.Add("price6");
fields.Add("price7");
fields.Add("price8");
break;
case ServerQueryType.ClientContacts:
fields.Add("name");
fields.Add("position");
fields.Add("company.name");
fields.Add("phone");
fields.Add("email");
fields.Add("active");
//Will be hidden
fields.Add("misc");
break;
case ServerQueryType.ClientDocuments:
//fields.Add("createdtime");
fields.Add("coworker.name");
fields.Add("type");
fields.Add("comment");
fields.Add("document");
break;
case ServerQueryType.MyPagesStatistics:
fields.Add("name");
fields.Add("todayvisits");
fields.Add("todayorders");
fields.Add("todaydemos");
fields.Add("todaysales");
fields.Add("todaybookings");
break;
case ServerQueryType.MyPagesGoalValues:
fields.Add("coworker.name");
fields.Add("coworker.idcoworker");
fields.Add("coworker.periodsales");
fields.Add("coworker.yearlysales");
fields.Add("coworker.yearlybudget");
fields.Add("startdate");
fields.Add("enddate");
fields.Add("budget");
break;
case ServerQueryType.ClientSearch:
fields.Add("name");
fields.Add("deliveryaddress1");
fields.Add("deliverycity");
fields.Add("phone");
fields.Add("district.name");
fields.Add("customerno");
//fields.Add("deliveryzipcode");
//fields.Add("registrationno");
break;
case ServerQueryType.ActivityHistory:
fields.Add("date");
fields.Add("type");
fields.Add("company.name");
fields.Add("person.name");
fields.Add("note");
fields.Add("coworker.name");
fields.Add("business.businessvalue");
break;
case ServerQueryType.ActivityAlarms:
fields.Add("latesthistory");
fields.Add("customerno");
fields.Add("name");
fields.Add("latesthistorytype");
break;
case ServerQueryType.OrderOfferHistory:
fields.Add("orderdate");
fields.Add("businessid");
fields.Add("company.name");
fields.Add("person.name");
fields.Add("businesstatus");
fields.Add("coworker.name");
fields.Add("businessvalue");
break;
case ServerQueryType.OrderOfferUrgents:
fields.Add("orderdate");
fields.Add("businessid");
fields.Add("company.name");
fields.Add("person.name");
fields.Add("businesstatus");
fields.Add("coworker.name");
fields.Add("businessvalue");
break;
case ServerQueryType.ArticleCampaigns:
fields.Add("headline");
fields.Add("description");
fields.Add("startdate");
fields.Add("enddate");
break;
case ServerQueryType.ArticleSearch:
fields.Add("articleno");
fields.Add("name");
fields.Add("division.name");
foreach(var item in availablePriceGroups)
{
fields.Add(item);
}
break;
case ServerQueryType.AddArticleDemoed:
if(withSearch)
{
fields.Add("articleno");
fields.Add("name");
fields.Add("division.name");
foreach(var item in availablePriceGroups)
{
fields.Add(item);
}
}
else
{
fields.Add("history.date");
fields.Add("article.idarticle");
fields.Add("article.articleno");
fields.Add("article.name");
fields.Add("article.division.name");
foreach(var item in availablePriceGroups)
{
fields.Add("article." + item);
}
}
break;
case ServerQueryType.AddArticleBusiness:
if(withSearch)
{
fields.Add("articleno");
fields.Add("name");
fields.Add("division.name");
foreach(var item in availablePriceGroups)
{
fields.Add(item);
}
}
else
{
fields.Add("business.orderdate");
fields.Add("article.idarticle");
fields.Add("article.articleno");
fields.Add("article.name");
fields.Add("article.division.name");
foreach(var item in availablePriceGroups)
{
fields.Add("article." + item);
}
}
break;
}
if(fields.Count > 0)
{
fields.Insert(0, "timestamp");
fields.Insert(0, "id" + tableName);
}
return fields;
}
public static List<string> GetSearchFields(ServerQueryType type, bool withSearch = false)
{
List<string> fields = new List<string>();
switch(type)
{
case ServerQueryType.MapsNearbyClients:
break;
case ServerQueryType.ClientToDo:
fields.Add("starttime");
fields.Add("endtime");
fields.Add("subject");
fields.Add("person.name");
fields.Add("note");
fields.Add("coworker.name");
break;
case ServerQueryType.ClientHistory:
fields.Add("date");
fields.Add("type");
fields.Add("company.name");
fields.Add("person.name");
fields.Add("note");
fields.Add("business.businessid");
fields.Add("coworker.name");
break;
case ServerQueryType.ClientContacts:
fields.Add("name");
fields.Add("position");
fields.Add("company.name");
fields.Add("phone");
fields.Add("email");
fields.Add("misc");
break;
case ServerQueryType.ClientOrderOffers:
fields.Add("orderdate");
fields.Add("businessid");
fields.Add("company.name");
fields.Add("person.name");
fields.Add("businesstatus");
fields.Add("coworker.name");
fields.Add("marking");
fields.Add("businessvalue");
break;
case ServerQueryType.ClientArticlesBought:
fields.Add("business.orderdate");
fields.Add("article.articleno");
fields.Add("article.name");
// fields.Add("quantity");
// fields.Add("price");
// fields.Add("totalprice");
fields.Add("business.coworker.name");
break;
case ServerQueryType.ClientArticlesDemoed:
fields.Add("history.date");
fields.Add("article.articleno");
fields.Add("article.name");
fields.Add("history.coworker.name");
break;
case ServerQueryType.ClientDocuments:
fields.Add("coworker.name");
fields.Add("type");
fields.Add("comment");
break;
case ServerQueryType.MyPagesStatistics:
//Kan inte söka(Är ingen table)
break;
case ServerQueryType.MyPagesGoalValues:
//Kan inte söka(Är ingen table)
break;
case ServerQueryType.ClientSearch:
fields.Add("companycategory.name");
fields.Add("country.name");
fields.Add("customerno");
fields.Add("deliveryaddress1");
fields.Add("deliveryaddress2");
fields.Add("deliverycity");
fields.Add("deliveryname");
fields.Add("deliveryzipcode");
fields.Add("district.name");
fields.Add("email");
fields.Add("invoiceaddress1");
fields.Add("invoicecity");
fields.Add("invoicezipcode");
fields.Add("labelno");
fields.Add("name");
fields.Add("person.name");
fields.Add("person.phone");
fields.Add("person.mobilephone");
fields.Add("person.email");
fields.Add("phone");
fields.Add("registrationno");
fields.Add("telefax");
fields.Add("www");
break;
case ServerQueryType.ActivityHistory:
fields.Add("date");
fields.Add("type");
fields.Add("company.name");
fields.Add("person.name");
fields.Add("note");
fields.Add("business.businessid");
fields.Add("coworker.name");
break;
case ServerQueryType.ActivityAlarms:
fields.Add("latesthistory");
fields.Add("customerno");
fields.Add("name");
break;
case ServerQueryType.OrderOfferHistory:
fields.Add("orderdate");
fields.Add("businessid");
fields.Add("company.name");
fields.Add("person.name");
fields.Add("businesstatus");
fields.Add("marking");
fields.Add("coworker.name");
break;
case ServerQueryType.OrderOfferUrgents:
fields.Add("orderdate");
fields.Add("businessid");
fields.Add("company.name");
fields.Add("person.name");
fields.Add("businesstatus");
fields.Add("marking");
fields.Add("coworker.name");
break;
case ServerQueryType.ArticleCampaigns:
fields.Add("headline");
fields.Add("description");
fields.Add("startdate");
fields.Add("enddate");
break;
case ServerQueryType.ArticleSearch:
fields.Add("articleno");
fields.Add("name");
fields.Add("division.name");
foreach(var item in availablePriceGroups)
{
fields.Add(item);
}
break;
case ServerQueryType.AddArticleDemoed:
if(withSearch)
{
fields.Add("articleno");
fields.Add("name");
fields.Add("division.name");
foreach(var item in availablePriceGroups)
{
fields.Add(item);
}
}
else
{
fields.Add("article.articleno");
fields.Add("article.name");
fields.Add("article.division.name");
foreach(var item in availablePriceGroups)
{
fields.Add("article." + item);
}
}
break;
case ServerQueryType.AddArticleBusiness:
if(withSearch)
{
fields.Add("articleno");
fields.Add("name");
fields.Add("division.name");
foreach(var item in availablePriceGroups)
{
fields.Add(item);
}
}
else
{
fields.Add("article.articleno");
fields.Add("article.name");
fields.Add("article.division.name");
foreach(var item in availablePriceGroups)
{
fields.Add("article." + item);
}
}
break;
}
return fields;
}
public static List<string> GetHideFields(ServerQueryType type, bool withSearch = false)
{
List<string> fields = new List<string>();
fields.Add("createduser");
fields.Add("createdtime");
fields.Add("updateduser");
fields.Add("timestamp");
switch(type)
{
case ServerQueryType.ClientDocuments:
fields.Add("document");
break;
case ServerQueryType.AddArticleDemoed:
fields.Add("history.date");
break;
case ServerQueryType.AddArticleBusiness:
fields.Add("business.orderdate");
break;
case ServerQueryType.ClientContacts:
fields.Add("misc");
break;
}
return fields;
}
static List<string> GetNumericFieldsAndRemoveThemFromList(ref List<string> fields, string value, ServerQueryType queryType)
{
bool isNumber = true;
try
{
float.Parse(value, System.Globalization.CultureInfo.InvariantCulture);
}
catch
{
isNumber = false;
}
string tableName = GetTableName(queryType);
List<string> numericTypesToFind = new List<string>() {
"businessid",
"id"+tableName,
"price1","price2","price3","price4","price5","price6","price7","price8",
};
List<string> numericFields = fields.FindAll(delegate(string obj) {
var splitted = obj.Split('.');
var checkString = obj;
if(splitted.Length > 0)
checkString = splitted[splitted.Length - 1];
return numericTypesToFind.Contains(checkString);
});
for(int i = 0; i < numericFields.Count; i++)
{
fields.Remove(numericFields[i]);
}
if(!isNumber)
numericFields = new List<string>();
return numericFields;
}
