private static byte[] GetAnswerForRequest(KeyValuePair <string, IList <string> > requestData)
{
string operationKeyWord = requestData.Key;
switch (operationKeyWord)
{
/*case "initHandler":
* string login = requestData.Value[0];
* string password = requestData.Value[1];
* string database = requestData.Value[2];
* Handler = new PostgreSqlHandler(login, password, database);
* break;
* case "pass":
* return GetPassword(requestData.Value);*/
case "pass":
string login = requestData.Value[0];
string password = requestData.Value[1];
string database = requestData.Value[2];
Handler = new PostgreSqlHandler(login, password, database);
return(GetPassword(requestData.Value));
case "tablesNames":
return(GetTablesNames());
case "table":
return(GetTable(requestData.Value));
case "sampleFromTable":
return(GetSampleFromTable(requestData.Value));
case "delete":
ExecuteDelete(requestData.Value);
break;
case "updateOneValue":
UpdateOneValue(requestData.Value);
break;
case "insertWithId":
ExecuteInsertWithId(requestData.Value);
break;
case "insertWithoutId":
ExecuteInsert(requestData.Value);
break;
case "getUserId":
return(GetUserId(requestData.Value));
case "getHistory":
return(GetOrdersHistoryByReader(requestData.Value));
case "getBooks":
return(GetBooksByPublisher(requestData.Value));
}
return(null);
}
private static byte[] GetPassword(IList <string> parameters)
{
if (parameters.Count < 1)
{
return(null);
}
string login = parameters[0];
string reply = new PostgreSqlHandler("postgres", "postgres", "LibraryUsers").GetPassword(login);
return(Encoding.UTF8.GetBytes(reply));
}
