public Stream GetFilteredContacts(QuryType qt, string email)
{
//http://localhost:6090/0/rest/WorkshopWebService/GetFilteredContacts?qt=0&[email protected]
Timer.Start();
Tuple <DataTable, string> result;
switch (qt)
{
case QuryType.SELECT:
result = ReadingData.GetFilteredContactsSelect(email);
break;
case QuryType.ESQ:
result = ReadingData.GetFilteredContactsEsq(email);
break;
case QuryType.CustomQuery:
result = ReadingData.GetFilteredContactsCustomQuery(email);
break;
default:
result = ReadingData.GetFilteredContactsSelect(email);
break;
}
Timer.Stop();
string htmlPage = result.Item1.GetHtmlPage(Timer.ElapsedTicks, result.Item2, qt.ToString());
return(GetMemoryStream(htmlPage));
}
public Stream GetContactsWithMinutes(QuryType qt, Guid ContactId)
{
// http://localhost:6090/0/rest/WorkshopWebService/GetContactsWithMinutes?qt=1&ContactId=410006e1-ca4e-4502-a9ec-e54d922d2c00
Timer.Start();
Tuple <DataTable, string> result;
switch (qt)
{
case QuryType.SELECT:
result = ReadingData.GetContactsWithMinutesSelect(ContactId);
break;
case QuryType.ESQ:
result = ReadingData.GetContactsWithMinutesEsq(ContactId);
break;
case QuryType.CustomQuery:
result = ReadingData.GetAllContactsCustomQuery();
break;
default:
result = ReadingData.GetAllDataReverseJoinEsq();
break;
}
Timer.Stop();
string htmlPage = result.Item1.GetHtmlPage(Timer.ElapsedTicks, result.Item2, qt.ToString());
return(GetMemoryStream(htmlPage));
}
public Stream GetAllDataReverseJoin(QuryType qt)
{
// This is simple example of EntitySchemaQuery and use of reverse join expressions
// Example to run:
// http://localhost:6090/0/rest/WorkshopWebService/GetAllDataReverseJoin?qt=1
Timer.Start();
Tuple <DataTable, string> result;
switch (qt)
{
case QuryType.SELECT:
result = ReadingData.GetAllDataReverseJoinSelect();
break;
case QuryType.ESQ:
result = ReadingData.GetAllDataReverseJoinEsq();
break;
case QuryType.CustomQuery:
result = ReadingData.GetAllContactsCustomQuery();
break;
default:
result = ReadingData.GetAllDataReverseJoinEsq();
break;
}
Timer.Stop();
string htmlPage = result.Item1.GetHtmlPage(Timer.ElapsedTicks, result.Item2, qt.ToString());
return(GetMemoryStream(htmlPage));
}
public string DeleteContact(QuryType qt, Guid ContactId)
{
// http://localhost:6090/0/rest/WorkshopWebService/DeleteContact?qt=1&ContactId=060b93d0-0b94-4967-af32-030ac0844ec9
Timer.Start();
string result = string.Empty;
switch (qt)
{
case QuryType.INSERT:
result = DeletingData.DeleteContact(ContactId);
break;
case QuryType.ESQ:
result = DeletingData.DeleteContactEsq(ContactId);
break;
default:
result = DeletingData.DeleteContactEsq(ContactId);
break;
}
Timer.Stop();
return(result);
}
public string InsertSeveralContacts(QuryType qt)
{
// http://localhost:6090/0/rest/WorkshopWebService/InsertSeveralContacts?qt=1
Timer.Start();
string result = string.Empty;
switch (qt)
{
case QuryType.INSERT:
result = InsertingData.InsertSeveralContacts();
break;
case QuryType.ESQ:
result = InsertingData.InsertSeveralContactsEsq();
break;
default:
result = InsertingData.InsertSeveralContacts();
break;
}
Timer.Stop();
return(result);
}
public string UpdateContactName(QuryType qt, Guid ContactId, string NewName)
{
// http://localhost:6090/0/rest/WorkshopWebService/UpdateContactName?qt=1&ContactId=410006e1-ca4e-4502-a9ec-e54d922d2c00&NewName=Kirill
Timer.Start();
string result = string.Empty;
switch (qt)
{
case QuryType.UPDATE:
result = UpdatingData.UpdateContactUpdate(ContactId, NewName);
break;
case QuryType.ESQ:
result = UpdatingData.UpdateContactEsq(ContactId, NewName);
break;
default:
result = UpdatingData.UpdateContactEsq(ContactId, NewName);
break;
}
Timer.Stop();
return(result);
}
