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