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